RE: [xsl] XSLT to query/output a portion of an XML source document

Thanks for the responses.  Based on your help, the
following stylesheet was implemented.

<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
        <xsl:strip-space elements="*"/>
        <xsl:output method="xml" indent="yes"
encoding="UTF-8"/>
        
        <xsl:param name="productid"/>
        <xsl:param name="productidext"/>
        <xsl:param name="companynumber"/>
        
        <xsl:template match="/">

        <DataService>
                <Transaction>
                        <Command type="Add">
                                <MasterCatalogRecord etype="Entity"
commandqualifier="Validate/Process">    

                                        <xsl:apply-templates/>
                
                                </MasterCatalogRecord>
                        </Command>
                </Transaction>
        </DataService>                  
        
        </xsl:template>    
        
        <xsl:template match="Transaction">
                <xsl:apply-templates/>
        </xsl:template>
        
        <xsl:template match="Response">
                <xsl:apply-templates
select="MasterCatalogRecord[ExternalKeys[Key[(_at_)name='PRODUCTID']=$productid
and Key[(_at_)name='PRODUCTIDEXT']=$productidext]]"/>
        </xsl:template>
        
        <xsl:template match="MasterCatalogRecord">
                <xsl:copy-of select="ExternalKeys"/>
                <xsl:copy-of select="EntityData"/>
        </xsl:template>
        
<!--    <xsl:template
match="//DataService/Transaction/Response/MasterCatalogRecord/ExternalKeys/Key[(_at_)name='PRODUCTIDEXT']">-->
        <xsl:template
match="//Key[(_at_)name='PRODUCTIDEXT']/text()">
                <xsl:value-of select="$companynumber"/>
        </xsl:template> 

        
                
        <xsl:template match="TransactionResult">
        </xsl:template> 

</xsl:stylesheet>


I now have a requirement to only extract the <Key>
elements which have values.

Thanks in advance.
Chris


--- cknell(_at_)onebox(_dot_)com wrote:

> I had to clean up your XML ("MasterCatalogResponse"
> in the opening tag does not match "" in the closing
> tag), but here is a quick and dirty stylesheet that
> does what you ask.
>
> Whenever I do one of these, the next person to come
> along invariably has a much more elegant solution,
> so you may want to hold your fire pending further
> responses.
>
> <?xml version="1.0"?>
> <xsl:stylesheet version="2.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
>   <xsl:strip-space elements="*" />
>   <xsl:output method="xml" indent="yes"
> encoding="UTF-8" />
>   
>   <xsl:param name="key1" />
>   <xsl:param name="key2" />
>
>     <xsl:template match="/">
>         <xsl:apply-templates />
>     </xsl:template>
>     
>       <xsl:template match="Transaction">
>         <xsl:apply-templates />
>       </xsl:template>
>       
>       <xsl:template match="Response">
>         <xsl:apply-templates
> select="MasterCatalogResponse[ExternalKeys[Key=$key1
> and Key=$key2]]" />
>       </xsl:template>
>       
>       <xsl:template match="MasterCatalogResponse">
>         <xsl:copy-of select="EntityData" />
>       </xsl:template>
>
> </xsl:stylesheet>
> -- 
> Charles Knell
> cknell(_at_)onebox(_dot_)com - email
>
>
>
> -----Original Message-----
> From:     Chris Coyle <chriscoyle(_at_)yahoo(_dot_)com>
> Sent:     Wed, 24 Jan 2007 11:51:12 -0800 (PST)
> To:       "Mullberytech.com"
> <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
> Subject:  [xsl] XSLT to query/output a portion of an
> XML source document
>
>
>
> I need to write a query to pull 1 node out of a
> source
> XML document.
>
> The source document has a structure of 
>
> <Transaction>
>       <Response>
>               <MasterCatalogResponse>
>                       <ExternalKeys>
>                               <Key>1</Key>
>                               <Key>a</Key>
>                       </ExternalKeys>
>                               <EntityData>
>                                       <Attribute>a</Attribute>
>                                       <Attribute>b</Attribute>
>                               </EntityData>
>               </MasterCatalogRecord>
>               <MasterCatalogResponse>
>                       <ExternalKeys>
>                               <Key>2</Key>
>                               <Key>b</Key>
>                       </ExternalKeys>
>                               <EntityData>
>                                       <Attribute>a</Attribute>
>                                       <Attribute>b</Attribute>
>                               </EntityData>
>               </MasterCatalogRecord>
>               <MasterCatalogResponse>
>                       <ExternalKeys>
>                               <Key>3</Key>
>                               <Key>c</Key>
>                       </ExternalKeys>
>                               <EntityData>
>                                       <Attribute>a</Attribute>
>                                       <Attribute>b</Attribute>
>                               </EntityData>
>               </MasterCatalogRecord>
>       </Response>
> </Transaction>
>
> I need to extract the <EntityData> element for a
> given
> <ExternalKeys> value match.  The result should look
> like this for an ExternalKeys  (2,b)
>
>                               <EntityData>
>                                       <Attribute>a</Attribute>
>                                       <Attribute>b</Attribute>
>                               </EntityData>
>
>
> This is what I tried:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <?altova_samplexml SampleQueryResponse.xml?>
> <xsl:stylesheet version="2.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
> xmlns:fo="http://www.w3.org/1999/XSL/Format";
> xmlns:xs="http://www.w3.org/2001/XMLSchema";
> xmlns:fn="http://www.w3.org/2005/xpath-functions";>
>
>     <xsl:output method="xml" encoding="UTF-8"
> indent="yes" />
>
> <xsl:template match="/">
>    <xsl:for-each
select="//DataService/Transaction/Response/MasterCatalogRecord">
>          <xsl:element name="EntityData">
>                  <xsl:value-of select="."/>
>          </xsl:element>
>    </xsl:for-each>
>  </xsl:template>
>
> </xsl:stylesheet>
>
>
> Any suggestions are welcome.
>
>       
>
>
>
>  
____________________________________________________________________________________
> Bored stiff? Loosen up... 
> Download and play hundreds of games for free on
> Yahoo! Games.
> http://games.yahoo.com/games/front
--~------------------------------------------------------------------
> 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>
> --~--


 
____________________________________________________________________________________
Food fight? Enjoy some healthy debate 
in the Yahoo! Answers Food & Drink Q&A.
http://answers.yahoo.com/dir/?link=list&sid=396545367

--~------------------------------------------------------------------
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>
--~--