Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 04-30-2019, 03:06 PM   #1
cscoley
Junior Member
cscoley began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Oct 2016
Device: laptop
Custom column that lists date AND time a book is added

Hello,
Is there a way to create a column that shows both date and time a book is added? I need to be able to see what time books were added especially when they are added on the same day.
Thank you in advance for your help.
cscoley is offline   Reply With Quote
Old 04-30-2019, 03:20 PM   #2
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 5,111
Karma: 19597086
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9
The default date/timestamp column already stores this information. You just need to change how it's displayed. The help window shows you how you can customize the display format. I normally just use iso format for timestamp and last modified.

Preferences - Tweaks - Control how dates are displayed

Code:
gui_timestamp_display_format = 'iso'
ilovejedd is offline   Reply With Quote
Old 04-30-2019, 03:23 PM   #3
cscoley
Junior Member
cscoley began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Oct 2016
Device: laptop
Quote:
Originally Posted by ilovejedd View Post
The default date/timestamp column already stores this information. You just need to change how it's displayed. The help window shows you how you can customize the display format. I normally just use iso format for timestamp and last modified.

Preferences - Tweaks - Control how dates are displayed

Code:
gui_timestamp_display_format = 'iso'

Thank you so much!!!!!
cscoley is offline   Reply With Quote
Old 04-30-2019, 04:04 PM   #4
lumpynose
Wizard
lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.
 
Posts: 1,086
Karma: 6719822
Join Date: Jul 2012
Device: Palm Pilot M105
Why didn't this work for me? I always get 00:00 for the time part.

Click image for larger version

Name:	Capture.PNG
Views:	436
Size:	42.2 KB
ID:	171189
lumpynose is offline   Reply With Quote
Old 04-30-2019, 04:11 PM   #5
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,211
Karma: 11766195
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Quote:
Originally Posted by lumpynose View Post
Why didn't this work for me? I always get 00:00 for the time part.

Attachment 171189
How do you insert the data in the field?
Terisa de morgan is offline   Reply With Quote
Old 04-30-2019, 04:25 PM   #6
lumpynose
Wizard
lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.
 
Posts: 1,086
Karma: 6719822
Join Date: Jul 2012
Device: Palm Pilot M105
Quote:
Originally Posted by Terisa de morgan View Post
How do you insert the data in the field?
If I understand your question, it's the Template field in that Edit Custom Column window. I used the field last_modified, after eyeballing the bottom of this page:

https://manual.calibre-ebook.com/gen...plate_ref.html

Reading this page

https://manual.calibre-ebook.com/template_lang.html

with several trial-and-error attempts led me to the template I used.

For the custom column, after I clicked the green +, for the Column Type I selected Column built from other columns.
lumpynose is offline   Reply With Quote
Old 04-30-2019, 04:25 PM   #7
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 5,111
Karma: 19597086
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9
Quote:
Originally Posted by lumpynose View Post
Why didn't this work for me? I always get 00:00 for the time part.

Attachment 171189
I just tried it with Template Tester. It seems the template uses the display value of last_modified so if you don't have it set to show the time (via tweak), then the template only has the date available.
ilovejedd is offline   Reply With Quote
Old 04-30-2019, 04:28 PM   #8
lumpynose
Wizard
lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.
 
Posts: 1,086
Karma: 6719822
Join Date: Jul 2012
Device: Palm Pilot M105
Quote:
Originally Posted by ilovejedd View Post
I just tried it with Template Tester. It seems the template uses the display value of last_modified so if you don't have it set to show the time (via tweak), then the template only has the date available.
And of course I didn't know about (and use) the Template Tester, I just kept changing my custom column and restarting calibre.
lumpynose is offline   Reply With Quote
Old 04-30-2019, 04:35 PM   #9
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 5,111
Karma: 19597086
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9
Quote:
Originally Posted by lumpynose View Post
And of course I didn't know about (and use) the Template Tester, I just kept changing my custom column and restarting calibre.
Don't sweat it. I started using Calibre ten years ago and I only learned about Template Tester last year.
ilovejedd is offline   Reply With Quote
Old 04-30-2019, 04:44 PM   #10
lumpynose
Wizard
lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.
 
