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.

Sunday, September 21, 2008

UDIMagic with Auto Run feature

UDIMagic v3.0 Release 1.60 comes with a new feature called Auto-Run.

What is Auto Run ?

The Auto Run feature allows you to setup UDIMagic to run automatically without any User-intervention.

Once this feature is enabled, you can add UDIMagic to "Windows Scheduler" to run UDIMagic at scheduled timings.

How to enable the Auto Run mode in UDIMagic ?

1) Start UDIMagic and follow the wizard instructions to import data as you normally do.
2) In the last screen, click on the "Enable Auto Run" check-box to enable it.
3) Next, click on the Start button to import data into Tally.

This now enables Auto-Run mode; and few lines are added to the UDIMagic.ini (configuration) file. You can also manually edit the UDIMagic.ini (configuration) to enable/disable the Auto-Run feature.

How do I add UDIMagic to Windows Scheduler ?

1) From the Windows Start menu, select "Settings >> Control Panel"
2) Next, select Scheduled Tasks
This displays all the currently scheduled tasks.
3) Next, select "File >> New >> Scheduled Task"
4) Give a name to the Task, say UDIMAGIC.
5) Next, double-click on UDIMAGIC scheduled task to modify the settings

This will auto-run UDIMagic at the schedule timings.

1) In the Auto-Run mode, a file named "Autorun.log" is created which records the UDIMagic process activites. This is generally useful for keeping track of Data imported; or errors (if any).
2) When the Auto-Run mode is enabled, manually starting UDIMagic will display a AUTO-RUN Splash screen that allows you to Skip or Disable the Auto-Run mode.