Saturday, 15 May 2010

tibco - Need Inputs on the XSD Schema -


I'm looking for suggestions to create an XSD structure to handle the following XML format so that my processing logic can be more efficient . Looping logic TIBCO BW

  & lt; Line & gt; Will be managed in & Lt; ShipmentLineNumber & gt; 1 & lt; / ShipmentLineNumber & gt; & Lt; SalesOrderLineNumber & gt; 1.1 & lt; / SalesOrderLineNumber & gt; & Lt; PurchaseOrderLineNumber & gt; 1 & lt; / PurchaseOrderLineNumber & gt; & Lt; PARTNUMBER & gt; 1CH162-510 & lt; / PARTNUMBER & gt; & Lt; ModelNumber & gt; ST1000DM003 & lt; / ModelNumber & gt; & Lt; / Line & gt; & Lt; Package packagetype = "p" package = level = "1" & gt; & Lt; PackageNumber & gt; PWN34332 & lt; / PackageNumber & gt; & Lt; ShipmentNumber & gt; 105909390 & lt; / ShipmentNumber & gt; & Lt; ShipmentLineNumber & gt; 1 & lt; / ShipmentLineNumber & gt; & Lt; PARTNUMBER & gt; 1CH162-510 & lt; / PARTNUMBER & gt; & Lt; Quantity & gt 1000 & lt; / Quantity & gt; & Lt; SSCCNumber & gt; 00176364909402100165 & lt; / SSCCNumber & gt; & Lt; / Package & gt; & Lt; Package packagetype = "c" package = level = "2" & gt; & Lt; PackageNumber & gt; CWX612432660 & lt; / PackageNumber & gt; & Lt; ParentPackageNumber & gt; PWN34332 & lt; / ParentPackageNumber & gt; & Lt; ShipmentNumber & gt; 105909390 & lt; / ShipmentNumber & gt; & Lt; ShipmentLineNumber & gt; 1 & lt; / ShipmentLineNumber & gt; & Lt; PARTNUMBER & gt; 1CH162-510 & lt; / PARTNUMBER & gt; & Lt; Quantity & gt; 25 & lt; / Quantity & gt; & Lt; SSCCNumber & gt; 00176364909402100165 & lt; / SSCCNumber & gt; & Lt; / Package & gt; & Lt; Package packagetype = "s" package = = "3" & gt; & Lt; PackageNumber & gt; W1D2WNGL & lt; / PackageNumber & gt; & Lt; ParentPackageNumber & gt; CWX612432660 & lt; / ParentPackageNumber & gt; & Lt; ShipmentNumber & gt; 105909390 & lt; / ShipmentNumber & gt; & Lt; ShipmentLineNumber & gt; 1 & lt; / ShipmentLineNumber & gt; & Lt; PARTNUMBER & gt; 1CH162-510 & lt; / PARTNUMBER & gt; & Lt; Quantity & gt; 1 & lt; / Quantity & gt; & Lt; DateOfMfg & gt; 20131209 & lt; / DateOfMfg & gt; & Lt; COO & gt; CN & lt; / COO & gt; & Lt; SSCCNumber & gt; 00176364909402100165 & lt; / SSCCNumber & gt; & Lt; SerialAttribute1 & gt; CN0G1XNT212323C60C25 & lt; / SerialAttribute1 & gt; & Lt; SerialAttribute3 & gt; A0 02 & lt; / SerialAttribute3 & gt; & Lt; SerialAttribute5 & gt; CC47 & lt; / SerialAttribute5 & gt; & Lt; SerialAttribute6 & gt; B719 & lt; / SerialAttribute6 & gt; & Lt; SerialAttribute7 & gt; GPG17B.CCD4.DC0CAL.CC47 & lt; / SerialAttribute7 & gt; & Lt; / Package & gt;  

You should properly estimate XSD structure this XML Example matches, but this will probably not be enough unless you have an example of presenting all possible combinations and values ​​of each element.

In addition, your current XML example is invalid because this root element.


No comments:

Post a Comment