Tuesday, September 23, 2008

Importing CSV data into Tally Software using UDIMagic

CSV (Comma Separated values) files are plain-text files having extension (.csv or .txt) that contains data-values that are separated by commas. The first line in the file must be the Header-line and is followed by data-rows.

CSV files can be directly opened/ viewed in MS-Excel.

This post provides a CSV file that contains Ledger-Master records. Follow the steps given underneath to import data from the CSV file into Tally 9 :-

1) Download and unzip the ledger-master-csv.zip file.
The zip file contents are :-
a) Ledger-Master.csv (Can be directly opened in MS-Excel)
b) Ledger-Master.xml (Use Internet Explorer to view this file)

2) Next, start Tally and create/open any Dummy Company
3) Next, minimize Tally
4) Start UDIMagic Software
5) Select option "Excel to Tally"
6) Select option "Masters"
7) Next, select the CSV file by clicking on the Browse button. By default, only Excel-files are displayed in the list-box. You need to set the option "Files of Type" as "All Files" as shown below:-

After setting option "Files of Type" as "All files", select the CSV file named "Ledger-master".

8) Next, select the XML tags file "Ledger-Master.xml".
Remarks: The XML tags file is to be selected in the same screen in which you are prompted to select the Excel/CSV file

9) Next, click on the START button to import data into Tally.

If everything goes fine, then ONE Ledger-Master record (named Shweta Softwares) will be imported into Tally. You can view the same using option "Gateway of Tally >> Accounts Info >> Ledger >> Alter" and check for Ledger named "Shweta Softwares".

1) The "Excel to Tally" feature can be used to import data from both MS-Excel files or CSV files.
2) For importing data from other sources like SQL-Server; MySQL; Access; DBF-files and popular databases, you must use the "Advanced Usage" option in UDIMagic software.
3) UDIMagic identifies data in the source-file (MS-Excel or CSV or Database-files) based upon the mapping given in the XML-file and constructs proper XML tags which are supported by Tally Software.

No comments: