Online tutorials on Tally, Tally.ERP XML tags, Excel to Tally and more..

Excel to Tally and lots more...

UDI-Magic is a software utility that allows you to Import data into Tally. It supports Import of data from various sources like Excel, SQL Server, MySQL, Access, DBF and various other DBF formats.

Website :- www.rtslink.com/udimagic.htm
Blog-site :- www.udimagic.blogspot.com

If you are new to this blog-site, we advice that you read the Posts from the beginning.i.e. Exercise 1 onwards. The bog-archive is given on the left-hand-side.

=========================================================

Wednesday, June 4, 2008

Exercise 4 - Creating Stock-Group Masters before creating Stock-Item Masters

Here's a sample Excel sheet (with Stock-Item Masters) and XML tags file. In this Excel sheet, we have two Columns of data viz.
a) Name (i.e. Stock-Item Name in Column A)
b) Parent (i.e. Stock-Group Name in column B)

Download the Excel sheet and XML tags file.

This exercise illustrates how to create Stock-Group Masters before creating the Stock-Item Masters.

The XML tags for creating Stock-Group Masters are as follows:-

<MASTER TYPE="STOCKGROUP"/>
<NAME.LIST>
<NAME COLUMNREFERENCE="B"/>
<NAME.LIST>
</MASTER>

The XML tags for creating Stock-Item Masters are as follows:-

<MASTER TYPE="STOCKITEM"/>
<NAME.LIST>
<NAME COLUMNREFERENCE="A"/>
<NAME.LIST>
<PARENT COLUMNREFERENCE="B"/>
</MASTER>

And here is the complete XML tags file :-

<XMLTAGS CELLREFERENCE="A1" xmlns:UDF="TallyUDF">

<MASTER TYPE="STOCKGROUP"/>
<NAME.LIST>
<NAME COLUMNREFERENCE="B"/>
<NAME.LIST>
</MASTER>

<MASTER TYPE="STOCKITEM"/>
<NAME.LIST>
<NAME COLUMNREFERENCE="A"/>
<NAME.LIST>
<PARENT COLUMNREFERENCE="B"/>
</MASTER>

</XMLTAGS>

Explanation:-
1) The above tags instruct UDIMagic to first create the Stock-Group Masters based on the Column B data.
2) Next, UDIMagic creates the Stock-Item Masters based on the Column A data.

Tips:-
1) Use Internet Explorer (or Firefox) to view the XML tags file.
2) For editing the XML tags, you can use any XML Editor (like Microsoft Visual Web Developer 2005 Express Edition).
3) You can get the Tally XML tags for any Master. All you need to do is to manually enter a dummy record in Tally and then Export it using option "Gateway of Tally >> Display >> List of Accounts >> Alt+E". This generates the XML tags for the Master record in file MASTER.XML

References
Understanding XML tags

Solution to Exercise 3
Though the Excel sheet (given in Exercise-3) contained 5 records, only 4 records were imported into Tally Sofware. The reason is:-

"The Column A contains duplicate NAME's (i.e. Stock-Item Name BUSH is repeated in Cell A2 and A6). This creates a single Master-record in Tally. In fact, the first Master-record named BUSH gets overwritten with the 2nd record."

No comments: