Martyn Kenyon
asked on
Data editing tool for XML file based on 3rd party XSD
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
Denormalised data
A mapped element's relationship with other elements cannot be preserved
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
Denormalised data
A mapped element's relationship with other elements cannot be preserved
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.