Solved

Data editing tool for XML file based on 3rd party XSD

Posted on 2013-11-04
1
341 Views
Last Modified: 2013-11-07
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
0
Comment
Question by:isense
1 Comment
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 500 total points
ID: 39626150
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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to DocumentFormat 8 93
robocopy vs xcopy vs copy 8 110
XML XSLT If loop 4 26
Powershell script to zip up xml files in a directory 13 14
Log files are useful in diagnosing and repairing problems.  This is a list of common log files and their standard locations that I've compiled.   While this is not exhaustive, it is a pretty good list that I've found to be useful.  I may update it f…
Many admins will agree: WSUS is is a nice invention but using it on the client side when updating a newly installed computer is still time consuming as you have to do several reboots and furthermore, the procedure of installing updates, rebooting an…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question