XML converter required

[kremmen]

I have to convert a XML data feed file to a comma separated CSV file so that I can import this file manually to an e-commerce store I am developing.

Currently using a Apple Mac platform but I have access to a PC as well.

If anyone knows of any software that would do this easily, or if there are any online converters for this I would much appreciate this.

Many thanks
Kremmen

[rpgfan3233]

I haven't personally used any software of this sort (I just create my own via PHP or something), but usually things like this are rather easy to find by typing <format1>2<format2> in a Google search. In your case, it would be xml2csv. That should give you quite a few. Here is one that apparently works using Java, meaning that it should be cross-platform:
http://www.downloadtube.com/Mac/Utilities/XML2CSV-download.html

[jbladeus]

These two links provide what you're looking for:

http://www.ricebridge.com/xml-csv-convert.htm
http://www.codeproject.com/KB/vbscript/xml2csv.aspx

[kremmen]

Many thanks to all your help guys

I have now managed to convert an XML to a CSV okay now but I have a slight problem on the output of the CSV.

It shows that I have 8 Categories columns for each product with up to 3000 items, some of the products may have 2 or 5 or even 8 diff category numbers to go into, now what I want to be outputted in the CSV file is 1 columns for each product showing Category number separated by two pipes.

e.g:
ProductA 2053||5689||956
ProductB 5687||6687||321||957||3120
ProductC 2053
ProductD 125||335||147||568

I would be very grateful for your thoughts on this matter


Kremmen

[kremmen]

Hi again

Or could there be something I could tweak in the way the XML feed is configured when getting products.

Here is an example of the feed;

http://yourcompany.com/xml_feed.php?email=your@email&password=yourpassword&products&fields=categories|cat_id|parent_cat_id|cat_name|cat_sort_order|pid|name|p|pev|f|wl|sd|ld|dcc|dcev|dc iv|aic|m|sl|ndd|d|descriptors|descriptor_name|descriptor_label|descriptor_list|piu|fullname|show_to_ public|keywords|product_breadcrumb|breadcrumb_order|thumbnail_product_id|show_items_not_for_sale|des criptors&limit=10


Kremmen