homepage Welcome to WebmasterWorld Guest from 54.226.136.179
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Advertising / Affiliates
Forum Library, Charter, Moderators: eljefe3 & skibum

Affiliates Forum

    
Data Feed to HTML software
newbie in need of easy way to process feed to site
coco

10+ Year Member



 
Msg#: 1566 posted 10:12 am on Sep 10, 2003 (gmt 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

 

mogwai

10+ Year Member



 
Msg#: 1566 posted 2:08 pm on Sep 10, 2003 (gmt 0)

Hi,

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

[fourthworld.com...]

Drastic

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1566 posted 4:17 pm on Sep 10, 2003 (gmt 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.

mogwai

10+ Year Member



 
Msg#: 1566 posted 7:03 pm on Sep 10, 2003 (gmt 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+ Year Member



 
Msg#: 1566 posted 10:56 pm on Sep 11, 2003 (gmt 0)

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

10+ Year Member



 
Msg#: 1566 posted 8:56 am on Sep 12, 2003 (gmt 0)

Removed.

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

aspdaddy

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1566 posted 9:22 am on Sep 12, 2003 (gmt 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

coco

10+ Year Member



 
Msg#: 1566 posted 9:30 am on Sep 12, 2003 (gmt 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.

Alternative Future

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1566 posted 9:49 am on Sep 12, 2003 (gmt 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

aspdaddy

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1566 posted 10:30 am on Sep 12, 2003 (gmt 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?

Alternative Future

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1566 posted 10:40 am on Sep 12, 2003 (gmt 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

aspdaddy

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1566 posted 11:11 am on Sep 12, 2003 (gmt 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

Alternative Future

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1566 posted 12:19 pm on Sep 12, 2003 (gmt 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

MrSpeed

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1566 posted 3:48 pm on Sep 12, 2003 (gmt 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.

TranscendMedia

10+ Year Member



 
Msg#: 1566 posted 8:58 pm on Sep 23, 2003 (gmt 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]

coco

10+ Year Member



 
Msg#: 1566 posted 10:16 am on Sep 24, 2003 (gmt 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?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Advertising / Affiliates
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved