Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • Posted on Nov 16, 2015 at 07:05 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 17, 2015 at 06:30 AM

    Hi Vijay,

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2015 at 04:20 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2015 at 02:49 AM

    can anyone suggest the best practice please.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Posted on Dec 05, 2015 at 01:49 AM

    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 ?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 20, 2016 at 10:01 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 20, 2016 at 05:29 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 09, 2016 at 09:29 PM

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

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.