Print

Print


Edward,
        I've got some ColdFusion template pages working with our Voyager
database to produce some RSS pages for new books.  I haven't publicized them
yet because I'm still tinkering with them.  But here's what a page that
produces the RSS looks like:
http://www.clarku.edu/offices/library/cf/voyager/rss/newebooks.cfm.txt.

This page is doing an SQL query against our Voyager tables for new books
from the last thirty days for books with the LC Class of "E".  The rest of
the page is creating the output in the correct RSS format.  Then the output
is written to an XML file.  I run these once a day.  One of the important
things is to fix those pesky ampersands and angle brackets that can cause
the XML to be not "well formed": the <cfscript> section is where this
happens.

Sorry, I haven't commented the page so if you have any questions please let
me know.

I'm sure this same idea can be transposed to perl or php without too much
trouble (not that I could do it).

Ed McDermott

Edward J. McDermott
Systems Librarian
Robert H. Goddard Library
Clark University
950 Main Street
Worcester, MA  01610
(508) 793-7651
[log in to unmask]

-----Original Message-----
From: Edward Iglesias [mailto:[log in to unmask]]
Sent: Thursday, February 10, 2005 3:00 PM
To: [log in to unmask]
Subject: Re: [CODE4LIB] Creating an RSS feed of newly cataloged books

Thanks Roy,
    SIRSI is indeed working on the issue but what I was hoping for was a
relatively simple solution.  Every month we send out lists of newly
cataloged books to our "Academic Liaisons".  I already have the list in
plain text.  I was simply looking for a quick and dirty way to turn it
into an RSS feed.

E

Roy Tennant wrote:

> I notice you're a Sirsi site, in which case you might want to check
> with your vendor. Word was that they recently added RSS support to
> Rooms, at least. I would hate for you to re-engineer the wheel.
> Roy
>
> On Feb 10, 2005, at 11:16 AM, Edward Iglesias wrote:
>
>> Greetings All,
>>    I've been experimenting with the idea of creating an RSS feed of
>> newly cataloged books with the idea that you could "subscribe" to new
>> books on whatever.  Has anyone else done this already?
>>
>> --
>> Edward Iglesias
>> Integrated Library Systems Coordinator
>> 504.864.7838 (work)
>> 504.864.7842 (FAX)
>>
>

--
Edward Iglesias
Integrated Library Systems Coordinator
504.864.7838 (work)
504.864.7842 (FAX)