Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jagdish Sharma
  Where is Jagdish Sharma?
 Mumbai
 India
 Jagdish Sharma
 Tags
Subject: dbf to XML
Thread ID: 209632 Message ID: 209632 # Views: 8 # Ratings: 0
Version: Visual FoxPro 7 Category: XML
Date: Tuesday, December 30, 2008 7:16:11 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

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