on 10-21-2015 7:03 AM
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.
Hello, Modify your mapping as ;{+0}:{1}:"{2}";
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Seems like it is a known bug , which was not resolved so far:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try placing &# 59 (ASCI value for 😉 in csv. It will work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vijay,
Adding "{2}"; will accept all the UTF-8 characters.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
can anyone suggest the best practice please.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.