Welcome to WebmasterWorld Guest from 54.160.131.144

Forum Moderators: eljefe3 & skibum

Message Too Old, No Replies

Data Feed to HTML software

newbie in need of easy way to process feed to site

     

coco

10:12 am on Sep 10, 2003 (gmt 0)

10+ Year Member



Hello,

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

mogwai

2:08 pm on Sep 10, 2003 (gmt 0)

10+ Year Member



Hi,

If you can get the data from the supplier in delimited format you can use Web Merge:

[fourthworld.com...]

Drastic

4:17 pm on Sep 10, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Webmerge doesn't do xml. I spent some time looking for something like you need a while back, and couldn't find anything off the shelf.

You'll probably need to hire a programmer.

mogwai

7:03 pm on Sep 10, 2003 (gmt 0)

10+ Year Member



The chances are the xml they supply you with will have been generated from a database of some description.

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.

FourthWorld

10:56 pm on Sep 11, 2003 (gmt 0)

10+ Year Member



Yes, getting a coy of the data in nearly any tabular, delimited format will work great in WebMerge, and probably be a significantly smaller file as well. Most major affiliates provide data feeds in tabular formats, most often pipe ("¶") delimited.

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.

Spannerworks

8:56 am on Sep 12, 2003 (gmt 0)

10+ Year Member



Removed.

[edited by: Spannerworks at 9:22 am (utc) on Sep. 12, 2003]

aspdaddy

9:22 am on Sep 12, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I dont know if this is any use - it works in IE only and creates a table of the xml data. You maybe could run it once in IE and then save it as plain HTML,


<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

coco

9:30 am on Sep 12, 2003 (gmt 0)

10+ Year Member



I will try to get a delimited format from the merchant.

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.

Alternative Future

9:49 am on Sep 12, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Simaler to ASPDADDY's suggestion you can use the data-island (only works in IE5.5+):

<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

aspdaddy

10:30 am on Sep 12, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Alternative Future,

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?

Alternative Future

10:40 am on Sep 12, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



aspdaddy,

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

aspdaddy

11:11 am on Sep 12, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



It has loads of extra headers and the data contained in Z:row tags,

- <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

Alternative Future

12:19 pm on Sep 12, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



aspdaddy,

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

MrSpeed

3:48 pm on Sep 12, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I believe Excel can open XML files. All you have to do then is save it as CSV or tab delimited txt file.

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.

TranscendMedia

8:58 pm on Sep 23, 2003 (gmt 0)

10+ Year Member



If you have access to an ASP developer or know basic ASP yourself this should do the trick for you!

[digitalcolony.com...]

Hope this Helps

[edited by: Drastic at 9:05 pm (utc) on Sep. 23, 2003]
[edit reason] no sigs please [/edit]

coco

10:16 am on Sep 24, 2003 (gmt 0)

10+ Year Member



Thanks all.

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?