Solved

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

Posted on 2013-11-04
1
339 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Many times while working on a computer regardless of any Operating System, lag and crashes seem to creep in, hindering your working speed. Sometimes, it can also cause your work to be lost unexpectedly and as a result, you are unable to meet your de…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

760 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now