I am unfamiliar with the workings of XML but I am going to have to handle some XML files related to order processing. Each file will have several items and each item could have upto 4 lines of text associated with it, as the following text example shows.

Which VFP commands do I use to get this data into parent and child tables representing the order header and the order items?

I have tried XMLTOCURSOR but cannot seem to work out how to get the child table created correctly.

I have read about Schemas but am not clear on how they work in this context.

Apologies for what is a very basic question - but any help to get me started would be greatly appreciated.

Barry Sutton.

<WebRelayXML>
  <Summary>
    <SiteID>WT3</SiteID>
    <FileCreationDate>16/07/2008 15:23:32</FileCreationDate>
    <FileType>Order</FileType>
    <FileRef>/1024.xml</FileRef>
    <Version>WebRelayXML Version 4.44</Version>
  </Summary>
  <OrderHeader>
    <OrderNumber>1024</OrderNumber>
    <CampaignCode>WEB</CampaignCode>
    <SourceCode>WEB</SourceCode>
    <MediaID>WEB_WEB</MediaID>
    <LastOrderNumber />
    <PurchaseOrderNumber />
    <LoyaltyCardNumber />
    <OrderNotes />
    <OrderType>0</OrderType>
    <OrderStatusMajor>0</OrderStatusMajor>
    <OrderStatusMinor>0</OrderStatusMinor>
    <ShippingCode>2ND</ShippingCode>
    <CurrencyCode>GB</CurrencyCode>
    <CurrencyRate>0</CurrencyRate>
    <OrderNetValue>0</OrderNetValue>
    <OrderTaxValue>0</OrderTaxValue>
    <OrderGrossValue>0</OrderGrossValue>
    <OrderValuePaid>0</OrderValuePaid>
    <VoucherValue>0</VoucherValue>
    <DeliveryNetValue>0</DeliveryNetValue>
    <DeliveryTaxValue>0</DeliveryTaxValue>
    <DeliveryGrossValue>0</DeliveryGrossValue>
    <DeliveryTaxCode />
    <OrderDiscountValue>0</OrderDiscountValue>
    <DiscountReasonCode />
    <OrderDate>16/07/2008 15:23:32</OrderDate>
    <DueDate>16/07/2008 15:23:32</DueDate>
    <DeliverByDate />
    <ContactID>0</ContactID>
    <CardID>0</CardID>
    <BillToID>0</BillToID>
    <ShipToID>0</ShipToID>
    <OrderedByID>-1</OrderedByID>
    <MailToID>0</MailToID>
    <GiftMessageID>-1</GiftMessageID>
    <DeliveryInstructionID>-1</DeliveryInstructionID>
    <ReferalRef>/1024.xml</ReferalRef>
    <AffiliateID />
    <MessageID>-1</MessageID>
  </OrderHeader>
  <OrderItems>
    <OrderItem>
      <ItemSeq>0</ItemSeq>
      <Sku>GT1</Sku>
      <Qty>1</Qty>
      <ExtraInfo>
        <Text1>TEST TEXT LINE 1</Text1>
        <Text2>TEST TEXT LINE 2</Text2>
        <Text3>TEST TEXT LINE 3</Text3>
      </ExtraInfo>
      <QtyAllocated>0</QtyAllocated>
      <ItemStatusMajor>0</ItemStatusMajor>
      <ItemStatusMinor>0</ItemStatusMinor>
      <CompositionProfile>0</CompositionProfile>
      <StockStatus>0</StockStatus>
      <ReservationID>0</ReservationID>
      <PaymentStatusMajor>0</PaymentStatusMajor>
      <PaymentStatusMinor>0</PaymentStatusMinor>
      <ItemUnitPrice>0</ItemUnitPrice>
      <ItemNetValue>0</ItemNetValue>
      <ItemTaxValue>0</ItemTaxValue>
      <ItemGrossValue>0</ItemGrossValue>
      <ItemTaxCode />
      <ItemPostageValue>0</ItemPostageValue>
      <ItemPostageTaxValue>0</ItemPostageTaxValue>
      <ItemPostageGrossValue>0</ItemPostageGrossValue>
      <ItemPostageTaxCode />
      <ItemDiscountValue>0</ItemDiscountValue>
      <ItemDiscountCode>0</ItemDiscountCode>
      <ItemDiscountReasonCode />
      <HasPersonalisation>N</HasPersonalisation>
      <SKUStatus>0</SKUStatus>
      <ParentItem>-1</ParentItem>
      <ShipToID>0</ShipToID>
      <GiftMessageID>-1</GiftMessageID>
      <ContactID>0</ContactID>
      <ItemPersonalisationID>-1</ItemPersonalisationID>
      <MessageID>-1</MessageID>
    </OrderItem>
    <OrderItem>
      <ItemSeq>1</ItemSeq>
      <Sku>GT2</Sku>
      <Qty>1</Qty>
      <ExtraInfo>
        <Text1>TEST TEXT LINE A</Text1>
        <Text2>TEST TEXT LINE B</Text2>
        <Text3>TEST TEXT LINE C</Text3>
      </ExtraInfo>
      <QtyAllocated>0</QtyAllocated>
      <ItemStatusMajor>0</ItemStatusMajor>
      <ItemStatusMinor>0</ItemStatusMinor>
      <CompositionProfile>0</CompositionProfile>
      <StockStatus>0</StockStatus>
      <ReservationID>0</ReservationID>
      <PaymentStatusMajor>0</PaymentStatusMajor>
      <PaymentStatusMinor>0</PaymentStatusMinor>
      <ItemUnitPrice>0</ItemUnitPrice>
      <ItemNetValue>0</ItemNetValue>
      <ItemTaxValue>0</ItemTaxValue>
      <ItemGrossValue>0</ItemGrossValue>
      <ItemTaxCode />
      <ItemPostageValue>0</ItemPostageValue>
      <ItemPostageTaxValue>0</ItemPostageTaxValue>
      <ItemPostageGrossValue>0</ItemPostageGrossValue>
      <ItemPostageTaxCode />
      <ItemDiscountValue>0</ItemDiscountValue>
      <ItemDiscountCode>0</ItemDiscountCode>
      <ItemDiscountReasonCode />
      <HasPersonalisation>N</HasPersonalisation>
      <SKUStatus>0</SKUStatus>
      <ParentItem>-1</ParentItem>
      <ShipToID>0</ShipToID>
      <GiftMessageID>-1</GiftMessageID>
      <ContactID>0</ContactID>
      <ItemPersonalisationID>-1</ItemPersonalisationID>
      <MessageID>-1</MessageID>
    </OrderItem>
  </OrderItems>
  <Payments>
    <CashPayments>
      <CashPayment>
        <CashPaymentID>0</CashPaymentID>
        <CashPaymentRef>Cash Payment</CashPaymentRef>
        <CashPaymentValue>0</CashPaymentValue>
      </CashPayment>
    </CashPayments>
    <VoucherPayments />
    <OnAccountPayments />
    <CreditCardPayments />
  </Payments>
  <Messages />
  <Personalisation />
</WebRelayXML>