Exploiting Library Services

Work Completed By: Chris Jones

DESCRIPTION

The WCC system for managing library transactions includes services for querying the catalogue. An RSS feed can provide information on new catalogue items, or a specific feed can be accessed based on a search query.

Can these services (or other WCC services) be combined with commercial web services to both enrich the user experience and potentially provide commercial opportunities for the organisation?

DETAILS/LOCATION OF PRACTICAL DEMONSTRABLE OUTPUT

Details of where code, web pages etc can be found.

Example of how the 'New catalogue items' RSS feed from the library catalogue can be added into FeedBurner, to generate its content as HTML. As an example I've used this feed to generate HTML which has been embed within our own web pages database. (internal link)
http://wcc-apps1/Web/corporate/pages.nsf/Pages%20by%20Department/36CEBDED8E1B4E7C802575A6003A47B4

Setup twitter feed using twitterfeed.com, based on the 'New catalogue items' RSS feed from our library catalogue database.
https://twitter.com/wcclatestitems

This web page takes the keywords held in the metadata, displays them on the webpage and auto generates hyperlinks configured to search the libraries catalogue. (internal link)
http://wcc-apps1/Web/corporate/pages.nsf/Pages%20by%20Department/70C1695BEB914AED802575A60047DAFA

Finally I was trying to achieve something similar to the below for our own library books. Where we could use both the Google Books API to produce a Google Preview button and also use the Amazon API to show reviews and ratings. Unfortunately due to time this wasn't possible to complete.
http://www.silverlightbooks.net/book/pro-csharp2008-and-the-dotnet35platform

DESCRIPTION OF THE WORK CARRIED OUT

Describe how you approached this piece of work, any technologies, tools or techniques that you found useful or tried and discarded. Include any examples that you used for inspiration and any contacts you have made in carrying out the work.

I started this project by first exploring different ways we could combine existing commercial web services, into these already existing RSS feeds in order exploit them further, to either help promote them within our own site or to provide a completely new web service.

Following this I looked at way's we could further use the existing library catalogue search facility and expand the use of this further within our own site.

Finally I started to delve a little deeper into the use of external API's such as Google Books and Amazon to see how the use of these could enrich the user experience.

Generate HTML output using Feedburner
I started by 'burning' the existing 'New catalogue items' RSS feed into FeedBurner. Once added you can setup the BuzzBoost tool in order to republish the RSS feed as HTML. Once setup you can copy the HTML into your own website, see below.

flickr:3506501899

On setup you can configure the how the feed is displayed within the HTML, See below screenshoot.

flickr:3507265998

Then further styling can be done using custom CSS directed at the FeedBurner tags, Google provide some simple examples within this web page:
http://www.google.com/support/feedburner/bin/answer.py?answer=78974&topic=13240

Using both the BuzzBoost configuration settings and custom CSS styling I've embed the generate HTML into our own web pages database, see below.

flickr:3506469707

Generate Twitter Feed for new library catalogue items RSS Feed

Another way we could provide a service and promote new items added to the Library catalogue is to generate twitter updates. This could be done using a combination of the 'New catalogue items' RSS feed:

http://librarycatalogue.warwickshire.gov.uk/ABwarwick/rss.ashx?uilang=en

and the external TwitterFeed web service. I won't dwell too much on the configuration of this as I know its been covered in previous R&D project's, but its quite simple and only minutes to setup.

Here's a link to the twitter account that published new items added to the library catalogue:
https://twitter.com/wcclatestitems

Promoting our library catalogue, throughout the Warwickshire Website

After thinking about this, it occurred to me that every page on our site that uses the Web Pages database has a meta keywords field that needs filling out when creating a new web page, see below picture.

flickr:3507289534

We could display these keywords at the bottom of web pages with auto generated hyperlinks configured to search the library catalogue. The hyperlinks can be generated using a 'Get' post that combines the standard library catalogue search URL:

http://shvaqu01/ABwarwick/default.ashx?q=

with the actual keywords for example 'Warwick Castle'. Note you need to replace any spaces with the '+' symbol e.g. 'Warwick+Castle'

For example: http://shvaqu01/ABwarwick/default.ashx?q=Warwick+Castle

Using JavaScript within our web pages database I dynamically extracted the meta keywords data from the header and added the hyperlink information and displayed it on the actually web page within our webpage database. See Below.

flickr:3506487435

In reality this is probably not the best way of doing this, but does prove the concept. The best way would be to add another computed field within the web pages database that generates a list of the keywords with links which is then displayed on the actual web page. If desired we could also give content authors the choice of whether to displaying these keyword or not, using a Yes/No display option while edting the Notes web page document.

Investigation into possible useful web service API's to combine with our Library Catalogue system

Looking on the ProgrammableWeb website I came across the Silverlight Books Mashup that combines the books they are selling with a Google Preview button and also Reviews taken from Amazon. This seems like a very good mashup and perhaps something similar could be incorporated within our Library catalogue system. See below:

http://www.silverlightbooks.net/book/pro-csharp2008-and-the-dotnet35platform

I did start to investigate how to use Amazon web Services in ASP.NET, using the below site as a guide:

http://www.sitepoint.com/article/amazon-web-services-asp-net

However I couldn't get it to work and reading from other peoples comments they too were experiencing problems.

PROJECT OUTCOME

Describe the degree to which the work was successful in addressing the project description. Include reasons why or why not.

The initial part of the project involved exploring different ways we could combine existing commercial web services with our own library catalogue. This proved very useful as it demonstrated how quickly these web services from FeedBurner and TwitterFeed could be used in conjunction with our existing library catalogue to enrich the user experience and also help promote our library catalogue service.

The next part of the project involved extending the Library catalogue search facility to other parts of our site using a 'Get' post URL. This is a reasonable simple idea, that could have far reaching consequences as it becomes possible to hyperlink a web pages keywords in order to search for them within the library catalogue database. This facility could be replicated across the majority of web pages on our site.

The final area was investigating relating web service api's to help enrich the user experience. This was a bit more involved and it was disappointing not to have developed anything tangible. However the Silverlight books website show's what's possible. If only I had more time.

SHORT TERM BENEFITS

What immediate impact could the output of this R&D work have on the organisation – could it provide benefits without compromising our strategic approach?

Certainly the use of Feedburner and Twitterfeed could be setup and used quickly without compromising our strategic approach. This would allow us to display RSS feeds like 'New catalogue items' as HTML on our website and also setup a TwitterFeed relating to new Catalogue items.
Extending the library catalogue search facility would probably involve updating our webpage database, so perhaps that could be classed as compromising our strategic approach slightly, however it would not be a big change and perhaps could be implemented if future updates to the web page database are required.

STRATEGIC IMPLICATIONS

How the work carried out fits with our strategic direction or how it should contribute to our strategic thinking.

Definitely the use of commercial web services such as Feedburner and Twitterfeed fits in with our strategic direction. As even if the underlining feed source changes these intermediary layer will remain constant making the transition from one underlying source to another more transparent.

OTHER NOTES ETC

The below web services API's could possibly be combined in some way with our own Library Catalogue system to enrich user experience.
Google Books – http://books.google.co.uk
Amazon - http://aws.amazon.com
Goodreads - http://www.goodreads.com
Isbndb.com - http://www.isbndb.com

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License