STEP 2d
(Objective: Modify the XML tags)
Tally vs UDI-Magic [XML tags]
The XML tags exported from the Tally Software have fixed tag-values. Herein, we
shall modify these tags and specify the Excel sheet Column-References where our
data is stored. UDI-Magic reads the data from the specified Columns in the Excel
sheet and sends it to Tally.
Excel-sheet Column-references are given underneath:-
Tally Format
Originial Tags taken from MASTER.XML
|
udiMagic Format
Modified XML Tags
|
Remarks |
|
<UNIT NAME="Ltrs" RESERVEDNAME=""> |
<MASTER TYPE="UNIT"> |
The <MASTER TYPE="UNIT"> XML tag specifies that udi-Magic
must create UNIT Masters. |
|
<NAME>Ltrs</NAME> |
<NAME COLUMNREFERENCE="A"/> |
Herein, we specify that the value for NAME tag is to be taken from Column
A (in the Excel sheet) |
|
<ORIGINALNAME>Litres</ORIGINALNAME> |
<ORIGINALNAME COLUMNREFERENCE="B"/> |
ORIGINALNAME tag value is to be taken from Column B |
|
<ISSIMPLEUNIT>Yes</ISSIMPLEUNIT> |
<ISSIMPLEUNIT>Yes</ISSIMPLEUNIT> |
|
|
<DECIMALPLACES>0</DECIMALPLACES> |
<DECIMALPLACES COLUMNREFERENCE="C"/> |
DECIMALPLACES tag-value is to be taken from Column C |
|
</UNIT> |
</MASTER> |
|
Next, add the <XMLTAGS> header to the tags file as shown below:-
<XMLTAGS CELLREFERENCE="A1" xmlns:UDF="TallyUDF">
<MASTER TYPE="UNIT">
......XML tags......
......XML tags......
</MASTER>
</XMLTAGS>
That's all. You now have the Excel sheet and the required XML tags.
Next Page : Run UDI-Magic
and import data into Tally
|
