XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Liz StanleySubject: Exporting XML to SQL
Author: Liz Stanley
Date: 24 Oct 2005 09:18 AM
Originally Posted: 24 Oct 2005 06:06 AM
I'm new to XML and StyleStudio so I apologise if I'm asking a really stupid question. I have to convert an XML file created by one of our suppliers to SQL. I thought I would create a dummy SQL table with just a few of the fields to test importing the XML but I'm falling at every hurdle. In an ideal world I would like the XML to create the table and populate it - is this possible? I found a very helpful posting by Ivan Pedruzzi that talked me through bulk loading an XML file into a single table but I get "Document root element is missing" when I run it. Thanks in advance for any help. Regards Liz

Postnext
(Deleted User) Subject: Exporting XML to SQL
Author: (Deleted User)
Date: 24 Oct 2005 09:15 AM
Hi Liz,

Can you publish XML file you want to transform into a table here ?
We need this to help you create proper SQL/XML.

Postnext
Liz StanleySubject: Exporting XML to SQL
Author: Liz Stanley
Date: 24 Oct 2005 09:24 AM
Thanks for replying Yuriy
The actual XML is over 10meg so I've made a cut down version - hopefully I've only deleted data and nothing vital!
Here it is:

Regards
Liz


DocumentListed.xml
Listed.xml

Postnext
(Deleted User) Subject: Exporting XML to SQL
Author: (Deleted User)
Date: 24 Oct 2005 12:18 PM
From this XML it looks like you'll have to create multiple tables in your relational DB. At least it looks like :

<designations><designation>
<characters><character>

prompts for the tables "Destinations" and "Characters"

if this is the case, you will probably have to write C++, C# or Java application to perform this job. Stylus Studio does not support multiple table inserts.

Posttop
Liz StanleySubject: Exporting XML to SQL
Author: Liz Stanley
Date: 25 Oct 2005 02:54 AM
Thanks for all your time and for pointing me in the right direction Yuriy.
Regards
Liz

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.