Solved

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

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

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

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

INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
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…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
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…

632 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