Hi Sergey,

i have a XSD schema for this, is it posibble to import directly to cursors or tables(dbf)?.

thanks,
ryan



>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>
>>
>>