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
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
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)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Still had to figure out some things, but the tips helped me.
http://www.w3schools.com/xsl/default.asp
Try it yourself:
http://www.w3schools.com/xsl/tryxslt.asp?xmlfile=cdcatalog&xsltfile=cdcatalog