I followed the tutorial posted here completely and found if very informative.
However, when I open an XML file, nothing happens. It just opens a blank spreadsheet.
I have found this has been an issue for at least 3 other people (here, here, and here), with no answer in sight. I can speculate that it could be a problem with this version of Open Office, but it could be that I'm doing something wrong.
What I've tried:
-hol.sten's tutorial
-several other tutorials
-several other xml files with their corresponding xlst files
-learning how to write xml and an xlst file myself, then making one using this tutorial
-tested and made sure my files worked fine with this XSLT file tester
Steps I took to open my xml file:
1) set up xlst filter
Tools > XML Filter Settings... > New >
Filter name: EVE marketstat_xml
Application: OpenOffice.org Calc (.ods)
Name of file type: EVE marketstat_xml
File extension: xml
XSLT for import: D:\EVE dumps\EVE Market Dumps\marketstat.xslt
2) open xml file
File > Open >
-selected EVE marketstat_xml from drop down list
-navigated to marketstat.xml
-hit open
-a blank spreadsheet named marketstat.xml opens
-???
Here is my XML file:
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<!-- Automatically generated data from EVE-Central.com -->
<!-- This is the new API :-) -->
<evec_api version="2.0" method="marketstat_xml">
<marketstat>
<type id="34">
<all>
<volume>44535858756</volume>
<avg>3.32005454545</avg>
<max>48.0</max>
<min>0.3</min>
<stddev>2.03123599286</stddev>
<median>3.0</median>
</all>
<buy>
<volume>13622049998</volume>
<avg>2.51534152346</avg>
<max>2.75</max>
<min>0.3</min>
<stddev>0.525498565054</stddev>
<median>2.59</median>
</buy>
<sell>
<volume>30913808758</volume>
<avg>3.32396375443</avg>
<max>48.0</max>
<min>2.69</min>
<stddev>2.14567907</stddev>
<median>3.21</median>
</sell>
</type>
<type id="35">
<all>
<volume>8311419936</volume>
<avg>4.32410822511</avg>
<max>30.0</max>
<min>1.01</min>
<stddev>2.4816563396</stddev>
<median>4.2</median>
</all>
<buy>
<volume>5597452174</volume>
<avg>3.86002751794</avg>
<max>4.6</max>
<min>1.01</min>
<stddev>0.683825842835</stddev>
<median>3.765</median>
</buy>
<sell>
<volume>2713967762</volume>
<avg>4.79337253657</avg>
<max>30.0</max>
<min>3.0</min>
<stddev>3.16653968577</stddev>
<median>4.3</median>
</sell>
</type>
</marketstat>
</evec_api>
Here is my XLST file:
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<body>
<h2>Market Stats</h2>
<table border="0">
<tr>
<th>typeID</th>
<th>all</th>
<th>buy</th>
<th>sell</th>
</tr>
<xsl:for-each select="evec_api/marketstat/type">
<tr>
<td><xsl:value-of select="@id"/></td>
<td><xsl:value-of select="all/avg"/></td>
<td><xsl:value-of select="buy/avg"/></td>
<td><xsl:value-of select="sell/avg"/></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
If someone can tell me why this and other XMLs are not opening correctly, I would love to hear the answer. Meanwhile, I'm going to try installing older versions of Open Office.