printing

Can we print our lists on Library Thing? We have a Church library and I am organizing things. And was really wanting to print my list so I can see if I got all the books.

Sure. When you are in your catalogue - http://www.librarything.com/catalog/MEMBERNAME - there is a printer view button to the far right of the buttons right above the list of books. If you click that button you will get a page formatted for print. Just print it!

thank you so much. I will check it out right now :)

600 pages is a bit much for me to print. I have two many columns in my default view to fit on a page comfortably. Still, it does have some interesting possibilities, as does the all cover view.

James

In practice I've always found it better to export it to Excel (or similar) and print from there, after getting it into a more compact format (to save on paper apart from anything else). You can export from http://www.librarything.com/more/import

Having said which, in the past I've gone to the print page and then copy & pasted that into Excel - that way you can choose the fields.

>5 mart1n:

I am printing out from an exported version as well - this way I remove all the fields I do not want and I get book ID as well (no covers though).

How do I print book labels and barcodes from Librarything?

8 > I don't think you can. Certainly not barcodes.

Thanks.

Not to contradict PhaedraB, but... If the information you want to encode as a barcode is available in one of the exports (eg ISBN), export it to a spreadsheet, change the font of that column to a barcode font and Robert is a brother of your father or mother!

11 > I stand corrected. I didn't know there were barcode fonts.

Yeah, the hard part is to find a free one. They exist, but most of the quick answers (top of Google - at least the last time I searched, a few years ago) want you to pay something from a nominal fee to more than $1000 for a barcode font.

A couple of years ago, someone asked if there was a way to print spine labels from an LT catalog export file.

So, I created one. Check back here later, and when I find where I posted it, I'll provide a link for you.

An hour of searching, and I can't find it. Here's what I use in my spreadsheet (your column names will be different, most likely):

=IF(AND(ISBLANK(O2),ISBLANK(C2)),"",LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(O2," ",""),"'",""),"/",""),6)&CHAR(13)&CHAR(10)&IF(ISERR(SEARCH(",",C2)),LEFT(C2,3),LEFT(C2,SEARCH(",",C2)-1)))

There is one space character in this formula, so the message formatting opted to break the formula there.

Column O is where I store the Dewey/Melvin number, and Column C is Author's name (last, first).

If either is blank, I leave the Spine Label cell empty.

That LEFT... business scans the Melvin # for undesirable characters -- slashes, apostrophes, spaces (just in case) and removes them.

The 6 in that formula is the maximum number of characters you want to print for the number, in this up to 2 decimal -- 123.56. If you want 3 decimals replace the 6 with a 7.

The Char 13 and 10 forces a new line, so the name will print below the number.

The rest of the formula returns the author's name up to, but not including, the comma. If you want to use just the first three letters, let me know and I'll rework the formula for you. Some authors have just one or two characters in their last name (Oz, Frank) , and some have a space - or two - in there (de la Bedoyere, Guy). Let me know what you need.

I have the spine label column set to center the text.