xsl help

nguna · March 3rd, 2011, 01:44 PM

I have got the following xml in file_1

<in>
<document>
<content>
<fileName>doc11.txt</p52:fileName>
<contentSWA>941622958268</contentSWA>
</content>
</document>
<document xmlns:p52="http://travelers/content">
<content>
<fileName>doc22.txt</fileName>
<contentSWA>9574318958</contentSWA>
</content>
</document>
</in>

and in file_2
<manifest>
<attachments>
<attachment>
<uri>cid:contentSWA=941622958268.1299148531514.IBM.WEBS ERVICES@drhiit09358</uri>
</attachment>
<attachment>
<uri>cid:contentSWA=9574318958.1299148531514.IBM.WEBSER VICES@drhiit09358</uri>
</attachment>
</attachments>
</manifest>

i have the following in my xsl

<xsl:variable name="manifest" select="'file_2.xml'"/>
<xsl:template match="contentSWA">
<xsl:copy>
<xsl:copy-of select="*"/>
<xsl:for-each select="document($manifest//attachments)">
</xsl:for-each>
</xsl:copy>
</xsl:template>

what i want to do is match the nth document/content/contentSWA ( in file_1) to the nth manifest/attachements/attachment(in file2). With my xsl for each document/content/contentSWA i'm processing all the attachements which i do not want to do . Could anyone let me know what i'm missing.

Thanks

Martin Honnen · March 3rd, 2011, 01:52 PM

Do you want to use XSLT 2.0 or 1.0? And what output do you want to create with your XSLT for the two samples you have posted?

nguna · March 3rd, 2011, 01:54 PM

The output is in XML and i'm using xslt 2.0

Martin Honnen · March 3rd, 2011, 02:05 PM

One way is to count the elements as in

Code:

  <xsl:template match="contentSWA">
    <xsl:variable name="pos" select="count(../../(., preceding-sibling::document))"/>
    <xsl:variable name="attachment" select="doc($manifest)/manifest/attachments/attachment[$pos]"/>
    <xsl:copy>
      <xsl:copy-of select="$attachment"/>
    </xsl:copy>
  </xsl:template>

nguna · March 3rd, 2011, 02:11 PM

Thank you for the code. I would also like to know how to do it in XSLT 1.0

Martin Honnen · March 3rd, 2011, 02:15 PM

Code:

  <xsl:template match="contentSWA">
    <xsl:variable name="pos" select="count(../../preceding-sibling::document) + 1"/>
    <xsl:variable name="attachment" select="document($manifest)/manifest/attachments/attachment[$pos]"/>
    <xsl:copy>
      <xsl:copy-of select="$attachment"/>
    </xsl:copy>
  </xsl:template>

should do in XSLT 1.0.

nguna · March 3rd, 2011, 02:17 PM

Thank you very much