Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XmlAdapter and schema
Message
De
21/04/2003 07:48:41
 
 
À
20/04/2003 18:09:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00777588
Message ID:
00779707
Vues:
35
Hi Aleksey,

thank you for using your time to help. I just try to understand which is the best tactic to follow when we want to import xml docs into tables. I still cannot understand the rationale that vfp uses thru xmltables and xmlfields to interpret xml doc. Is it possible to describe every xml format via xmltables and xmlfields as maybe you can do via schema ? Is it possible to make a generic import class that will interpret any xml and assigning default datatypes ? Take the following xml which describes a table with its keys and some values. What rationale should i use to crate the table and import the data on the fly ?
My question is : is there any rule of thumb, a method apart of lerning how to create schemas ?
<?xml version="1.0" encoding="ibm-1253"?>
<jdeRequest type="trans" user="JDE" pwd="JDEPRO" environment="PD7333" session="" sessionidle="">
  <transaction action="inbound" type="JDEJE">
    <key>
      <column name="EdiUserId">JDEBO1</column>
      <column name="EdiBatchNumber">801723</column>
      <column name="EdiTransactNumber">801723</column>
    </key>
		<table name="F0911Z1" type="header">
			<column name="EdiTransactNumber">0000001</column>
			<column name="EdiLineNumber">0079</column>
			<column name="EdiTransactionType">J</column>
			<column name="EdiTransactionAction">A</column>
			<column name="EdiSuccessfullyProcess">0</column>
			<column name="AddressNumber">0018845 </column>
			<column name="DocumentType">PL</column>
			<column name="DocVoucherInvoiceE">119348</column>
			<column name="JournalEntryLineNo">00079</column>
			<column name="Company">00001</column>
			<column name="DateBatchJulian">03/04/2003</column>
			<column name="DateForGLandVoucherJULIA">03/04/2003</column>
			<column name="DateServiceCurrency">03/04/2003</column>
			<column name="DteServiceShipProdMo">04</column>
			<column name="DteServiceShipProdDa">03</column>
			<column name="DteServiceShipProdYr">03</column>
			<column name="DteServiceShipProdCt">20</column>
			<column name="DateInvoiceMonth">04</column>
			<column name="DateInvoiceDA">03</column>
			<column name="DateInvoiceYEAR">03</column>
			<column name="DateInvoiceCENTURY">20</column>
			<column name="AmountField">00000001197.94-</column>
			<column name="AmountCurrency">               </column>
			<column name="CurrencyMode">D</column>
			<column name="CurrencyCodeFrom">EUR</column>
			<column name="AccountModeGL">2</column>
			<column name="AcctNoInputMode">1.539898            </column>
			<column name="LedgerType">AA</column>
			<column name="NameAlphaExplanation">10570         S19348</column>
			<column name="Subledger">        </column>
			<column name="SubledgerType"> </column>
			<column name="NameRemarkExplanation">10570         S19348</column>
		</table>
</transaction>
</jdeRequest>
Thanks again
Dimitris
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform