In that case you may want to export the data as xml file. Use the "Rational ClearQuest Client" (not the windows client) and click on the "export query results" icon above the query results pane. This will open a window where you can select the export format. In this window select the xml format and you can get the results as an xml file. (You can find detailed instruction on how to import here) However, the xml file is not very friendly to read. You can create a simple xsl file and add a single line to the xml file to use the xsl file you just created to make the file more reader friendly.
Here is a sample xsl file you can use: (You can download a copy from here)
<?xml version="1.0" encoding="ISO-8859-1"?
> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html> <body> <h2>My ClearQuest Results </h2> <table> <xsl:for-each select="exportedResults/columnNames"> <tr bgcolor="gray"> <xsl:for-each select="columnName"> <th><xsl:value-of select="."/> </th> </xsl:for-each> </tr> </xsl:for-each> <xsl:for-each select="exportedResults/records/record"> <tr> <xsl:for-each select="field"> <td><xsl:value-of select="."/></td> </xsl:for-each> </tr> </xsl:for-each> </table> </body> </html> </xsl:template> </xsl:stylesheet>
> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html> <body> <h2>My ClearQuest Results </h2> <table> <xsl:for-each select="exportedResults/columnNames"> <tr bgcolor="gray"> <xsl:for-each select="columnName"> <th><xsl:value-of select="."/> </th> </xsl:for-each> </tr> </xsl:for-each> <xsl:for-each select="exportedResults/records/record"> <tr> <xsl:for-each select="field"> <td><xsl:value-of select="."/></td> </xsl:for-each> </tr> </xsl:for-each> </table> </body> </html> </xsl:template> </xsl:stylesheet>
You can add the following line to the generated xml so you tell the browser to use the xsl. Make sure that the xsl and xml fiels are in the same directory.
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="cqTransform.xsl"?>
<!--Generated by ClearQuest Eclipse client Mon Aug 23 14:43:15 EDT 2010-->
4 comments:
Our writers are the leaders of their profession. Their expertise is the key to your academic success. Unlock the door to new https://essaysrescue.com/edubirdie-review/ opportunities and advances! Furthermore, when a client places their first order, we provide a 5% discount on what they ordered.
We have a rigorous recruitment process that filters the mediocre writers from the experts essay writer. Each prospective research paper writer must pass several tests to determine whether they are a perfect candidate for the job.
This is what I’m searching for, thank you so much for providing this detailed information. I will it with my classmates and also post it to my social media page so more and more students will see this post. Is that ok wait you? On the other hand, a have a crucial beginner tips article here that I want you to read. The content is very interesting especially if you are into gaming. Please visit site to check it. Thanks!
The guide on exporting ClearQuest records to Excel is incredibly useful for anyone working with data management! As a student often juggling multiple responsibilities, I sometimes find myself needing someone to take my class for me to keep up with coursework while tackling practical tasks like this. It’s great to have resources that simplify complex processes, making our academic and professional lives easier.
Post a Comment