Tuesday, June 10, 2008

Solution to Exercise 9

Download the Excel sheet with XML tags for Stock Item Masters with Aliases.

Here's a snapshot of the Excel Sheet used in Exercise 9.

XML tags for Exercise 9


<!-- StockItem Name-->
<!-- Fetch the value for NAME tag from Column A of Excel Sheet -->
<!-- ALIAS FOR NAME to be taken from Column C of Excel Sheet -->


<!-- Partno -->
<!-- Part Number to be taken from Column B -->
<!-- Alias for Part Number to be taken from Column D -->


1) You can specify multiple Aliases for Stock-Item NAME and PART-NUMBER.
2) The <NAME.LIST> tag is used to specify the NAME as well as Alias for Stock-Item NAME.
3) The <ADDITIONALNAME.LIST> tag is used to specify the PART-NUMBER as well as the Alias for Part-Number.

No comments:

Excel to Tally and lots more...

UDI-Magic is a software utility that allows you to Import data into Tally. It supports Import of data from various sources like Excel, SQL Server, MySQL, Access, DBF and various other DBF formats.

Website :- www.rtslink.com/udimagic.htm
Blog-site :- www.udimagic.blogspot.com

If you are new to this blog-site, we advice that you read the Posts from the beginning.i.e. Exercise 1 onwards. The bog-archive is given on the left-hand-side.