Welcome to WebmasterWorld Guest from 54.196.244.186

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

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

Junior Member

10+ Year Member

joined:Feb 25, 2002
posts:74
votes: 0


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

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

Junior Member

10+ Year Member

joined:Feb 26, 2003
posts:50
votes: 0


Hi,

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

[fourthworld.com...]

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Oct 5, 2000
posts:1091
votes: 0


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.

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

Junior Member

10+ Year Member

joined:Feb 26, 2003
posts:50
votes: 0


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 Sept 11, 2003 (gmt 0)

Inactive Member
Account Expired

 
 


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.

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

Junior Member

10+ Year Member

joined:Dec 10, 2002
posts:75
votes: 0


Removed.

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

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts:2162
votes: 0


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

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

Junior Member

10+ Year Member

joined:Feb 25, 2002
posts:74
votes: 0


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.

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 22, 2003
posts:1022
votes: 0


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

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts:2162
votes: 0


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?

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 22, 2003
posts:1022
votes: 0


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

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts:2162
votes: 0


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

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 22, 2003
posts:1022
votes: 0


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

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Jan 16, 2003
posts:746
votes: 0


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.

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

New User

10+ Year Member

joined:Sept 23, 2003
posts:3
votes: 0


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]

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

Junior Member

10+ Year Member

joined:Feb 25, 2002
posts:74
votes: 0


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?