Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2013-11-04
1
Medium Priority
?
361 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
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…

688 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