Posts

Showing posts from September, 2008

Importing CSV data into Tally Software using UDIMagic

Image
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 :- STEPS:- 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 o...

UDIMagic with Auto Run feature

Image
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 Settings 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...