Join LibraryThing to post.
This topic is currently marked as "dormant"—the last message is more than 90 days old. You can revive it by posting a reply.
I have a cataloging question: is there a program available for printing labels (say by LC no.) to help me organize my personal library (about 500 volumes currently)? I don't have all LC nos. in my LT catalog yet, so a second question is whether there is a method for automating that info given an existing database of book titles.
This needs to be a FAQ question, I think.
I don't know the answer to it. Someone does, I think. Surely there is some labels template that can be used, together with our export feature.
Thanks Tim. I wonder what libraries use to automate the labeling function. For that matter, I wonder if there is an adhesive label product available out there.
I help out at my church library and there is a catalog called The Library Store that carries a nice selection of labels. We use a set that gives us a label for the spine, one for the card pocket and one for the card. This is a small church library and we still use the card and pocket system. The Library Store has a website.
You said that you are missing some numbers, I thought I would share this website. It gives both LC and Dewey numbers if you enter the ISBN number (as well as other code numbers that I don't know).
There must be some trick to that site that I'm not able to figure out.
Besides LT, I have a parallel catalog in the form of a spreadsheet. In it, I track 6 different catalog codes when I can find them all.
Full disclosure: One of them is merely whole-number-Dewey (and how I have the books arranged on my shelves now); another is the BISAC cataloging system (what most bookstores use), and I've got just one entry in it at the moment. It is the system that MrsHouseLibrary and I are currently attempting to implement due to the woeful inadequacies of Dewey.
I've tried a dozen ISBNs so far, and I've ONLY gotten Dewey and LC numbers back - but not always. In one case, the Classify site had only the LC; in 3 cases, only the Dewey number.
I was hoping for a site that might cross reference several different cataloging systems.
>1 printing labels
I make LC Classification labels for my books. There may be a better way, but here's what I do.
I use Excel, Word and standard 1"x2 5/8" labels (Avery 8160).
The first step is finding LC Classifications for the books. The Library of Congress is obviously the first place to go. It try to use them as my import source. If they don't have my book I search WorldCat for another college or university library that does, and check to see if they use LCC.
Next is to export your LT library. Check under the "More" tab at the far right of the top navigation bar and scroll down in the right column. I don't think it matters whether you use CSV or tab-delimited export. Since I now just do updates, I tag books "needs label" so I can filter the list after export.
I open the exported library in excel. First I filter the tag column for "needs label" and remove any rows without that tag. Then, I remove all of the columns except author, title, LC Class and date. The first two are not really necessary, but I like to keep them to know what I'm looking at.
Next is the labor intensive step. And I'd love to hear better ideas if anyone has them.
Here's a sample LCC: N72.S6H3613 v.2 1952
But I want my label to look like (imagine it center-justified):
.S6 H3613 v.2
So I have to bust up the one LC Class. column I get from LT into 6 columns for the various parts. I use the "Text to Columns..." command and some find/replace tricks but it still takes a while, especially the first time.
With that done, I go to Word and create a label sheet using the "Labels" command and "data merge" with the above created excel file as the source. I layout the label, do a print merge and I'm done. I save the Word file, so I don't have to redo that step.
I only do this about once a year and it's been a while since the last time, so I can't really explain in more detail. I tend to forget exactly what I did in the interim and end up working out again as I go.
I'm also nutty enough that I've put plastic covers on all of my hardbound books so the label isn't stuck to the dust jacket or the book (for those without dust jackets).
I hope this is of some use. And if anyone has a better way, that would be great too.
Thanks, eromsted for that very helpful post. I'm hoping to study this a little more carefully and give it a try. I too was wondering about the labels sticking to the books permanently. This would be more of an issue for paperbacks. Maybe there's a removable label adhesive option out there?
Paperbacks are a problem. The regular labels stick hard in short order and removing them does damage the book. If you find labels with more forgiving adhesive let me know, but I don't think I would trust any adhesive left to sit for years and years.
I decided early that I didn't really care about damaging the paperbacks. I have occasionally regretted this decision, but not too much. More recently, I have experimented with folding a plastic cover around a few paperbacks that seemed to me interesting enough to be worth the trouble. The pictures below illustrate one example (from a series of Anchor books with Edward Gorey cover art). The plastic is from a Demco dust jacket cover with the paper backing cut off and trimmed to fit the book. You can also see one of my spine labels.
>6 re: entering numbers in the OCLC search
Click on the ISBN tab or else you will need to enter OCLC# (available from WorldCat)
By the way, this is a very useful search! I was previously using WorldCat and then clicking libraries with holdings to see what they used. But this hardly ever worked for fiction. Now I can move beyond the whole numbers I was filling in a start using basic Dewey lists (for virtual organization only, no labels for me).
As for the labels, another source of supplies is Gaylord such as their "processing labels" at http://gaylord.com/listing.asp?H=7&PCI=132253 which have some sort of reference OCLC, so I think there may be a service available to their member libraries (i.e. that difficult formatting part). Yep, here it is at http://www.oclc.org/us/en/label/default.htm. You'll need to be a paying customer to use though...
This won't help if you don't know the number, but once you do you can buy a simple label printer for about $15.00. I work in a library and that's what we use... I've seen them at Wal-Mart and office supply stores. It looks like a little keyboard with soft keys, very easy to use, and it prints a label about half an inch tall.
There has got to be an easier way. I've set up my "E" view for what information I'd like on the spine, card envelope, and card, and even cutting and printing it out and taping to the respective areas sounds easier. I'm hoping and praying. I have about 300 books to tackle and I'm tired of my living room floor piled with books. Today is the day!
This group does not accept members.
This topic is not marked as primarily about any work, author or other topic.