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

bodiccea · 08-26-2018, 10:55 AM

@BetterRed,

I want the file system modification date to be the MAX({last_modified}, {timestamp}).
Or, to be more clear: I must set my 3000 books modification date on file system automatically from calibre data.
So any GUI (finder or other) is not useable: I have to extract the dates from calibre automatically, and only a script (already done, look in a previous message) can do it.

So the date seen on web site will almost be correct.
I did read somewhere that some changes on boot itself (for instance adding a chapter, this kind of things) may change the {timestamp} field, so taking the MAX wil be the secure way.
If this {timestamp} ("date" column in GUI) always stays the same, and is the insertion book date in library, the MAX() will maybe not be necessary). This field is not really well documented.

br.

08-26-2018, 10:55 AM	#13
bodiccea Member Posts: 11 Karma: 10 Join Date: Aug 2018 Device: samsung tablet 8", kitkai	Modification date on file system @BetterRed, I want the file system modification date to be the MAX({last_modified}, {timestamp}). Or, to be more clear: I must set my 3000 books modification date on file system automatically from calibre data. So any GUI (finder or other) is not useable: I have to extract the dates from calibre automatically, and only a script (already done, look in a previous message) can do it. So the date seen on web site will almost be correct. I did read somewhere that some changes on boot itself (for instance adding a chapter, this kind of things) may change the {timestamp} field, so taking the MAX wil be the secure way. If this {timestamp} ("date" column in GUI) always stays the same, and is the insertion book date in library, the MAX() will maybe not be necessary). This field is not really well documented. br.