Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Profiterole 232 posts 264 karma points
    Sep 23, 2010 @ 20:45
    Profiterole
    0

    map properties problem

    Hi, I have a problem to import data with umbimport. I have a csv file which look like that : 'nodeName';'mediaDescription';'insertCode' etc...

    And each line is separate by an enter.

    So first step : I choose csv file as content

    Step 2 : I browse my file and choose the text seperator

    Step 3 : I choose location and docType

    Step 4 : I'm supposed to map csv column with documentProperty, but I got this screen and there's no choice :

    The only thing I can do is ignoreMappingOption. Why am I stuck?

    Thank you

    Simon

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Sep 23, 2010 @ 22:21
    Richard Soeteman
    0

    Hi Simon,

    First of all, I think CMSImport can't update the language files, makes sure that it can write to the /umbraco/config/lang/ folder.

    I think your problem is related to encoding. Save the file in UTF-8 format and please try again. If that doesn't help it could also be a problem with the API I'm using for parsing csv files. Id that is the case it might be better to store the csv file in sql server and use that table as datasource. In that case I'm very interested in the original file so if you want to share it please send it to richard [at] soetemansoftware.nl. I'm building a new version with a new version of the csv parser and would like to see if it's solved.

    Hope this helps you,

    Richard 

  • Profiterole 232 posts 264 karma points
    Sep 24, 2010 @ 01:19
    Profiterole
    0

    Hi Richard,

    My /umbraco/config/lang folder has a 777 permission, so it should be able to write. My ffile is an excel (open office calc) file that I saved in cvs. The idea to store the file to an sql server is kind complicated for my... I'm a apache/php/mysql user normaly!

    I emailed you the file. Each column enter value in my docType. I want a new node for each line. The first one is the name of the column (like bodyText).

    Thank you for your help

    Simon

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Sep 24, 2010 @ 09:29
    Richard Soeteman
    0

    HI Simon,

    I just emailed the file back. Don't use text indicators on the columnnames.

    Cheers,

    Richard

  • Profiterole 232 posts 264 karma points
    Sep 24, 2010 @ 11:51
    Profiterole
    0

    Sorry for bothering you again! Now I can pass the maping step. It confirm me that everything is good, but it just do not import. I click next I have the little "upload bar" that appears and in the final step, I have zeros (0) on importation time, importation success, importation error and record.

    So it don't import anything. Do I have to have a publish date column?

    Thank you again.

    Simon

Please Sign in or register to post replies

Write your reply to:

Draft