XML to CSV

[etherealfocus]

So I've got a 10MB csv file from work that we want to convert to Excel-friendly xml. It's for a Vortx/Aspdotnetstorefront web cart, if it makes a difference. Their csv support is a little lacking in that we can only create new categories on the fly with xml. Considering that we need to import a couple thousand categories, I'd rather not do it by hand.

I've found some free converters on Google but some have 4MB limits, others generate crappy code that Excel doesn't like, etc.

More precisely, Vortx will only export to csv and their import template is in csv, but it supports uploads via xml as well. Their documentation is just messy and incomplete and I'm trying hard to crank this out tonight.

Suggestions? Thanks in advance guys - I've been grinding over this one for a while and so far I've got nothing.

 

[lxskllr]

Doesn't Excel open .csv? Try opening it in LibreOffice Calc, then export in .xml

 

[etherealfocus]

Excel will open csv, but like I said I need to convert to xml to create categories on the fly. Excel won't export to xml without a data map and apparently it takes some proficiency in Visual Basic to create one (according to a random technet article). I could pry figure it out but not sure if I can do it tonight. Could OpenOffice really export without a data map?

 

[etherealfocus]

Excel can handle xml too (apparently with a data map). I haven't been able to find very good documentation on this so might have the specifics wrong.

 

[lxskllr]

Could OpenOffice really export without a data map?

I honestly couldn't say. If you had a test file of non sensitive data, I could try it, and send it back to you to see if it works.

 

[etherealfocus]

Sure, I'd appreciate that. I'll PM you my email address. Thanks!

 

[lxskllr]

I'm not having much luck with this. Perhaps some kind of scripting would be useful. The only problem is coming up with something Excel will like.

 

[etherealfocus]

The best I've come up with so far is a technet article suggesting making a data map in VB. Unfortunately I am not a VB ninja. I'm sure I could figure it out with time, but it's a rush job. :/

Anyone else?