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
