UDIMagic v5.0 with in-built Teamviewer QuickSupport module

Remote Support using Teamviewer

UDIMagic v5.0 Release 1.95 comes with inbuilt Teamviewer QuickSupport Module which allows :-

1) Sending message / text-chat with  Shweta Softwares SupportDesk
2) Allow Remote Control / Connection for getting support / assistance.

PS:
The Teamviewer QucikSupport Module displays a box which allows for chatting / sending message or ID /pwd. However, this box appears only if Shweta Softwares SupportDesk is available / Online.

UDIMagic - Ways of writing XML tags

A brief introduction to XML is given at http://www.rtslink.com/udimagic-xml-tags.html

There are two methods of writing XML tags for UDIMagic :-

1) In the Excel sheet itself (i.e. in the Comments section of Cell A1)
Refer the Exercise 1

2) In a plain text file
Refer the Exercise 2

UDIMAGIC v5.0 Release 1.6

NEW FEATURES IN UDIMAGIC V5.0 RELEASE 1.6

Status-bar
UDIMagic v5.0 Release 1.6 comes with a Status-bar which :-
1) Alerts the user if Tally is NOT running or if the Tally Port / IP Address settings are incorrect.
2) Allows the user to change the Settings.
3) Allows selection of Company in Tally into which you wish to import data.

Remarks:-
a) By default, the Status bar is hidden. You can use the Roll-down button (which appears at the right-bottom corner of UDIMagic) to display the Status Bar.
b) By default, UDIMagic imports data into the current Company in Tally. You can select / change the Company using the Status Bar.

Improved Speed wherein SCROLLHORIZONTALLY attribute is used
The SCROLLHORIZONTALLY attribute was introduced in UDIMagic v5.0 Release 1.0. This feature supports looping mechanism to loop through the Columns in Excel Sheet. The current release has around 50% to 80% speed improvement in cases wherein the aforesaid SCROLLHORIZONTALLY attribute is used.

BoundToTally (for Advanced users only)
You can use the following option in UDIMagic.ini (configuration file) to specify the Tally details (with which UDIMagic is bound). This is required only if you wish to upload data to another Tally in LAN or Internet.

[BoundToTally]
ServerPort=9000
ServerAddress=127.0.0.1

.

Excel to Tally - AutoRun Demo

UDIMagic v5.0 Release 1.4 supports AutoRun DEMO for Excel to Tally.

i.e. After downloading and installing UDIMagic v5.0, simply click on the DEMO button in the main screen. It starts the Demo and guides you about the steps for using UDIMagic to import Excel data into Tally.

You can download UDIMagic Demo from www.rtslink.com/images/udiMagicDemo.zip

UDIMagic v4.0 support to be discontinued from 1st January 2014

UDIMagic v4.0 (or lower versions) customers / users are requested to note that the support for UDIMagic v4.0 shall be discontinued from 1st January 2014 and there shall be no product enhancements in UDIMagic v4.0 thereafter.

Also, to avail technical support and product enhancements, users will have to upgrade to UDIMagic v5.0.

If XML tags are required for any new formats, then v5.0 compatible XML tags shall only be provided.

UDIMAGIC v5.0 Release 1.2

NEW FEATURES IN UDIMAGIC v5.0 RELEASE 1.2

Computing Totals using curly braces {}
In earlier versions (i.e. v4.0 or lower), we had to use Macros (VBA) for computing totals of Excel Sheet data where ever required. Now from Release 1.2 onwards, we can use curly braces {} within XML tags to compute totals .

Fist, let us have a look at a simple Excel Formula as shown underneath:-

Formula:     =Round(H#,2)
The aforesaid Formula gives the rounded-value of a specific cell (say cell H2). The # symbol is replaced with Excel sheet row no at run-time. 

Now, let us have a look at the new syntax wherein curly braces are used:-

Formula with Totals:   ={Round(H#,2)}
The aforesaid Formula gives the running totals. Say a voucher starts from row 2 and ends at row 5, then this formula gives total of  cells H2 to H5.

This new feature is used to compute totals for Excel sheet data in following formats :-
Vouchers-V5-Sales-with-VAT-with-stockitems.xls
Vouchers-V5-Purchase-with-VAT-with-stockitems.xls

You can use the aforesaid formats with UDIMagic v5.0 Release 1.2 onwards. Following are the noteworthy points :-

a) Sales and Purchase formats with StockItems; Multiple VAT rates.
Ex: VAT 5%,VAT6%,VAT7%......etc. You can have any number of VAT types in these formats and can use any number of Columns.

b) Other Ledgers like Frieght, Cash Discount....etc can also be specified.
There is no limit and you can use all Columns in the Excel sheet.

These formats can be downloaded from folder http://www.rtslink.com/excelfiles/v5.0/

Excel : Active Method of Range Class Failed

Error Message : Active Method of Range Class Failed

Sympton / Cause of Error:
While importing data using UDIMagic from Excel into Tally, if you manually open any Excel sheet (the same file or any other excel file), in such situations you may get the aforesaid error.

Notes:
This is due to MDI (Multiple Document Interface) feature of MS Excel wherein a single instance of Excel is opened and hence, if you are working on Excel programmatically using UDIMagic (or any other external application which uses Automation), you must not manually start  Excel or work in Excel simultaneously.

In simple words, you must not manually start Excel while UDIMagic is running. Although, you can open any Excel sheet(s) prior to starting UDIMagic and keep them opened, but should not manually move in Excel sheet or add/edit any data.