matching last_modified with file date modified?

jiembe · 11-07-2020, 09:51 AM

Is there a way to reset the last_modified column to the modified file date of the ePubs files in the Calibre folder?

theducks · 11-07-2020, 10:21 AM

NO
Last_modified reflects ANY change affecting the book.
And sometimes the Library (changing a tags case, spelling) affects all uses in the entire Library

BetterRed · 11-07-2020, 04:17 PM

↑ ↑ ↑ ✔

Calibre's "Modified/last_modified" column is the date and time a book's metadata was last changed. A book's metadata is stored in the library database, which is the metadata.db file in the library folder.

A file system's "Date modified" is the date and time the content of a file was changed.

Format files (book content), such as .epub, .mobi, .pdf, .cbz etc, are not changed when the metadata changes.

Because it is written when the metadata is changed, the file system's "Date Modified" of a book's 'metadata.opf' file will be normally be equal to or close to Calibre's "Modified/last_modified" column.

The Polish Book or Embed Metadata tools can be used to inject the current metadata values into a book's format file. When used, the file system's "Date modified" of a book's format file will be updated to the date and time the Polish or Embed operation was performed.

BR

ownedbycats · 11-07-2020, 04:26 PM

Job Spy has "Reset Last-Modified Date" and "Set Last-Modified Date to Date-Added," but I don't think either of those are what you want.

jiembe · 11-08-2020, 08:10 AM

Quote:

Originally Posted by jiembe

Is there a way to reset the last_modified column to the modified file date of the ePubs files in the Calibre folder?

One time only ?

11-07-2020, 09:51 AM	#1
jiembe Zealot Posts: 137 Karma: 10 Join Date: Sep 2016 Location: Montréal Québec Device: Kobo Glo; Kobo Libra	matching last_modified with file date modified? Is there a way to reset the last_modified column to the modified file date of the ePubs files in the Calibre folder?

11-07-2020, 04:17 PM	#3
BetterRed null operator (he/him) Posts: 20,957 Karma: 27620688 Join Date: Mar 2012 Location: Sydney Australia Device: none	↑ ↑ ↑ ✔ Calibre's "Modified/last_modified" column is the date and time a book's metadata was last changed. A book's metadata is stored in the library database, which is the metadata.db file in the library folder. A file system's "Date modified" is the date and time the content of a file was changed. Format files (book content), such as .epub, .mobi, .pdf, .cbz etc, are not changed when the metadata changes. Because it is written when the metadata is changed, the file system's "Date Modified" of a book's 'metadata.opf' file will be normally be equal to or close to Calibre's "Modified/last_modified" column. The Polish Book or Embed Metadata tools can be used to inject the current metadata values into a book's format file. When used, the file system's "Date modified" of a book's format file will be updated to the date and time the Polish or Embed operation was performed. BR Last edited by BetterRed; 11-07-2020 at 04:20 PM. Reason: typo

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Modified date	Klaas Vaak	Calibre	11	06-25-2017 11:55 PM
Searching Published matching Date	Perkin	Library Management	0	09-22-2011 05:35 AM
E-book Viewer Updates "Date Modified" on File. Why?	spedinfargo	Calibre	3	02-28-2011 05:24 PM
Date Added vs. Date Modified	aglaia761	Calibre	5	11-28-2010 05:34 AM
Last Modified Date	jjansen	Calibre	1	09-12-2010 10:16 PM

11-07-2020, 10:21 AM	#2
theducks Well trained by Cats Posts: 30,410 Karma: 58055234 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	NO Last_modified reflects ANY change affecting the book. And sometimes the Library (changing a tags case, spelling) affects all uses in the entire Library

11-07-2020, 04:26 PM	#4
ownedbycats Custom User Title Posts: 9,363 Karma: 64435965 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Job Spy has "Reset Last-Modified Date" and "Set Last-Modified Date to Date-Added," but I don't think either of those are what you want.

Advert

Advert