Printing Shelf Labels

CharlasTalk about LibraryThing

Únete a LibraryThing para publicar.

Printing Shelf Labels

1walterknowles
Abr 26, 2021, 3:56 pm

I shelve my books by Library of Congress Cataloguing. Thus Howard Risatti's "Theory of Craft" gets a bookmark which has its spine label (NK1110 .R57 2007) printed at the top of the slip as:
NK1110
.R57
2007

and author and title printed vertically down the slip.

Right now, the way I'm doing this is creating one of my "Your Books" lists with LCCN, Author, Title, and Entry Date (which I can sort by). I then select the rows I want to print labels for and copy and paste them into Excel. I then format and print them. This is cumbersome. Is there a way to query LibraryThing for these data items (selecting by date) so that I can easily import them into a database? Even better is there an API hiding someplace that I can use to generate a web page with this info? And what would be best of all, is that there is already a feature in LibraryThing that I can use or adapt to do this?

Thanks much!

Walt Knowles

2gilroy
Abr 26, 2021, 8:00 pm

Depending on the database program, you can export in a tab delimited excel file for import into a database. And you can filter some of these by tag, by collection, or by specific filter options.

3walterknowles
Abr 28, 2021, 2:01 pm

>2 gilroy: That's what I'd expect, but I must be blind--I can't find a way to generate that delimited file. Could you help me out by pointing me at it? Once I have it in an interchange format (tdf, cdf, sgml, xml, xls, whatever), I'm home free.

Thanks!

4gilroy
Abr 28, 2021, 2:59 pm

Okay, basic walk through:

In the top chocolate brown bar, find the More tab and click on that.
Scroll down to find the import/export option and click that.
You'll be at this web address:
https://www.librarything.com/more/import
On the right hand side it says Export as Tab-Delimited Text. Click that link.
This should be your web address now:
https://www.librarything.com/export.php?export_type=tsv
On that page, select the appropriate options, and scroll to the bottom to click Export Filtered