Friday, April 15, 2016

How to specify XML tags file name in the XLS file ?

While importing data from Excel to Tally using udiMagic Software, you can :

a) Select the XML tags file using the udiMagic interface; or
b) Specify the XML tags within the Excel file.

Here are the steps to specify the Mapping (XML tags) file name in the Excel sheet.

1) Open the Excel sheet.
2) Right click the cell A1 and select option "Insert/Edit Comments"
3) Type out the following :

<XMLTAGSFILENAME> theXmlFileName </XMLTAGSFILENAME>

4) Save the Excel sheet.

Now, while importing using udiMagic, you can simply select the XLS file and no need to select the Mapping (Xml) file.

No comments: