Link to home
Start Free TrialLog in
Avatar of Johan85
Johan85

asked on

Convert XML to CSV File

Hi,

I need to convert an XML file to CSV for an import into a websop. I tried different free tools, but I still don't get a good result.

Can anyone help me with that, the file is attached. Thanks in advance.
products.xml
Avatar of Om Prakash
Om Prakash
Flag of India image

hello.
I've examined your file (products.xml) and i found that there is an incosistency at <![CDATA[Douchekop Rain 2½"] .
the quote (two and a half inches)  messes  your xml structure a lot .
 is there a way of getting a "cleaner" version of the file? (without styling in some records)
ASKER CERTIFIED SOLUTION
Avatar of Gertone (Geert Bormans)
Gertone (Geert Bormans)
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have not checked the spec completely
http://tools.ietf.org/html/rfc4180
but there appears to be some confusion

some sources say that a " should always be escaped with ""
if your importing application expects that, I need to change the code slightly

have fun

Geert
Avatar of Johan85
Johan85

ASKER

Still had to figure out some things, but the tips helped me.