Remove Namespaces and Process Optional Elements?!

jgec1981 · July 19th, 2010, 10:29 AM

Hi All!!

Does anyone have a solution to convert the XML below which has optional Property elements and multiple namespaces (I've unsuccessfully tried stripping the namespaces using this approach http://dpawson.co.uk/xsl/sect2/N5536.html#d7035e1753):

Code:

<?xml version="1.0" encoding="utf-8"?>
<Message xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xmlns:xsd="http://www.w3.org/2001/XMLSchema"
         UserId="xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" When="2010-07-07T16:42:26.1735814+01:00">
  <Body Name="ABC">
    <Properties xmlns="http://schemas.someone.com/xyz/1234">
      <Property xsi:type="UniqueID" Name="Field_A">
        <Value>12345678-1234-1234-1234-123456789012</Value>
      </Property>
      <Property xsi:type="List" Name="Field_B">
        <Value name="Default Value">1</Value>
      </Property>
      <Property xsi:type="String" Name="Field_C">
        <Value>Something</Value>
      </Property>
    </Properties>
  </Body>
</Message>

To something like this:

Code:

<Message>
  <Who>xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx</Who>
  <When>2010-07-07T16:42:26.1735814+01:00</When>
  <Type>ABC</Type>
  <Field_A>12345678-1234-1234-1234-123456789012</Field_A>
  <Field_B>1</Field_B>
  <Field_C>Something</Field_C>
</Message>

I've been banging my head against the walls for days on this!!! Help, Help, Help!!!!

Martin Honnen · July 19th, 2010, 10:39 AM

Here is a stylesheet:

Code:

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:ns1="http://schemas.someone.com/xyz/1234"
  version="1.0">
  
  <xsl:output indent="yes"/>
  
  <xsl:template match="Message">
    <Message>
      <xsl:apply-templates select="@UserId | @When | Body/@Name | Body/ns1:Properties/ns1:Property"/>
    </Message>
  </xsl:template>
  
  <xsl:template match="@*">
    <xsl:element name="{local-name()}">
      <xsl:value-of select="."/>
    </xsl:element>
  </xsl:template>

  <xsl:template match="ns1:Property">
    <xsl:element name="{@Name}">
      <xsl:value-of select="ns1:Value"/>
    </xsl:element>
  </xsl:template>
  
</xsl:stylesheet>

mhkay · July 19th, 2010, 10:39 AM

The FAQ that you've cited contains the answer. If you haven't made it work, you've done something wrong; so show us what you tried, and we can tell you where you went wrong.

samjudson · July 19th, 2010, 10:41 AM

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                xmlns:xyz="http://schemas.someone.com/xyz/1234"
                version="1.0">
   <xsl:output indent="yes"/>

    <xsl:template match="Message">
    	<Message>
	    		  <Who>
            <xsl:value-of select="@UserId"/>
         </Who>
	    		  <When>
            <xsl:value-of select="@When"/>
         </When>
	    		  <Type>
            <xsl:value-of select="Body/@Name"/>
         </Type>
         <xsl:for-each select="Body/xyz:Properties/xyz:Property">
         	<xsl:element name="{@Name}"><xsl:value-of select="xyz:Value"/></xsl:element>
         	</xsl:for-each>
    		</Message>
    	</xsl:template>

</xsl:stylesheet>

jgec1981 · July 19th, 2010, 10:50 AM

You guys are amazing..... All problems solved and thank you - this has really made my day

joefawcett · July 19th, 2010, 11:41 AM

That output also assumes that the attribute Name contains a legal XML name. In some ways the input XML is a better design. Possibly a more usable schema would be:

Code:

<Message>
  <property name="Who">xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx</property >
  <property name="When">2010-07-07T16:42:26.1735814+01:00</property >
  <property name="Type">ABC</property >
 <!-- etc. -->
</Message>

Which is also easier to search and process.