Cataloging Our Stuff

Here’s the deal. Like good consumers, we have a lot of CDs, DVDs, and books. Especially books. We have books on the bookshelf in Baby TBA’s room. We have them under the bed in Baby TBA’s room. We have them in closets. Under end tables. If you open the pantry? Books spill out, a tide of literacy and potential paper cuts. What’s a family to do?

Get rid of some of those books? Ha, you clearly don’t know us. No, what we need to do is catalog it all. We tried this a few years ago using a combination of Python scripts and chutzpah, but the scripts needed too much hand-holding and in the end I would have still had to do something with the information that was being saved in big long text files. But I hear there are nifty packaged programs now available to do the job. Maybe we should buy something from SIRSI. Ha! Ha! Just kidding, dad!

Anyway, I took a look at several cataloging programs. Here are the things I’m looking for:

  • Catalog books, DVDs, and CDs. The last is less important, since we’re about done with our year-long project to digitize all of our music, but I’d rather not have a program that just does books or just does CDs.
  • Decent interface. What doomed the project last time was all of the fiddling I had to do to add books, and I had no good way of looking at the data once I’d entered it.
  • Ease of data entry. Most of the software packages use barcode scanners, which is a fine way to read the UPC information. But it’s what the program does after that that is important. How much manual massage is required to turn that UPC information into bibliographic information?
  • Tracks loans. We hand out books and CDs and all, and it’d be nice to keep track of who has what. Our current system of writing things down on post-it notes that then get lost or thrown away is not so ideal.
  • Portable data format or good exporting tools. Any software package I buy today has no guarantee of being around in five or ten years. I need to be able to take the data elsewhere. Plain text is a bare minimum requirement, though export to something like XML or a CSV spreadsheet format would be nifty.
  • Portable data. One thing I’d like to be able to do is have the data on a PDA when trolling used book stores to make sure I don’t buy duplicates unawares.
  • Cross-platform. Ours is a house divided, with me using PCs and Misty using Macs.

Ladies and gentlemen, we have our judging criteria. Bring in the candidates!

Collectorz.com

Collectorz is the goofy name for an umbrella of software designed to catalog media. You type in author and title information or ISBN data; alternatively, you scan the media’s UPC bar code with a barcode reader. The software then gathers full information about the book, movie or CD and populates its database with the results.

The good: Adding media to the database is simple. The program pulls information from the Library of Congress, the British Library, the various flavors of Amazon.com, Barnes & Noble, IMDB, and their own online databases. The program grabs cover images while it’s at it. You can create custom printed lists using XML/XSL, and can export to HTML, CSV, and XML. The software is available for Mac or PC, though you must buy one or the other.

The bad: Each and every type of media you want to catalog requires a separate software purchase at either $20 (standard version) or $30 (pro version) a pop. Music, movies, video games, books, comic books (!), mp3s (!!), all are separate programs. The standard version of the software has no exporting features, does “simple lists”, and will not track loans. You can buy “premium support” to get your support questions answered faster.

Summary: Collectorz feels like it was designed to extract as much money from me as possible. To cover both books and movies would cost $60; throw in CD cataloging and we’re up to $90. That’s before you buy a barcode scanner, too.

Readerware

Readerware is the granddaddy of these software packages. You type in a list of ISBNs or scan them in using a barcode scanner. Readerware then downloads the information including cover images. The data itself is stored in an SQL database, though it’s not clear to me whether or not you can do SQL searches directly.

The good: Like the Collectorz software, Readerware pulls information from many online sources and downloads cover images. It exports to tab-delimited files, CSVs, and UIEE. The software is available for Mac, PC, and Linux. It tracks loans. It has a built-in browser and integrates directly with sites like Amazon and Barnes & Noble so you can purchase books through the program and enter them into your database at once.

The bad: Also like Collectorz, Readerware has separate programs for books, for CDs, and for movies. The programs are $40 apiece or $75 for all three. It’s a clunkier-looking program than the others reviewed here — it looks like one of those old Borland applications that companies use to keep track of items in their stockroom.

Summary: This has many of the same strengths and weaknesses of Collectorz, though you can get all three versions of Readerware for less than the three analogous Collectorz packages. On the other hand, Collectorz has a nicer-looking interface.

Delicious Library

Delicious Library, like the previous two programs, lets you scan your media and catalog them. It’s a Mac-only product that is tightly integrated with the OS and uses an iTunes-like interface.

The good: Delicious Library is extremely pretty. The iTunes-like interface has the benefit of familiarity. You can scan your books in by putting the barcode in front of an iSight camera. (How cool is that?) Your catalog is saved in XML format, and a number of pre-written scripts exist to take that data and export it as other things. It keeps track of loaned items. For $40 it will catalog books, movies and CDs.

The bad: It’s Mac only. The interface is only as good as the iTunes interface; you don’t have the flexibility of Collectorz in setting up views. It doesn’t pull data from as many sources.

Summary: Everything I’ve read has given a big thumbs-up to Delicious Library. I will admit my shallow outlook and say that the program’s look is just about enough to sell it to me. Plus the ability to read barcodes via a camera is genius. I’ve seen that application in industrial machine vision applications, but had never thought about applying it to the problem of cataloging media.

LibraryThing

LibraryThing is an online book catalog site that collates its members’ catalogs into a collaborative social catalog. You type in a book’s title and author, import a list of ISBN codes from text files or web pages, or pull information directly from a CueCat scanner. LibraryThing then collates information about the books from various libraries and from Amazon.com.

