<!-- @page { size: 8.27in 11.69in; margin: 0.79in } P { margin-bottom: 0.08in } -->

How to import tally data into sql-ledger.

First , we need to export three files from tally.

1. master.xml

2. daybook.xml (Daybook)

3. bsheet.xml (Balance Sheet)

Now, we need to make a party file from master.xml file. So simply execute.

$ party.pl master.xml log.txt party.txt

party.txt will contain all creditors and debtors. it guesses it from ledger heads. most of the time it works finw, but if you think particular entry is neither creditor nor debtor, just delete that entire line.

Now to combine creditors and debtors as a party, make there last no same in party file. For instance, there are 2 entry,

174 | Technet pvt Ltd | D | 174

175 | Technet pvt Ltd |C | 175

Then either change last no to 174 in second entry or change last no to 175 in first entry

Do this step for all creditors and debtors that you want to make party.

Now after editing party file, you ned to check party file for consistency To do this type

$party.pl party.txt log.txt

this script will check the log file to see there us any error in party.txt . now we need to provide a start date. This date will be used as a date of transaction for opening balance of various accounts. So simply execute the command.

$ do-all.sh master.xml daybook.xml bsheet.xml party.txt '2006-12-19'

replace '2006-12-19' with appropriate date. note that date is in 'yyyy-mm-dd' format.

This script complete the importing procedure.