Wednesday, September 25, 2013

Understanding new features in v5.0

SCROLLHORIZONTALLY

The SCROLLHORIZONTALLY attribute is like a Looping contruct / mechanism supported in programming languages. In other words, it allows you to loop through the Excel sheet Columns.

To understand what this attribute is, let's have a look at some tags required to create Ledger Masters (in v4.0 or lower) based on values given in Header Row in Excel Sheet.

XML tags required in UDIMagic v4.0 or lower versions
<!-- Create a Ledger Master based on value given in cell F1 -->
<MASTER TYPE="LEDGER" SINGLERECORD="YES">
<NAME.LIST>
<NAME COLUMNREFERENCE="$F$1">
</NAME>
<PARENT>Indirect Expenses</PARENT>
</MASTER>

<!-- Create a Ledger Master based on value given in cell G1 -->
<MASTER TYPE="LEDGER" SINGLERECORD="YES">
<NAME.LIST>
<NAME COLUMNREFERENCE="$G$1">
</NAME>
<PARENT>Indirect Expenses</PARENT>
</MASTER>

<!-- Create a Ledger Master based on value given in cell H1 -->
<MASTER TYPE="LEDGER" SINGLERECORD="YES">
<NAME.LIST>
<NAME COLUMNREFERENCE="$H$1">
</NAME>
<PARENT>Indirect Expenses</PARENT>
</MASTER>

Remarks:-
1) In earlier versions (v4.0 or lower), the aforesaid tags were required to create 3 ledgers based on values given in Cell F1, G1, H1
2) We had to copy/paste the same XML tags and had to change the Cell-reference, in case if we wanted to create additional Ledgers for values given in I1, J1, K1,L1 and so on....

XML tags required in UDIMagic v5.0 onwards
<!--Create Ledger Masters based on value given in cell F1 and
scrollhorizontally till blank cell is found -->
<MASTER TYPE="LEDGER" SCROLLHORIZONTALLY="=Len(F$1)>0">
<NAME.LIST>
<NAME COLUMNREFERENCE="F$1">
</NAME>
<PARENT>Indirect Expenses</PARENT>
</MASTER>

Remarks:-
1) The SCROLLHORIZONTALLY attribute is used herein. It is similar to LOOP mechanism found in programming languages.
2) It contains a condition (any valid Excel Formula) which is evaluated at run-time. If the condition is true, then the COLUMN references used within the FORMULA are incremented.
3) In the aforesaid cited example,
>> the Ledger Name is initially taken from cell F1. It is then enters a loop and increments the Column-references in the formula
>> next, if the cell G1 contains any data, then the condition Len(G$1)>0 evaluates to true and ledger is created for value given in G1. It then again increments the Column-references in the Formula.
>> next, if the cell H1 contains any data, then the condition Len(H$1)>0 evaluates to true and ledger is created for value given in H1. It then again increments the Column-references in the Formula.
>> This looping process continues till the condition becomes false.
>> This way with lesser xml code, we can process any number of Excel sheet Columns.

You can download the sample Excel templates (supported by v5.0 only) from :-
http://www.rtslink.com/excelfiles/v5.0


Saturday, September 21, 2013

INTRODUCING UDIMAGIC V5.0

We are pleased to announce the launch of UDIMagic v5.0. The details are as under :-

UDIMagic v5.0 is now more EXTENSIBLE
SCROLLHORIZONALLY, a new feature (XML attribute) supported by UDIMagic v5.0 enables transfer of data from Excel to Tally wherein you can add data in any number of Columns.

Ex: An Excel template has Columns for "Sales 5%; VAT 5%; Sales 12.5%; VAT 12.5%", but you want few more Columns but without doing any changes in coding / xml tags. This new feature allows you to add ANY number of Columns with data as required (say Sales 15%, VAT 15%, Sales 20%, VAT 20% etc) without any modification.

Try out using these new sample templates provided with UDIMagic v5.0
a) Vouchers-V5-Sales-with-VAT-without-stockitems.xls
b) Vouchers-V5-Purchase-with-VAT-without-stockitems.xls

Supports DEBUGGING mode
You can now run UDIMagic v5.0 in normal mode (as usual) or in Debug mode. In the Debugging mode, you can upload / process records one-by-one and view the status along with the source and destination xml tags.

Settings / Options button
>> Create dependent Masters - Yes or No
Use this option to specify whether dependent Masters are to be created or not, before uploading Vouchers into Tally.

>> Warn if dependent Masters do not exist in Tally - Yes or No
Displays a warning message along with list of dependent Masters that do not exist in Tally.

>> Allow import even if multiple Companies are open in Tally - Yes or No
This is required / useful when you want to Import data into Multiple Companies from a single Excel sheet.

>> Allow Debugging - Yes or No
Displays a Debug button which allow you to run UDIMagic in Debugging mode.

UDIMagic v5.0 - Licensing
No need to surrender UDIMagic license when you format the hard disk or change the system. UDIMagic is bound to your Tally Serial Number.

Remarks:-
UDIMagic v3.0 / v4.0 users can upgrade to the UDIMagic v5.0. The upgradation charges are as follows depending upon the version :-

Rs   750/- Upgrade from UDIMagic v4.0 Light to UDIMagic v5.0 Light
Rs 1500/- Upgrade from UDIMagic v4.0 Standard  to UDIMagic v5.0 Standard  
Rs 3000/- Upgrade from UDIMagic v4.0 Professional to UDIMagic v5.0 Professional

Rs 1200/- Upgrade from UDIMagic v3.0 Light to UDIMagic v5.0 Light
Rs 2500/- Upgrade from UDIMagic v3.0 Standard  to UDIMagic v5.0 Standard  
Rs 4500/- Upgrade from UDIMagic v3.0 Professional to UDIMagic v5.0 Professional

The above charges are for Single-User version. For Multi-user version, the charges will be 2.5 times that of the Single-user charges as shown above.

Customers who have purchased UDIMagic v4.0 on or after 20/06/2013 shall be provided upgrades free-of-charge.

Download UDIMagic demo version from http://www.rtslink.com/images/udiMagicDemo.zip