The good: The del.icio.us-like social aspects are intriguing, and allows the site to provide recommendations. You can enter 200 books for free; for $10 a year or $25 lifetime you can add all the books you want. You can export your book information as tab-delimited text or as a CSV file. Playing with the website is fun. You can integrate your library into your blog easily. It’s clearly cross-platform, and it has an API you can use to get at its data.

The bad: It only does books. It doesn’t track loans per se, though you can tag books that you’ve loaned out as being on loan. You’re giving your library data to a business to hold, which may or may not bother you.

Summary: LibraryThing is a really fun site, and if we were only cataloging books, this is the way I’d go in a heartbeat.

The Summary

From where I’m sitting, Delicious Library is the way to go, even though we have a number of PCs in the house. It has a number of nifty features and has a lower price point for my needs. I may spring for a full LibraryThing account as well because it’s fun to play with. Were I going to limit myself to software that ran under Windows, it’d be a toss-up. Luckily, everything I’ve looked at in this article has trial versions or free-but-limited versions. Talk to me in a few months when I’ve tried using one of these programs in more depth.

Share

15 Comments

  1. on December 12, 2006 at 9:36 pm | Permalink

    I am definitely a Delicious Library fan.

    GFM <– just “checked out” the CDs that you and the Kings borrowed, heh

  2. duchess
    on December 12, 2006 at 10:19 pm | Permalink

    We are currently reviewing a bunch of linux software for cataloging…do you guys run linux at all? Is this something you would be interested in?

  3. on December 12, 2006 at 10:45 pm | Permalink

    Probably not, given that we don’t have a Linux desktop, only a server.

  4. on December 13, 2006 at 9:51 am | Permalink

    Eh, I downloaded Delicious Library last night to play with it and did run into a few problems. Mainly, I had a couple of books that it read the UPC correctly on, but it could not find the book information. However, I had no problems doing a title search and picking the correct book, so that is an acceptable workaround for me.

  5. on December 13, 2006 at 9:54 am | Permalink

    My complaint about DL right now is there seem to be features that don’t work correctly with the trial version and I’m wondering if those will be resolved with the paid version. Specifically, the “location in building” notation. I want to be able to look up a book and find out where it lives in the house so I can go lay hands on it. Maybe Geof can say if this works or not?

    Also, check out the bundle of DL and some other cool mac software at http://macheist.com

  6. on December 13, 2006 at 11:43 am | Permalink

    A further update: we played with DL last night and had so-so success with its scanning-via-iSight. I’m guessing that we’d need to set up a more consistent lighting scheme to get book barcodes read smoothly. I am impressed that it can read barcodes from a built-in non-focusing camera, since those barcodes are pretty darn fuzzy by the time you get them close to the camera.

  7. on December 13, 2006 at 12:07 pm | Permalink

    And now I’ve found a few other collaborative book cataloging sites like Web-2.0-name-compliant Zestr and Compender. Anyone have experience with those?

  8. on December 13, 2006 at 1:08 pm | Permalink

    Short of signing up and using those Zestr or Compender, they don’t give much info on the interface.

  9. on December 13, 2006 at 7:59 pm | Permalink

    My complaint about DL right now is there seem to be features that don’t work correctly with the trial version and I’m wondering if those will be resolved with the paid version. Specifically, the “location in building” notation. I want to be able to look up a book and find out where it lives in the house so I can go lay hands on it. Maybe Geof can say if this works or not?

    I quickly tested this [one book tagged as Office, another as Bedroom, then searching on Books for “Office” and “Bedroom”] and it works in the registered version.

    DL2 is going to be Leopard-only. I swear, Leopard is going to push me over the edge to buying an Intel-based Mac. At that point, I’ll have four PPC-based Macs in my house, none of which will ably run Leopard!

    [Steve … let me just give you the password to my online banking now, guy.]

    MacHeist may not be the greatest thing for developers, but some did agree to be involved. It’s a good deal for both users and MacHeist, though.

  10. Denise
    on September 17, 2007 at 2:18 pm | Permalink

    Great article! I’ve been looking for something to catalog books and cds and found these same products. I’m wondering if now, almost a year later, how you feel about these products and what you would recommend for windows only user. Thanks.

  11. on September 17, 2007 at 4:10 pm | Permalink

    If you’re okay with storing data about your books out there on the Internet, I’d use LibraryThing. It can actually export your data so you can have a local copy as a backup, or if you later decide to use another program like Readerware.

  12. alejandra
    on March 6, 2008 at 1:42 pm | Permalink

    Hi, I’m shopping for a library software within the realm of what you discussed in this post. Needs to be PC compatible and the two I have looked into are Collectorz and Readerware. We need the loan/due capability for sure, being a small non-profit organization with members that have library benefits. Have you heard of BookCAT or Book Organizer? Anyone with suggestions? Thank you.

  13. on March 7, 2008 at 1:40 pm | Permalink

    Sorry, I haven’t heard of either of those.

  14. on October 20, 2009 at 11:56 pm | Permalink

    Hi Stephen,
    Thanks for the great article. I am in the same boat as alejandra. Are you able to contact him/her? I would like to know if they found a solution that works. Might save us time.

    Oh…it would be really cool if the library software could register users and also take their fingerprints. Then if one wants to borrow a book, fingerprint scan instead of library card, its hard to loose one’s finger. We work with kids. Heard of any software that does this?

    Cheers!

  15. on October 21, 2009 at 11:01 am | Permalink

    Sorry, Glad, I don’t have contact info for him.

One Trackback

  1. […] For Christmas, Amy bought us the Delicious Library software that Stephen talked about here. […]