XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Transforming XML into another XML.
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + how to insert un return in the... (2)
-> + String in a range (5)
-> + To identify the right edition (4)
-> + Flow Control Feature (2)
-> + calling nested external functi... (3)
-> + Replacing commas with a blank (6)
-> + Grouping very urgent . (2)
-> + xsl node number (3)
-> + Wordml intelligence (6)
-> + Preview and backmapping for wo... (5)
-> + XSLT - find line numbers of di... (2)
-> + The last five bytes of a varia... (7)
-> + simple problem but i'm a bit t... (3)
-> + H plz help me (2)
-> + XSLT : Very Urgent Requirement (7)
-> + comparing two xml files (3)
-> + Support for xsl created from w... (4)
-> + Wildcard Param (3)
-> + XSLT OutOfMemoryError (3)
-> + How can I output the filename ... (7)
-> + How do I strip out a comma ast... (8)
-> + xslt current-dateTime() not re... (2)
-> + Exceed the maximum recursion d... (8)
-> + Saxon9 "java.net.ConnectExcept... (2)
-> - Help Required (1)
-> + XSLT Help to get value from Up... (2)
-> + Date Functions (5)
-> + Need to unescape < and > (2)
-> + No Topic (2)
-> + Problem with handling multiple... (3)
-> + Question XPath expression (dis... (2)
-> + New user, basic question (2)
-> + Serializing XML to a string wi... (2)
-> + Node already has a control li... (2)
-> + Trying to access the position ... (5)
-> + XSLT Help (2)
-> + XSLT, Microsoft Access, and re... (4)
-> + saxon:assign usage problem. (5)
-> + Help with XSLT mapping require... (4)
-> + Muenchian Grouping problem (6)
-> + Automatic postprocessing (2)
-> + Problem Setting Variable (3)
-> - Problem Setting Variable (1)
-> + Looping question (14)
-> + Attribute Centeric XML from Re... (2)
-> + How do I do this ? (2)
-> + Accessing an attribute based o... (3)
-> + help needed - using saxon thro... (2)
-> + Grouping Problem still (6)
-> + Use XSL-FO to create tables fr... (6)
-> + taking out a child and (6)
-> + Yet another problem (3)
-> + using XSL-FO to convert PDF (4)
-> + Preventing namespace declarati... (2)
-> + Small problem during conversio... (4)
-> + Problems removing namespaces (2)
-> + Grouping/Following question (4)
-> - Transforming XML into another ... (3)
-> ->Transforming XML into ano...
-> ->Transforming XML into ano...
-> + Help Needes (3)
-> - Help needed! (1)
-> + Conv of DSML Format to XML for... (2)
-> - Regd, entering text in the t... (1)
-> + displaying all the text around... (4)
-> + inserting values into empty ta... (5)
-> + How to get rid of xmlns="" att... (3)
-> + XSLT How to include the '<' sy... (2)
-> - HELP: Functional XSLT Implemen... (1)
-> - Cannot find a matching 1-argum... (1)
-> + XSLT a:? (2)
-> + Attribute Value Concatenation (2)
-> - Why is the WYSIWYG xslt editor... (1)
-> + WebService Call Error: Ref ele... (4)
-> + How to replace value of a fiel... (2)
-> + Schema Validation Problems (3)
-> + Reusing a prior valid value in... (5)
-> + Clutching at straws! (2)
-> + Adding a number to a for each ... (2)
-> + Transform Name Value pairs int... (4)
-> + Transform the XML Scheme with ... (2)
-> + create XML drop down lists (2)
-> + error during stylesheet tutori... (3)
-> + Modify the value in a element ... (2)
-> + Call to extension function fai... (2)
-> + Convert XML Schema to XML - Mi... (2)
-> + How to calculate maximun RowCo... (3)
-> + Help with using not(preceding:... (5)
-> - Please Help me on this XML to ... (1)
-> + Paasing Parameter Values From ... (6)
-> + XSLT Transformation w/ namespa... (3)
-> + For-each select and parameter ... (3)
-> + Using < (less than) operator (5)
-> + Inserting carriage return (spe... (3)
-> + Inserting carriage return (spe... (2)
-> + Help with SerializerTrace erro... (8)
-> + xml to x3d (5)
-> + Exiting processing loop early (2)
-> + Easy way to Convert One source... (3)
-> + XSLT Editor tab missing from D... (2)
-> + Writing strings of characters ... (4)
-> + Adding the content of an eleme... (3)
-- Previous [601-620] [621-640] [641-660] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Thanuja RaoSubject: 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
Postnext
James DurningSubject: 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.

Posttop
Thanuja RaoSubject: 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:<!--please note the change in the topic-->
<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><!--for description-->
</xsl:element><!--for item-->
</xsl:element><!--for section-->
</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
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.