|05-05-2012, 12:17 PM||#1|
Join Date: Jan 2012
Location: SF Bay Area, California
Device: Sony PRS T-1, Kindle Fire
Import from Library Thing
I maintain a LibraryThing database of books for an individual that I choose and deliver books to from the library. I really don't like LibraryThing and am thinking about setting up a calibre library instead. Is there a way to import the records from LibraryThing into calibre and have each record an empty book?
|09-24-2013, 10:14 PM||#2|
drowned in old books
Join Date: May 2012
Device: Kindle Touch 3G
The only way I've found to do it is to do it via ISBNs..
1. Export an xls file of the Librarything library.
2. Open it in Libreoffice, with the ONLY the option "Tab" selected under the Separated By import options (you can't have commas selected, because they'll ruin the formatting by trying to read your tags as different headings etc...)
3. Scroll rightward, to the ISBN column. (It's column "H" on my export file.) Click the column heading letter to select the whole column.
4. CTRL + C to copy THE WHOLE THING.
5. Paste them into a text editor.
6. Use the Find + Replace option to get rid of ISBN-less entries, by replacing all
with nothing. Then get rid of all the [ and ] using the same method.
7. Also delete the ISBNs heading at the top (which it would also have copied.)
8. Bring up Calibre! you can run multiple libraries for it, so it helps to create a new library for the project you're managing; it makes things less confusing. Click on the Calibre icon within the program icon bar, and go to Switch/Create Library. Make a new folder for the library with whatever name you like and then select to "Create an Empty Library at the New Location", using the new folder.
9. Now go to Calibre > Add Books > Add from ISBN. Paste the ISBNs into the Calibre dialogue (one number per line!), set any tags you want to add to all of them and then click Okay. You'll see a dialogue come up with options to download metadata, download covers, download both or configure downloads, to fill in the missing data. Calibre will fetch the missing metadata, including Title, Author, Publisher, Publishing Date, Description and some tags (such as General, Fiction) and append it to the book. It does not create/download an ebook; you'll just get a nice empty file you can use like a library card catalogue. (I'm still trying to figure out how to import my custom ratings, shelves and tags from Librarything- and also, some books don't have ISBNs due to age or rarity, so it can be a problem... Some books might have to be added in manually. But for most recently-published/popular books, the method I just listed should work.)
|Thread Tools||Search this Thread|
|Thread||Thread Starter||Forum||Replies||Last Post|
|HOW does the library/overdrive/publisher thing work?||gracie||General Discussions||20||12-25-2011 09:16 PM|
|[Old Thread] import library or export to single file add to existing library||PCreighton||Calibre||4||04-10-2011 02:08 AM|
|Can't import library books in reader library||missbrooklyn||Sony Reader||7||04-08-2011 04:48 AM|
|How do I import this library ?||Giuseppe Chillem||Library Management||11||02-01-2011 06:10 PM|
|"Library Friendly" - an interesting idea from Library Thing||Snowman||General Discussions||0||11-07-2010 08:26 PM|