Friday, January 23, 2009

Debugging with UDI-Magic

Before we proceed with the task-on-hand, let's have a look at what way the UDI-Magic software functions.

UDI-Magic functionality
UDI-Magic is an EDI (Electronic Data interchange) tool that facilitates and involves the following :-

1) Extract data from a data-source (herein MS-Excel)
2) Transform the data
3) Load it into the target (herein the Tally Accounting Software database)

Tech-guys may refer this link for more information on ETL (Extract, Load and Transform)

Debugging with UDI-Magic
"Debugging with UDI-Magic" relates to the 3rd step (i.e. Load) in the Extract, Transform and Load method. At times (generally in case of errors) , we may need to see what is being uploaded into the Tally Software. UDI-Magic allows you to send the data into a file simultaneously as it is being uploaded into Tally. The steps for enabling debugging in UDI-Magic are given below :-

Step 1
Open the UDIMagic.ini (configuration file) using Notepad. This file is their in the "c:\udi-magic" folder.

Step 2
Search for heading [UDIMAGIC] and add the option "RedirectXMLTagsToFile=Yes" under it.

Here's how it must appear in your UDIMagic.ini file

[UDIMAGIC]
RedirectXMLTagsToFile=Yes


Remarks:-
1) There may be several other options under the [UDIMAGIC] heading in your INI file. Herein, we have just shown the RedirectXMLTagsToFile=Yes option which is required for Debugging.
2) Setting the option RedirectXMLTagsToFile=Yes will generate a file named xmltags.xml in "c:\udi-magic" folder (or where udimagic is installed)
3) Always remember to turn off this feature when you finish debugging as this will slow-down the process of uploading the data into Tally.

You can use NOTEPAD to view the file xmltags.xml which contains the XML-tags for all the records that are uploaded into Tally.



No comments: