or, The Hitchhiker’s Guide to Fear and Loathing at a Public Library Reference Desk

Reference Question of the Week – 8/21/11

   August 27th, 2011 Brian Herzog

This isn't a real reference question, but it's kind of related and I thought people would be interested.

When I was reading The Atlantic article about people not knowing about Ctrl+F, the last paragraph mentioned Google's AGoogleADay.com campaign. I had never heard of this, but it's basically a Google game - here's how they describe it:

A Google A Day directions

The couple questions I've done have been fairly simple, and taken only minutes to answer (although one I had the right answer but Google kept telling me it was incorrect - it might be picky about the format you use to type in the answer).

I enjoy games and challenges like this (librarian!), but it's not like we need to go out of our way to find them. But something I liked about AGoogleADay was that, when it gives you the answer, it also tells you what Google thinks is the right way to find the answer. It's never matched my search strategy, but like they say, "there's no right way to solve it."

To prevent players finding the answer after someone else has posted the question, the game is powered by Deja Google - it's a "wormhole inspired time machine [that] searches the Internet as it existed before the game began ... Because nobody wants someone's recent blog post about finding an answer spoiling their fun." Good thinking.

Something else interesting was the link to Google Inside Search. I'd heard that Google retired Google Labs, and Inside Search seems to be, not exactly a replacement, but a new method for Google to introduce their new tools. My favorite part was the timeline at the bottom, that shows you exactly when different tools launched.

So if it's a slow day at the library, or you're a library student looking to hone your reference skills, give it a try.

Tags: , , , , ,

Reference Question of the Week – 5/22/11

   May 28th, 2011 Brian Herzog

I was all proud of myself for ultimately finding the answer to this question - but afterward I discovered the answer wasn't nearly as hard to find as I had thought. Oh well.

A patron came up to the desk and pushed this newspaper clipping towards me (click to read it):

WSJ clipping

As she did this she said,

This from the Wall Street Journal page A12, but I can't remember date. I looked through all the issues you have, but it's not in any of them. You need to find out when is this article from because I want to read the rest of it. I'll leave this with you and go back to my computer, so just bring it over when you find it.

We keep the last three months of the WSJ in print, and since she said she looked at every issue, that ruled out anything between now and March 2011. I asked her if she had any idea when she photocopied it, and she said she thought it was in March, but it could have been a little earlier, so I decided to focus my search between January and March 2011.

Unfortunately, we don't have subscription database access to the WSJ, so I went to their website to see what kind of archive search they had. Their search did allow limiting to a date range, so I combined that with what seemed like the most important keywords from the article (Victim Funds, Columbine High School, Virginia Tech, Von Mour, etc) - and came up empty.

I usually don't have much luck with newspaper searches, so I quickly switched to Google - sometimes their cached results contain a better record of what has been published (or at least a temporary view through paywalls), and I'd be happy if I could even just get a citation. I searched on various iterations of those same keywords, and included the "site:wsj.com" limiter, but still had no luck.

I thought I was on the right track, but just using the wrong keywords, so I reread what I could of the article, looking for something unique. Towards the top of the page is a photo caption listing peoples' names, so I tried another Google search for "victim funds" "dan smolnik" site:wsj.com and got exactly one hit.

Clicking into the article and skimming it, I saw the same "Victim Funds" table, and also did a Ctrl+F for the phrase "As many as 4.62 points," which appears at the bottom of the clipping, so I knew this was the right article.

So yay, that made me happy. I scrolled back up to the top to find the date: March 28, 2010. Wow, the patron had the right month, but the wrong year.

I went over to the patron's computer and pulled up the article for her. At first she was skeptical because of the year, but when I showed her the table and the same paragraphs from the clipping, she agreed it must be the same one.

After getting back to the desk, I felt pretty proud of myself for being able to unearth this based on such a fragment of a clipping - no title, no author, no date. But I was curious if the search on the WSJ website would have found the man's name. I tried it, and it didn't - until I remembered to expand the time frame to 2 years, and then it did.

I also found success searching on the phrases "As many as 4.62 points" and "token of support from the community" which were in the article. At this point, my pride dissipated, as I realized I had just picked all the wrong keywords from the start - making what should have been a 1-2 minute search unnecessarily long. Luckily it didn't matter in this case, as the patron was still around - but next time I'll just start with random phrases as keywords and see how it works.

Tags: , , , , , , , ,

Reference Question of the Week – 3/27/11

   April 2nd, 2011 Brian Herzog

Lifehacker QR Code #1Instead of a reference question, here's something in honor of April 1st:

Yesterday, Lifehacker posted an April Fools QR Code Internet Scavenger Hunt - the point is to find and decode a series of QR codes hidden on various websites. But the trick is that you not only need to decipher the clues, but use reference skills to search and find the right websites.

It was fun, and the information provided in the clues is remarkably similar to library reference transactions - cryptic and obscure, but usually enough to go on.

So test out your reference skills - it's fun. It's also a very good example of how a library can use QR codes for an enjoyable and engaging project.

It would have also been interesting to sort of track peoples' search techniques and strategies, to see if librarians are any better at something like this than anyone else.

The article also linked to a handy online QR code decoder - neat.

Tags: , , , , , , , , , , , , ,

King County Library System Launches Evergreen Catalog

   September 28th, 2010 Brian Herzog

King County Library System + EvergreenI found out yesterday that the King County (WA) Library System is now live on Evergreen. They did a lot of work to develop the online catalog, and many of their customizations will become part of the core Evergreen code.

Which is good news for many Massachusetts libraries, as we'll be following in their footsteps in May 2011. But development continues, and we can still customize beyond what KCLS has done - so if anyone has comments or suggestions, please submit them to Kathy Lussier at http://masslnc.cwmars.org.

And for the curious, these introductory videos show and explain a little more:

Yay for open source!

Tags: , , , , , , , , , , , , ,

The Resurrection of Newspaper Obituaries

   September 7th, 2010 Brian Herzog

Yahoo PipesLast week I started talking about newspaper obituaries. Today's post details how we're improving access to the obituaries we do have in our newspaper microfilm records, using an online index created with Yahoo Pipes.

Our microfilm records of the local papers go back to 1940. But microfilm is primarily an archival format, rather than an accessible format, so it can be cumbersome to use. Our biggest impediment was that we didn't know what was there - when a patron contacted the Reference Desk asking for someone's obituary, it was very time-consuming for us to search the microfilm for an obituary, which may or may not have even appeared in the paper - we wouldn't even know until we checked.

So we created an online searchable index to the newspaper's obituaries - not the text of the obituaries, just a name/date/page index. Patrons and staff can use this to know whether someone's obituary appeared in our newspaper, instead of having to check the microfilm every time.

Here's how we did it: first, for about the past 10 months, volunteers have been going through every microfilm reel we have, page by page, and building an Excel spreadsheet with the following information:

Newspaper Year Month Day Page FirstName MiddleInitial LastName Maiden-Jr-Sr

The first column is necessary because we have records for both the Chelmsford Newsweekly (1940-1993) and the Chelmsford Independent (1986-present). The middle columns are reference and retrieval information. In the last column, we included extra information, like maiden name, whether a person was a "Jr." or "Sr." etc., and anything else that was random and didn't fit into another column.

The spreadsheet itself is useful, but I wanted to put this online so anyone could search it. The tool I chose was Yahoo Pipes, which has both pros and cons:


  • It's easy to play with and learn (like most Web 2.0 tools), but is also very powerful so we can grow into it
  • It can use a csv file for the data, which is easy to create with Excel
  • Beyond a simple search, it also provides fancy features like RSS feeds and tie-ins with other social media tools
  • Using Yahoo Pipes is covered in Chapter 7 of Library Mashups, written by Nicole Engard
  • The data is easy to update as the file continues to grow
  • It worked


  • Searching a database is not what Pipes is intended to do, so it's probably not the best tool out there (I wanted to use DabbleDB, but they're in transition right now)
  • The csv file must be ftp'ed to the webserver, which will be increasingly problematic - right now the file is 17,000+ lines and over 1MB. It will only get bigger, and the entire thing needs to be uploaded each time it's updated
  • Pipes has funny rules that you don't know about until something breaks. For instance, field names must be single words (hence "FirstName" and "Maiden-Jr-Sr"), you can't use certain characters in the data (like /), the search doesn't let you combine keywords (so far - I'm sure there must be some kind of fancy loop setup that will allow it, but right now people can only search either by first name or last name or year)
  • There isn't an easy way to embed the search box back into our website (there are Badge options, but only for search output) - you have to use the Pipe interface to search
  • There doesn't seem to be a wildcard for search
  • The results can't not link to something - I wanted the names and dates just to be displayed, but the way Pipes works requires the results to link to something

