Archive for the ‘excel’ tag
A-to-Z tweak: magazines from Google books
Yesterday, I spotted (thanks @calire) that Google books have created a page that lets you browse their available magazine titles.
I can’t resist a free journal.
So I copied-&-pasted the entire page into MS Excel, used a handy function to extract the underlying URLs from the hyperlinked titles, did a bit of search-&-replace to make the list fit EBSCO’s data structure, and hey presto!
87 magazines from Google books on the E-journals A-to-Z
Image: a Google magazine, yesterday.
I also did a bit of bodging with EBSCO’s custom notes to pull in the journal cover images (c.f. what I did with ScienceDirect).
The whole thing will need re-creating every so often, but it’s only a 10-minute job.
Thank you, Google.
My Mashed Library lightning talk – atoz’n'rss
Edit (8th July) – slideshare.net does not seem to like displaying these slides on-screen, so here they are to download in MS PowerPoint format.
Here are the slides (on slideshare.net) of the 5-minute lightning talk I just gave at Mashed Library 2009, on using ticTOCs data to display e-journal ToC feeds, and on creating a new-titles feed with Yahoo Pipes, etc.
