K
Ken
What software is required to extract certain data from an XML
document?
document?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken
What I mean by the below question is rather : What software is
required to extract certain data from an XML document that is served
from another website?
required to extract certain data from an XML document that is served
from another website?
M
Martin Honnen
Ken said:What I mean by the below question is rather : What software is
required to extract certain data from an XML document that is served
from another website?
XML parsers know how to load files via HTTP so all you need is an XML
parser. Check http://xml.apache.org/ for XML parsers.
P
Patrick TJ McPhee
% What I mean by the below question is rather : What software is
% required to extract certain data from an XML document that is served
% from another website?
What do you want to do? There are programs which can extract data
and stick it a relational database. There are programs which can
extract data and write it to a flat file. There are libraries which
can feed data directly to an application you've written.
% required to extract certain data from an XML document that is served
% from another website?
What do you want to do? There are programs which can extract data
and stick it a relational database. There are programs which can
extract data and write it to a flat file. There are libraries which
can feed data directly to an application you've written.
U
user
What software is
required to extract certain data from an XML document that is served
from another website?
You can use XSLT's document() function.
Code example:
<xsl:template match="foo">
<xsl:apply-templates select="document('http://www.theserver.com/foo.xml')"/>
</xsl:template>
Devon
K
Ken
I want to extract the data and put them into an access database. But
do tell me more about the other programs like libraries which can feed
data directl y to an application I have written.
Tks
do tell me more about the other programs like libraries which can feed
data directl y to an application I have written.
Tks
K
Ken
Thanks Devon. I use your method and can't seem to return the required
elements. Can you tell me what's wrong with the code below? The code
is adapted from http://www.w3schools.com/xsl/xsl_value_of.asp
--------------- code start 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="/">
<xsl:apply-templates
select="document('http://www.w3schools.com/xsl/cdcatalog.xml')"/>
</xsl:template>
<html>
<body>
<h2>My CD Collection</h2>
<table border="1">
<tr bgcolor="#9acd32">
<th>Title</th>
<th>Artist</th>
</tr>
<tr>
<td><xsl:value-of select="catalog/cd/title"/></td>
<td><xsl:value-of select="catalog/cd/artist"/></td>
</tr>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
-------------------- code end here -------------------
elements. Can you tell me what's wrong with the code below? The code
is adapted from http://www.w3schools.com/xsl/xsl_value_of.asp
--------------- code start 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="/">
<xsl:apply-templates
select="document('http://www.w3schools.com/xsl/cdcatalog.xml')"/>
</xsl:template>
<html>
<body>
<h2>My CD Collection</h2>
<table border="1">
<tr bgcolor="#9acd32">
<th>Title</th>
<th>Artist</th>
</tr>
<tr>
<td><xsl:value-of select="catalog/cd/title"/></td>
<td><xsl:value-of select="catalog/cd/artist"/></td>
</tr>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
-------------------- code end here -------------------
A
Andy Dingley
Thanks Devon. I use your method and can't seem to return the required
elements. Can you tell me what's wrong with the code below? The code
is adapted from http://www.w3schools.com/xsl/xsl_value_of.asp
Try this:
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:variable name="doc"
select="document('http://www.w3schools.com/xsl/cdcatalog.xml')"/>
<xsl:template match="/">
<html><body>
<h2>My CD Collection</h2>
<table border="1">
<tr bgcolor="#9acd32"><th>Title</th><th>Artist</th></tr>
<xsl:for-each select="$doc/catalog/cd" >
<tr>
<td><xsl:value-of select="./title"/></td>
<td><xsl:value-of select="./artist"/></td>
</tr>
</xsl:for-each>
</table>
</body></html>
</xsl:template>
</xsl:stylesheet>
If you want to see it quickly in client-side IE, save it as
xsl_document.xsl and try browsing the following xml document
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="xsl_document.xsl" ?>
<foo />
P
Patrick TJ McPhee
% I want to extract the data and put them into an access database. But
% do tell me more about the other programs like libraries which can feed
% data directl y to an application I have written.
I was thinking specifically of XML parsers, and in particular parsers
which have XPath implementations. There are many of them floating around.
% do tell me more about the other programs like libraries which can feed
% data directl y to an application I have written.
I was thinking specifically of XML parsers, and in particular parsers
which have XPath implementations. There are many of them floating around.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
Similar Threads
Forum statistics
Latest Threads
-
How to Merge to div with each other as shadow effect?
- Started by treekmostly22
-
Syntax error
- Started by RGIANNETTI
-
SYNTAX ERROR
- Started by RGIANNETTI
-
Right or wrong
- Started by Tobi1987
-
Hello , Im Emilio
- Started by Mercury_Dev
-
Anyone want to balance my browser-based clicker game?
- Started by timo
-
DNS Disaster: The Server Downfall
- Started by Infinityhost
-
Web-Based RAM Management: Real-Time Server Control in Windows 10
- Started by Infinityhost
-
Create and Preview HTML & PDF with Custom Encryption and Micro Cloud Storage
- Started by Infinityhost
-
Demonstration of a Self-Written HTTP Server for an Online Store
- Started by Infinityhost