Changing Plain XML into Customized XML using XSLT

Question

naomimoogle 0 Newbie Poster

10 Years Ago

Hello I have an input:

<Records>
  <Record>
    <Row A="UOBSGD2" B="50000"/>
  </Record>
  <Record>
    <Row A="UOBSGD1" B="75050"/>
  </Record>
  <Record>
    <Row A="DBSSGD2" B="55800"/>
  </Record>
  <Record>
    <Row A="DBSSGD1" B="14239"/>
  </Record>
  <Record>
    <Row A="OCBCSGD1" B="55510"/>
  </Record>
  <Record>
    <Row A="OCBCSGD2" B="31714"/>
  </Record>
  <Record>
    <Row A="UOBUSD1" B="36471.1"/>
  </Record>
  <Record>
    <Row A="UOBUSD2" B="41941.765"/>
  </Record>
  <Record>
    <Row A="UOBUSD3" B="48233.02975"/>
  </Record>
  <Record>
    <Row A="DBSUSD1" B="55467.9842125"/>
  </Record>
  <Record>
    <Row A="OCBCUSD1" B="14239"/>
  </Record>
  <Record>
    <Row A="OCBCUSD2" B="16374.85"/>
  </Record>
  <Record>
    <Row A="OCBCEUR1" B="45857"/>
  </Record>
  <Record>
    <Row A="OCBCEUR2" B="19239"/>
  </Record>
  <Record>
    <Row A="DBSEUR1" B="33510"/>
  </Record>
</Records>

I need to change this to Output XML:

<chart>
  <set label='UOBSGD2' value='50000' />
  <set label='UOBSGD1' value='75050' />
  <set label='DBSSGD2' value='55800' />
  <set label='DBSSGD1' value='14239' />
  <set label='OCBCSGD1' value='55510' />
  <set label='OCBCSGD2' value='31714' />
  <set label='UOBUSD1' value='36471.1' />
  <set label='UOBUSD2' value='41941.765' />
  <set label='UOBUSD3' value='48233.03' />
  <set label='DBSUSD1' value='55467.98' />
  <set label='OCBCUSD1' value='14239' />
  <set label='OCBCUSD2' value='16374.85' />
  <set label='OCBCEUR1' value='45857' />
  <set label='OCBCEUR2' value='19239' />
  <set label='DBSEUR1' value='33510' />
</chart>

By using XSLT.. Can someone please help me?
Many Thanks!!!

xml

2 Contributors
8 Replies
291 Views
3 Days Discussion Span
Latest Post 10 Years Ago Latest Post by xml_looser

xml_looser 3 Junior Poster

10 Years Ago

I do not know where the node employee details coming from.
is the best way to solve
each node, and then select the value and or attribute
specify
do not think like a programmed but for node node
respond and evaluate

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output indent="yes" omit-xml-declaration="yes" method="xml"/>
    <xsl:template match="/">
        <chart>
            <xsl:apply-templates select="Records"/>
        </chart>
    </xsl:template>
    <xsl:template match="Records">
        <xsl:apply-templates select="Record"/>
    </xsl:template>
    <xsl:template match="Record">
        <xsl:apply-templates select="Row"/>
    </xsl:template>
    <xsl:template match="Row">
        <set>
            <xsl:attribute name="label">
                <xsl:value-of select="@A"/>
            </xsl:attribute>
            <xsl:attribute name="alue">
                <xsl:value-of select="@B"/>
            </xsl:attribute>
        </set>
    </xsl:template>
</xsl:stylesheet>

xml_looser 3 Junior Poster

10 Years Ago

found information and cat

<xsl:variable name="mon" select="format-number(substring-before(@name,'/'),'00')"/>
<xsl:variable name="day" select="format-number(substring-before(substring-after(@name,'/'),'/'),'00')"/>
<xsl:variable name="year" select="substring-after(substring-after(@name,'/'),'/')"/>

concat with

<xsl:value-of select="concat($year,'-',$mon,'-',$day)"/>





<?xml version="1.0"?>
<Records>
    <Record>
        <Row A="UOBSGD2" B="50000" name='1/1/2014' />
    </Record>
    <Record>
        <Row A="UOBSGD1" B="75050" name='1/2/2014'/>
    </Record>
    <Record>
        <Row A="DBSSGD2" B="55800" name='1/4/2014'/>
    </Record>
    <Record>
        <Row A="DBSSGD1" B="14239" name='1/5/2014'/>
    </Record>
    <Record>
        <Row A="OCBCSGD1" B="55510" name='1/6/2014'/>
    </Record>
    <Record>
        <Row A="OCBCSGD2" B="31714" name='1/16/2014'/>
    </Record>
    <Record>
        <Row A="UOBUSD1" B="36471.1"/>
    </Record>
    <Record>
        <Row A="UOBUSD2" B="41941.765"/>
    </Record>
    <Record>
        <Row A="UOBUSD3" B="48233.02975"/>
    </Record>
    <Record>
        <Row A="DBSUSD1" B="55467.9842125"/>
    </Record>
    <Record>
        <Row A="OCBCUSD1" B="14239"/>
    </Record>
    <Record>
        <Row A="OCBCUSD2" B="16374.85"/>
    </Record>
    <Record>
        <Row A="OCBCEUR1" B="45857"/>
    </Record>
    <Record>
        <Row A="OCBCEUR2" B="19239"/>
    </Record>
    <Record>
        <Row A="DBSEUR1" B="33510"/>
    </Record>
</Records>



