MobileRead Forums - View Single Post - Calibre "save to disk", "last_modified" field format

bodiccea · 08-25-2018, 08:09 PM

@BetterRed,

I don't think it is practical for 3,000 books with a GUI, even as I don't know the last modification date.

For now, I will try, if possible (all by CLI interface, not GUI), so it can be scriptable:
1) try to get the last_modified date from a correct backup (1 have 7 days/4 weeks/12 months/3 years backups). I believe a few months old one will be fine.
2) try to inject these dates in new Calibre DB for each book (making a list of the few ones which were not found for some reason, such as author/title change). I will have to manually change these errors.
3) replace #brtime with MAX({last_modified}, {timestamp}). The reason I created this new brtime field was to end-up with this: The filesystem date will show the real last change, metadata or book.

I believe I can write a function for point 3, never wrote one in Calibre.

I need to study the CLI interface first, not sure how powerful/easy it is...

Another maybe simpler solution: As I have file system backups. I know which books were added recently (look in ebooks.raoult.com, french section).
I save them somewhere else, delete the library and import a backup, where {last_modified} fields are correct, and add the new books.

In that case, just the point (3) will be the difficult task:
I will need a new plugin, but python is an easy language, just not sure how it integrates in columns.

br.

08-25-2018, 08:09 PM	#9
bodiccea Member Posts: 11 Karma: 10 Join Date: Aug 2018 Device: samsung tablet 8", kitkai	@BetterRed, I don't think it is practical for 3,000 books with a GUI, even as I don't know the last modification date. For now, I will try, if possible (all by CLI interface, not GUI), so it can be scriptable: 1) try to get the last_modified date from a correct backup (1 have 7 days/4 weeks/12 months/3 years backups). I believe a few months old one will be fine. 2) try to inject these dates in new Calibre DB for each book (making a list of the few ones which were not found for some reason, such as author/title change). I will have to manually change these errors. 3) replace #brtime with MAX({last_modified}, {timestamp}). The reason I created this new brtime field was to end-up with this: The filesystem date will show the real last change, metadata or book. I believe I can write a function for point 3, never wrote one in Calibre. I need to study the CLI interface first, not sure how powerful/easy it is... Another maybe simpler solution: As I have file system backups. I know which books were added recently (look in ebooks.raoult.com, french section). I save them somewhere else, delete the library and import a backup, where {last_modified} fields are correct, and add the new books. In that case, just the point (3) will be the difficult task: I will need a new plugin, but python is an easy language, just not sure how it integrates in columns. br.