Schema File for XML data

I already created XSD file and reference in ADF file.
Anyway, the XSD that generated from my XML file have many table. ( you
can try by generate XSD from my actual EventData.xml)
It is not too simple like EventData.xml in Stock application which have
only 2 element for StockSymbol and StockPrice.
My EventData.xml have some node as below
...
...
<files>
<file>
<name>zip</name>
<content>uesdbbqaaaaiaatk0c6r9ck</content>
</file>
</files>
...
...
You will see <name> and <content> that defined inside <files>/<file>.
I don't know how to define node <name> and <content> in ADF (not XSD)
that will generate database table for my application.

It's work if I modify my EventData.xml by remove node
<files>
<file>
</file>
<files>

***************Modified EventData.xml*************
<root>
<NewsID>abcd</NewsID>
  <VendorTime>20030826T</VendorTime>
  <UpdateTime>20030826T</UpdateTime>
  <SourceCode>SWD</SourceCode>
  <OriginalCode>STK</OriginalCode>
  <Headline>sdfsd</Headline>
  <Story>sdfasdf</Story>
<Language>Thai</Language>
<Symbol>BBL</Symbol>
  <Reference>sdfsd</Reference>
  <Name>sfsdf</Name>
<Content>aaaa</Content>
</root>

Then create the XSD file from the modiied EventData.xml.
But my application must support to the actual EventData.xml


The actual EventData.xml must be as below

**************Actual EventData.xml****************
<root>
<newsid>abcd</newsid>
<transaction>add</transaction>
<vendortime>20030826t</vendortime>
<updatetime>20030826t</updatetime>
<sourcecode>swd</sourcecode>
<originalcodes>
<originalcode>stk</originalcode>
</originalcodes>
<headline>asdsdas</headline>
<story>asdasdad</story>
<languages>
<language>thai</language>
</languages>
<symbol>bbl</symbol>
<reference>fsdfsdf</reference>
<files>
<file>
<name>zip</name>
<content>uesdbbqaaaaiaatk0c6r9ck</content>
</file>
</files>
</root>




*** Sent via Developersdex <a style='text-decoration: underline;' href="http://www.developersdex.com" target="_blank">http://www.developersdex.com</a> ***
Don't just participate in USENET...get rewarded for it!<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Schema File for XML data 

I fear that, as far as I know, you *cannot* define an event class on more
than exactly one table on SQL Server: in fact you cannot have more than one
Schema section under the EventClass element in the ADF files.

This means that if you supply an xsd schema the teoretically allows you the
use more than 1 table, you cannot define the database schema (so tables and
their relation) in the ADF file, so, in other words you cannot pratically
import event data that needs to be stored in more than one table.

What you can try to do, but beware that is a dirty trick, is to modify your
database AFTER the NSControl has created it. Since NS uses the SQL XML Bulk
Load function, they *should* be capable of importing data into more than one
table...so if you change the database on your own the solution may work at
the end....but this is just an hypotetic thesis.....i'll try this solution
as soon as possible since it may be interesting anyway.

Davide

PS
Maybe someone at MS can say if what I suppose will effectively work...

"Preeda Intanee" <ipreeda.TakeThisOut@chula.com> wrote in message
news:uOKdBEcoDHA.3700@TK2MSFTNGP11.phx.gbl...
 > I already created XSD file and reference in ADF file.
 > Anyway, the XSD that generated from my XML file have many table. ( you
 > can try by generate XSD from my actual EventData.xml)
 > It is not too simple like EventData.xml in Stock application which have
 > only 2 element for StockSymbol and StockPrice.
 > My EventData.xml have some node as below
 > ..
 > ..
 > <files>
 > <file>
 > <name>zip</name>
 > <content>uesdbbqaaaaiaatk0c6r9ck</content>
 > </file>
 > </files>
 > ..
 > ..
 > You will see <name> and <content> that defined inside <files>/<file>.
 > I don't know how to define node <name> and <content> in ADF (not XSD)
 > that will generate database table for my application.
 >
 > It's work if I modify my EventData.xml by remove node
 > <files>
 > <file>
 > </file>
 > <files>
 >
 > ***************Modified EventData.xml*************
 > <root>
 > <NewsID>abcd</NewsID>
 > <VendorTime>20030826T</VendorTime>
 > <UpdateTime>20030826T</UpdateTime>
 > <SourceCode>SWD</SourceCode>
 > <OriginalCode>STK</OriginalCode>
 > <Headline>sdfsd</Headline>
 > <Story>sdfasdf</Story>
 > <Language>Thai</Language>
 > <Symbol>BBL</Symbol>
 > <Reference>sdfsd</Reference>
 > <Name>sfsdf</Name>
 > <Content>aaaa</Content>
 > </root>
 >
 > Then create the XSD file from the modiied EventData.xml.
 > But my application must support to the actual EventData.xml
 >
 >
 > The actual EventData.xml must be as below
 >
 > **************Actual EventData.xml****************
 > <root>
 > <newsid>abcd</newsid>
 > <transaction>add</transaction>
 > <vendortime>20030826t</vendortime>
 > <updatetime>20030826t</updatetime>
 > <sourcecode>swd</sourcecode>
 > <originalcodes>
 > <originalcode>stk</originalcode>
 > </originalcodes>
 > <headline>asdsdas</headline>
 > <story>asdasdad</story>
 > <languages>
 > <language>thai</language>
 > </languages>
 > <symbol>bbl</symbol>
 > <reference>fsdfsdf</reference>
 > <files>
 > <file>
 > <name>zip</name>
 > <content>uesdbbqaaaaiaatk0c6r9ck</content>
 > </file>
 > </files>
 > </root>
 >
 >
 >
 >
 > *** Sent via Developersdex <a style='text-decoration: underline;' href="http://www.developersdex.com" target="_blank">http://www.developersdex.com</a> ***
 > Don't just participate in USENET...get rewarded for it!<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Schema File for XML data 

It is a good news for me that you understand my problems.
By the way, in the real world EventData.xml might be similar ito my
case.
I would appreciate if you could solve my problems.
I'm waiting for your solution.
Please keep in touch.

Thanks,
Preeda Intanee



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 >> Stay informed about: Schema File for XML data 

Hi

now i cannot try the solution i suggested you since i'm full of work, but i
think you can find a nice help in the SQLXML 3.0 Sp1 Help.

Look for this topic:

Examples of Bulk Loading XML Documents

it tells you how to bulk load xml into multiple tables.

By

Davide

"Preeda Intanee" <ipreeda DeleteThis @chula.com> wrote in message
news:OXscouqoDHA.2416@TK2MSFTNGP10.phx.gbl...
 > It is a good news for me that you understand my problems.
 > By the way, in the real world EventData.xml might be similar ito my
 > case.
 > I would appreciate if you could solve my problems.
 > I'm waiting for your solution.
 > Please keep in touch.
 >
 > Thanks,
 > Preeda Intanee
 >
 >
 >
 > *** Sent via Developersdex <a style='text-decoration: underline;' href="http://www.developersdex.com" target="_blank">http://www.developersdex.com</a> ***
 > Don't just participate in USENET...get rewarded for it!<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Schema File for XML data