Hello,
I have searched around and found some tutorials for xsl:key and key() function, but somehow I still am missing some understanding apparently.
There is a XML-XML transformation I need to do, which includes some 10 fields where you I have to take string values from source XML, find appropriate numeric codes from appropriate lookup tables (provided), and put those codes in resulting XML.
I have a working version of this doing xsl:for-each for lookup table, but I suspect it is suboptimal and would like to know if I should have used select="key('CR-Lookup',$CR)" instead somhow.
So, what I want to do is (deep part of tree):
<Contributor>
<ContributorRole>producer</ContributorRole>
<ContributorName>Anglet, J.</ContributorName>
</Contributor>
to be transformed into something like this:
<Contributor>
<ContributorRole id="7" code="818"/>
<Value id="Name">Anglet, J.</Value>
</Contributor>
The files I've made like thus:
Lookup table file lookup_ContributorRole.xml :
<lookup id="ContributorRole">
<row>
<id>7</id>
<parentid>NULL</parentid>
<valueMember>1</valueMember>
<displayMember>producer</displayMember>
<code>818</code>
<externalId>NULL</externalId>
<description>NULL</description>
</row>
<!-- more <row>s...-->
</lookup>
Amd the XSLT file, where I attempt to do the matching:
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:foxml="info:fedora/fedora-system:def/foxml#"
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:rel="info:fedora/fedora-system:def/relations-external#"
xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/"
xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema"
xmlns:audit="info:fedora/fedora-system:def/audit#"
xmlns:fedoraxsi="http://www.w3.org/2001/XMLSchema-instance"
exclude-result-prefixes="xsl foxml rdf rel oai_dc dc xsi audit fedoraxsi"
>
<xsl:output omit-xml-declaration="yes" indent="yes" method="xml" />
<xsl:key name="CR-lookup" match="row" use="displayMember"/>
<xsl:variable name="CRTable" select="document('lookup_ContributorRole.xml')/lookup/row"/>
<xsl:template match="Contributor">
<Contributor>
<xsl:variable name="CR"><xsl:value-of select="ContributorRole"/></xsl:variable>
<ContributorRole>
<xsl:for-each select="$CRTable">
<xsl:if test="displayMember=$CR">
<xsl:attribute name="id"><xsl:value-of select="id"/></xsl:attribute>
<xsl:attribute name="code"><xsl:value-of select="code"/></xsl:attribute>
</xsl:if>
</xsl:for-each>
</ContributorRole>
<Value id="Name"><xsl:value-of select="ContributorName"/></Value>
</Contributor>
</xsl:template>
<xsl:template match="/">
<DigitalObject>
<Core>
<xsl:for-each select="/foxml:digitalObject/foxml:datastream[@ID='DigitalObjectLL']/foxml:datastreamVersion">
<xsl:sort select="@CREATED" order="descending"/>
<xsl:if test="position() = 1">
<xsl:for-each select="./foxml:xmlContent/lnbdo">
<xsl:apply-templates select="Contributor"/>
</xsl:for-each>
</xsl:if>
</xsl:for-each>
</Core>
</DigitalObject>
</xsl:template>
</xsl:stylesheet>