Check
Re: Why can't I parse this XML using VFP XMLAdapter? Message #
1170974>
> im a beginner in using XML file, i want a code to convert xml to cursors or tables. here's my xml files.
>
>
>
> <?xml version="1.0" encoding="UTF-16" ?>
>- <BOM>
>- <BO>
>- <AdmInfo>
> <Object>20</Object>
> <Version>2</Version>
> </AdmInfo>
>- <Documents>
>- <row>
> <DocNum>5</DocNum>
> <DocType>dDocument_Items</DocType>
> <HandWritten>tNO</HandWritten>
> <Printed>tNO</Printed>
> <DocDate>20061113</DocDate>
> <DocDueDate>20061113</DocDueDate>
> <CardCode>V10000</CardCode>
> <CardName>Acme Associates</CardName>
> <Address>600 Eastern Blvd Manchester PA 03101 USA</Address>
> <DocCurrency>USD</DocCurrency>
> <DocRate>0.000000</DocRate>
> <DocTotal>4187.600000</DocTotal>
> <Reference1>5</Reference1>
> <Comments>Remarks Based On Purchase Orders 5.</Comments>
> <JournalMemo>Goods Receipt POs - V10000</JournalMemo>
> <PaymentGroupCode>2</PaymentGroupCode>
> <DocTime>1606</DocTime>
> <SalesPersonCode>2</SalesPersonCode>
> <TransportationCode>1</TransportationCode>
> <Confirmed>tYES</Confirmed>
> <ImportFileNum>0</ImportFileNum>
> <SummeryType>dNoSummary</SummeryType>
> <ContactPersonCode>8</ContactPersonCode>
> <ShowSCN>tNO</ShowSCN>
> <Series>13</Series>
> <TaxDate>20061113</TaxDate>
> <PartialSupply>tYES</PartialSupply>
> <DocObjectCode>20</DocObjectCode>
> <DiscountPercent>0.000000</DiscountPercent>
> <RevisionPo>tNO</RevisionPo>
> <BlockDunning>tNO</BlockDunning>
> <Pick>tNO</Pick>
> <PaymentMethod />
> <PaymentBlock>tNO</PaymentBlock>
> <MaximumCashDiscount>tNO</MaximumCashDiscount>
> <WareHouseUpdateType>dwh_Stock</WareHouseUpdateType>
> <Rounding>tNO</Rounding>
> <DeferredTax>tNO</DeferredTax>
> <NumberOfInstallments>1</NumberOfInstallments>
> <ApplyTaxOnFirstInstallment>tNO</ApplyTaxOnFirstInstallment>
> <DocumentsOwner>3</DocumentsOwner>
> <DocumentSubType>bod_None</DocumentSubType>
> <Address2>1901 Maynesboro Drive Suite 200 Camden PA 19065 USA</Address2>
> <PayToCode>Bill To</PayToCode>
> <UseShpdGoodsAct>tNO</UseShpdGoodsAct>
> <IsPayToBank>tNO</IsPayToBank>
> <DownPayment>0.000000</DownPayment>
> <LanguageCode>3</LanguageCode>
> <PickRemark />
> <SequenceModel>0</SequenceModel>
> <UseCorrectionVATGroup>tNO</UseCorrectionVATGroup>
> <VatPercent>0.000000</VatPercent>
> <U_STReqNum>11</U_STReqNum>
> <U_DestWH>1</U_DestWH>
> <U_SORef>1</U_SORef>
> </row>
> </Documents>
>- <Document_Lines>
>- <row>
> <LineNum>0</LineNum>
> <ItemCode>A00001</ItemCode>
> <ItemDescription>IBM Inforprint 1312</ItemDescription>
> <Quantity>10.000000</Quantity>
> <ShipDate>20061113</ShipDate>
> <Price>380.000000</Price>
> <PriceAfterVAT>418.760000</PriceAfterVAT>
> <Currency>USD</Currency>
> <Rate>0.000000</Rate>
> <DiscountPercent>5.000000</DiscountPercent>
> <VendorNum />
> <WarehouseCode>01</WarehouseCode>
> <SalesPersonCode>2</SalesPersonCode>
> <CommisionPercent>10.000000</CommisionPercent>
> <TreeType>iNotATree</TreeType>
> <AccountCode>_SYS00000000019</AccountCode>
> <UseBaseUnits>tNO</UseBaseUnits>
> <SupplierCatNum />
> <CostingCode />
> <ProjectCode />
> <BarCode />
> <VatGroup />
> <Height1>0.000000</Height1>
> <Height2>0.000000</Height2>
> <Lengh1>0.000000</Lengh1>
> <Lengh2>0.000000</Lengh2>
> <Weight1>0.000000</Weight1>
> <Weight2>0.000000</Weight2>
> <Factor1>1.000000</Factor1>
> <Factor2>1.000000</Factor2>
> <Factor3>1.000000</Factor3>
> <Factor4>1.000000</Factor4>
> <BaseType>22</BaseType>
> <BaseEntry>5</BaseEntry>
> <BaseLine>0</BaseLine>
> <Volume>0.000000</Volume>
> <VolumeUnit>5</VolumeUnit>
> <Width1>0.000000</Width1>
> <Width2>0.000000</Width2>
> <Address />
> <TaxCode>CA</TaxCode>
> <TaxType>tt_Yes</TaxType>
> <TaxLiable>tYES</TaxLiable>
> <ShippingMethod>3</ShippingMethod>
> <CorrectionInvoiceItem>ciis_ShouldBe</CorrectionInvoiceItem>
> <CorrInvAmountToStock>0.000000</CorrInvAmountToStock>
> <CorrInvAmountToDiffAcct>0.000000</CorrInvAmountToDiffAcct>
> <WTLiable>tNO</WTLiable>
> <DeferredTax>tNO</DeferredTax>
> <LineTotal>3800.000000</LineTotal>
> <TaxPercentagePerRow>10.200000</TaxPercentagePerRow>
> <ConsumerSalesForecast>tNO</ConsumerSalesForecast>
> <ExciseAmount>0.000000</ExciseAmount>
> <SWW />
> <DistributeExpense>tYES</DistributeExpense>
> <ShipToCode />
> <RowTotalFC>0.000000</RowTotalFC>
> <TaxOnly>tNO</TaxOnly>
> <UnitPrice>400.000000</UnitPrice>
> <LineStatus>bost_Open</LineStatus>
> </row>
> </Document_Lines>
> </BO>
> </BOM>
>
>
--sb--