For a data-exchange scenario, we need to be able to transform a rather complex XML structure into CSV ... and back again.
We could programme this but I 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) but some of them seem to be rather limited and I am not sure how they would handle more complex XML structures. Anyway, 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.