Rank: Newbie
Joined: 10/22/2009
Posts: 1
Location: usa
|
Please help to convert XML to Table format using XSL stylesheet or any other method.
I am trying to convert this XML to tablular form having all the fileds.
I really appreciate your help.
<TRANSACTIONDETAIL>
<TRANSHEADER>
<TRANSID>12</TRANSID>
<TRANSSTARTTIME>2009-10-20 18:05:43</TRANSSTARTTIME>
<TRANSENDTTIME>2009-10-20 18:07:31</TRANSENDTTIME>
<RETURNASSISTEDPARAM>true</RETURNASSISTEDPARAM>
<TRANSAMT>53.5</TRANSAMT>
...
<COMMISSION>
<ACCESS>1478727</ACCESS>
</COMMISSION>
<CUSTOMER>
<LASTNAME>NA</LASTNAME>
<FIRSTNAME>NA</FIRSTNAME>
</CUSTOMER>
<ITEM>
<QUANTITY>1.0</QUANTITY>
<LISTPRICE>0.08</LISTPRICE>
<SELLINGPRICE>50.0</SELLINGPRICE>
<DISCOUNTCODE/>
<DISCOUNTAMT>0.0</DISCOUNTAMT>
<TAXDETAIL>
<TAXABLEAMOUNT>50.0</TAXABLEAMOUNT>
<TAXSTATUS>TAXABLE</TAXSTATUS>
<TAXTYPE>SALES</TAXTYPE>
</TAXDETAIL>
<TAXDETAIL>
<TAXABLEAMOUNT>50.0</TAXABLEAMOUNT>
<TAXSTATUS>TAXABLE</TAXSTATUS>
<TAXTYPE>SALES</TAXTYPE>
</TAXDETAIL>
<TAXDETAIL>
<TAXABLEAMOUNT>50.0</TAXABLEAMOUNT>
<TAXSTATUS>TAXABLE</TAXSTATUS>
<TAXTYPE>SALES</TAXTYPE>
</TAXDETAIL>
<TAXDETAIL>
<TAXABLEAMOUNT>50.0</TAXABLEAMOUNT>
<TAXSTATUS>TAXABLE</TAXSTATUS>
<TAXTYPE>SALES</TAXTYPE>
</TAXDETAIL>
<TAXRATE>0.07</TAXRATE>
<TOTTAXAMOUNT>3.5</TOTTAXAMOUNT>
</ITEM>
<TAXCOLLECTED>
<TAXID>not-used</TAXID>
<TAXAMT>3.5</TAXAMT>
<TAXRATE>0.0</TAXRATE>
</TAXCOLLECTED>
<TENDER>
<TENDERTYPECODE>1</TENDERTYPECODE>
<TENDERCLASSCODE>1</TENDERCLASSCODE>
</TENDER>
</TRANSACTIONDETAIL>
|
Rank: Advanced Member
Joined: 12/13/2005
Posts: 2,856
Location: Mauritius
|
It should be very easy to do with MapForce
|
