Dear Experts., I want to import following xml file from visual fox pro to tally., but i don't know how to integrate with tally., please help me ., <ENVELOPE> <HEADER> <TALLYREQUEST>Import Data</TALLYREQUEST> </HEADER> <BODY> <IMPORTDATA> <REQUESTDESC> <REPORTNAME>All Masters</REPORTNAME> </REQUESTDESC> <REQUESTDATA> <TALLYMESSAGE xmlns:UDF="TallyUDF"> <LEDGER NAME="sample ledger" Action ="Create"> <NAME>sample ledger</NAME> <PARENT>Sundry Debtors</PARENT> <OPENINGBALANCE>-0.00</OPENINGBALANCE> </LEDGER> </TALLYMESSAGE> </REQUESTDATA> </IMPORTDATA> </BODY> </ENVELOPE>
Hi There, Edit: Apologies! I think if there is a direct way to achieve what you are trying to do but unfortunately I am not aware of it. As I understood from your question you want to Export the data from Visual Fox Pro and Import it into Tally. For this you need to first parse your XML file and re-format the extracted data in a new Excel Spreadsheet and then you can code a simple TDL file to read the data from generated Excel file. Hope if it helps. Regards, Kailash
Hi Mam, You can use software for converting fox pro database into excel . Ex : DBF Viewer 2000 You can download it and browse for dbf and then convert to excel.
Axtually i did it for my own application. U can first export the dbf to excel and from excel u can create a xml file as required by tally using the mail merge option. I had around 900 product and 2000 customer to import.
Import from any software to Tally is possible.. Xml file must be in Tally readable (xml format).. 1 ) Excel - XML - Tally 2) Visual Foxpro - Excel - XML - Tally 3) Visual Foxpro-XML-Tally (Here Excel format not required) This and all coding magic.. if you sound in Visual Foxpro .. or any application it is possible.. Thanks Ramesh http://www.aruninfo.com