RE: Help to convert an XML document to another format

cknell Mon, 01 Aug 2005 08:27:20 -0700

I think you will have better luck if you post this kind of question to the XSL 
list at http://www.mulberrytech.com/xsl/xsl-list/index.html, but that 
notwithstanding, I looked over your file to see if I could help.


I had some problem with the encoding, so in order to proceed I removed the 
characters with accent marks. English doesn't use them and you didn't give any 
hint as to the encoding you are using. Is is the usual MS Windows ISO encoding?

Having changed the accented characters to non-accented characters I then wrote 
a stylesheet to transform your file to an HTML page. I added some minimal 
styling to make it more readable.

You didn't offer any explanation for "The issue is that I need to be able to 
exploit it.", so I don't know if you can exploit an HTML page. Here is the 
stylesheet.:

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
 <xsl:output method="xml" indent="yes" encoding="UTF-8" />

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

 <xsl:template match="NewDataSet">
  <html>
   <head>
    <style type="text/css">
     .td-header  {font-family:Arial;font-weight:bold;}
     .td-data   {font-family:Arial;font-weight:normal;font-size:6 pt.;}
    </style>
   </head>
   <body>
    <table>
     <tr><xsl:apply-templates select="Table" mode="header-row" /></tr>
     <xsl:apply-templates select="Table" mode="body-row" />
    </table>
    <table>
     <tr><xsl:apply-templates select="Table1[1]" mode="header-row" /></tr>
     <xsl:apply-templates select="child::Table1" mode="body-row" />
    </table>
    <table>
     <tr><xsl:apply-templates select="Table2" mode="header-row" /></tr>
     <xsl:apply-templates select="Table2" mode="body-row" />
    </table>
   </body>
  </html>
 </xsl:template>

 <xsl:template match="Table|Table1|Table2" mode="header-row">
  <xsl:call-template name="col-names" />
 </xsl:template>

 <xsl:template match="Table|Table1|Table2" mode="body-row">
  <tr><xsl:call-template name="values" /></tr>
 </xsl:template>

 <xsl:template name="col-names">
  <xsl:for-each select="child::*">
   <td class="td-header"><xsl:value-of select="name()" /></td>
  </xsl:for-each>
 </xsl:template>

 <xsl:template name="values">
  <xsl:for-each select="child::*">
   <td class="td-data"><xsl:value-of select="." /></td>
  </xsl:for-each>
 </xsl:template>

</xsl:stylesheet>
-- 
Charles Knell
[EMAIL PROTECTED] - email



-----Original Message-----
From:     Jimmy Pierre <[EMAIL PROTECTED]>
Sent:     Sun, 31 Jul 2005 23:07:47 +0200
To:       <[email protected]>;<[email protected]>
Subject:  Help to convert an XML document to another format

Greetings,

 

I am not a programmer, so when I encounter the type of problem that I will
expose, I am ever so grateful :-)

 

I have a report per machine and the report can only be saved in XML.

 

I would like to now convert the report in whatever, HTML, DOC, PDF,
spreadsheet etc. The issue is that I need to be able to exploit it.

 

I have posted the report on my site:

 

 <http://www.cisware.co.uk/xmlproblem> http://www.cisware.co.uk/xmlproblem
it's only 20 K

 

Anybody could give me a tool to just convert this thing? I am fluent in
English/French..

 

Best wishes,

Jimmy

ÿþ<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.3790.2440" name=GENERATOR></HEAD> <BODY> <DIV> <DIV> Greetings,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I am not a programmer, so when I encounter the type of problem that I will expose, I am ever so grateful :-) <o:p> </o:p> I have a report per machine and the report can only be saved in XML.<o:p></o:p> <o:p> </o:p> I would like to now convert the report in whatever, HTML, DOC, PDF, spreadsheet etc. The issue is that I need to be able to exploit it.<o:p></o:p> <o:p> </o:p> I have posted the report on my site:<o:p></o:p> <o:p> </o:p> <A title=http://www.cisware.co.uk/xmlproblem href="http://www.cisware.co.uk/xmlproblem">http://www.cisware.co.uk/xmlproblem</A> it’s only 20 K<o:p></o:p> <o:p> </o:p> Anybody could give me a tool to just convert this thing? I am fluent in English/French….<o:p></o:p> <o:p> </o:p> Best wishes,<o:p></o:p> Jimmy</DIV></DIV></BODY></HTML>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Help to convert an XML document to another format

Reply via email to