Autonumber

moji · October 16th, 2014, 08:11 AM

i have this following xml

<abc xmlns="http://ACORD.org/Standards/Life/2">
<CDS id="cd1">
<Vendor>
<VendorNumber>1910def</VendorNumber>
</Vendor>
<Vendor>
<VendorNumber>1910abc</VendorNumber>
</Vendor>
<Vendor>
<VendorNumber>1910dcd</VendorNumber>
</Vendor>
</CDS>
</abc>

and i need to add numbering to vendor tag with attribute id like v1,v2,v3 shown below

<abc>
<CDS id="cd1">
<Vendor id="v1">
<VendorNumber>1910def</VendorNumber>
</Vendor>
<Vendor id="v2">
<VendorNumber>1910abc</VendorNumber>
</Vendor>
<Vendor id="v3">
<VendorNumber>1910dcd</VendorNumber>
</Vendor>
</CDS>
</abc>

i have this following xslt i have written

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output indent="yes"/>
<xsl:strip-space elements="*"/>
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>

<xsl:template match="CDS/Vendor">
<Vendor id="{format-number(count(preceding::Vendor)+1,'v0')}">
<xsl:apply-templates select="@*|node()"/>
</Vendor>
</xsl:template>

</xsl:stylesheet>

i'm not able to get the result as desired if there is namespace for root element <abc>

Can anyone help me out. Thanks in advance!!!

Martin Honnen · October 16th, 2014, 08:21 AM

In the stylesheet bind a prefix to the namespace e.g.

Code:

<xsl:stylesheet ... xmlns:lf="http://ACORD.org/Standards/Life/2" exclude-result-prefixes="lf">

then use that prefix anywhere you qualify element names e.g.

Code:

<xsl:template match="lf:CDS/lf:Vendor">
        <Vendor  id="{format-number(count(preceding::lf:Vendor)+1,'v0')}">
            <xsl:apply-templates select="@*|node()"/>
        </Vendor>
    </xsl:template>

That should show you how to change your code to work with namespaces, I would also suggest to use xsl: number to count and number the elements.

moji · October 16th, 2014, 10:28 AM

Thanks Martin for the response,but right now i'm getting below xml while transforming

<abc xmlns="http://ACORD.org/Standards/Life/2">
<CDS id="cd1">
<Vendor xmlns="" id="v1">
<VendorNumber xmlns="http://ACORD.org/Standards/Life/2">1910def</VendorNumber>
</Vendor>
<Vendor xmlns="" id="v2">
<VendorNumber xmlns="http://ACORD.org/Standards/Life/2">1910abc</VendorNumber>
</Vendor>
<Vendor xmlns="" id="v3">
<VendorNumber xmlns="http://ACORD.org/Standards/Life/2">1910dcd</VendorNumber>
</Vendor>
</CDS>
</abc>

i do not want xmlns="" for vendor and vendorNumber tags. can you tell a solution for that

Martin Honnen · October 16th, 2014, 11:38 AM

Put the namespace declaration into the stylesheet:

Code:

<xsl:stylesheet ... xmlns="http://ACORD.org/Standards/Life/2" xmlns:lf="http://ACORD.org/Standards/Life/2" exclude-result-prefixes="lf">

that way the new elements that you create are in the right namespace.
Or use

Code:

<xsl:template match="lf:CDS/lf:Vendor">
  <xsl:copy>
    <xsl:attribute name="id">
      <xsl:value-of select="format-number(count(preceding::lf:Vendor)+1,'v0')"/>
    </xsl:attribute>
    <xsl:apply-templates select="@* | node()"/>
  ...
</xsl:template>

moji · October 17th, 2014, 08:10 AM

Thanq.. It worked...