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> |
| SCROLLCOLUMN |
Specifies that the XML tag spans to multiple rows
with respect to the specified Column.
Example:-
<ALLINVENTORYENTRIES.LIST SCROLL="YES" SCROLLCOLUMN="9">
.......
</ALLINVENTORYENTIES.LIST> |
| SKIP |
Used to SKIP the tag
Example:-
<ALLINVENTORYENTRIES.LIST SKIP="=K#=0">
........
</ALLINVENTORYENTRIES.LIST>
Remarks:-
SKIP attribute is used to skip/ignore the tag including child-tags if
the specified condition evaluates to TRUE.
|
| 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 |
