xsl-list
[Top] [All Lists]

RE: [xsl] using key to merge data

2007-10-22 12:58:09
If you want the children of question/info to be copied, then you need to
copy them, just as you are currently copying the attributes. For example you
could do:

  <xsl:template match="question/info">
     <xsl:copy>
       <xsl:copy-of select="@*|*"/> <!-- note change here -->
       <xsl:variable name="question_g_code" select="notes"/>
       <xsl:for-each select="$standardFile">
         <xsl:copy-of select="key('standard_by_g_code', 
$question_g_code)"/>
       </xsl:for-each>
     </xsl:copy>
  </xsl:template>
</xsl:stylesheet>

Michael Kay
http://www.saxonica.com/

-----Original Message-----
From: Terry Ofner [mailto:tofner(_at_)comcast(_dot_)net] 
Sent: 22 October 2007 20:52
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] using key to merge data

Greetings,

I am trying to merge a set of standards into another xml 
file. I have tried using document() pointing to a separate 
file as well as incorporating the standards into the 
stylesheet. With both methods I run into a similar problem. 
The standards information merges fine. 
However, it removes the sibling nodes from tree. Here is the 
basic structure of the xml file I am importing into:

<top>
      <question>
              <info>
                      <topic>Vocabulary</topic>
                      <keyword>Prefixes</keyword>
                      <notes>G4U1S01></notes>
                      <foo>blah blah</foo>
              </info>
      </question>
</top>

The standards.xml file looks like this:

<top>
      <standard>
              <g_code>G4U1S01</g_code>
              <state-obj state="AZ">blah blah blah</state-obj>
              <state-obj state="TX">blah blah blah</state-obj>
              . . .
      </standard>
</top>


When I run the stylesheet below, the <notes> node along with 
all the sibling nodes are removed from the <info> node.

<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
    <xsl:import href="copy.xslt"/>
    <xsl:output method="xml"/>

    <xsl:variable name="standardFile" 
select="document('standards.xml')"/>
    <xsl:key name="standard_by_g_code" match="standard" use="g_code"/>

  <xsl:template match="/">
     <xsl:copy>
       <xsl:apply-templates/>
     </xsl:copy>
  </xsl:template>

  <xsl:template match="question/info">
     <xsl:copy>
       <xsl:copy-of select="@*"/>
       <xsl:variable name="question_g_code" select="notes"/>
       <xsl:for-each select="$standardFile">
         <xsl:copy-of select="key('standard_by_g_code', 
$question_g_code)"/>
       </xsl:for-each>
     </xsl:copy>
  </xsl:template>
</xsl:stylesheet>


The current result looks like this:

<top>
      <question>
              <info>
              <standard>
              <g_code>G4U1S01</g_code>
              <state-obj state="AZ">blah blah blah</state-obj>
              <state-obj state="TX">blah blah blah</state-obj>
              . . .
              </standard>
              </info>
      </question>
</top>

I am looking for this:

<top>
      <question>
              <info>
                      <topic>Vocabulary</topic>
                      <keyword>Prefixes</keyword>
                      <notes>G4U1S01></notes>
                      <foo>blah blah</foo>
                      <state-obj state="AZ">blah blah blah</state-obj>
                      <state-obj state="TX">blah blah blah</state-obj>
                      . . .
              </info>
      </question>
</top>


No doubt there something simple that I am doing wrong.

FYI: the  <xsl:import href="copy.xslt"/> points to this stylesheet:

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

Thanks in advance.

Terry

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--