Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: vinod kabdal
  Where is vinod kabdal?
 Delhi
 India
 vinod kabdal
 To: Jagdish Sharma
  Where is Jagdish Sharma?
 Mumbai
 India
 Jagdish Sharma
 Tags
Subject: RE: dbf to XML
Thread ID: 209632 Message ID: 209636 # Views: 4 # Ratings: 0
Version: Visual FoxPro 7 Category: XML
Date: Tuesday, December 30, 2008 7:59:09 AM         
   


> Dear Experts,
>
> how to create XML from dbf using VFP7 ?
> My dbf file structure is as given below
> docid c 8
> docdate d
> custid c 6
> bill_no c 10
> bill_dt d
> narration c 100
> dr_cr c 1
> b_amt n 12,2
> duty n 12,2
> tax n 12,2
> netamt n 12,2
>
> i want to create XML tags like given below
>
>
- <VOUCHER REMOTEID="00000001" VCHTYPE="Purchase" ACTION="Create">
>   <VOUCHERTYPENAME>Purchase</VOUCHERTYPENAME> 
>   <DATE>20080401</DATE> 
>   <VOUCHERNUMBER>1</VOUCHERNUMBER> 
>   <REFERENCE>1</REFERENCE> 
>   <PARTYLEDGERNAME>Party Name</PARTYLEDGERNAME> 
>   <NARRATION>bill no 1 dated 1-4-08</NARRATION> 
> - <ALLLEDGERENTRIES.LIST>
>   <LEDGERNAME>Ledger Name</LEDGERNAME> 
>   <AMOUNT>1000.00</AMOUNT> 
> - <BILLALLOCATIONS.LIST>
>   <NAME>1</NAME> 
>   <BILLTYPE>New Ref</BILLTYPE> 
>   <BILLCREDITPERIOD /> 
>   <AMOUNT>52327.00</AMOUNT> 
>   </BILLALLOCATIONS.LIST>
>   </ALLLEDGERENTRIES.LIST>
>  </VOUCHER>

>
> Thanks in advance
>
> Warm Regards
>
> Jagdish

CURSORTOXML("stanmast", "myXMLFile.xml", 1, 512, 0, "1")

Thanks

Vinod Kabdal

ENTIRE THREAD

dbf to XML Posted by Jagdish Sharma @ 12/30/2008 7:16:11 AM
RE: dbf to XML Posted by vinod kabdal @ 12/30/2008 7:59:09 AM
RE: dbf to XML Posted by Jagdish Sharma @ 12/31/2008 12:36:37 PM
RE: dbf to XML Posted by vinod kabdal @ 1/1/2009 7:50:05 AM