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
Rama KadiyalaSubject: Unable to Bulk Load the XML file to SQL Server 2000
Author: Rama Kadiyala
Date: 19 Jun 2006 09:05 AM
Hello All,
I am new to the XML World. What I am trying to do is to load a XML Data file from the xsd file provided to me to SQL SERVER 2000 file. Is there any way for me in Stylus Studio to create a new xsd file from an existing XML file. Any help is greatly appreciated.

Thanks,
Rama

Postnext
Ivan PedruzziSubject: Unable to Bulk Load the XML file to SQL Server 2000
Author: Ivan Pedruzzi
Date: 19 Jun 2006 11:08 AM

Please see under chapter 7 "Creating XML Schema from an XML Document" in the product documentation

http://www.stylusstudio.com/docs/v2006/d_schema7.html#wp644782


Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
Rama KadiyalaSubject: Unable to Bulk Load the XML file to SQL Server 2000
Author: Rama Kadiyala
Date: 19 Jun 2006 11:18 AM
Ivan,
Thanks. That helped a lot, It created a Prod_stylus.xsd from the XML Document. How can I load the XML Data into SQL SERVER 2000?
Can I do it in Stylus?

-Rama.
Broadrange CRM Solutions
847-668-8267

Postnext
Rama KadiyalaSubject: Unable to Bulk Load the XML file to SQL Server 2000
Author: Rama Kadiyala
Date: 19 Jun 2006 11:34 AM
Also I am getting the following errors when I validate the converted XSD document:

-----
Validating prod_samlple_1.xsd...
file:///i:/bh_prod_xml/Script_dev/xsi.xsd:4,68: The {target namespace} of 'noNamespaceSchemaLocation' must not match 'http://www.w3.org/2001/XMLSchema-instance'.
file:///i:/bh_prod_xml/Script_dev/xsi.xsd:5,30: The {target namespace} of 'type' must not match 'http://www.w3.org/2001/XMLSchema-instance'.
file:///i:/bh_prod_xml/Script_dev/prod_samlple_1.xsd:32,56: Could not find top level attribute: xsi:type
file:///i:/bh_prod_xml/Script_dev/prod_samlple_1.xsd:9,73: Could not find top level attribute: xsi:noNamespaceSchemaLocation

The XML document prod_samlple_1.xsd is NOT valid (4 errors)
--------------

Thanks,
Rama

Postnext
Ivan PedruzziSubject: Unable to Bulk Load the XML file to SQL Server 2000
Author: Ivan Pedruzzi
Date: 19 Jun 2006 11:48 AM

Stylus Studio dos not provide direct support for the SQL Server bulk load.


Which Stylus Studio version are you running?

If possible could you please send to us (stylus-field-report@progress.com) the XML document you are trying to use to generate the schema?

Thank You for your help
Ivan Pedruzzi
Stylus Studio Team

Postnext
Rama KadiyalaSubject: Unable to Bulk Load the XML file to SQL Server 2000
Author: Rama Kadiyala
Date: 19 Jun 2006 11:56 AM
Ivan,
Sent Prod_sample.xml file.

Thanks,
Rama

Posttop
Ivan PedruzziSubject: Unable to Bulk Load the XML file to SQL Server 2000
Author: Ivan Pedruzzi
Date: 19 Jun 2006 01:04 PM
Rama,

Your XML document is already pointiong to an existing XML Schema

The document root has the attribute xsi:noNamespaceSchemaLocation

<Products
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://registry.bighammer.com/schema/2004/10/Import.xsd">

The schema is located at
http://registry.bighammer.com/schema/2004/10/Import.xsd

What you really need is the mapping file, as described on the Microsoft support site
http://support.microsoft.com/?scid=316005

Stylus Studio doesn't provide an automatic way to create the mapping file, but you can still use the XML editor in conjution with the File Explorer to browse which table/columns you wish to map.


Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
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.