Problem in Reading data from XML File.......

pavans · Post by **pavans** » Thu Mar 20, 2008 12:36 pm

Hi,
I have a parallel job:

External SOurce-->XML Input-->Transformer--->Dataset.
My XML input file has two records at the line level.
But the dataset is getting loaded twice with the record at first line level.
Its not processing the second record.
Can someone take a look at this.
i have /order/orderlines/orderline/ as key in the XPATH.
I am also attaching my XML input file.

------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
- <Order EnterpriseCode="Target.com" DocumentType="Transfer Order" OrderType="TTR" BuyerOrganizationCode="Target.com" SellerOrganizationCode="116472" OrderNo="6000311" Status="Draft" ReqShipDate="" ReqCancelDate="" ReqDeliveryDate="" SearchCriteria1="1" CustomerPONo="12" OrderDate="" Action="CREATE" ShipNode="Hebron" ShipToID="WHSE_5" ReceivingNode="021" Createuserid="TargetTTR" CreateUserName="TagetTTR" Modifyts="">
- <OrderLines>
- <OrderLine PrimeLineNo="1" OrderedQty="30" Action="CREATE" Status="Draft Order Created" PersonalizeFlag="Y">
<OrderLineTranQuantity ReceivedQty="3" />
+ <Extn ExtnIsForceRevieved="Y" ExtnASIN="Y" ExtnDPCI="N" ExtnVendorStyleNo="13213" ExtnTCBI="N" ExtnCasePackQuantity="12" ExtnForceRecievedQuantity="1" ExtnTotalRetail="1233.000" ExtnPOReadiness="N" ExtnTariffNo1="2222" ExtnTariffNo2="" ExtnTariffNo3="" ExtnTariffNo4="" ExtnTariffNo5="" ExtnIsAssortmentItem="N" ExtnIsKitItem="Y" ExtnMinOrderQuantity="2" ExtnPrepCode="Y" ExtnVisaNo1="1233" ExtnVisaNo2="" ExtnVisaNo3="" ExtnVisaNo4="" ExtnVisaNo5="" ExtnColor="green" ExtnSize="45">
- <Documents>
<Document Name="A" Value="1" />
</Documents>
</Extn>
<Item ItemID="1" UnitOfMeasure="EACH" ItemShortDesc="abc" UPCCode="123456789125" />
<LinePriceinfo PricingUOM="EACH" UnitCost="100.000" RetailPrice="100.000" />
<LineOverallTotals LineTotal="100.000" />
+ <OrderDates>
<OrderDate CommittedDate="" />
</OrderDates>
- <Notes>
<Note NoteText="111" />
</Notes>
</OrderLine>
- <OrderLine PrimeLineNo="2" OrderedQty="300" Action="CREATE" Status="Draft Order Created" PersonalizeFlag="Y">
<OrderLineTranQuantity ReceivedQty="2" />
+ <Extn ExtnIsForceRevieved="Y" ExtnASIN="Y" ExtnDPCI="N" ExtnVendorStyleNo="13213" ExtnTCBI="N" ExtnCasePackQuantity="12" ExtnForceRecievedQuantity="1" ExtnTotalRetail="1233.000" ExtnPOReadiness="N" ExtnTariffNo1="2222" ExtnTariffNo2="" ExtnTariffNo3="" ExtnTariffNo4="" ExtnTariffNo5="" ExtnIsAssortmentItem="N" ExtnIsKitItem="Y" ExtnMinOrderQuantity="2" ExtnPrepCode="Y" ExtnVisaNo1="1233" ExtnVisaNo2="" ExtnVisaNo3="" ExtnVisaNo4="" ExtnVisaNo5="" ExtnColor="green" ExtnSize="45">
- <Documents>
<Document Name="B" Value="2" />
</Documents>
</Extn>
<Item ItemID="2" UnitOfMeasure="EACH" ItemShortDesc="abc" UPCCode="123456789125" />
<LinePriceinfo PricingUOM="EACH" UnitCost="100.000" RetailPrice="100.000" />
<LineOverallTotals LineTotal="100.000" />
+ <OrderDates>
<OrderDate CommittedDate="" />
</OrderDates>
- <Notes>
<Note NoteText="" />
</Notes>
</OrderLine>
</OrderLines>
<Extn ExtnOrderSubType="Special" ExtnHotPO="N" ExtnReservePO="Y" ExtnRetransmit="None" ExtnTotalRetail="1234.000" ExtnPromiseDate="" ExtnShipFromID="021" ExtnContactEmail="rayg@1908studios.com" ExtnContactPhone="3458445" ExtnVendorName="1908 STUDIOS" ExtnTerms="term" ExtnIsEDI860Compliant="Y" ExtnIsEDI850Compliant="N" ExtnGMSVendorID="12" ExtnVendorNotes="This is reservePO" ExtnVendorActive="Y" ExtnImportVendor="N" ExtnPaymentType="" ExtnFOBTypeCode="" ExtnFOBCountry="US" ExtnFOBState="WS" ExtnFOBCity="New York" ExtnFOBZipCode="23423" ExtnFreightTerm="Term" ExtnVendorContactFirstName="Manohar" ExtnVendorContactAddressLine1="33 South" ExtnVendorContactAddressLine2="Downtown" ExtnVendorContactAddressLine3="" ExtnVendorContactCity="Minneapolis" ExtnVendorContactState="Minesotta" ExtnVendorContactZipCode="4354444444" ExtnVendorContactCountry="mn" ExtnVendorContactEmail="Manohar.Chakravarthy@target.com" ExtnVendorContactDayPhone="4343444" />
<OverallTotalsInEnterpriseCurrency LineSubTotal="10.000" />
- <Notes>
<Note NoteText="notes" />
</Notes>
<PersonInfoBillTo FirstName="Target Corporation" AddressLine1="33 South" AddressLine2="6th Street" City="MS CC-2325" ZipCode="55402" State="Minneapolis" Country="MN" />
<PersonInfoShipTo Company="Savannah" AddressLine1="756 Third St." AddressLine2="ABC" City="New York" ZipCode="23423" State="WS" Country="US" />
<PersonInfoMarkFor Company="Amazon" AddressLine1="12 East" AddressLine2="Block" City="Houston" ZipCode="12321" State="WW" Country="US" />
</Order>

-----------------------------------------------------------------------------------

Thanks in Advance.
Let me know if some more information is needed.

eostic · Post by **eostic** » Thu Mar 20, 2008 12:54 pm

It's not clear what problem you are having. For the orderlines info, you should be receiving two rows out of your xml structure.... which elements are being duplicated incorrectly beyond that?

Outside of xml, what kind of a config file do you have? Are you running everything sequential with single node for testing?

Ernie

pavans · Post by **pavans** » Thu Mar 20, 2008 3:09 pm

eostic wrote:It's not clear what problem you are having. For the orderlines info, you should be receiving two rows out of your xml structure.... which elements are being duplicated incorrectly beyond that?

Outside of xml, what kind of a config file do you have? Are you running everything sequential with single node for testing?

Ernie

I am receiving two rows out of XML but both are first record.
The second record is not coming out of XML.

eostic · Post by **eostic** » Thu Mar 20, 2008 6:02 pm

Ok...not sure what release you are using, but in v8, I get two rows, using this Xpath with the xml content above. They are correct.

/Order/OrderLines/OrderLine/

Do you have a test job that has only one column, with nothing else except this? How do you know it's the same value twice? Send it to a flat file, to be sure.

Ernie