Calibre modifying dbase record, throwing off sorting

John IV · 05-24-2023, 02:40 PM

I use cover grid view in Calibre, sorting by modified so my most recently manually modified epubs go to the top left corner.

Occasionally, for whatever reason, I'll see books that I haven't touched move up in the order towards the top. Is there any dbase background metadata culling or maintenance happening on those that I can toggle?

Again, these are books that haven't even been clicked on. Can I see a change history or something on them to see what Calibre is doing? Thanks -

theducks · 05-24-2023, 03:06 PM

(last_)Modified is affected by ANY change to metadata values.
Since this library is built on a Relational Data Base (rdb), changing the casE of a Tag, will affect all books using that tag.

And no, there is no setting to stop that. last_modified is mostly for internal use (flags dirtied records).
{date} is usually when you create the initial entry
I added {#edited} to flag when I made a change (so it rises to the top of a sort)

ownedbycats · 05-24-2023, 03:17 PM

https://www.mobileread.com/forums/sh...d.php?t=341183

Quote:

Originally Posted by capink

This plugin enables the user to have his own custom last_modified column(s), instead of relying on calibre's last_modified which is reserved for internal use and sometimes changes when the books has not been modified. The plugin can update one or more custom date column(s) whenever one or more of the following events happen:

book metadata updated. (with options on what columns to include/exclude)
cover modified.
format added.
format(s) removed.
category item renamed.
category item removed.
book edited by calibre editor.
book created.

This gives the user more flexibility in defining when a custom #last_modified column(s) should be updated. There is also option to include/exclude changes from certain columns from updating the custom Last modified column(s) (see screenshots).

John IV · 05-24-2023, 04:10 PM

Quote:

Originally Posted by theducks

(last_)Modified is affected by ANY change to metadata values.
Since this library is built on a Relational Data Base (rdb), changing the casE of a Tag, will affect all books using that tag.

Thank you, that was likely it, altering a shared tag.
Thanks to ownedbycats, was looking at that plugin earlier too.

05-24-2023, 02:40 PM	#1
John IV Member Posts: 24 Karma: 10 Join Date: May 2022 Device: Kindle Scribe	Calibre modifying dbase record, throwing off sorting I use cover grid view in Calibre, sorting by modified so my most recently manually modified epubs go to the top left corner. Occasionally, for whatever reason, I'll see books that I haven't touched move up in the order towards the top. Is there any dbase background metadata culling or maintenance happening on those that I can toggle? Again, these are books that haven't even been clicked on. Can I see a change history or something on them to see what Calibre is doing? Thanks -

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre EPUB throwing exception on Cybook Odyssey	odabaz	Devices	5	07-31-2022 02:40 PM
Calibre throwing a Memory Exception	Thisiswhatiam	Calibre	6	06-17-2012 03:44 AM
How do i add dbase with metadata?	gijsbuis	Library Management	1	12-27-2011 05:22 AM
Can I create am empty record that refers back to another record?	ficbot	Calibre	1	10-13-2011 10:20 AM
corrupted dbase	hnoto	Related Tools	43	05-17-2010 12:27 PM

05-24-2023, 03:06 PM	#2
theducks Well trained by Cats Posts: 31,273 Karma: 61916422 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	(last_)Modified is affected by ANY change to metadata values. Since this library is built on a Relational Data Base (rdb), changing the casE of a Tag, will affect all books using that tag. And no, there is no setting to stop that. last_modified is mostly for internal use (flags dirtied records). {date} is usually when you create the initial entry I added {#edited} to flag when I made a change (so it rises to the top of a sort)

Advert