Convert xml to csv for website x5
Author: Branislav Nemeth
Visited 912,
Followers 1,
Shared 0
Who will convert my xml to csv for website x5?
Posted on the
Who will convert my xml to csv for website x5?
Hello Branislav,
usually the softwares themselves used to compile the file should have options to save with different formats, otherwise you should be able to find online conversion tools.
Eric
Author
I found app.conviu.com they converted my xml to csv for the X5 website.I just don't know if it will stretch the images for the products, since they are on www.nellys.sk servers.
can you check the csv for me, it showed me some errors, but I couldn't figure out what.
it showed errors from line 4900 and above, so I'm sending a download link, because the csv is over 1024KB
https://exports.conviu.com/open/x9ju2quzamksck0lxp5exan7uhzjza3z/writer/u4v5yvu27g802rggz8ucdgxkbl341xel.csv
Branislav
Hello,
from what I can see, in this file as well the value for availability has been translated to Skladem, as in the previous version. However, in my case the error mentions line 1 already.
Eric
Author
Translation problem solved, replaced by "Fixed" in all products.
I sent a link to download the original, I have the corrected feed on my computer, but since it is large, more than 1024 KB, I did not send it.
after editing it gave me the error Invalid field count (line 4939) and after deleting line 4939 it gave me the error Invalid field count (line 5xxx) again, so I deleted all the error lines, but I don't know why it showed an error.The lines are formatted the same and yet there is a line that prevents the upload of the feed.
I still don't see the images of the goods in the eshop, are they correct in the feed?
Sorry for so many questions, but I've been struggling with this for a week and I'm glad I found some software that can be used to convert xml/csv to website x5. The help from conviu.com was helpful, because they don't offer a template for website x5.
This is a template on app.conviu.com(is this correct?)
id;category;name/code;description;sku;price;weight;options;enable discounts;discounts;availability type;available;pending;images
{{ product }}
"";"%categories%|last";"%name%";"%descriptionextended%|first|spaceless|replace({'"': '""'})";"%code%";"%price-vat%";"%weight%";"{{ variant }}{{ if not loop.first }}|{{ endif }}{{ parameter }}%param-value%{{ if not loop.last }}|{{ endif }}{{ end }}{{ end }}";"0";"";"%availability%";"";"";"%images%|join('|')"
{{ end }}
THX again for your help
Nice weekend
Branislav
Author
Hi ,
I still do not see pictures of products www.babyboom.boutique
See Attachment feed
Hello Branislav,
so this version can be imported without the errors about a certain line, but the images are not displayed?
Can you send me this version of the .csv?
Eric
Author
Hi see attachment, http://www.babyboom.boutique/cartsearch/index.html no pictures
Hello Branislav,
I am investigating to check if something in the format of the path used for the images is causing them to be detected incorrectly, I will update you as soon as possible.
Eric