XML not reading XSL right

Vandy.Chan · June 28th, 2013, 11:17 AM

Hello all... I'm having a problem with converting my xml file to xsl using Saxon 9 on Windows 7. So far I have created this xsl file:

Code:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output indent="yes"/>
	<xsl:template match="/">
		<xsl:for-each select="drugs/drug">
			<xsl:result-document method = "hml"
					href="file:///C:/Users/X201/Desktop/drugbank/drugbank.xml">
						<xsl:value-of select="'&#xD;'"/>
						<drug>
							<xsl:value-of select="'&#xD;'"/>
							<drugbank-id>
								<xsl:value-of select="'&#xD;'"/>
								<xsl:value-of select="drug/drugbank-id"/>
								<xsl:value-of select="'&#xD;'"/>
							</drugbank-id>
							<xsl:value-of select="'&#xD;'"/>
							<name>
								<xsl:value-of select="'&#xD;'"/>
								<xsl:value-of select="drug/name"/>
								<xsl:value-of select="'&#xD;'"/>
							</name>
							<xsl:value-of select="'&#xD;'"/>
							<description>
								<xsl:value-of select="'&#xD;'"/>
								<xsl:value-of select="drug/description"/>
								<xsl:value-of select="'&#xD;'"/>
							</description>
							<xsl:value-of select="'&#xD;'"/>
							<mechanism-of-action>
								<xsl:value-of select="'&#xD;'"/>
								<xsl:value-of select="drug/mechanism-of-action"/>
								<xsl:value-of select="'&#xD;'"/>
							</mechanism-of-action>
							<xsl:value-of select="'&#xD;'"/>
						</drug>	
						<xsl:value-of select="'&#xD;'"/>			
			</xsl:result-document>
		</xsl:for-each>
	</xsl:template>
</xsl:stylesheet>

When I try to open my xml file in Chrome nothing comes up. This leads me to believe that my xls file is not well-formed and I have found no help on the interwebs.

These are the elements that I want to pull of my xml file and to show up in my browser:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet  type="text/xsl" version="2.0" href="drugbank.xsl"?>

<drugs xmlns="http://drugbank.ca" xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" schemaVersion="1.4" xs:schemaLocation="http://www.drugbank.ca/docs/drugbank.xsd">
  <drug type="biotech" created="2005-06-13 07:24:05 -0600" updated="2013-05-12 21:37:25 -0600" version="3.0">
    <drugbank-id>DB00001</drugbank-id>
    <name>Lepirudin</name>
    <description>Lepirudin is identical to natural hirudin except for substitution of leucine for isoleucine at the N-terminal end of the molecule and the absence of a sulfate group on the tyrosine at position 63. It is produced via yeast cells.&#xD;</description>
    <cas-number>120993-53-5</cas-number>
    <synthesis-reference></synthesis-reference>
    <indication>For the treatment of heparin-induced thrombocytopenia</indication>
    <pharmacology>Lepirudin is used to break up clots and to reduce thrombocytopenia. It binds to thrombin and prevents thrombus or clot formation. It is a highly potent, selective, and essentially irreversible inhibitor of thrombin and clot-bond thrombin. Lepirudin requires no cofactor for its anticoagulant action. Lepirudin is a recombinant form of hirudin, an endogenous anticoagulant found in medicinal leeches.</pharmacology>
    <mechanism-of-action>Lepirudin forms a stable non-covalent complex with alpha-thrombin, thereby abolishing its ability to cleave fibrinogen and initiate the clotting cascade. The inhibition of thrombin prevents the blood clotting cascade. </mechanism-of-action>

Any tips would be most appreciated, and thanks...

joefawcett · June 28th, 2013, 11:56 AM

I haven't time just now to examine the code in detail but if you open an XML file with an XSLT referenced by an xml-stylesheet processing instruction then the browser will use its own transformation engine. Unless something radical has happened recently Chrome doesn't support version 2.0 of XSLT (nor do the other main browsers) and, even if they did, it's unlikely that they would let you write to the user's file system. You don't seem to need to use xsl:result-document anyway so you could try changing to version 1.0 and simply output the result directly.

mhkay · June 28th, 2013, 12:38 PM

Furthermore, your stylesheet isn't generating HTML, but some XML vocabulary. So running it in the browser isn't going to display anything useful.

Vandy.Chan · June 28th, 2013, 04:23 PM

I got this to work...

Code:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema"
			xmlns:db="http://drugbank.ca" exclude-result-prefixes="db">
<xsl:output method="html" encoding="UTF-8"/>
<xsl:template match="/">
<html>
<head>
        <h1 align="center">DrugBank Data</h1>
</head>
<body>
	<table border ="2">
	<thead>
		<tr>
			<th>Drugbank Id</th>
			<th>Name</th>
			<th>Description</th>
			<th>Substrate</th>
			<th>Enzymes</th>
			<th>Mechanism Of Action</th>
			<th>Targets</th>
		</tr>
	</thead>
	<tbody>
		<xsl:for-each select="db:drugs/db:drug">
		<tr>
			<td><xsl:value-of select="db:drugbank-id"/></td>
			<td><xsl:value-of select="db:name"/></td>
			<td><xsl:value-of select="db:description"/></td>
			<td><xsl:value-of select="db:substrate"/></td>
			<td><xsl:value-of select="db:enzymes"/></td>
			<td><xsl:value-of select="db:mechanism-of-action"/></td>
			<td><xsl:value-of select="db:targets"/></td>
		</tr>
		</xsl:for-each>
	</tbody>
	</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>