I like to use the publishing date instead of the insert date that calibre uses.
That's because sometimes series order is not the same order in which the books where written (Just think about Asimov, Wilbur Smith or the Sharpe series). So I use series number for the chronological order, and the date for the writing/publishing order...
To edit metadata in batches, I've set up a couple of sqlite3 scripts: one for extract all the data in a CSV file to be edited in OpenOffice, and the other to reload the changes in the database.
Obviously I needed another script to write that date in the exported mobipocket file: calibre does not export it.
The last script I did, writes the language tag in the mobipocket file.
Calibre's database is very well designed and simple to read and edit.
|