SSDN - Transforming XML into another XML.

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Thanuja Rao

Subject: Transforming XML into another XML.
Author: Thanuja Rao
Date: 21 Mar 2008 01:39 AM

Hi All,

I am transforming an XML into another XML using XSLT v1.0. My input XML contains a list of questions. Each QUESTION has an attribute called TOPIC which basically mentions the section to which this question belongs to. The questions in the input XML are in a sorted order in the sense, that all questions belonging to a particular topic are together. In my output XML, I need to create an element called section which will have the TOPIC name and within that all questions of that topic need to be listed. So, basically each time the TOPIC attribute changes in the input XML, I need to add a SECTION element to the output. Ensuring that this section element is closed at the end of each section is creating a problem. Could anyone please help me?

Thanks,
Tan

James Durning

Subject: Transforming XML into another XML.
Author: James Durning
Date: 26 Mar 2008 12:32 PM

>Ensuring that this section element is closed at the end of each section is creating a problem.

Are you actually using XSLT 1.0? I hope you're not using output escaping to create elements.

We would need to see the relevant parts of your code to create the correct custom solution.

Thanuja Rao

Subject: Transforming XML into another XML.
Author: Thanuja Rao
Date: 27 Mar 2008 12:41 AM
Originally Posted: 27 Mar 2008 12:40 AM

I dont think I was clear enough in stating my requirement in my previous post. Here are some portions of the code snippets.
Input XML:
<ROOT>
<QUESTION TOPIC="ExamName1\Topic1\Complexity1">
<CONTENT> The 1st Question comes here </CONTENT>
</QUESTION>
<QUESTION TOPIC="ExamName1\Topic1\Complexity1">
<CONTENT> The 2nd Question comes here </CONTENT>
</QUESTION>
</ROOT>

Another Input XML:
<ROOT>
<QUESTION TOPIC="ExamName1\Topic1\Complexity2">
<CONTENT> The 3rd Question comes here </CONTENT>
</QUESTION>
<QUESTION TOPIC="ExamName1\Topic1\Complexity2">
<CONTENT> The 3rd Question comes here </CONTENT>
</QUESTION>
</ROOT>

I am using XSL (may be it is not version 1.0, not very sure) to transform these 2 XML into 1 XML which should look like this.
OUTPUT XML:
<test>
<section>
<sect-name>Topic1\Complexity1</sect-name>
<item>
<description>The 1st Question comes here</description>
</item>
<item>
<description>The 2nd Question comes here</description>
</item>
</section>
<section>
<sect-name>Topic1\Complexity2</sect-name>
<item>
<description>The 1st Question comes here</description>
</item>
<item>
<description>The 2nd Question comes here</description>
</item>
</section>
</test>

The XSLT that I have written looks something like this, which as of now transforms a single XML into another XML and then I run a unix script to club the outputs into a single XML. I am trying to see if I can avoid using Unix.

<xsl:template match="/">
<xsl:apply-templates/>
</xsl:template>

<xsl:template match="ROOT">
<xsl:element name="test">
<xsl:for-each select="/input-file/file">
<xsl:apply-templates select="document(@name)/ROOT/QUESTION"/
</xsl:for-each>
</xsl:template>

<xsl:template match="QUESTION">
<xsl:element name="section">
<xsl:variable name="SectionName">
<xsl:choose>
<xsl:when test="string-length(substring-after(QUESTION/@TOPIC,'\'))=0">
<xsl:value-of select="QUESTION/@TOPIC"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="substring-after(QUESTION/@TOPIC,'\')"/>
</xsl:otherwise>
</xsl:choose>
</xsl:variable>
<xsl:element name="sect-name"><xsl:value-of select="$SectionName"/></xsl:element>
<xsl:element name="item">
<xsl:element name="description"><xsl:value-of select="CONTENT"/> </xsl:element>
</xsl:element>
</xsl:element>
</xsl:template>

Problem here is that every question is surrounded by a section tag. I need the section tag to be added only when the TOPIC changes, or basically the file that i am reading changes. Any help in this regard in appreciated.

Thanks,
Tan

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.