Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import nested table
Message
From
01/09/2006 01:22:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Import nested table
Miscellaneous
Thread ID:
01150299
Message ID:
01150299
Views:
119
Hi,
I have customer data in XML format. The XML contains of customer information.
Customer master table contains customer#. The other info such as addresses, order history are stored as nested table. How could I import them using VFP?
<IDOC>
  <CUSTOMER_MASTER>
    <CUSTID>0001</CUSTID>
    <ADDRESSES>
      <ADDR1>No 12, Off Road</ADDR1>
      <POSTCODE>123364</POSTCODE>
    </ADDRESSES>
    <ORDERHISTORY>
      <ORDERID>000001</ORDERID>
      <AMOUNT>10</AMOUNT>
    </ORDERHISTORY>
  </CUSTOMER_MASTER>
  <CUSTOMER_MASTER>
    <CUSTID>0002</CUSTID>
    <ADDRESSES>
      <ADDR1>No 14, Off WAY</ADDR1>
      <POSTCODE>898986</POSTCODE>
    </ADDRESSES>
    <ORDERHISTORY>
      <ORDERID>000002</ORDERID>
      <AMOUNT>100</AMOUNT>
    </ORDERHISTORY>
    <ORDERHISTORY>
      <ORDERID>000003</ORDERID>
      <AMOUNT>30</AMOUNT>
    </ORDERHISTORY>
</CUSTOMER_MASTER>
</IDOC>
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Next
Reply
Map
View

Click here to load this message in the networking platform