XML to CSV ... and back

[asearle]

For a data-exchange scenario, I need to be able to tansform a rather complex XML structure into CSV ... and back again.

I could programme this but am hoping to find a tool that could cut down some of the 'leg-work'.

The authority which manages the exchange provides ample XSL and XSD files and structure-descriptions which we are hoping to use.

There seem to be a number of tools around (e.g. XML2CSV and others) so I am wondering what is recommended? Command-line or graphical? Based on which language?

Our first version will probably be called up from Excel (using VB) but once we have proved the concept we would like to use a language which will also run on a Unix server.

Any tips or links to tutorials would be a great help.

Regards,
Alan

[RedSon]

Your best source for this kind of information is google.

[asearle]

I agree: Google is the source. But I feel overwhealmed by the quantity of information and was hoping that someone could point me towards their 'pet tool'.

So far I really think that I can use XSLT to get the XML into CSV. That looks very good.

And I could programmaticall y convert the CSV into XML but I was wondering whether there is an easier way to convert CSV to XML? That would be a help.

But, yes, I am googling ... and I will post my findings just in case someone finds them helpful.

All the best,
Alan