Step 2: Write XML tags
With your Excel-sheet ready, the next step is to tell udi-Magic "What data you have
in your Excel sheet and where is it stored ?". This is done using XML tags.
For those who are not familiar with XML tags, here's a brief introduction.
"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. XML stands for Extensible
Markup Language. "
Now, let's take an example to understand the same.
<MASTER TYPE="UNIT">
<NAME COLUMNREFERENCE="A"/>
<DECIMALPLACES COLUMNREFERENCE="C"/>
..... other XML-tags ......
......other XML-tags ......
</MASTER>
|
Remarks:-
1. The above XML tags specify that the Excel sheet contains UNIT master records.
2. The Column A in the Excel sheet contains NAME.
3. The Column C in the Excel sheet contains DECIMALPLACES.
Before proceeding with the real task, let's have a look at some of the frequently-asked-questions.
How do I write XML tags ?
You can use any text-editor like Notepad for writing the XML tags. However, we suggest
you to use Microsoft Visual Web Developer 2005 Express Edition which is a FREE software
and can be downloaded from the Microsoft site.
Where do I get the XML-tags list which are supported
by Tally ?
The answer lies within the Tally Software itself. In simple words, you can get the
XML tags from the Tally Software itself. All you need to do is enter few sample
records in Tally and then Export the data in XML format.
Now, let's start with the real-task : Writing XML tags
This task is further sub-divided as folows :-
a) Create a UNIT Master record in Tally
b) Export the UNIT Master data in XML format
c) Select and Copy the XML tags from Master.xml file
d) Modify the XML tags
Next Page : Create a UNIT
Master record in Tally
|
