View Single Post
Old 02-23-2009, 06:20 AM   #8
Format C:
Guru
Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.Format C: ought to be getting tired of karma fortunes by now.
 
Posts: 753
Karma: 1496807
Join Date: Jul 2008
Location: The Third World
Device: iLiad + PRS-505 + Kindle 3
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.
Format C: is offline   Reply With Quote