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

<XMLTAGS CELLREFERENCE="A1" xmlns:UDF="TallyUDF">

<MASTER TYPE="STOCKITEM">
<!-- StockItem Name-->
<NAME.LIST>
<!-- Fetch the value for NAME tag from Column A of Excel Sheet -->
<NAME COLUMNREFERENCE="A"/>
<!-- ALIAS FOR NAME to be taken from Column C of Excel Sheet -->
<NAME COLUMNREFERENCE="C"/>
</NAME.LIST>

<PARENT/>
<BASEUNITS/>

<!-- Partno -->
<ADDITIONALNAME.LIST>
<!-- Part Number to be taken from Column B -->
<ADDITIONALNAME COLUMNREFERENCE="B"/>
<!-- Alias for Part Number to be taken from Column D -->
<ADDITIONALNAME COLUMNREFERENCE="D"/>
</ADDITIONALNAME.LIST>

</MASTER>
</XMLTAGS>

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

---