Tis okay.... I just had a few xtra minutes myself... lol... besides, I have been working with XML recently myself...
R
>Ric you are right. I was a bit lazy to go through the XML.
>
>
>My statement of two tables or two cursor was based on the following line mentioned by Paul.
>
>"It seems to me their are 2 major components: OrderHeader and ListOfOrderDetail. "
>
>
>It needs a good normalization.
>
>Aashish
>
>
>>To just expand a bit regarding your cursor and XML... use normalization to the fullest exent... a general rule to use in generating XML is to never go more than two 'indents' deep in a single cursor... more than that means you should be checking you data duplication.
>>
>>Using your sample XML below, I see instances of several cursors you will need to effectively handle this task:
>>
>>1. OrderHeader - Base Cursor
>> 'POIssuedDate
>> 'RequestedDeliveryDate
>> '
>> '
>>
>>2. Order Party - Supplier (Can be in the cursor as above in that most order party info is unique to the above BuyerRefNum)
>> '
>> '
>>
>>3. Order Party - Ship To Party (I recommend you keep this separate in that shipto may not
>> etc....
>>
>>
>>So you can see that the breakdown of 'indents' can help you structure your cursors....
>>
>>HTH
>>
>>Ric
>>
>>>XMLTOCURSOR and CURSORTOXML will all all flexibility to convert
>>>XML to Cursor or Cursor to XML.
>>>
>>>Though with the mentioned example the data of both the file will come in one cursor.
>>>You need to apply normalization to divide in two tables or two cursors.
>>>
>>>Aashish
>>>
>>>>I need to add XML functionality to my application. I want to start by creating a purchase order via xml so my customers can send the PO elecronically to the vendor. I have a vendor that is willing to work with me as I develop this feature.
>>>>
>>>>The vendor sent me a sample xml document they receive from a client:
>>>>
>>>>>>>><?xml version="1.0" encoding="utf-8"?>
>>>><PurchaseOrder>
>>>> <OrderHeader>
>>>> <POIssuedDate>20030318T193435</POIssuedDate>
>>>> <RequestedDeliveryDate>20030318T193435</RequestedDeliveryDate>
>>>> <OrderReference>
>>>> <AccountCode>
>>>> <Reference>
>>>> <RefNum>1212909801</RefNum> (our trading partner’s ID)
>>>> </Reference>
>>>> </AccountCode>
>>>> <BuyerRefNum>
>>>> <Reference>
>>>> <RefNum>Z78740</RefNum> (PO#)
>>>> </Reference>
>>>> </BuyerRefNum>
>>>> </OrderReference>
>>>> <OrderParty>
>>>> <SupplierParty>
>>>> <Party PartyID="18-710-1399"/> (our trade ID)
>>>> <NameAddress>
>>>> <Name1>Kaman Music Corporation</Name1>
>>>> </NameAddress>
>>>> </SupplierParty>
>>>> <ShipToParty>
>>>> <Party PartyID="2"/> (ID assigned to this location)
>>>> <NameAddress>
>>>> <Identifier>
>>>> <Ident>DROP SHIP</Ident>
>>>> </Identifier>
>>>> <Attention>Mike Smith</Attention>
>>>> <Name1>Mike’s Music</Name1>
>>>> <Address1>2114 Tech Drive</Address1>
>>>> <Address2/>
>>>> <City>South Bend</City>
>>>> <StateOrProvince>IN</StateOrProvince>
>>>> <PostalCode>46628</PostalCode>
>>>> <Country>United States</Country>
>>>> </NameAddress>
>>>> </ShipToParty>
>>>> </OrderParty>
>>>> <Payment>
>>>> <PaymentTerm>Other</PaymentTerm>
>>>> <PaymentTermOther>21</PaymentTermOther> (previously agreed upon terms – will discuss later)
>>>> </Payment>
>>>> <SpecialHandlingNote>4% FREIGHT ALLOWANCE </SpecialHandlingNote>
>>>> <Transport>
>>>> <Carrier>Other</Carrier>
>>>> <CarrierOther>1</CarrierOther> (carrier code. Ex: 1 = UPS)
>>>> </Transport>
>>>> </OrderHeader>
>>>> <ListOfOrderDetail>
>>>> <OrderDetail>
>>>> <BaseItemDetail>
>>>> <LineItemNum>1</LineItemNum>
>>>> <BuyerPartNum>
>>>> <PartNum>
>>>> <PartID>17740</PartID> (your item id)
>>>> </PartNum>
>>>> </BuyerPartNum>
>>>> <ManufacturerPartNum>
>>>> <PartNum>
>>>> <Agency AgencyID="Other">UPC</Agency>
>>>> <PartID>00731201528238</PartID> (Item UPC code)
>>>> </PartNum>
>>>> </ManufacturerPartNum>
>>>> <BackOrderItem>Y</BackOrderItem>
>>>> <ItemDescription>LP LP637</ItemDescription>
>>>> <Quantity>
>>>> <Qty>3</Qty>
>>>> </Quantity>
>>>> </BaseItemDetail>
>>>> <BuyerExpectedUnitPrice>
>>>> <Price>
>>>> <UnitPrice Currency="USD">123.45</UnitPrice>
>>>> </Price>
>>>> </BuyerExpectedUnitPrice>
>>>> </OrderDetail>
>>>> <OrderDetail>
>>>> <BaseItemDetail>
>>>> <LineItemNum>2</LineItemNum>
>>>> <BuyerPartNum>
>>>> <PartNum>
>>>> <PartID>56600</PartID>
>>>> </PartNum>
>>>> </BuyerPartNum>
>>>> <ManufacturerPartNum>
>>>> <PartNum>
>>>> <Agency AgencyID="Other">UPC</Agency>
>>>> <PartID>00622537350054</PartID>
>>>> </PartNum>
>>>> </ManufacturerPartNum>
>>>> <BackOrderItem>Y</BackOrderItem>
>>>> <ItemDescription>Sabian 35005</ItemDescription>
>>>> <Quantity>
>>>> <Qty>1</Qty>
>>>> </Quantity>
>>>> </BaseItemDetail>
>>>> <BuyerExpectedUnitPrice>
>>>> <Price>
>>>> <UnitPrice Currency="USD">123.45</UnitPrice>
>>>> </Price>
>>>> </BuyerExpectedUnitPrice>
>>>> </OrderDetail>
>>>> </ListOfOrderDetail>
>>>></PurchaseOrder>
>>>>
>>>>
>>>>It seems to me their are 2 major components: OrderHeader and ListOfOrderDetail.
>>>>
>>>>With my purchase order program the info that would go into orderheader is on the form in text boxes (Po#, Date, Address info, etc) and the info that would go into listorderdetail would be in a cursor (the line items to be ordered).
>>>>
>>>>The Vendor also sent me a list of the minimum requirements...but I won't display them here unless it would help.
>>>>
>>>>Will I be able to produce a document like this with CursorToXml()?
>>>>
>>>>It seems to me I would need to put all of the info in the cursor. However if I include the vendor#, date, etc in the cursor then it will be repeated for every lineitem?
>>>>
>>>>Can you point me in the right direction?
>>>>
>>>>Thank you in advance
>>>>
>>>>Paul Acton
