admin said:
I'd like to create an RSS feed allowing interested parties the ability
to subscribe to our inventory database - with new items being streamed
to them via the RSS feed.
I've read the confusing discussion on adding an RSS feed on Microsofts
site (actually using
www.archive.org since MS took the links/pages down)
and that left me totally confused..
So I thought I'd ask here..
Anyone done this? If so - how?
TIA!
Never mind... figured it out myself.
Actually - really pretty easy - short version:
1 - create a database display of your inventory, I sorted it by
descending inventory numbers (meaning - newest first)
2 - go into the code editor - and hack away all the code generated by FP
to display the data.
3 - in that same part - in the code editor - use ASP to write the code
needed to generate the RSS feed "Channels" and "Items"
4 - there is some additional identifying crap needed at the beginning of
the page so browsers recognize it as an RSS feed
Sample:
Top crap - top of page:%>
<rss version="2.0" xmlns:dc="
http://purl.org/dc/elements/1.1/">
<channel>
<title>Blah-blah New Arrivals RSS Feed</title>
<link>
http://www.blah-blah.com/Browses/RSS_FEED.asp/</link>
<description>Used/refurbished blah, blah, blah
listings</description>
<language>en-gb</language>
<%
In the section that displays the output from the database:
<%
response.write "<item>"
response.write "<title> Used " & FP_FieldVal(fp_rs,"Manufacturer") & "
" & FP_FieldVal(fp_rs,"Model") & " for sale - " & " $" &
FP_FieldVal(fp_rs,"Price") & "</title>"
response.write
"<link>
http://www.blah-blah.com/Browses/DHTML_Photos1.asp?InvNum=" &
FP_FieldVal(fp_rs,"InventoryNum") & "</link>"
response.write "<description>" & FP_FieldVal(fp_rs,"Description") &
"</description>"
response.write "<guid>
http://www.blah-blah.com/Browses/DHTML_Photos1.asp?InvNum=" &
FP_FieldVal(fp_rs,"InventoryNum") & "</guid>"
response.write "</item>"
%>
That's it - generates a nice RSS feed that is easily subscribed to using
FeedReader (good program.)
Works a charm.
