Data editing tool for XML file based on 3rd party XSD
Posted on 2013-11-04
I have a XSD file which defines a format for data to be collected (provided by an eternal organisation which requires the data in this format).
Some of the data will be entered manually but other data I can get from a query against an ORACLE database
Has any one got a good suggestion for a tool to use to create the XML file from the XSD definition using our data. I don't need to edit the XSD etc. just get the data and output it to the XML file.
I tried using Excel and I could import the XSD file. But when I try to export to XML it gives an error "The XML maps in this file are not exportable"
If I verify the map I get message that it is not exportable due to:
List of Lists
A mapped element's relationship with other elements cannot be preserved