The last point was initially a pain, but it forced me to be creative, and I think the solution is actually more helpful for patrons than what I originally wanted. Now, when a patron finds the obituary listing they'd like to read, they click the link, and it automatically fills the obituary information into an email contact form on our website. That request gets sent to Reference staff, who then have an easy time of retrieving the obituary from the microfilm. Unfortunately, our microfilm machine isn't connected to a computer, so we'll just print and mail or fax the obituary to the patron. When possible we'll type them in and email them, and of course that will go into the searchable database too.

To make the connection from the Pipes listing to our email form, I had to use some javascript (which introduced another glitch: javascript makes names like O'Conner problematic, because it stops at the ', but I'll worry about this later).

Here's what the whole Pipe's source code looks like:
Yahoo Pipe for Obituary Search

Here's what it does:

  • The "Fetch CSV" module is the path to the csv file on our webserver
  • The module to the right of that controls what the patron search input box looks like. The "Label" field is "Enter EITHER a First Name, Last Name OR Year:" and you can see where that displays on the Pipe page
  • Both of those modules feed into "Filter" module - this one takes what the patron enters into the search box and filters the data from the csv file to create a subset of just matching records. Whatever the patron enters gets searched for in all the fields listed in the "Filter" module
  • The next module is "Rename" and I'm not sure I'm using it properly - I needed to create two new fields, so I'm just taking two existing fields, copying them, and renaming them so I can work with them later. The fields that got copied still exist untouched
  • Next is the "Regex" module, which is the most complicated and powerful, and I use it to create what the patron sees for the search results. The "Title" field is one I created, and here I'm replacing the contents from when I copied it to display what the patron will see on the screen - the code for it is "${FirstName} ${MiddleInitial} ${LastName} ${Maiden-Jr-Sr} - ${Newspaper}, ${Month} ${Day}, ${Year}, Page ${Page} ${Obituary}" which also includes punctuation formatting. So, for example, the result looks like this:

    Katherine M. Polley - Chelmsford Newsweekly, December 31, 1940, Page 7

    Because this field has to be a link, I also had to define what it links to, which is what I'm doing in the "Link" field. The value for that field is being written as


    which carries the data over to the library's website and some javascript pulls the data from the url and puts it in an email form. The patron can fill in their name and contact info into the form and submit it to us as an email message

  • The "Sort" module is self-explanatory, and I chose to list them with most recent first

This feels far more complicated than it should be, and I'm sharing it here to both save someone else from having to figure it all out again on their own, and to hopefully get suggestions on how to simplify/improve it.

Although, speaking of improving it, I do have one idea for future development: the local Cemetery Department has spreadsheet online listing complete burial locations - it would be neat to mashup up that data, so the obituary is linked to the cemetery plot location.

That's down the road a bit, so in the meantime I just keep adding whatever new obituaries appear in the paper to the csv data file - I had planned to do that weekly, but lately there have been many weeks without any obituaries in the paper (see my previous post). Anyway, we'll see how this works - it only went live last week, but already patrons have been using it, and it certainly does save a lot of staff time.

Tags: , , , , , , , , , , , , , ,

Library Blog Search

   August 31st, 2010 Brian Herzog

LISZENSometimes when I am working on a post, I wonder if another library blogger has already covered it - an am afraid I'll look kind of dumb rehashing something.

So I thought, wouldn't it be great to set up a Google custom search engine to search all library-related blogs? Before I did, I checked if anyone already created one, and it turned out Library Zen had - four years ago (I'm even further behind than I thought).

LISZEN Search searches over 500 library blogs, and has an accompanying wiki to keep track. If you write about the library world, add yourself.

Something related that would also be nice is a custom search of just library websites - so it would be easy to quickly see what other library's policies are regarding ebooks, or circulating laptops, or how much they charge for printing, etc. But considering the breadth of libraries and the complexity of maintaining it, just using regular Google might be more realistic.

Tags: , , , , , , , , , , , , ,