XSLT with sequence row number

[email protected] · February 19th, 2014, 04:09 AM

Hi All,

Am new to XSLT, in my project we have requirement of XML to XML conversion

1. Have XML

Code:

<?xml version="1.0"?>
<OpsmanDRS>
	<?xml-multiple dataOpsmanDRS?>
	<dataOpsmanDRS>
		<drsNumber>YPDB0510000001</drsNumber>
		<?xml-multiple deliveryDtlsDO?>
		<deliveryDtlsDO>
			<consignmentNumber>F991B4300018</consignmentNumber>
		</deliveryDtlsDO>
		<deliveryDtlsDO>
			<consignmentNumber>F991B4300022</consignmentNumber>
		</deliveryDtlsDO>
	</dataOpsmanDRS>
	<dataOpsmanDRS>
		<drsNumber>DS9140000002</drsNumber>
		<?xml-multiple deliveryDtlsDO?>
		<deliveryDtlsDO>
			
		</deliveryDtlsDO>
		<deliveryDtlsDO>
			<consignmentNumber>S991B0000223</consignmentNumber>
			
		</deliveryDtlsDO>
	</dataOpsmanDRS>
</OpsmanDRS>

2. But result XML should be as below

Code:

<?xml version="1.0" encoding="iso-8859-1"?>
<root>
	<FORM name="Delivery">
		<row no="0">
			<FL val="Consignment No">S02400001310</FL>
			<FL val="drsNumber">AUT751004</FL>
		</row>
		<row no="1">
			<FL val="Consignment No">S02400001333</FL>
			<FL val="drsNumber">AUT751004</FL>
			
		</row>
	</FORM>
</root>

please help me to write XSLT for below line

<row no="1">

here issue with incremental value in no attribute of <row>

mhkay · February 19th, 2014, 04:28 AM

Take a look at the position() function. Or at xsl:number. You will find plenty of examples in my book.

If you have further questions, it's a good idea to show your attempts so far, and to explain where you are stuck. Then we can see what help you need.

Don't expect people here to write your code for you.

[email protected] · February 19th, 2014, 05:19 AM

Quote:

Originally Posted by mhkay

Take a look at the position() function. Or at xsl:number. You will find plenty of examples in my book.

If you have further questions, it's a good idea to show your attempts so far, and to explain where you are stuck. Then we can see what help you need.

Don't expect people here to write your code for you.

Thanks mhkay for your quick reply....

have created XSL as below

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0"
	xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output method="xml" indent="yes" />
	<xsl:strip-space elements="*" />
	<xsl:template match="/OpsmanDRS">
		<root>
			<FORM name="Delivery">
				<xsl:for-each select="/OpsmanDRS/dataOpsmanDRS">

				<xsl:for-each select="current()/deliveryDtlsDO">
						<row>
		<xsl:attribute name="no"><xsl:number/></xsl:attribute>
							
	<FL val="Runsheet Id">		<xsl:value-of select="../drsNumber" />
							</FL>
<FL val="Consignment no"><xsl:value-of select="consignmentNumber" />
							</FL>
						</row>
					</xsl:for-each>

				</xsl:for-each>

			</FORM>
		</root>
	</xsl:template>

</xsl:stylesheet>

and generating the output as

Code:

<?xml version="1.0" encoding="UTF-8"?>
<root>
	<FORM name="Delivery">
		<row no="1">
			<FL val="Runsheet Id">YPDB0510000001</FL>

			<FL val="Consignment no">F991B4300018</FL>
		</row>
		<row no="2">
			<FL val="Runsheet Id">YPDB0510000001</FL>
			<FL val="Consignment no">F991B4300022</FL>
		</row>
		<row no="3">
			<FL val="Runsheet Id">YPDB0510000001</FL>
			<FL val="Consignment no">F991B4300047</FL>
		</row>
		<row no="1">
			<FL val="Runsheet Id">DS9140000002</FL>

			<FL val="Consignment no">S991B0000237</FL>
		</row>
		<row no="2">
			<FL val="Runsheet Id">DS9140000002</FL>
			<FL val="Consignment no">S991B0000223</FL>
		</row>
		<row no="1">
			<FL val="Runsheet Id">DS914000018</FL>
			<FL val="Consignment no">F991B0000106</FL>
		</row>
		<row no="2">
			<FL val="Runsheet Id">DS914000018</FL>
			<FL val="Consignment no">F991B0000058</FL>
		</row>
	</FORM>
</root>

HTML Code:

problem here is <row no="1"> is  repeating again.... can just help me to correct it.....

it may looks silly ..but am a just started to implement XSLT...

Martin Honnen · February 19th, 2014, 10:23 AM

Try

Code:

<xsl:for-each select="deliveryDtlsDO">
    <row>
        <xsl:attribute name="no"><xsl:number level="any"/></xsl:attribute>

[email protected] · February 20th, 2014, 05:25 AM

Thank you.....it worked...