Understanding XML Tags
XML stands for Extensible
Markup Language. Its primary
purpose is to facilitate sharing of structured data across different information
systems.
XML is a W3C
recommendation and is the most popular and widely used format for Data-Interchange.
It is classified as an Extensible Language because it allows users to define their
own elements. You can get lots of XML tutorials at W3schools. For those who are new to XML,
here's a brief introduction to XML (tags).
"XML tags are basically holders that hold your data. XML tags names are generally
descriptive and the user can easily make out
what it refers to."
Example:-
Tally XML Tags
Tally Software has its own XML tags. Though there are thousands of tags supported
by Tally, it is not very difficult to understand the same as the tag-names are descriptive.
In addition to this, you can get the Tally XML tags from the Tally software itself.
Here's how you can get the XML tags for the Masters data...
Gateway of Tally >> Display >> List of Accounts >> Alt+E
And for the Vouchers data...
Gateway of Tally >> Display >> Daybook >> Alt+E
Tally XML Tags format
<DATE>01-04-2007</DATE>
<VOUCHERTYPENAME>Sales</VOUCHERTYPENAME>
Remarks:-
a) Herein, we have taken up just two XML tags to understand the basic concepts.
b) The 1st tag specifies the value for DATE
c) The 2nd tag tag specifies the value for VOUCHERTYPENAME tag.
UDI-Magic XML Tags
UDI-Magic supports all Tally XML tags for the MASTER and VOUCHER objects. As a result,
you can import any Master or Voucher from Excel into Tally.
UDI-Magic extends the Tally XML tags functionality by adding additional ATTRIBUTES
to it. Let's see what does this mean.
|
Tag-Name |
Tally XML tag format |
UDI-Magic XML tag format |
|
<DATE> |
<DATE>01-04-2007</DATE> |
<DATE COLUMNREFERENCE="A"/> |
Remarks:-
a) In the UDI-Magic tags format, we have used an Attribute called COLUMNREFERENCE.
This instructs UDI-Magic to fetch data from the specified Column in the Excel-sheet.
b) There are several other ATTRIBUTES used by UDI-Magic which have been discussed
later-on.
UDI-Magic uses the following TOP-LEVEL XML tags to identify the data in the Excel
sheet.
The VOUCHER Tag
<VOUCHER>
<DATE COLUMNREFERENCE="B"/>
<NARRATION COLUMREFERENCE="I"/>
....
</VOUCHER> |
Remarks:-
udi-Magic supports all Tally XML tags that are used within the VOUCHER tag.
The MASTER Tag
<MASTER TYPE="LEDGER">
<NAME.LIST>
<NAME COLUMNREFERENCE="C"/>
</NAME.LIST>
<PARENT>Sundry Debtors</PARENT>
</MASTER> |
Remarks:-
udi-Magic supports all Tally XML tags that are used for Masters like GROUP; LEDGER;
STOCKITEM etc.
Attributes are used with XML tags to provide additional meaning to the Tags. UDI-Magic
has its own attributes which are required for identifying Excel sheet data as given
below:-
|
Attribute
|
Remarks |
|
COLUMNREFERENCE |
Used to specify the Column-name from which data is to be fetched
Example:-
<DATE COLUMNREFERENCE="B"/> |
|
FORMULA |
Used to specify a Formula which is evaluated at run-time
Example:-
<AMOUNT FORMULA="=+H#*-1"/> |
|
TYPE |
Used to specify the MASTER type.
Example:-
<MASTER TYPE="LEDGER">
.....
</MASTER> |
|
SCROLL |
Specifies that the XML tag spans to multiple rows.
Example:-
<ALLINVENTORYENTRIES.LIST SCROLL="YES">
.......
</ALLINVENTORYENTIES.LIST> |
|
SINGLERECORD |
Specifies that the XML tag is to be evaluated once only.
Example:-
<MASTER TYPE="LEDGER" SINGLERECORD="YES">
<NAME.LIST>
<NAME>Sale of FG</NAME>
</NAME.LIST>
<PARENT>Sales Accounts</PARENT>
<AFFECTSSTOCK>Yes</AFFECTSSTOCK>
</MASTER> |
|
COMPANYNAME |
Specifies the Company in which the data is to be imported
Example:-
<MASTER TYPE="LEDGER" COMPANYNAME="ABC LTD">
......tags......
......tags......
</MASTER> |
Remarks:-
The above mentioned ATTRIBUTES are udi-Magic specific and are not related/supported
by Tally Software. These attributes help udi-Magic in retrieving data from the Excel
sheet.
Tags: Excel to Tally, UDIMagic, XML, Tags |
