Excel to Tally Convertor

Tuesday, February 28, 2012

UDIMagic v4.0 Release 2.0

UDIMagic v4.0 Release 2.0 supports bulk-record processing which reduces processing time upto 40% to 60% as compared to the earlier release.

Settings (Use Notepad to make changes in UDIMAGIC.INI i.e. configuration file)

[UDIMAGIC]
;; Lot-size specified in percentage
;;(i.e. records are processed in lot-size of 10% of total number of records)
UploadDataLotSize=10%

;;Lot-size specified in Nos (uncommented / remove semi-colons to use this)
;;UploadDataLotSize=50

Remarks:
The default lot-size is 5%

Thursday, February 9, 2012

Online Training Session - 14th and 18th Feb., 2012

Session Topic
14th Feb, 2012 - Writing XML tags to modify Ledger Masters by adding new ALIAS.
18th Feb, 2012 - Writing XML tags to import Cash Payment Vouchers from Excel sheet into Tally.

Product : UDI Magic

For more details, refer http://www.rtslink.com/online-training-sessions/schedule.html

Monday, January 9, 2012

Online Training Session - 12th and 16th Jan., 2012

Session Topic
12th Jan - Writing XML tags to import Sales Vouchers with StockItems, Godown from Excel sheet into Tally.
16th Jan - Writing XML tags to import Sales Vouchers with Multi-Currency from Excel sheet into Tally.

Product : UDI Magic

For more details, refer http://www.rtslink.com/online-training-sessions/schedule.html

Sunday, January 1, 2012

Online Training Session - 5th and 7th Jan., 2012

Session Topic
5th Jan - Writing XML tags to import Financial Vouchers from Excel sheet into Tally.
7th Jan - Writing XML tags to import Financial Vouchers with Reference from Excel sheet into Tally.

Product : UDI Magic

For more details, refer http://www.rtslink.com/online-training-sessions/schedule.html

Sunday, December 25, 2011

Online Training Session - 29th Dec., 2011

Session Topic
Writing XML tags to import Journal Vouchers from Excel sheet into Tally.

Product : UDI Magic

For more details, refer http://www.rtslink.com/online-training-sessions/schedule.html

Saturday, December 24, 2011

UDIMagic v4.0 Release 1.3

UDIMagic v4.0 Release 1.3 now supports some new options in the UDIMagic.ini (configuration) file as shown underneath :-

[Tally]
;;Specify the Tally version
version=x.x.x.x

[UDIMagic]
;;Specify this option if you need to import data into Multiple Companies
MultipleCompanies=Yes


Remarks:-
1) As we cannot programmatically get the Tally version/release, a new option has been kept in the udimagic.ini (configuration) file to specify the Tally version. Ex: 9.0.3.2 specifies that the Tally version is 9.0 and Release is 3.2

2) While importing data into Tally, the Masters with same name (i.e. same master) are skipped by UDIMagic, by default. However, when data is to be imported into multiple Companies, we may require one Master to be imported into more than one companies. In such cases, you need to specify the MultipleCompanies=Yes in the UDIMagic configuration file

Friday, December 23, 2011

Excel to Tally - Sample Excel sheet formats

The following sample Excel sheet format is now available for UDIMagic users :-

Employee Master - For Payroll