Using XSLT to transform one XML format to other

sivakumar_g01 · June 14th, 2010, 08:42 AM

Hi,

I am using XSLT for Xforming one XML format to other. Both the formats are given below:

Source Format:
<ns0:UserInput>
<ns0:attr name="UserCode"> <ns0:value>user</ns0:value> </ns0:attr>
<ns0:attr name="Pasword"> <ns0:value>user</ns0:value> </ns0:attr>
</ns0:UserInput>

Target Format:
<ns1:CreateUser>
<ns1:UserCode> user </ns1:UserCode>
<ns1:Pasword> user </ns1:Pasword>
</ns1:CreateUser>

basically if we see the element name in target format(UserCode) is nothing but the attr name in source format(UserCode). I don't want to hardcode and apply this logic in XSLT. how can this be done using xslt?

Thanks
Siva

Martin Honnen · June 14th, 2010, 08:55 AM

You could do it along these lines:

Code:

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:ns0="http://example.com/ns0"
  xmlns:ns1="http://example.com/ns1"
  exclude-result-prefixes="ns0"
  version="1.0">
 
  <xsl:template match="ns0:UserInput">
     <ns1:CreateUser>
       <xsl:apply-templates/>
     </ns1:CreateUser>
  </xsl:template>

  <xsl:template match="ns0:UserInput/ns0:attr">
     <xsl:element name="ns1:{@name}">
        <xsl:apply-templates/>
     </xsl:element>
   </xsl:template>

</xsl:stylesheet>

You will have to adjust the namespaces to ones actually used in your input and output formats.

sivakumar_g01 · June 14th, 2010, 09:35 AM

Hi Martin,

I think i have misled your answer because of my little experience with XSLT,not sure whether i can make use of this in my scenario.. I am trying to put my actual scenario. Actually i have source and target xsds and have to use xslt to convert from one xsd formatted XML to another xsd formatted XML.

Source XSD:
<xsd:complexType name="CreateUserAttr">
<xsd:sequence>
<xsd:element name="value" type="DsmlValue"/>
</xsd:sequence>
<xsd:attribute name="name" type="CreateUserDescValue" use="required"/>
</xsd:complexType>

<xsd:complexType name="UserInput">
<xsd:sequence>
<xsd:element name="attr" type="CreateUserAttr"/>
</xsd:sequence>
</xsd:complexType>

<xsd:element name="UserInput" type="UserInput"/>

Target XSD:
<xsd:complexType name="Input">
<xsd:sequence>
<xsd:element name="UserCode" type="xsd:string"/>
<xsd:element name="Password" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
<xsd:element name="CreateUser" type="Input"/>

So to do this i am creating the xstl like below. And in if scenario i dont want to hard code it to 'UserCode' or 'Password' and wants to use use any in built function, so that i will be able to extend my xsds in future without worrrying about xslt Xformation. Please let me know how can i get the UserCode element name in if condition below. I was unable to refer any target element in xslt if condition.

<xsl:template match="/">
<ns1:CreateUser>
<xsl:for-each select="/ns0:UserInput/ns0:attr">
<xsl:if test="@name = 'UserCode'">
<ns1:UserCode>
<xsl:value-of select="ns0:value"/>
</ns1:UserCode>
</xsl:if>
</xsl:for-each>
</ns1:UserCreateInput>
</xsl:template>

Thanks
Siva

Martin Honnen · June 14th, 2010, 09:45 AM

I am afraid I don't really understand what you write in your second post. You say you don't want to "hard code" UserCode or Password. The stylesheet I posted does not hard code them so why can't you use it?