If you can get the data from the supplier in delimited format you can use Web Merge:
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.
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.
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.
[edited by: Spannerworks at 9:22 am (utc) on Sep. 12, 2003]
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,
<SCRIPT FOR="window" EVENT="onload">
var xmlDso = xmldso.XMLDocument;
<OBJECT classid=clsid:550dda30-0541-11d2-9ca9-0060b0ec3d39 height=0 id=xmldso width=0></OBJECT>
btw - does anyone know how i can modify it to run a query of the properties rather than return them all
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.
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">
<table DATASRC="#test" DATAFLD="testTypeOption">
*or* with the use of xslt (WHICH YOU HAVE AVAILABLE):
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
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
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.
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!
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">
<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.
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.
If you have access to an ASP developer or know basic ASP yourself this should do the trick for you!
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?