MobileRead Forums - View Single Post

DaltonST · 11-17-2017, 12:24 PM

Version 1.0.83 -2017-11-17 New GUI Tool: Set Last-Modified Date to Date-Added (Timestamp)

In case you forgot to first back up the last-modified dates so you could restore them after you made changes to any custom column in Preferences > Add your own columns (which unfortunately changes every book's last-modified date), you can at least reset the newly changed last-modified dates to the date that each book was originally added to the library.

See the attached.

n.b. since Calibre automatically updates a book's author-sort whenever any metadata column residing on table "books" is changed, and auto-commits that author-sort change, this takes longer than you would think. In testing, 40,000 books took 5 minutes to be changed instead of just a dozen or so seconds that this GUI Tool would otherwise take.

DaltonST

11-17-2017, 12:24 PM	#154
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	New GUI Tool: Set Last-Modified Date to Date-Added (Timestamp) Version 1.0.83 -2017-11-17 New GUI Tool: Set Last-Modified Date to Date-Added (Timestamp) In case you forgot to first back up the last-modified dates so you could restore them after you made changes to any custom column in Preferences > Add your own columns (which unfortunately changes every book's last-modified date), you can at least reset the newly changed last-modified dates to the date that each book was originally added to the library. See the attached. n.b. since Calibre automatically updates a book's author-sort whenever any metadata column residing on table "books" is changed, and auto-commits that author-sort change, this takes longer than you would think. In testing, 40,000 books took 5 minutes to be changed instead of just a dozen or so seconds that this GUI Tool would otherwise take. DaltonST Attached Thumbnails