Trying to take the result from a report on RS exported as XML via URLSyntax
Ex.
http://servername/ReportServer?/folder/reportName&customerName=customerName&rs:Command=Render&rs:Format=XML
This example renders a XML-document, trying to use Microsoft.XMLHTTP, ASP to
get the data from server.
Sample:
-set xml=server.createObject("Microsoft.XMLHTTP")
-xml.open "GET", XMLURL, false
-xml.send
-xml.responseText
No problems so far, the document is there.
Is there anyone out there who can tell me how to use XSLT serverside
together with above XML.
best regards
Kjell BrandesKjell,
You can assign XSLT using the Data Output tab (Data Transform field) on the
report properties.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Kjell Brandes" <kjell@.brandes.tv> wrote in message news:e2gMQDtqEHA.556@.
tk2msftngp13.phx.gbl...
> Trying to take the result from a report on RS exported as XML via
URLSyntax
> Ex.
>
http://servername/ReportServer?/folder/reportName&customerName=customerName&rs:Command=Render&rs:Format=XML
>
> This example renders a XML-document, trying to use Microsoft.XMLHTTP, ASP
to
> get the data from server.
> Sample:
> -set xml=server.createObject("Microsoft.XMLHTTP")
> -xml.open "GET", XMLURL, false
> -xml.send
> -xml.responseText
> No problems so far, the document is there.
> Is there anyone out there who can tell me how to use XSLT serverside
> together with above XML.
> best regards
> Kjell Brandes
>
Showing posts with label xml. Show all posts
Showing posts with label xml. Show all posts
Tuesday, March 20, 2012
Monday, March 12, 2012
Pls help. new to xml.
If an assembly Box consists of Parts listed how do I retrieve record set
that lists
Box and all its parts as
Assembly Part
-- --
Box 1-400-53
Box 1-1-45
Box 1-2-47
and so on.
Thank you so much for your help.
Farmer
DECLARE @.XmlDocumentHandle int
DECLARE @.XmlDocument nvarchar(1000)
SET @.XmlDocument = N'<ROOT>
<Assembly>
<Name>Box</Name>
<Part>1-400-53</Part>
<Part>1-1-45</Part>
<Part>1-2-47</Part>
<Part>1-802-57</Part>
<Part>1-300-48</Part>
<Part>1-851-55</Part>
<Part>1-850-54</Part>
<Part>1-800-52</Part>
<Part>1-801-50</Part>
<Part>1-700-56</Part>
<Part>1-1260-49</Part>
<Part>1-1260-44</Part>
<Part>1-1260-46</Part>
<Part>1-1260-58</Part>
<Part>1-1260-51</Part>
</Assembly>
</ROOT>'
-- Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @.XmlDocumentHandle OUTPUT, @.XmlDocument
-- Execute a SELECT stmt using OPENXML rowset provider.
SELECT *
FROM OPENXML(@.XmlDocumentHandle, N'/ROOT/Assembly', 2)
WITH (
AssName varchar(25) 'Name'
,Part varchar(25) 'Part'
)
EXEC sp_xml_removedocument @.XmlDocumentHandleHello Farmer,
> If an assembly Box consists of Parts listed how do I retrieve record
> set that lists
Um, you cheat... :)
SELECT *
FROM OPENXML(@.XmlDocumentHandle, N'/ROOT/Assembly/Part', 2)
WITH (
AssName varchar(25) '../Name',
Part varchar(25) '.'
)
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||I can't pass my judgement if it is "cheating" but it works. Thank you.
If understand it correctly, you extended path to read the dataset based on
Part as a tag instead of Assembly.
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad74273e18c82ad3ef4dd330@.news.microsoft.com...
> Hello Farmer,
>
> Um, you cheat... :)
> SELECT *
> FROM OPENXML(@.XmlDocumentHandle, N'/ROOT/Assembly/Part', 2)
> WITH (
> AssName varchar(25) '../Name',
> Part varchar(25) '.'
> )
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>|||Hi,
Actually, you should use this method because you need to navigate to the
element that should be mapped to a row in the row pattern
Otherwise, openxml only recognize one subelement.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--
<b87ad74273e18c82ad3ef4dd330@.news.microsoft.com>
on|||Hi
How do I implement it the other way round; i.e. convert SQL Column into
a XML type?|||Hi,
Since our Newsgruop is an issue based support. Would you please open a new
post and describe your concern in detail. We are glad to be of assistance.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--
19:49:23 GMT)
.NET CLR 1.1.4322; .NET CLR 2.0. 50727),gzip(gfe),gzip(gfe)[color=darkred
]
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed00
.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!border1.nntp.dca.
giganews.com!nntp.giganews.com!postnews.google.com!v46g2000cwv.googlegroups.
com!not-for-mail|||Look at the FOR XML functionality...
Best regards
Michael
<prabhupr@.hotmail.com> wrote in message
news:1144871356.496917.315650@.v46g2000cwv.googlegroups.com...
> Hi
> How do I implement it the other way round; i.e. convert SQL Column into
> a XML type?
>
that lists
Box and all its parts as
Assembly Part
-- --
Box 1-400-53
Box 1-1-45
Box 1-2-47
and so on.
Thank you so much for your help.
Farmer
DECLARE @.XmlDocumentHandle int
DECLARE @.XmlDocument nvarchar(1000)
SET @.XmlDocument = N'<ROOT>
<Assembly>
<Name>Box</Name>
<Part>1-400-53</Part>
<Part>1-1-45</Part>
<Part>1-2-47</Part>
<Part>1-802-57</Part>
<Part>1-300-48</Part>
<Part>1-851-55</Part>
<Part>1-850-54</Part>
<Part>1-800-52</Part>
<Part>1-801-50</Part>
<Part>1-700-56</Part>
<Part>1-1260-49</Part>
<Part>1-1260-44</Part>
<Part>1-1260-46</Part>
<Part>1-1260-58</Part>
<Part>1-1260-51</Part>
</Assembly>
</ROOT>'
-- Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @.XmlDocumentHandle OUTPUT, @.XmlDocument
-- Execute a SELECT stmt using OPENXML rowset provider.
SELECT *
FROM OPENXML(@.XmlDocumentHandle, N'/ROOT/Assembly', 2)
WITH (
AssName varchar(25) 'Name'
,Part varchar(25) 'Part'
)
EXEC sp_xml_removedocument @.XmlDocumentHandleHello Farmer,
> If an assembly Box consists of Parts listed how do I retrieve record
> set that lists
Um, you cheat... :)
SELECT *
FROM OPENXML(@.XmlDocumentHandle, N'/ROOT/Assembly/Part', 2)
WITH (
AssName varchar(25) '../Name',
Part varchar(25) '.'
)
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||I can't pass my judgement if it is "cheating" but it works. Thank you.
If understand it correctly, you extended path to read the dataset based on
Part as a tag instead of Assembly.
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad74273e18c82ad3ef4dd330@.news.microsoft.com...
> Hello Farmer,
>
> Um, you cheat... :)
> SELECT *
> FROM OPENXML(@.XmlDocumentHandle, N'/ROOT/Assembly/Part', 2)
> WITH (
> AssName varchar(25) '../Name',
> Part varchar(25) '.'
> )
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>|||Hi,
Actually, you should use this method because you need to navigate to the
element that should be mapped to a row in the row pattern
Otherwise, openxml only recognize one subelement.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--
<b87ad74273e18c82ad3ef4dd330@.news.microsoft.com>
on|||Hi
How do I implement it the other way round; i.e. convert SQL Column into
a XML type?|||Hi,
Since our Newsgruop is an issue based support. Would you please open a new
post and describe your concern in detail. We are glad to be of assistance.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--
19:49:23 GMT)
.NET CLR 1.1.4322; .NET CLR 2.0. 50727),gzip(gfe),gzip(gfe)[color=darkred
]
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed00
.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!border1.nntp.dca.
giganews.com!nntp.giganews.com!postnews.google.com!v46g2000cwv.googlegroups.
com!not-for-mail|||Look at the FOR XML functionality...
Best regards
Michael
<prabhupr@.hotmail.com> wrote in message
news:1144871356.496917.315650@.v46g2000cwv.googlegroups.com...
> Hi
> How do I implement it the other way round; i.e. convert SQL Column into
> a XML type?
>
Saturday, February 25, 2012
Please help. i need to create an XSD and dont know how!
hello all.
i attached an xml that need to put data into and sql server tables
i having probleams creating the XSD schema.
i allready have the tables in the sql
i am using the SQLXMLBulkLoad object. and wrote a program with vb.net that
do it.
it's work fine for simple xml and Xsd .
i need help writing the xsd that will insert to data into 2 tables with
relation (that i created )
attached the xml
please help
thanks
<?xml version = '1.0'?>
<ROWSET>
<ROW num="1">
<JOB_NUMBER>3</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>WC E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>10000</ASSEMBLY_QUANTITY>
<CUSTOMER_NUMBER>??? ?????? ?????</CUSTOMER_NUMBER>
<PRODUCTION_LINE>L02</PRODUCTION_LINE>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Released</JOB_STATUS>
<LOT_NUMBER>3</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1200</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>3220</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>160</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>50</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>100</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>5020</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>2.5</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>42.999656</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>30.0003</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="2">
<JOB_NUMBER>4</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>11PVCNZ0004B</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>SOLVIN 270PF SOLVAY</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Unreleased</JOB_STATUS>
<COMPONENTS/>
<OPERATIONS/>
</ROW>
<ROW num="3">
<JOB_NUMBER>5</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>347200000000</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>P.V.C SOFT 472/NAT.0000</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
<BULK_DENSITY>44949</BULK_DENSITY>
<PPG>JHY0992</PPG>
<HUMIDITY__PERMITTED>0.998</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Unreleased</JOB_STATUS>
<COMPONENTS/>
<OPERATIONS/>
</ROW>
<ROW num="4">
<JOB_NUMBER>6</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>2</ASSEMBLY_QUANTITY>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Released</JOB_STATUS>
<LOT_NUMBER>6</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.24</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.644</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.032</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.02</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1.004</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="5">
<JOB_NUMBER>7</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Complete</JOB_STATUS>
<LOT_NUMBER>7</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.12</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.322</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.016</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.005</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.502</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="7">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBLX00034</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>AKROPAN 2143GX
AKDENIZ</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.025536</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="6">
<JOB_NUMBER>9</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
<CUSTOMER_NUMBER>??? ?????? ?????</CUSTOMER_NUMBER>
<PACK_TYPE>PE BAG WITHOUT LOGO</PACK_TYPE>
<PACK_CODE>PBR</PACK_CODE>
<PALLET_SIZE_TYPE>TELMA PALLET HOLIS</PALLET_SIZE_TYPE>
<MARKED_PACK>REGULAR STANDARD LABEL</MARKED_PACK>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Complete</JOB_STATUS>
<LOT_NUMBER>010508001</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>1</OPERATION_SEQ_NUM>
<COMPONENT_ITEM>3E1120102390</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>W&C
E-112/WHITE-1239</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS/>
</ROW>
</ROWSET>
Here is what I do.
Read this into a data set and then write it out using the WriteXMLSchema
method.
Here is a brief example in c#.
DataSet ds = new DataSet("MyXML");
ds.ReadXml("C:\\c53a1602ff3011d48d140004ac5e3ab0.x ml");
ds.WriteXmlSchema("C:\\MyXML.xsd");
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlxml problem Please help"
<sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
news:3B1097A3-88B2-432F-8CA9-FACB0C063997@.microsoft.com...
> hello all.
> i attached an xml that need to put data into and sql server tables
> i having probleams creating the XSD schema.
> i allready have the tables in the sql
> i am using the SQLXMLBulkLoad object. and wrote a program with vb.net
> that
> do it.
> it's work fine for simple xml and Xsd .
> i need help writing the xsd that will insert to data into 2 tables with
> relation (that i created )
> attached the xml
> please help
> thanks
>
> <?xml version = '1.0'?>
> <ROWSET>
> <ROW num="1">
> <JOB_NUMBER>3</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>WC E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>10000</ASSEMBLY_QUANTITY>
> <CUSTOMER_NUMBER>? ? ??</CUSTOMER_NUMBER>
> <PRODUCTION_LINE>L02</PRODUCTION_LINE>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Released</JOB_STATUS>
> <LOT_NUMBER>3</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1200</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>3220</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>160</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>50</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>100</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>5020</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>2.5</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>42.999656</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>30.0003</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="2">
> <JOB_NUMBER>4</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>11PVCNZ0004B</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>SOLVIN 270PF SOLVAY</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Unreleased</JOB_STATUS>
> <COMPONENTS/>
> <OPERATIONS/>
> </ROW>
> <ROW num="3">
> <JOB_NUMBER>5</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>347200000000</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>P.V.C SOFT 472/NAT.0000</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>44949</BULK_DENSITY>
> <PPG>JHY0992</PPG>
> <HUMIDITY__PERMITTED>0.998</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Unreleased</JOB_STATUS>
> <COMPONENTS/>
> <OPERATIONS/>
> </ROW>
> <ROW num="4">
> <JOB_NUMBER>6</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>2</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Released</JOB_STATUS>
> <LOT_NUMBER>6</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.24</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.644</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.032</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.02</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1.004</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="5">
> <JOB_NUMBER>7</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Complete</JOB_STATUS>
> <LOT_NUMBER>7</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.12</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.322</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.016</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.005</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.502</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="7">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBLX00034</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>AKROPAN 2143GX
> AKDENIZ</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.025536</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="6">
> <JOB_NUMBER>9</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
> <CUSTOMER_NUMBER>? ? ??</CUSTOMER_NUMBER>
> <PACK_TYPE>PE BAG WITHOUT LOGO</PACK_TYPE>
> <PACK_CODE>PBR</PACK_CODE>
> <PALLET_SIZE_TYPE>TELMA PALLET HOLIS</PALLET_SIZE_TYPE>
> <MARKED_PACK>REGULAR STANDARD LABEL</MARKED_PACK>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Complete</JOB_STATUS>
> <LOT_NUMBER>010508001</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>1</OPERATION_SEQ_NUM>
> <COMPONENT_ITEM>3E1120102390</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>W&C
> E-112/WHITE-1239</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS/>
> </ROW>
> </ROWSET>
|||Dear Hilary
i need to write a Mapping Scehma.
which i do not know to to do.
can you please help me.
i allredy write a source in vb.net that read the XML and The XSD and insert
into SQL
all i need is the right schema according to the XML below
thanks.
"Hilary Cotter" wrote:
[vbcol=seagreen]
> Here is what I do.
> Read this into a data set and then write it out using the WriteXMLSchema
> method.
> Here is a brief example in c#.
> DataSet ds = new DataSet("MyXML");
> ds.ReadXml("C:\\c53a1602ff3011d48d140004ac5e3ab0.x ml");
> ds.WriteXmlSchema("C:\\MyXML.xsd");
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sqlxml problem Please help"
> <sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
> news:3B1097A3-88B2-432F-8CA9-FACB0C063997@.microsoft.com...
|||I normally do this as part of a manual process. I create stored procedures
to fire the xml data into the respective tables.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlxml problem Please help"
<sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
news:1D7DBF7A-E015-448C-883C-72839C357484@.microsoft.com...[vbcol=seagreen]
> Dear Hilary
> i need to write a Mapping Scehma.
> which i do not know to to do.
> can you please help me.
> i allredy write a source in vb.net that read the XML and The XSD and
> insert
> into SQL
> all i need is the right schema according to the XML below
> thanks.
> "Hilary Cotter" wrote:
|||You can also open the Xml file in the Xml editor (in VS 2005) and click on
the create schema icon.
To get the mapping information check-out the SQLXML help.
Thanks,
Avner Aharoni[MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hilary Cotter" wrote:
[vbcol=seagreen]
> I normally do this as part of a manual process. I create stored procedures
> to fire the xml data into the respective tables.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sqlxml problem Please help"
> <sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
> news:1D7DBF7A-E015-448C-883C-72839C357484@.microsoft.com...
i attached an xml that need to put data into and sql server tables
i having probleams creating the XSD schema.
i allready have the tables in the sql
i am using the SQLXMLBulkLoad object. and wrote a program with vb.net that
do it.
it's work fine for simple xml and Xsd .
i need help writing the xsd that will insert to data into 2 tables with
relation (that i created )
attached the xml
please help
thanks
<?xml version = '1.0'?>
<ROWSET>
<ROW num="1">
<JOB_NUMBER>3</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>WC E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>10000</ASSEMBLY_QUANTITY>
<CUSTOMER_NUMBER>??? ?????? ?????</CUSTOMER_NUMBER>
<PRODUCTION_LINE>L02</PRODUCTION_LINE>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Released</JOB_STATUS>
<LOT_NUMBER>3</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1200</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>3220</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>160</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>50</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>100</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>5020</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>2.5</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>42.999656</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>30.0003</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="2">
<JOB_NUMBER>4</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>11PVCNZ0004B</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>SOLVIN 270PF SOLVAY</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Unreleased</JOB_STATUS>
<COMPONENTS/>
<OPERATIONS/>
</ROW>
<ROW num="3">
<JOB_NUMBER>5</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>347200000000</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>P.V.C SOFT 472/NAT.0000</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
<BULK_DENSITY>44949</BULK_DENSITY>
<PPG>JHY0992</PPG>
<HUMIDITY__PERMITTED>0.998</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Unreleased</JOB_STATUS>
<COMPONENTS/>
<OPERATIONS/>
</ROW>
<ROW num="4">
<JOB_NUMBER>6</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>2</ASSEMBLY_QUANTITY>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Released</JOB_STATUS>
<LOT_NUMBER>6</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.24</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.644</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.032</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.02</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1.004</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="5">
<JOB_NUMBER>7</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Complete</JOB_STATUS>
<LOT_NUMBER>7</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.12</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.322</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.016</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.005</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.502</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="7">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBLX00034</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>AKROPAN 2143GX
AKDENIZ</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.025536</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="6">
<JOB_NUMBER>9</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
<CUSTOMER_NUMBER>??? ?????? ?????</CUSTOMER_NUMBER>
<PACK_TYPE>PE BAG WITHOUT LOGO</PACK_TYPE>
<PACK_CODE>PBR</PACK_CODE>
<PALLET_SIZE_TYPE>TELMA PALLET HOLIS</PALLET_SIZE_TYPE>
<MARKED_PACK>REGULAR STANDARD LABEL</MARKED_PACK>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Complete</JOB_STATUS>
<LOT_NUMBER>010508001</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>1</OPERATION_SEQ_NUM>
<COMPONENT_ITEM>3E1120102390</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>W&C
E-112/WHITE-1239</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS/>
</ROW>
</ROWSET>
Here is what I do.
Read this into a data set and then write it out using the WriteXMLSchema
method.
Here is a brief example in c#.
DataSet ds = new DataSet("MyXML");
ds.ReadXml("C:\\c53a1602ff3011d48d140004ac5e3ab0.x ml");
ds.WriteXmlSchema("C:\\MyXML.xsd");
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlxml problem Please help"
<sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
news:3B1097A3-88B2-432F-8CA9-FACB0C063997@.microsoft.com...
> hello all.
> i attached an xml that need to put data into and sql server tables
> i having probleams creating the XSD schema.
> i allready have the tables in the sql
> i am using the SQLXMLBulkLoad object. and wrote a program with vb.net
> that
> do it.
> it's work fine for simple xml and Xsd .
> i need help writing the xsd that will insert to data into 2 tables with
> relation (that i created )
> attached the xml
> please help
> thanks
>
> <?xml version = '1.0'?>
> <ROWSET>
> <ROW num="1">
> <JOB_NUMBER>3</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>WC E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>10000</ASSEMBLY_QUANTITY>
> <CUSTOMER_NUMBER>? ? ??</CUSTOMER_NUMBER>
> <PRODUCTION_LINE>L02</PRODUCTION_LINE>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Released</JOB_STATUS>
> <LOT_NUMBER>3</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1200</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>3220</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>160</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>50</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>100</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>5020</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>2.5</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>42.999656</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>30.0003</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="2">
> <JOB_NUMBER>4</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>11PVCNZ0004B</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>SOLVIN 270PF SOLVAY</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Unreleased</JOB_STATUS>
> <COMPONENTS/>
> <OPERATIONS/>
> </ROW>
> <ROW num="3">
> <JOB_NUMBER>5</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>347200000000</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>P.V.C SOFT 472/NAT.0000</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>44949</BULK_DENSITY>
> <PPG>JHY0992</PPG>
> <HUMIDITY__PERMITTED>0.998</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Unreleased</JOB_STATUS>
> <COMPONENTS/>
> <OPERATIONS/>
> </ROW>
> <ROW num="4">
> <JOB_NUMBER>6</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>2</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Released</JOB_STATUS>
> <LOT_NUMBER>6</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.24</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.644</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.032</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.02</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1.004</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="5">
> <JOB_NUMBER>7</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Complete</JOB_STATUS>
> <LOT_NUMBER>7</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.12</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.322</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.016</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.005</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.502</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="7">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBLX00034</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>AKROPAN 2143GX
> AKDENIZ</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.025536</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="6">
> <JOB_NUMBER>9</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
> <CUSTOMER_NUMBER>? ? ??</CUSTOMER_NUMBER>
> <PACK_TYPE>PE BAG WITHOUT LOGO</PACK_TYPE>
> <PACK_CODE>PBR</PACK_CODE>
> <PALLET_SIZE_TYPE>TELMA PALLET HOLIS</PALLET_SIZE_TYPE>
> <MARKED_PACK>REGULAR STANDARD LABEL</MARKED_PACK>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Complete</JOB_STATUS>
> <LOT_NUMBER>010508001</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>1</OPERATION_SEQ_NUM>
> <COMPONENT_ITEM>3E1120102390</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>W&C
> E-112/WHITE-1239</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS/>
> </ROW>
> </ROWSET>
|||Dear Hilary
i need to write a Mapping Scehma.
which i do not know to to do.
can you please help me.
i allredy write a source in vb.net that read the XML and The XSD and insert
into SQL
all i need is the right schema according to the XML below
thanks.
"Hilary Cotter" wrote:
[vbcol=seagreen]
> Here is what I do.
> Read this into a data set and then write it out using the WriteXMLSchema
> method.
> Here is a brief example in c#.
> DataSet ds = new DataSet("MyXML");
> ds.ReadXml("C:\\c53a1602ff3011d48d140004ac5e3ab0.x ml");
> ds.WriteXmlSchema("C:\\MyXML.xsd");
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sqlxml problem Please help"
> <sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
> news:3B1097A3-88B2-432F-8CA9-FACB0C063997@.microsoft.com...
|||I normally do this as part of a manual process. I create stored procedures
to fire the xml data into the respective tables.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlxml problem Please help"
<sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
news:1D7DBF7A-E015-448C-883C-72839C357484@.microsoft.com...[vbcol=seagreen]
> Dear Hilary
> i need to write a Mapping Scehma.
> which i do not know to to do.
> can you please help me.
> i allredy write a source in vb.net that read the XML and The XSD and
> insert
> into SQL
> all i need is the right schema according to the XML below
> thanks.
> "Hilary Cotter" wrote:
|||You can also open the Xml file in the Xml editor (in VS 2005) and click on
the create schema icon.
To get the mapping information check-out the SQLXML help.
Thanks,
Avner Aharoni[MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hilary Cotter" wrote:
[vbcol=seagreen]
> I normally do this as part of a manual process. I create stored procedures
> to fire the xml data into the respective tables.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sqlxml problem Please help"
> <sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
> news:1D7DBF7A-E015-448C-883C-72839C357484@.microsoft.com...
Please help. i need to create an XSD and dont know how!
hello all.
i attached an xml that need to put data into and sql server tables
i having probleams creating the XSD schema.
i allready have the tables in the sql
i am using the SQLXMLBulkLoad object. and wrote a program with vb.net that
do it.
it's work fine for simple xml and Xsd .
i need help writing the xsd that will insert to data into 2 tables with
relation (that i created )
attached the xml
please help
thanks
<?xml version = '1.0'?>
<ROWSET>
<ROW num="1">
<JOB_NUMBER>3</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>WC E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>10000</ASSEMBLY_QUANTITY>
<CUSTOMER_NUMBER>??? ?????? ?????</CUSTOMER_NUMBER>
<PRODUCTION_LINE>L02</PRODUCTION_LINE>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Released</JOB_STATUS>
<LOT_NUMBER>3</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1200</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>3220</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>160</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>50</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>100</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>5020</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>2.5</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>42.999656</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>30.0003</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="2">
<JOB_NUMBER>4</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>11PVCNZ0004B</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>SOLVIN 270PF SOLVAY</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Unreleased</JOB_STATUS>
<COMPONENTS/>
<OPERATIONS/>
</ROW>
<ROW num="3">
<JOB_NUMBER>5</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>347200000000</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>P.V.C SOFT 472/NAT.0000</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
<BULK_DENSITY>44949</BULK_DENSITY>
<PPG>JHY0992</PPG>
<HUMIDITY__PERMITTED>0.998</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Unreleased</JOB_STATUS>
<COMPONENTS/>
<OPERATIONS/>
</ROW>
<ROW num="4">
<JOB_NUMBER>6</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>2</ASSEMBLY_QUANTITY>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Released</JOB_STATUS>
<LOT_NUMBER>6</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.24</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.644</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.032</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.02</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1.004</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="5">
<JOB_NUMBER>7</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Complete</JOB_STATUS>
<LOT_NUMBER>7</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.12</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.322</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.016</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.005</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.502</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="7">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBLX00034</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>AKROPAN 2143GX
AKDENIZ</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.025536</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="6">
<JOB_NUMBER>9</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
<CUSTOMER_NUMBER>??? ?????? ?????</CUSTOMER_NUMBER>
<PACK_TYPE>PE BAG WITHOUT LOGO</PACK_TYPE>
<PACK_CODE>PBR</PACK_CODE>
<PALLET_SIZE_TYPE>TELMA PALLET HOLIS</PALLET_SIZE_TYPE>
<MARKED_PACK>REGULAR STANDARD LABEL</MARKED_PACK>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Complete</JOB_STATUS>
<LOT_NUMBER>010508001</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>1</OPERATION_SEQ_NUM>
<COMPONENT_ITEM>3E1120102390</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>W&C
E-112/WHITE-1239</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS/>
</ROW>
</ROWSET>Here is what I do.
Read this into a data set and then write it out using the WriteXMLSchema
method.
Here is a brief example in c#.
DataSet ds = new DataSet("MyXML");
ds.ReadXml("C:\\c53a1602ff3011d48d140004ac5e3ab0.xml");
ds.WriteXmlSchema("C:\\MyXML.xsd");
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlxml problem Please help"
<sqlxmlproblemPleasehelp@.discussions.microsoft.com> wrote in message
news:3B1097A3-88B2-432F-8CA9-FACB0C063997@.microsoft.com...
> hello all.
> i attached an xml that need to put data into and sql server tables
> i having probleams creating the XSD schema.
> i allready have the tables in the sql
> i am using the SQLXMLBulkLoad object. and wrote a program with vb.net
> that
> do it.
> it's work fine for simple xml and Xsd .
> i need help writing the xsd that will insert to data into 2 tables with
> relation (that i created )
> attached the xml
> please help
> thanks
>
> <?xml version = '1.0'?>
> <ROWSET>
> <ROW num="1">
> <JOB_NUMBER>3</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>WC E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>10000</ASSEMBLY_QUANTITY>
> <CUSTOMER_NUMBER>? ' '?</CUSTOMER_NUMBER>
> <PRODUCTION_LINE>L02</PRODUCTION_LINE>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Released</JOB_STATUS>
> <LOT_NUMBER>3</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1200</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>3220</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>160</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>50</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>100</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>5020</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>2.5</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>42.999656</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>30.0003</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="2">
> <JOB_NUMBER>4</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>11PVCNZ0004B</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>SOLVIN 270PF SOLVAY</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Unreleased</JOB_STATUS>
> <COMPONENTS/>
> <OPERATIONS/>
> </ROW>
> <ROW num="3">
> <JOB_NUMBER>5</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>347200000000</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>P.V.C SOFT 472/NAT.0000</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>44949</BULK_DENSITY>
> <PPG>JHY0992</PPG>
> <HUMIDITY__PERMITTED>0.998</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Unreleased</JOB_STATUS>
> <COMPONENTS/>
> <OPERATIONS/>
> </ROW>
> <ROW num="4">
> <JOB_NUMBER>6</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>2</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Released</JOB_STATUS>
> <LOT_NUMBER>6</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.24</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.644</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.032</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.02</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1.004</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="5">
> <JOB_NUMBER>7</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Complete</JOB_STATUS>
> <LOT_NUMBER>7</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.12</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.322</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.016</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.005</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.502</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="7">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBLX00034</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>AKROPAN 2143GX
> AKDENIZ</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.025536</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="6">
> <JOB_NUMBER>9</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
> <CUSTOMER_NUMBER>? ' '?</CUSTOMER_NUMBER>
> <PACK_TYPE>PE BAG WITHOUT LOGO</PACK_TYPE>
> <PACK_CODE>PBR</PACK_CODE>
> <PALLET_SIZE_TYPE>TELMA PALLET HOLIS</PALLET_SIZE_TYPE>
> <MARKED_PACK>REGULAR STANDARD LABEL</MARKED_PACK>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Complete</JOB_STATUS>
> <LOT_NUMBER>010508001</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>1</OPERATION_SEQ_NUM>
> <COMPONENT_ITEM>3E1120102390</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>W&C
> E-112/WHITE-1239</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS/>
> </ROW>
> </ROWSET>|||Dear Hilary
i need to write a Mapping Scehma.
which i do not know to to do.
can you please help me.
i allredy write a source in vb.net that read the XML and The XSD and insert
into SQL
all i need is the right schema according to the XML below
thanks.
"Hilary Cotter" wrote:
> Here is what I do.
> Read this into a data set and then write it out using the WriteXMLSchema
> method.
> Here is a brief example in c#.
> DataSet ds = new DataSet("MyXML");
> ds.ReadXml("C:\\c53a1602ff3011d48d140004ac5e3ab0.xml");
> ds.WriteXmlSchema("C:\\MyXML.xsd");
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sqlxml problem Please help"
> <sqlxmlproblemPleasehelp@.discussions.microsoft.com> wrote in message
> news:3B1097A3-88B2-432F-8CA9-FACB0C063997@.microsoft.com...|||I normally do this as part of a manual process. I create stored procedures
to fire the xml data into the respective tables.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlxml problem Please help"
<sqlxmlproblemPleasehelp@.discussions.microsoft.com> wrote in message
news:1D7DBF7A-E015-448C-883C-72839C357484@.microsoft.com...
> Dear Hilary
> i need to write a Mapping Scehma.
> which i do not know to to do.
> can you please help me.
> i allredy write a source in vb.net that read the XML and The XSD and
> insert
> into SQL
> all i need is the right schema according to the XML below
> thanks.
> "Hilary Cotter" wrote:
>|||You can also open the Xml file in the Xml editor (in VS 2005) and click on
the create schema icon.
To get the mapping information check-out the SQLXML help.
Thanks,
Avner Aharoni[MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hilary Cotter" wrote:
> I normally do this as part of a manual process. I create stored procedures
> to fire the xml data into the respective tables.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sqlxml problem Please help"
> <sqlxmlproblemPleasehelp@.discussions.microsoft.com> wrote in message
> news:1D7DBF7A-E015-448C-883C-72839C357484@.microsoft.com...
i attached an xml that need to put data into and sql server tables
i having probleams creating the XSD schema.
i allready have the tables in the sql
i am using the SQLXMLBulkLoad object. and wrote a program with vb.net that
do it.
it's work fine for simple xml and Xsd .
i need help writing the xsd that will insert to data into 2 tables with
relation (that i created )
attached the xml
please help
thanks
<?xml version = '1.0'?>
<ROWSET>
<ROW num="1">
<JOB_NUMBER>3</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>WC E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>10000</ASSEMBLY_QUANTITY>
<CUSTOMER_NUMBER>??? ?????? ?????</CUSTOMER_NUMBER>
<PRODUCTION_LINE>L02</PRODUCTION_LINE>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Released</JOB_STATUS>
<LOT_NUMBER>3</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1200</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>3220</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>160</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>50</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>100</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>5020</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>2.5</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>42.999656</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>30.0003</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="2">
<JOB_NUMBER>4</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>11PVCNZ0004B</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>SOLVIN 270PF SOLVAY</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Unreleased</JOB_STATUS>
<COMPONENTS/>
<OPERATIONS/>
</ROW>
<ROW num="3">
<JOB_NUMBER>5</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>347200000000</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>P.V.C SOFT 472/NAT.0000</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
<BULK_DENSITY>44949</BULK_DENSITY>
<PPG>JHY0992</PPG>
<HUMIDITY__PERMITTED>0.998</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Unreleased</JOB_STATUS>
<COMPONENTS/>
<OPERATIONS/>
</ROW>
<ROW num="4">
<JOB_NUMBER>6</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>2</ASSEMBLY_QUANTITY>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Released</JOB_STATUS>
<LOT_NUMBER>6</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.24</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.644</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.032</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.02</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1.004</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="5">
<JOB_NUMBER>7</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Complete</JOB_STATUS>
<LOT_NUMBER>7</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.12</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.322</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.016</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.005</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.502</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="7">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBLX00034</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>AKROPAN 2143GX
AKDENIZ</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.025536</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="6">
<JOB_NUMBER>9</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
<CUSTOMER_NUMBER>??? ?????? ?????</CUSTOMER_NUMBER>
<PACK_TYPE>PE BAG WITHOUT LOGO</PACK_TYPE>
<PACK_CODE>PBR</PACK_CODE>
<PALLET_SIZE_TYPE>TELMA PALLET HOLIS</PALLET_SIZE_TYPE>
<MARKED_PACK>REGULAR STANDARD LABEL</MARKED_PACK>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Complete</JOB_STATUS>
<LOT_NUMBER>010508001</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>1</OPERATION_SEQ_NUM>
<COMPONENT_ITEM>3E1120102390</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>W&C
E-112/WHITE-1239</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS/>
</ROW>
</ROWSET>Here is what I do.
Read this into a data set and then write it out using the WriteXMLSchema
method.
Here is a brief example in c#.
DataSet ds = new DataSet("MyXML");
ds.ReadXml("C:\\c53a1602ff3011d48d140004ac5e3ab0.xml");
ds.WriteXmlSchema("C:\\MyXML.xsd");
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlxml problem Please help"
<sqlxmlproblemPleasehelp@.discussions.microsoft.com> wrote in message
news:3B1097A3-88B2-432F-8CA9-FACB0C063997@.microsoft.com...
> hello all.
> i attached an xml that need to put data into and sql server tables
> i having probleams creating the XSD schema.
> i allready have the tables in the sql
> i am using the SQLXMLBulkLoad object. and wrote a program with vb.net
> that
> do it.
> it's work fine for simple xml and Xsd .
> i need help writing the xsd that will insert to data into 2 tables with
> relation (that i created )
> attached the xml
> please help
> thanks
>
> <?xml version = '1.0'?>
> <ROWSET>
> <ROW num="1">
> <JOB_NUMBER>3</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>WC E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>10000</ASSEMBLY_QUANTITY>
> <CUSTOMER_NUMBER>? ' '?</CUSTOMER_NUMBER>
> <PRODUCTION_LINE>L02</PRODUCTION_LINE>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Released</JOB_STATUS>
> <LOT_NUMBER>3</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1200</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>3220</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>160</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>50</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>100</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>5020</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>2.5</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>42.999656</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>30.0003</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="2">
> <JOB_NUMBER>4</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>11PVCNZ0004B</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>SOLVIN 270PF SOLVAY</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Unreleased</JOB_STATUS>
> <COMPONENTS/>
> <OPERATIONS/>
> </ROW>
> <ROW num="3">
> <JOB_NUMBER>5</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>347200000000</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>P.V.C SOFT 472/NAT.0000</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>44949</BULK_DENSITY>
> <PPG>JHY0992</PPG>
> <HUMIDITY__PERMITTED>0.998</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Unreleased</JOB_STATUS>
> <COMPONENTS/>
> <OPERATIONS/>
> </ROW>
> <ROW num="4">
> <JOB_NUMBER>6</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>2</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Released</JOB_STATUS>
> <LOT_NUMBER>6</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.24</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.644</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.032</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.02</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1.004</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="5">
> <JOB_NUMBER>7</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Complete</JOB_STATUS>
> <LOT_NUMBER>7</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.12</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.322</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.016</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.005</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.502</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="7">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBLX00034</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>AKROPAN 2143GX
> AKDENIZ</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.025536</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="6">
> <JOB_NUMBER>9</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
> <CUSTOMER_NUMBER>? ' '?</CUSTOMER_NUMBER>
> <PACK_TYPE>PE BAG WITHOUT LOGO</PACK_TYPE>
> <PACK_CODE>PBR</PACK_CODE>
> <PALLET_SIZE_TYPE>TELMA PALLET HOLIS</PALLET_SIZE_TYPE>
> <MARKED_PACK>REGULAR STANDARD LABEL</MARKED_PACK>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Complete</JOB_STATUS>
> <LOT_NUMBER>010508001</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>1</OPERATION_SEQ_NUM>
> <COMPONENT_ITEM>3E1120102390</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>W&C
> E-112/WHITE-1239</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS/>
> </ROW>
> </ROWSET>|||Dear Hilary
i need to write a Mapping Scehma.
which i do not know to to do.
can you please help me.
i allredy write a source in vb.net that read the XML and The XSD and insert
into SQL
all i need is the right schema according to the XML below
thanks.
"Hilary Cotter" wrote:
> Here is what I do.
> Read this into a data set and then write it out using the WriteXMLSchema
> method.
> Here is a brief example in c#.
> DataSet ds = new DataSet("MyXML");
> ds.ReadXml("C:\\c53a1602ff3011d48d140004ac5e3ab0.xml");
> ds.WriteXmlSchema("C:\\MyXML.xsd");
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sqlxml problem Please help"
> <sqlxmlproblemPleasehelp@.discussions.microsoft.com> wrote in message
> news:3B1097A3-88B2-432F-8CA9-FACB0C063997@.microsoft.com...|||I normally do this as part of a manual process. I create stored procedures
to fire the xml data into the respective tables.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlxml problem Please help"
<sqlxmlproblemPleasehelp@.discussions.microsoft.com> wrote in message
news:1D7DBF7A-E015-448C-883C-72839C357484@.microsoft.com...
> Dear Hilary
> i need to write a Mapping Scehma.
> which i do not know to to do.
> can you please help me.
> i allredy write a source in vb.net that read the XML and The XSD and
> insert
> into SQL
> all i need is the right schema according to the XML below
> thanks.
> "Hilary Cotter" wrote:
>|||You can also open the Xml file in the Xml editor (in VS 2005) and click on
the create schema icon.
To get the mapping information check-out the SQLXML help.
Thanks,
Avner Aharoni[MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hilary Cotter" wrote:
> I normally do this as part of a manual process. I create stored procedures
> to fire the xml data into the respective tables.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sqlxml problem Please help"
> <sqlxmlproblemPleasehelp@.discussions.microsoft.com> wrote in message
> news:1D7DBF7A-E015-448C-883C-72839C357484@.microsoft.com...
Subscribe to:
Posts (Atom)