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
Sebastian KruseSubject: Generating Schema question
Author: Sebastian Kruse
Date: 02 Sep 2004 06:07 AM
Hello,
when creating an xml-Schema from an xml file, Stylus Studio creates 5 Schema-files. (Besides they are not well-formed, but that is the smallest problem I got...)
My question now is: Is it possible to create just one Schema-file from my xml-file or will Stylus Studio always create more than one Schema-file?
Any help/advice would be very useful to me. :)
Thanks in advance,
Sebastian

P.S. I've been looking in the forum for topics which could help me, but I didn'd find anything. So please don't be mad at me, telling me things like "Search the forum stupid..." ;)

Postnext
Ivan PedruzziSubject: Generating Schema question
Author: Ivan Pedruzzi
Date: 02 Sep 2004 06:37 PM
Hi Sebastian,

Could you send me (mailto:ipedruzz@progress.com) the XML document you are using?

Thanks
Ivan

Postnext
Sebastian KruseSubject: Generating Schema question
Author: Sebastian Kruse
Date: 03 Sep 2004 08:12 AM
Hello Ivan,
I'm afraid that's not possible, because it contains company-data of which I'm not allowed to send to anyone outside of the company. :(

But here are some informations about the XML-File:
It has been created with the document wizard (ADO to XML, so it has been created from database tables of a MS SQL Database).
It consists of 1055 lines.

I don't know if this could be useful or not...if you need further information, please let me know. (Also, please let me know if the information given about the XML-File are relevant for you or not...) ;)

Well, thanks in advance :)
Sebastian

Postnext
Ivan PedruzziSubject: Generating Schema question
Author: Ivan Pedruzzi
Date: 03 Sep 2004 10:37 PM
Hi Sebastian,

I did the following experiment:

- Use ADO to XML to import the table "Region" from the sample SQLServer database Northwind.
the result is the following file

<?xml version="1.0"?>
<xml
xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset"
xmlns:z="#RowsetSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="ADOtoXML.xsd">

<s:Schema id="RowsetSchema">
<s:ElementType name="row" content="eltOnly">
<s:AttributeType name="RegionID" rs:number="1" rs:writeunknown="true">
<s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="RegionDescription" rs:number="2" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" rs:fixedlength="true" rs:maybenull="false"/>
</s:AttributeType>
<s:extends type="rs:rowbase"/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row RegionID="1" RegionDescription="Eastern"/>
<z:row RegionID="2" RegionDescription="Western"/>
<z:row RegionID="3" RegionDescription="Northern"/>
<z:row RegionID="4" RegionDescription="Southern"/>
</rs:data>
</xml>

As you can see the document uses multiple namespace; because XML schema can have only one target namespace the algorithm has to create multiples XML Schemas.

The schemas seem to be correct and I was able to validate the xml document using MSXML, XalanJ, Xerces and XSV.

If you would like to have more control you could try to use SQL/XML (DB to XML data source).
Here what I did:

Using the following query

SELECT
XMLELEMENT(name "row",
XMLELEMENT(name "RegionID",t.RegionID),
XMLELEMENT(name "RegionDescription",t.RegionDescription)
)
FROM Northwind.dbo.Region t

I generated a simpler document

<?xml version="1.0" encoding="UTF-8"?>
<root>
<row>
<RegionID>1</RegionID>
<RegionDescription>Eastern</RegionDescription>
</row>
<row>
<RegionID>2</RegionID>
<RegionDescription>Western</RegionDescription>
</row>
<row>
<RegionID>3</RegionID>
<RegionDescription>Northern</RegionDescription>
</row>
<row>
<RegionID>4</RegionID>
<RegionDescription>Southern</RegionDescription>
</row>
</root>

then I created the schema


<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
<xs:element name="root">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" ref="row"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="row">
<xs:complexType>
<xs:sequence>
<xs:element ref="RegionID"/>
<xs:element ref="RegionDescription"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="RegionID" type="xs:integer"/>
<xs:element name="RegionDescription" type="xs:string"/>
</xs:schema>


Hope this helps
Ivan

Posttop
Sebastian KruseSubject: Generating Schema question
Author: Sebastian Kruse
Date: 06 Sep 2004 09:57 AM
Hi Ivan,
in fact, this helps me very much.
Thank you very much for your efforts! :)

Sebastian

 
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.