Posts: 1,086
Karma: 6719822
Join Date: Jul 2012
Device: Palm Pilot M105
It's kind of annoying that some useful things are hidden away and, as far as I can tell, only accessible by reconfiguring the main toolbar or adding a menubar.
lumpynose is offline   Reply With Quote
Old 05-01-2019, 05:12 AM   #11
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,211
Karma: 11766195
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Quote:
Originally Posted by lumpynose View Post
It's kind of annoying that some useful things are hidden away and, as far as I can tell, only accessible by reconfiguring the main toolbar or adding a menubar.
Of course, how do you want them to be accesible? I would hate a menu with ALL the options, and what you can find useful another person can find it superfluous.
Terisa de morgan is offline   Reply With Quote
Old 05-01-2019, 12:33 PM   #12
lumpynose
Wizard
lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.
 
Posts: 1,086
Karma: 6719822
Join Date: Jul 2012
Device: Palm Pilot M105
Quote:
Originally Posted by Terisa de morgan View Post
Of course, how do you want them to be accesible? I would hate a menu with ALL the options, and what you can find useful another person can find it superfluous.
The thing at the top is a button bar, not a menu. They don't need to be added to the button bar at the top.

A pull down / drop down menu next to the Saved search thing on the right, named All Commands or something, with Exit at the bottom. Or perhaps a button in the button bar named All Commands.

Last edited by lumpynose; 05-01-2019 at 05:41 PM.
lumpynose is offline   Reply With Quote
Old 05-01-2019, 02:45 PM   #13
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,211
Karma: 11766195
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Quote:
Originally Posted by lumpynose View Post
The thing at the top is a button bar, not a menu. They don't needed to be added to the button bar at the top.

A pull down / drop down menu next to the Saved search thing on the right, named All Commands or something, with Exit at the bottom. Or perhaps a button in the button bar named All Commands.
I think it can be too long but anyway, you can put a request for it.
Terisa de morgan is offline   Reply With Quote
Old 05-01-2019, 03:38 PM   #14
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 5,111
Karma: 19597086
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9
Quote:
Originally Posted by lumpynose View Post
A pull down / drop down menu next to the Saved search thing on the right, named All Commands or something, with Exit at the bottom. Or perhaps a button in the button bar named All Commands.
That would be convenient. Something text-based similar to the Firefox/Chrome (hamburger menu button) where you can see a fixed menu showing all Calibre commands. Then a submenu for Plugins where you can update/add new plugins as well as submenus (inside the Plugins submenu) for each installed plugin.

You can add a menubar to Calibre but unfortunately, it doesn't provide a way to group commands into submenus. Hence, the menubar actually ends up being less space efficient than the main toolbar if you add all available Calibre commands.
ilovejedd is offline   Reply With Quote
Old 05-01-2019, 04:20 PM   #15
lumpynose
Wizard
lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.lumpynose ought to be getting tired of karma fortunes by now.
 
Posts: 1,086
Karma: 6719822
Join Date: Jul 2012
Device: Palm Pilot M105
Yeah, I tried the menubar and couldn't really see any advantage to using it for anything, unless you made the button bar empty.
lumpynose is offline   Reply With Quote
Reply

Tags
calibre, custom column, custom columns, date added, time added

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Column to enter date a book was completed (was read) Acousticvillage Library Management 6 12-08-2018 05:02 PM
Date Added column? Can I set date when book added to library? fitzhugh Calibre 4 06-03-2012 05:42 PM
"Date Added" custom column? cheechwhiz Library Management 1 08-20-2011 10:25 AM
Custom column for date added Gunnerp245 Calibre 2 07-08-2011 04:39 PM
Custom column for book added gandor62 Library Management 1 03-01-2011 06:58 AM


All times are GMT -4. The time now is 01:57 AM.


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