Hi there,

I am new to XSLT and need some help with my translation. I have an XML doc that needs to have its element names changed and then re-structured based on come criteria. The criteria is category names. I need to create new elements that group elements based on common categories. Here is my XSLT doc:



<xsl:stylesheet version="2.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

xmlns:els="http://www.consumerdirect.com/namespaces">

            <xsl:import href="copy.xslt"/>

            <xsl:variable name="cat" select="/*/*/@cat[not(. = ../preceding-sibling::*/@cat)]"/>



            <xsl:variable name="mapping-rules" select="document('UoPToELSMapping.xslt')"/>



            <xsl:variable name="lookup" select="$mapping-rules/*[els:*]"/>

            <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

            <xsl:template match="/">

                        <xsl:apply-templates mode="sub"/>

                         <xsl:apply-templates mode="grouper"/>

            </xsl:template>

            <xsl:template match="*" mode="sub">

                        <xsl:choose>

                                    <xsl:when test="$lookup/els:element[@from=name(current())]">

                                                <xsl:element name="{$lookup/els:element[@from=name(current())]/@to}">

                                                            <xsl:attribute name="cat">

                                                                        <xsl:value-of select="$lookup/els:element[@from=name(current())]/@cat"/>

                                                            </xsl:attribute>

                                                            <xsl:attribute name="ids">

                                                                        <xsl:value-of select="$lookup/els:element[@from=name(current())]/@ids"/>

                                                            </xsl:attribute>



                                                            <xsl:apply-templates select="@*"/>

                                                            <xsl:apply-templates/>

                                                </xsl:element>

                                    </xsl:when>



                                    <xsl:otherwise>

                                                <xsl:apply-imports/>

                                    </xsl:otherwise>

                        </xsl:choose>

            </xsl:template>



            <xsl:template match="*" mode="grouper">

            <xsl:for-each select="$cat">

                        <xsl:variable name="cat-name" select="."/>

                                    <xsl:element name="{$cat-name}">

                                    <xsl:for-each select="/*/*[@cat=$cat-name]">

                                                <xsl:copy>

                                                                        <xsl:apply-templates select="."/>

                                                </xsl:copy>

                                    </xsl:for-each>

                                    </xsl:element>

            </xsl:for-each>

            </xsl:template>



</xsl:stylesheet>



And my mapper is:



<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0"

 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

 xmlns:els="http://www.consumerdirect.com/namespaces">



<els:element from="Person_Names_First_Name" to="FIRST_NAME" cat="LEAD_TRANS_DETAILS"/>

<els:element from="Person_Names_Last_Name" to="LAST_NAME" cat="LEAD_TRANS_DETAILS"/>

<els:element from="Address_Home_Street" to="STREET1" cat="LEAD_ADDRESS" type="Home" ids="1"/>

<els:element from="Address_Home_Line2" to="STREET2" cat="LEAD_ADDRESS" type="Home" ids="1"/>

<els:element from="Address_Home_City" to="CITY" cat="LEAD_ADDRESS" type="Home" ids="1"/>

<els:element from="Address_Home_State_Prov" to="STATE" cat="LEAD_ADDRESS" type="Home" ids="1"/>

<els:element from="Address_Home_Country" to="COUNTRY" cat="LEAD_ADDRESS" type="Home" ids="1"/>

<els:element from="Address_Home_Postal_Code" to="ZIP" cat="LEAD_ADDRESS" type="Home" ids="1"/>

<els:element from="Address_Business_Street" to="STREET1" cat="LEAD_ADDRESS" type="Business" ids="2"/>

<els:element from="Address_Business_Line2" to="STREET2" cat="LEAD_ADDRESS" type="Business" ids="2"/>

<els:element from="Address_Business_City" to="CITY" cat="LEAD_ADDRESS" type="Business" ids="2"/>

<els:element from="Address_Business_State_Prov" to="STATE" cat="LEAD_ADDRESS" type="Business" ids="2"/>

<els:element from="Address_Business_Country" to="COUNTRY" cat="LEAD_ADDRESS" type="Business" ids="2"/>

<els:element from="Address_Business_Postal_Code" to="ZIP" cat="LEAD_ADDRESS" type="Business" ids="2"/>

<els:element from="Phone_Home_Country" to="Phone_Home_Country" cat="LEAD_PHONE" type="Home" ids="3"/>

<els:element from="Phone_Home_Area" to="Phone_Home_Area" cat="LEAD_PHONE" type="Home" ids="3"/>

<els:element from="Phone_Home_Number" to="PHONE_NUMBER" cat="LEAD_PHONE" type="Home" ids="3"/>

<els:element from="Phone_Business_Country" to="Phone_Business_Country" cat="LEAD_PHONE" type="Business" ids="4"/>

<els:element from="Phone_Business_Area" to="Phone_Business_Area" cat="LEAD_PHONE" type="Business" ids="4"/>

<els:element from="Phone_Business_Number" to="PHONE_NUMBER" cat="LEAD_PHONE" type="Business" ids="4"/>

<els:element from="Phone_Business_Extension" to="Phone_Business_Extension" cat="LEAD_PHONE" type="Business" ids="4"/>

<els:element from="Email_Address_Home_Email" to="LEAD_EMAIL_ADDRESS" cat="LEAD_EMAIL" type="Home" ids="5"/>

<els:element from="Email_Address_Business_Email" to="LEAD_EMAIL_ADDRESS" cat="LEAD_EMAIL" type="Business" ids="6"/>

<els:element from="Std_Primary_Lead_Source" to="Std_Primary_Lead_Source" cat="LEAD_INFO_DETAIL"/>

<els:element from="Create_Date" to="Create_Date" cat="LEAD_INFO_DETAIL"/>

<els:element from="Actual_Program" to="Actual_Program" cat="LEAD_INFO_DETAIL"/>

<els:element from="Program_of_Interest" to="Program_of_Interest" cat="LEAD_INFO_DETAIL"/>

<els:element from="Enrollment_Status" to="Enrollment_Status" cat="LEAD_INFO_DETAIL"/>

<els:element from="Std_Orga_Number" to="Std_Orga_Number" cat="LEAD_INFO_DETAIL"/>

<els:element from="Site_ids" to="Site_ids" cat="LEAD_INFO_DETAIL"/>

</xsl:stylesheet>



However, I do not get the desired effect. I can successfully substitute the element names, but grouping part never behaves the way that I need it.

I appreciate any help that you can provide.

Thanks.

-r

First, I'm not sure why you've made the mapping file be a stylesheet module. Why not make it an ordinary XML document?

Second, I guess from the title of your post that when you write:

<xsl:template match="/">

                        <xsl:apply-templates mode="sub"/>

                         <xsl:apply-templates mode="grouper"/>

            </xsl:template>

you are hoping that the "grouper" template will be applied to the result of the "sub" template. The standard pattern for this in XSLT 2.0 is:

<xsl:variable name="temp">
  <xsl:apply-templates mode="sub"/>
</xsl:variable>
<xsl:apply-templates select="$temp" mode="grouper"/>

In 1.0 this requires the xx:node-set() function which most XSLT processors offer as a vendor extension:

<xsl:variable name="temp">
  <xsl:apply-templates mode="sub"/>
</xsl:variable>
<xsl:apply-templates select="xx:node-set($temp)" mode="grouper"/>


Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference