L&LR staff blog

I’ve shown a couple of people this idea that Julie and I have been developing for Holbeach – that of using RefWorks to manage a new-books list for the relatively small number of new titles that we receive each year at the campus LRC – and that can be embedded into Blackboard or a subject web page.

The advantage of using RefWorks (apart from the fact that many L&LR staff are reasonably familiar with it) is that the RefWorks shared folders do most of the work for you.

If people like it, there’s no reason you can’t start using it straight away. I’ve already a trip planned to Hull next month to see if it’ll work for colleagues there.

First, here’s the end result: http://feeds.feedburner.com/HolbeachLRC

Now, here’s how it’s done:

• Every time Julie gets a PO slip back for an order she placed, she logs into her RefWorks account, searches our catalogue for the book, and imports it.
• Julie has created a RefWorks folder called ‘Holbeach new books‘, and shared it publicly. All newly-arrived titles are added to this folder on import.
• This is the clever bit – RefWorks allows you [PDF, p.4] to make the contents of a shared folder available as an RSS feed. Here’s the feed for the Holbeach new books folder. You can treat this like any other RSS feed – follow it in Google Reader / wherever, embed it into a web page using Feed2JS, etc.
• But… it’s not very pretty.
• So, in comes Yahoo! Pipes. I’ve created a pipe which takes any RefWorks shared-folder RSS feed with books in it (not designed to work with journal articles or other items – perhaps that’s phase II). This pipe, which you can find at – http://pipes.yahoo.com/lincoln/newbooks - does the following:
  1. Looks for, and extracts a valid(ish) ISBN from each RefWorks item;
  2. Creates a new link to our catalogue which looks up this ISBN for each item;
  3. Displays a book-cover image from Amazon.co.uk matching that ISBN (with a link back to Amazon through our affiliate scheme), next to a description of the book (manually added to RefWorks), and an extra link back to the original item record in RefWorks (marked by the RefWorks icon: ) – I’ve just added that last element, today, because I think it’ll be useful to give students & staff the option to take each item and export it to their own RefWorks account. Also to give credit where credit’s due, and recognise that RefWorks is the source of the information!
• The ‘prettified’ RSS feed from Yahoo! Pipes is then fed through Google Feedburner, in order to give it a stable, sensible URL, collect stats on subscriptions and hits, and to allow email subscriptions.

Couple of slight problems / areas for development: we’re finding it necessary sometimes to ‘tweak’ the ISBN before it can find an Amazon cover image. Maybe with a better use of regex in my pipe, that wouldn’t be necessary? Also, at the moment Julie is manually adding the paragraph description to each item after import. I’m sure that somewhere out there exists a source of book descriptions / reviews that I could pull in automatically (hello, library mashup fans?!) – that would streamline the process a bit.

…this was a talk that Joss and I gave yesterday, around the idea of using WordPress MU + Scriblio + Triplify to create a semantic, union catalogue. Joss has already blogged it (and for some reason, for him Slideshare worked fine…?).

Paul and I have just presented our ‘lightning talk’ on the use of WordPress MU and Scriblio to create a platform for publishing multiple OPAC catalogues and then exposing the aggregate data as RDF using Triplify. I blogged about this idea a while back and this is the first presentation we’ve given. Not sure what people made of it. Too ambitious? Threatening? Confusing? All I know is that from where I’m standing, it would require a relatively small amount of funding to show it working in principle with a handful of library catalogues. The difficult part would be scaling it to work for 100+ catalogues (though bear in mind, wordpress.com hosts 6 million sites) and satisfying the politics of each institution. Still, that shouldn’t stop us from trying.

(With apologies to Christian Bök for the title.)

I’m going to the long-anticipated Mashed Library 2009 (“Mash Oop North“) tomorrow at the University of Huddersfield.

If you want to follow the action from afar, here’s what one of the organisers (guess who?!) has suggested in a post on the event blog:

If you’re wanting to keep track of what’s happening on the day, there’s a few things you can keep an eye on…

Twitter

The hashtag for the event is #mashlib09 and you can keep track using Twitter Search or Twitterfall.

Ideas from the event

We’ll be encouraging delegates to publish their ideas under a CC Attribution-Share Alike 3.0 licence and you’ll be able to see them all via this RSS feed.

Ian’s Text Wall

Ian McNaught, who works at Huddersfield Uni, has developed an experimental SMS Text Wall which we’ll be playing around with at the event. It currently works with Firefox, Safari and Chrome.

Videos

We’re hoping to video all 6 of the opening sessions. Unfortunately we’re not able to stream them live but we’ll try and make them available to view online as quickly as possible. (If any delegates have experience of putting video online, please make yourself known on the day!)

