View Single Post
Old 12-29-2010, 04:52 AM   #5
kiwidude
Calibre Plugins Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,732
Karma: 2197770
Join Date: Oct 2010
Location: Australia
Device: Kindle Oasis
Quote:
Originally Posted by itimpi View Post
Another possibility is to write a batch file/script that processes the CSV file and uses the calibredb command to add each book in turn.
Indeed, the easiest of all. BadGandalf, you don't even need scripting knowledge to do that one, you could just make an extra column in your spreadsheet which is a formula that builds up the text representing a command line to calibredb. The options are all documented here. Then just grab that column of values generated, paste them into a new text file and save it as a name ending in .bat and you can then run it to actually create a whole bunch of empty book entries. The only data you will be able to specify is title and author from your spreadsheet, but you can populate whatever else from a normal metadata retrieval anyway and fill in gaps from your spreadsheet manually.

You would want to test it on a single book first (I've never used the command line myself) but if you had title in column A and author in column B the formula could look something like this:
=CONCATENATE("calibredb.exe -e -authors """&B1&""" -title """&A1&"""")
kiwidude is offline   Reply With Quote