cancel
Showing results for 
Search instead for 
Did you mean: 

Hot folder import for "Product" fails while Description field has semicolon in it ?

Former Member
0 Kudos

Hi,

I'm using out of the box impex converter in the hot folder.

My feed is in .CSV format and it contains the description field which is enclosed in double quotes. For example

"This is my sample; Data"

during import process only the part before semicolon(This is my sample) is referred as one field and the next part (Data) is taken as following one

Header is:

  INSERT_UPDATE Product code[unique=true];name[lang=en];description[lang=en];description[lang=es];

Mapping Value

                 ;{+0}:{1}:{2};

Sample CSV

      5699,Camera,"This is my sample; Data"

So for description[lang=en] only first part (This is my sample) is stored.

Please help me in resolving this.

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hello, Modify your mapping as ;{+0}:{1}:"{2}";

Answers (7)

Answers (7)

Former Member
0 Kudos

Seems like it is a known bug , which was not resolved so far:

https://jira.hybris.com/browse/ACCEL-588

Former Member
0 Kudos

I had a same problem. But it is not with the csv file. It is with idocs. I have written a CompositionHandler. It is working fine for me.

Thanks Samudrala

Former Member
0 Kudos

Try placing &# 59 (ASCI value for 😉 in csv. It will work.

Former Member
0 Kudos

Hi Arun,

Can u share the sample csv here. How this was implemented?

Regards, Siddhi

prahlad_singh_rajput
Participant
0 Kudos

Hi Experts,

I facing same type of issue, In my case

INSERT_UPDATE Product;code[unique=true];summary;type;$catalogVersion

;{+0};"{1}";{2};;{S} Trying with above combination not working. Means still considering new column after semicolon (;). Is any way to achieve it without changing the fieldSeparator (;) value ?

0 Kudos

Hi Vijay,

Adding "{2}"; will accept all the UTF-8 characters.

Former Member
0 Kudos

can anyone suggest the best practice please.

Former Member
0 Kudos

Hi Vinjay,

I just tried this out by changing the separator to tilde ~

csv.fieldseparator=~

The IMPEX Script I imported via the hac was:

INSERT_UPDATE PRODUCT~ CODE[unique=true]~ DESCRIPTION~ NAME~ CatalogVersion(Catalog(id),version) ~MYPRODUCT~ THIS IS MY ; PRODUCT~MYPROD~ electronicsProductCatalog:Online

Notice the semi-colon within the description.

The result was a successful import and I can see the product in my catalog with a matching description to the one imported.

Best Regards,

Ben

Former Member
0 Kudos

Hi Vijay,

One suggestion I can think of is to perhaps try to change the default csv seperator from a semi-colon.

For example setting it in your local.properties as:

csv.fieldseparator=!

Kind Regards,

Ben

Former Member
0 Kudos

Thank you for the reply Ben,

When i modify the csv.fieldseperator=! , I Did try with other characters like '#'

its throwing me

      de.hybris.platform.impex.jalo.header.HeaderValidationException: no current header for value line

Please do help me in resolving this.

Thanks in advance.