Quote:
Originally Posted by unboggling
I was researching if there might be a better way for me to work with the calibredb data only for the purpose of printing or saving a formatted table of metadata, as opposed to the unformatted catalog.csv.
|
If you only want to extract and save data from metadata.db, the simplest way is to use sqlite3 and a script. In Windows, I could use this batch file to get a list of all book titles sent to test1.txt:
Code:
Echo ON
Echo Calibre metadata.db test ...
Echo .output test1.txt > sqlscript.scr
Echo SELECT title FROM books; >> sqlscript.scr
Echo .quit >> sqlscript.scr
SQLITE3 METADATA.DB < sqlscript.scr
There are lots of SQL commands for selection, sorting, etc.