<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output indent="yes" omit-xml-declaration="yes" method="xml"/>
    <xsl:template match="/">
        <chart>
            <xsl:apply-templates select="Records"/>
        </chart>
    </xsl:template>
    <xsl:template match="Records">
        <xsl:apply-templates select="Record"/>
    </xsl:template>
    <xsl:template match="Record">
        <xsl:apply-templates select="Row"/>
    </xsl:template>
    <xsl:template match="Row">
        <xsl:variable name="mon" select="format-number(substring-before(@name,'/'),'00')"/>
        <xsl:variable name="day" select="format-number(substring-before(substring-after(@name,'/'),'/'),'00')"/>
        <xsl:variable name="year" select="substring-after(substring-after(@name,'/'),'/')"/>

        <set>
            <xsl:attribute name="label">
                <xsl:value-of select="@A"/>
            </xsl:attribute>
            <xsl:attribute name="value">
                <xsl:value-of select="@B"/>
            </xsl:attribute>
            <xsl:if test="@name">
            <xsl:attribute name="name">

                <xsl:value-of select="concat($year,'-',$mon,'-',$day)"/>
            </xsl:attribute>
            </xsl:if>
        </set>
    </xsl:template>
</xsl:stylesheet>




<chart>
  <set label="UOBSGD2" value="50000" name="2014-01-01"/>
  <set label="UOBSGD1" value="75050" name="2014-01-02"/>
  <set label="DBSSGD2" value="55800" name="2014-01-04"/>
  <set label="DBSSGD1" value="14239" name="2014-01-05"/>
  <set label="OCBCSGD1" value="55510" name="2014-01-06"/>
  <set label="OCBCSGD2" value="31714" name="2014-01-16"/>
  <set label="UOBUSD1" value="36471.1"/>
  <set label="UOBUSD2" value="41941.765"/>
  <set label="UOBUSD3" value="48233.02975"/>
  <set label="DBSUSD1" value="55467.9842125"/>
  <set label="OCBCUSD1" value="14239"/>
  <set label="OCBCUSD2" value="16374.85"/>
  <set label="OCBCEUR1" value="45857"/>
  <set label="OCBCEUR2" value="19239"/>
  <set label="DBSEUR1" value="33510"/>
</chart>

Edited 10 Years Ago by xml_looser

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

naomimoogle 0 Newbie Poster · Answer 1 · 2014-06-15T06:29:00+00:00

This is my XLST

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="xml"/>
  <xsl:template match="Chart">

    <Chart>
      <xsl:apply-templates select="EmployeeDetails" />
    </Chart>

  </xsl:template>


  <xsl:template match="Chart">

      <xsl:attribute name="A">
        <xsl:value-of select="@label" />
      </xsl:attribute>
      <xsl:attribute name="B">
        <xsl:value-of select="@value" />
      </xsl:attribute>



  </xsl:template>


</xsl:stylesheet>

I'm not sure if this is correct... Most likely it isn't... but I'm new at it... so please help me...

Thanks!

naomimoogle 0 Newbie Poster · Answer 2 · 2014-06-17T08:35:14+00:00

Thanks so much!!
I have one more question to ask you...

This is my desired XML:

<graph> 
 <categories>
    <category name='1/1/2014' />
    <category name='1/2/2014' />
    <category name='1/3/2014' />
  </categories>
</graph>

I used this XSLT:

 <graph>
   <xsl:apply-templates select="//row">
    <xsl:sort select="@line" />
   </xsl:apply-templates>
 </graph>

</xsl:template>

  <xsl:template match="//row">
    <xsl:element name="category">

      <xsl:attribute name="name">
        <xsl:value-of select="@Date" />
      </xsl:attribute>

    </xsl:element>
  </xsl:template>

</xsl:stylesheet>

But the result of my new XML is:

<graph>
<category name="2014-01-01"/>
<category name="2014-01-02"/>
<category name="2014-01-03"/>
</graph>

Can you please tell me why am I not getting the:

  <categories>
    <category name='1/1/2014' />
    <category name='1/2/2014' />
    <category name='1/3/2014' />
    <category name='1/4/2014' />
  </categories>

like i'm suppose to be having please?

xml_looser 3 Junior Poster · Answer 3 · 2014-06-17T10:37:50+00:00

xml_looser 3 Junior Poster

10 Years Ago

look here

naomimoogle 0 Newbie Poster · Answer 4 · 2014-06-18T01:51:24+00:00

It can't work >.<

  <xsl:template match="categories">

  <categories>
      <xsl:element name="category">  

      <xsl:attribute name="name">
        <xsl:value-of select="@Date" />
      </xsl:attribute>

      </xsl:element>
  </categories>

  </xsl:template>

naomimoogle 0 Newbie Poster · Answer 5 · 2014-06-18T05:09:22+00:00

Is it like this?

  <xsl:template match="*[not(self::categories)][category]">

    <xsl:element name="category">
      <xsl:attribute name="name">
        <xsl:value-of select="@Date" ></xsl:value>
      </xsl:attribute>
    </xsl:element>

    <xsl:copy>
      <xsl:apply-templates select="@*|node()[not(self::category)]"></xsl:apply>
      <categories>
        <xsl:apply-templates select="category"></xsl:apply>
      </categories>
    </xsl:copy>

  </xsl:template>

naomimoogle 0 Newbie Poster · Answer 6 · 2014-06-18T09:10:43+00:00

naomimoogle 0 Newbie Poster

10 Years Ago

Please help me......