Quote:
Originally Posted by itimpi
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&"""")