CSV data import issue for product description attribute

[Former Member]

Hi,

While importing product description data from csv we are having trouble with following characters.

1. next line character in the attribute breaks the feed. • Excellent off-road capability thanks to ground clearance, articulated steering (33°) and oscillating angle (15°) • Wide control stand and intuitive operating concept

2. if there is ; in the description though text is enclosed in double quotes the impex shows unresolved line. say "THE partner for large excavators; nothing beats this soil moving machine" can you please suggest the escape characters can be used while importing csv for hotfolder?

[Former Member]

There might be several issues with separators and quotation marks when it comes to hotfolders, because your file is being transformed into impex and then being imported to hybris. You first need to check the generated impex file in your hot-folder (i.e. look for it while processing in the "processing" subfolder or in the "archive" subfolder afterwards). If the original CSV is ok and the generated impex file is broken, you need to check your hot-folder configuration in hot-folder-*-spring.xml. Look for issues in your impexRow property, that might look something similar to:

 <property name="impexRow">
     <value>;{+0}:$catalog:Staged;{+1};{+2};{3};;;;$catalog:Staged</value>
 </property>

Your field separator in there might be different than currently used by impex engine (you can check that with fieldSeparator property of ImpexTransformerTask).

You can also check the section "CSV Files in ImpEx" in the link below to find what are the default values and how to escape them https://help.hybris.com/1808/hcd/7667647b512c420c9152a1eead11574f.html