rtslink.com
Home / UDI-Magic / Standard / XML tags

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:-

<book>My Book</book>

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. 


UDI-Magic Attributes



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
Tally is a registered trademark of Tally Solutions FZ LLC.

Valid HTML 4.01 Transitional