XSLT - Convert XML Element Name and add Attribute

Question

I have an XML file being sent to me from a third-party in the following format:

<Events>
  <COMPLETE>
    <TASK>1</TASK>
    <TIME>18:29</TIME>
    <USER>User1</USER>
    <DEP>OPPS</DEP>
  </COMPLETE>
  <PROGRESS>
    <TASK>2</TASK>
    <TIME>09:15</TIME>
    <USER>User1</USER>
    <DEP>OPPS</DEP>
  </PROGRESS>
  <PROGRESS>
    <TASK>2</TASK>
    <TIME>11:41</TIME>
    <USER>User2</USER>
    <DEP>COMS</DEP>
  </PROGRESS>
  <CLOSED>
    <TASK>3</TASK>
    <TIME>17:10</TIME>
    <DETAILS>
       <TIMECLOSED>17:01</TIMECLOSED>
       <CHECKEDBY>User9</CHECKEDBY>
    </DETAILS>
    <TAKEN>6.5</TAKEN>
    <USER>User8</USER>
    <DEP>FUNDS</DEP>
  </CLOSED>
  <COMPLETE>
    <TASK>4</TASK>
    <TIME>18:03</TIME>
    <USER>User3</USER>
    <DEP>COMS</DEP>
  </COMPLETE>
<Events>

Is there a way using XSLT to convert the child nodes of the Events element to be named Event and have an attribute called Name with the current child elements name. The output I was looking for is:

<Events>
  <Event Name='COMPLETE'>              <-- Changed
    <TASK>1</TASK>
    <TIME>18:29</TIME>
    <USER>User1</USER>
    <DEP>OPPS</DEP>
  </Event>
  <Event Name='PROGRESS'>              <-- Changed
    <TASK>2</TASK>
    <TIME>09:15</TIME>
    <USER>User1</USER>
    <DEP>OPPS</DEP>
  </Event>
  <Event Name='PROGRESS'>              <-- Changed
    <TASK>2</TASK>
    <TIME>11:41</TIME>
    <USER>User2</USER>
    <DEP>COMS</DEP>
  </PROGRESS>
  <Event Name='CLOSED'>                <-- Changed
    <TASK>3</TASK>
    <TIME>17:10</TIME>
    <DETAILS>
       <TIMECLOSED>17:01</TIMECLOSED>
       <CHECKEDBY>User9</CHECKEDBY>
    </DETAILS>
    <TAKEN>6.5</TAKEN>
    <USER>User8</USER>
    <DEP>FUNDS</DEP>
  </Event>
  <Event Name='COMPLETE'>              <-- Changed
    <TASK>4</TASK>
    <TIME>18:03</TIME>
    <USER>User3</USER>
    <DEP>COMS</DEP>
  </Event>
<Events>

I've looked online considerably and can not find how to do this. Many thanks!

What have you tried? Share your attempts and I am sure someone will be eager to comment/share a hint. — Grzegorz Oledzki
– Grzegorz Oledzki, Commented Oct 21, 2014 at 11:40
@Thomas Byme Take a look at this : stackoverflow.com/questions/4824843/… — Thirisangu Ramanathan
– Thirisangu Ramanathan, Commented Oct 21, 2014 at 11:43

zx485 · Accepted Answer · 2014-10-21 13:23:16Z

1

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xi="http://www.w3.org/2001/XInclude">
  <xsl:output method="xml" version="1.0" encoding="utf-8" indent="yes"/>
  <xsl:template match="/Events">
    <xsl:element name="Events">
      <xsl:for-each select="*">
        <xsl:element name="Event">
          <xsl:attribute name="Name">
            <xsl:value-of select="local-name()"/>
          </xsl:attribute>
          <xsl:copy-of select="*"/>
        </xsl:element>
      </xsl:for-each>
    </xsl:element>
  </xsl:template>
</xsl:stylesheet>

This should do the job. A little bit more verbose than the previous answer, though.

answered Oct 21, 2014 at 13:23

zx485

29.1k28 gold badges55 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tony Graham · Accepted Answer · 2014-10-23 08:01:10Z

1

As an addition to an identity stylesheet:

<xsl:stylesheet version="1.0"
                xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="PROGRESS | CLOSED | COMPLETE">
  <Event Name="{local-name()}">
    <xsl:apply-templates />
  </Event>
</xsl:template>

<xsl:template match="@*|node()">
  <xsl:copy>
    <xsl:apply-templates select="@*|node()"/>
  </xsl:copy>
</xsl:template>

</xsl:stylesheet>

edited Oct 23, 2014 at 8:01

answered Oct 21, 2014 at 12:13

Tony Graham

8,15316 silver badges20 bronze badges

Collectives™ on Stack Overflow

XSLT - Convert XML Element Name and add Attribute

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related