Importing Description Data with Line Breaks to Accounts from CSV File

[michael_Bonn]

Hi there,

i´d like to import data from a csv file into accounts. There is some comment data that is multi-lined, and I want to import that into the description field of the account record. How to encode the line breaks in the csv file ? I tried several ways without having success.

Any ideas will be appreciated.

Thanks,

Michael

[Angel]

CSV doesn't lend itself well for this type of task as a carriage return/line feed would indicate a new record, hence the reason why you are experiencing problems.

You need to either get rid of the line breaks or use a different file format/import tool.

[michael_Bonn]

Hi,
there´s no way to "encode" line breaks so that sugar does recognize it during import ? Which proceeding / import tool do you recommend ?

Rgds
Michael

[Angel]

Take a look at Talend Open Studio and/or SnapLogic as possible tools to perform the import.

[wdroush]

Write a little mysql importer in php? It's what I did for importing clickpoint data.

You'll have to rework the CSV format into something else though.

[Greetal]

Take a look at Talend Open Studio and/or SnapLogic as possible tools to perform the import.

Talend would a good tool to work with to import the csv files. You can try to import the files like they are now, but you might need to slightly rewrite them if there is a problem.