Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 10-25-2019, 04:09 PM   #1
Horus68
Zealot
Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.
 
Horus68's Avatar
 
Posts: 143
Karma: 76596
Join Date: Feb 2015
Location: Portugal
Device: Kobo Aura HD
Question Timestamp field for latest additions to library?

How can I list "latest additions to library" or "latest books edited entries" (library view)

Is there a way to implement an automatic date timestamp field for when was the entry last edited?

Scenario:
Create a virtual library with latest additions and another for the latest edited

The virtual library would have a code like this
Code:
timestamp:>5daysago
Note: date:>5daysago as told in the https://manual.calibre-ebook.com/gui...arch-interface don't work for me as the date field can already be filled in a different library and when I move it to a second library the book comes along with a sidecar opf file that specifies its own calibre:timestamp (or if importing it from a zip file created after a "save to disk" from another computer).

So I would require an individual library:timestamp (even if it would be one that would not survive a library restore!)

Last edited by Horus68; 10-25-2019 at 04:23 PM.
Horus68 is offline   Reply With Quote
Old 10-25-2019, 04:40 PM   #2
Horus68
Zealot
Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.
 
Horus68's Avatar
 
Posts: 143
Karma: 76596
Join Date: Feb 2015
Location: Portugal
Device: Kobo Aura HD
Replying to myself but just for half of the request:

For the "latest added" there are 2 ways to have a list:
Go to Preferences / Adding Books / Adding Actions /
Untick: - When using the "Copy to library" action to copy books between libraries, preserve the date

or
- Tags to apply when adding a book (add a tag like "new")... and then create a saved search or a virtual library for that tag
(see pic above)

Now... what to do to have a list of the "Latest edited"?
Attached Thumbnails
Click image for larger version

Name:	2019-10-25_01358.png
Views:	63
Size:	31.7 KB
ID:	174538  
Horus68 is offline   Reply With Quote
Advert
Old 10-25-2019, 04:48 PM   #3
itimpi
Wizard
itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.
 
Posts: 4,553
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
There are two time stamps columns as standard in Calibre - the date the book was added and the date it was last modified. You can click on the column header to sort by that field.

There is also the option to get a standard tag added to the book at the time or is added. I personally add a [TODO] tag that I later remove when I have checked all the cover and metadata are as I want them.
itimpi is offline   Reply With Quote
Old 10-25-2019, 04:51 PM   #4
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,031
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Last Modifid (all you need to do is unhide that column.
Note ANY metadata change (that affects the book) bumps this timestamp
theducks is offline   Reply With Quote
Old 10-25-2019, 06:22 PM   #5
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,712
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
↑ ↑ ↑ ✔

To elaborate - a book's Last Modified can get updated 'unexpectedly' - e.g. if you changed a tag name from "Antebellum" to "Pre-1861" all the books tagged "Antebellum" would have their Last Modified Dates set to current timestamp - i.e Now.

I have a Last Action/#last_action_date custom column. I edit metadata in the book list cells, so it's easy to maintain.

BR
BetterRed is online now   Reply With Quote
Advert
Old 10-26-2019, 02:49 AM   #6
Horus68
Zealot
Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.
 
Horus68's Avatar
 
Posts: 143
Karma: 76596
Join Date: Feb 2015
Location: Portugal
Device: Kobo Aura HD
Quote:
Originally Posted by theducks View Post
Last Modifid (all you need to do is unhide that column.
Note ANY metadata change (that affects the book) bumps this timestamp
Where can I unhide that column? In book list all columns are visible. Same as in Preferences / Add your own columns


Quote:
Originally Posted by BetterRed View Post
I have a Last Action/#last_action_date custom column. I edit metadata in the book list cells, so it's easy to maintain.
Is this an automatic change? Not seeing how can i set up a custom column to achieve that!
Attached Thumbnails
Click image for larger version

Name:	Add your own columns.png
Views:	73
Size:	34.6 KB
ID:	174545  

Last edited by Horus68; 10-26-2019 at 02:53 AM.
Horus68 is offline   Reply With Quote
Old 10-26-2019, 03:03 AM   #7
Horus68
Zealot
Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.Horus68 understands the mechanisms of the catecholamine pathways.
 
Horus68's Avatar
 
Posts: 143
Karma: 76596
Join Date: Feb 2015
Location: Portugal
Device: Kobo Aura HD
Solved (sorry!)... that column was too narrow in the column list for me to see it!


Now I can use this
Code:
last_modified:>=5daysago

Last edited by Horus68; 10-26-2019 at 03:07 AM.
Horus68 is offline   Reply With Quote
Old 10-26-2019, 03:41 AM   #8
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,712
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Horus68 View Post
Where can I unhide that column? In book list all columns are visible. Same as in Preferences / Add your own columns
Right click in book list column headers to show/hide columns


Quote:
Originally Posted by Horus68 View Post
Is this an automatic change? Not seeing how can i set up a custom column to achieve that!
No, not automatic as such. Just a different way of editing metadata, I prefer to enter data in a single user controlled table, rather than into different fixed layout forms.

Press F2 in a book list cell, for Date cells press '=' to set to Now, press '-' to set to Undefined (blank). Press Tab to edit next cell, Shift+Tab to edit previous cell. For me, this Tweak makes it easier.

Click image for larger version

Name:	Annotation 2019-10-26 182620.jpg
Views:	59
Size:	235.7 KB
ID:	174546

BR
BetterRed is online now   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make sure future additions on device and library matc? pinky62 Library Management 2 08-06-2018 08:33 PM
fw5.6.1+ — Is abuse of the author field only option for library management? danjcla Kindle Developer's Corner 7 01-19-2015 09:27 PM
Show tags searched results only in library field Scottrow Library Management 3 11-09-2013 09:04 PM
How to mark latest additions to Calibre? MelBr Library Management 14 03-10-2013 04:59 PM


All times are GMT -4. The time now is 12:14 AM.


MobileRead.com is a privately owned, operated and funded community.