There’s also the useful Mashed Library Ning site at: mashedlibrary.ning.com

I’m very much looking forward to tomorrow’s event, mainly because last year’s (the inaugural, held in London) was so interesting, and also because this year I’ve got the chance to talk about a couple of the mashup-inspired things I/we’ve got in the pipeline. Also because of this, and due in no small part to this.

I’ll be tweetin’ wi’ t’ best of ‘em on the day, and I promise a full writeup (plus slides from my two ‘lightning talks’) when I get back.

In February, I wrote about  how I’d added more than 5,000 ticTOCs RSS feeds to the A-to-Z, so that researchers can easily find and subscribe to Table-of-Contents (ToC) updates from journals in their field. I think this is an indispensable current awareness service, and I’m pleased it’s being promoted at the ‘Working Smarter With the Web‘ workshops.

(An aside: that ticTOCs data is overdue to be re-generated and reloaded onto the A-to-Z. This is next on the long list of e-journal packages for the “e team” to review.)

That’s all well and good, but there’s a clear need for a current awareness service ‘one level above’ the individual ToCs. That is, we could (and should) be providing an RSS feed of new e-journal titles.

At the moment, the EBSCO A-to-Z platform doesn’t provide this feature (I really do hope it’s something that EBSCO are considering developing themselves), and so in the past we’ve had to resort to emails, spreadsheets, etc.—all with varying degrees of success—just to keep people up to date with what new e-journals have become available.

~~~

So, I’ve created a rough-and-ready working demo of a ‘New e-journals at Lincoln‘ RSS feed for the A-to-Z. It’s not supported by EBSCO, so it’ll require a bit of manual intervention to keep it running (it’ll be a nice five-minute daily task for the “e team” to take on!), but has the potential to be a really important enhancement to the e-journals service.

Next time you go to the A-to-Z site, you’ll see a new tab – next to the existing ‘Titles’ tab – which I’ve labelled ‘New Titles (RSS)‘. This new tab links to a page containing information about the RSS feed, with a prominent link to the feed itself, plus a display of the 10 most-recently-added titles in the feed.

The links in the ‘ten most recent…’ list should go directly to the A-to-Z record for that title. The feed link itself you can paste into your favourite feed reader (I use Google Reader). I’m working on enabling email subscription to the feed. We should also be able to take this feed and filter/manipulate it to create (for example) subject-specific lists in Blackboard.

I’ve also made the feed autodiscoverable (c.f. my earlier post), so it should display in the browser toolbar (this will vary between browsers).

This is how the feed is auto-discovered by Firefox browser.

I still need to do some work on creating better documentation for users of the feed, and for the process of adding new titles within L&LR.

I’ll also need to do a bit of testing to make sure everything’s working as it should be, and iron out my feed-validation bugs.

When the time is right, I’ll launch the service more publicly.

Paul

~~~

P.S. Here’s how I did it:

1. The first stage is the most clunky – it involves getting information about the newly-added titles out of the closed box that is the Electronic Journals A-to-Z. EBSCO provide a daily report (available only to administrators) of “Titles added to Packages in my Collection“. This data can be exported on a daily basis in tab-delimited format.
   
2. Next, I created a spreadsheet using Google Docs and published it to the Web. The tabbed data from the A-to-Z admin report is pasted in to the spreadsheet, so it becomes openly accessible. Using Google Docs also means that I can invite other people to act as editors of the spreadsheet, and create public web forms to add titles that don’t appear in EBSCO’s daily report (not all of our e-journal packages are managed by EBSCO, so the data will need supplementing when we add custom titles).
3. The data output of the Google spreadsheet is then fed into Yahoo! Pipes, an excellent application for ‘mashing up’ and processing data. You can inspect the Yahoo! pipe for yourself, at: http://pipes.yahoo.com/lincoln/newejournals. If you create an account on Yahoo!, you can clone this (or any) pipe and modify it to create your own data mashup.
   
4. The Yahoo! pipe takes the raw Google spreadsheet data, filters it according to various rules, and exports a valid * RSS feed of new items, in reverse order by date.
5. * Well, it’s nearly valid. I need to do a bit of cleaning up of the pipe (I did say this was a working demo), mainly so I can pass the feed through Feedburner, which will allow email subscriptions. But it works well enough!
6. Finally, I created the new tab on the A-to-Z public site, and added the details to the page (the ‘ten most recent’ list was created using feed2js). The code for the autodiscoverable feed was pasted into the top of our customised A-to-Z template.

~~~