Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XmlAdapter and schema
Message
From
21/04/2003 07:48:41
 
 
To
20/04/2003 18:09:05
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00777588
Message ID:
00779707
Views:
36
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform