Forum Moderators: skibum
I am after an easy way to convert data from an XML feed straight into a website. The site is already built but I want it to be updated more easily. The shop are offering me an XML feed to do this, but my resources (both in terms of script knowledge and time), are a bit short.
I would prefer not to learn how to script, so ideally a piece of configurable software that will let me render the new data into the existing HTML is needed.
Is there anything out there that can help me?
Thanks in advance.
C0C0
If you can get the data from the supplier in delimited format you can use Web Merge:
[fourthworld.com...]
You'll probably need to hire a programmer.
If you are only looking to update the site periodically it will be worth asking them if they can give you a delimited dump of the database. Then you can use web merge.
If you have trouble getting the feed you need in a delimited format that WbMerge can handle, please send me a small sample of the file you have and I'll see what I can do to get WebMerge to support it in the future.
[edited by: Spannerworks at 9:22 am (utc) on Sep. 12, 2003]
<head>
<SCRIPT FOR="window" EVENT="onload">
var xmlDso = xmldso.XMLDocument;
xmlDso.load("http://www.mydomain.com/xmldata.xml");
</SCRIPT>
</head>
<body>
<OBJECT classid=clsid:550dda30-0541-11d2-9ca9-0060b0ec3d39 height=0 id=xmldso width=0></OBJECT>
<TABLE DATASRC=#xmldso>
<TR>
<TD><DIV DATAFLD="CITY"></DIV></TD>
<TD><DIV DATAFLD="TYPE"></DIV></TD>
<TD><DIV DATAFLD="BEDS"></DIV></TD>
<TD><DIV DATAFLD="PRICE"></DIV></TD>
<TD><img DATAFLD="IMG_PATH"></TD>
</TR>
</TABLE>
btw - does anyone know how i can modify it to run a query of the properties rather than return them all
Anyone used Sonicfactor's RXO?
Incidentally, I have access to programmers, XSL, ASP etc, however the conversion rate is low so I am trying to keep resource costs down. Hence wanting an off-the-shelf product that could let me update the site weekly or so, in a quick way, with fresh content.
Thanks for all your responses, much appreciated.
<XML ID="test" SRC="testData.xml"></XML>
<table id="testTable" DATASRC="#test" DATAFLD="testOption">
<tr>
<td>
<table DATASRC="#test" DATAFLD="testTypeOption">
<tr>
<td><span DATAFLD="name"></span></td>
</tr>
</table>
</td>
</tr>
</table>
*or* with the use of xslt (WHICH YOU HAVE AVAILABLE):
<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/">
<select>
<xsl:for-each select="testType/testTypeOption">
<option><xsl:value-of select="name"/></option>
</xsl:for-each>
</select>
</xsl:template>
</xsl:stylesheet>
The second example uses an option box for displaying the data, this can be changed to display in table-cells quite easily.
ht*p://www.creativyst.com/Doc/Articles/XMLhtmlT/XMLhtmlT.htm *this tutorial covers the basics of data-islands along with the MS site you can make a good start on it over a weekend.
ht*p://www.dpawson.co.uk/ *this is a good reference/tutorial site that covers most xslt
HTH,
-gs
Do you know how to do this with xml created by the ADO recordset save method?
I can get it to work fine on my own hand-made data islands but I have a database I want to share among a few sites - rs.save("myfile.xml") looked like the answer but the format iseems to be different, this code you/I posted doesnt read those files.
Any ideas?
Do you have a small sample of the generated xml file at hand? If so could you post a small sample so that i can see what the actual layout is, i have never worked with the ADO recordset, we use castor (ht*p://castor.exolab.org/) alongside our Java Dispatch Actions that make the actual query on Castor. If my memory serves me right we also had a few teething problems with accessing the xml, but got around it in the end!
-gs
- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- <s:Schema id="RowsetSchema">
.....
- <rs:data>
- <rs:insert>
<z:row c0="1" c1="88" c2="5" />
<z:row c0="2" c1="100" c2="19" />
I'v stickied a full example file to you
Can't help you with this one! It’s a brain buster for sure... Also I don't have ASP running on any of my test-beds to try some of the options available, but I did come across this post in another forum ht*p://www.experts-exchange.com/Web/Web_Languages/XML/Q_20708893.html you may have already seen it or tried the suggested fix. But apart from that am at a loss, sorry.
-gs
To my knowledge Excel can not save as a Pipe delimited file. I ususally need to open the CSV in a text editor and find/replace.
[digitalcolony.com...]
Hope this Helps
[edited by: Drastic at 9:05 pm (utc) on Sep. 23, 2003]
[edit reason] no sigs please [/edit]
TranscendMedia - from what I can gather from the article you sent to me, I don't need to use ASP, I only need to learn XSL, which seems like the way forward. Have you any more info on how to transform the XML via XSL on the server?
By the way, does anyone know which browsers and versions support XML and XSL?
