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
LVL 1
isenseAsked:
Who is Participating?
 
Geert BormansInformation ArchitectCommented:
I would suggest the XML IDE products range
eg.
www.oxygenxml.com
www.stylusstudio.com
those products allow easy editing based on an XSD
and they have connectors to relational databases, so you could prefill parts of the XML from Oracle
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.