Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import nested table
Message
De
01/09/2006 01:22:08
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Titre:
Import nested table
Divers
Thread ID:
01150299
Message ID:
01150299
Vues:
121
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...
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform