Utilities Blog by JuCa Cruz: January 2011

Monday, January 10, 2011

XSTL: match xmlns

Hello people!
This is my first post of the year and I want to start with something which was driving me crazy for 2 days in a row.
I have a XML which I want to transform into another format by using XSTL:
Input XML

<?xml version='1.0' encoding='UTF-8'?>
<POSServices
    xmlns = "http://pos.odc.vzwcorp.com"
    xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation = "http://pos.odc.vzwcorp.com http://pos.odc.vzwcorp.com">
    <ServiceHeader>
        <userName>motrn1</userName>
        <password>*******</password>
        <clientAppName>DVS</clientAppName>
        <clientAppUserName>VZW-ACSS</clientAppUserName>
        <serviceName>MISC</serviceName>
        <serviceAction>CMELIGIBILITY</serviceAction>
        <applicationResponseCode>NOT_SET</applicationResponseCode>
        <applicationResponseClass>NOT_SET</applicationResponseClass>
        <applicationResponseMessage>NOT_SET</applicationResponseMessage>
        <applicationResponseDetails>NOT_SET</applicationResponseDetails>
        <timeStamp>2011-01-10T10:21:38</timeStamp>
        <storeID/>
        <clientAddlInfo>NETA</clientAddlInfo>
        <transactionId/>
        <sessionID/>
        <serviceAreaZip>00000</serviceAreaZip>
        <responseFormat>XML</responseFormat>
    </ServiceHeader>
    <ServiceBody>
        <cmEligibilityCheck>
            <response>
                <mtn>2022078155</mtn>
                <eligibility>N</eligibility>
            </response>
        </cmEligibilityCheck>
    </ServiceBody>
</POSServices>

If you look carefuly to my input XML, there is something new:
This kind of tag requires some special extra work, because if XML'd come without these extra stuff, like this: My work'd be really easy :D
To solve this issue I have to add these extra information on my stylesheet:

xmlns:n="http://pos.odc.vzwcorp.com" exclude-result-prefixes="n"

Why "n"? Because I wanted :P, I could be using juan, pedro, etc.
Then on my XPath expressions I have to include my prefix on each tag I'm looking for: n:POSServices, n:ServiceBody/n:cmEligibilityCheck/n:response/n:mtn
my XSTL

<?xml version="1.0" encoding="UTF-8" ?> 
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:n="http://pos.odc.vzwcorp.com" exclude-result-prefixes="n"> 
<xsl:output method="xml" indent="yes" /> 
  <xsl:template match="n:POSServices">
  <service>
   <serviceHeader>
    <billingSys>VZW-POS</billingSys>
    <clientId><xsl:value-of select="n:ServiceHeader/n:clientAppUserName"/></clientId>
    <serviceName>posCampaignManagerElegibility</serviceName>
    <userId><xsl:value-of select="n:ServiceHeader/n:clientAppUserName"/></userId>
    <password/>
    <statusCode>00</statusCode>
    <errorCode><xsl:value-of select="n:ServiceHeader/n:applicationResponseCode"/></errorCode>
    <errorMsg><xsl:value-of select="n:ServiceHeader/n:applicationResponseMessage"/></errorMsg>
   </serviceHeader> 
   <serviceBody>
    <serviceResponse>
     <mtn><xsl:value-of select="n:ServiceBody/n:cmEligibilityCheck/n:response/n:mtn"/></mtn>
     <earlyUpgradeIndicator><xsl:value-of select="n:ServiceBody/n:cmEligibilityCheck/n:response/n:eligibility"/></earlyUpgradeIndicator>
    </serviceResponse>
   </serviceBody> 
  </service>
    </xsl:template> 
</xsl:stylesheet>

And finally what you'll get is what you're expecting ;)
Output XML