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 07-31-2012, 08:58 PM   #1
BetterRed
null operator
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: 3,021
Karma: 1682890
Join Date: Mar 2012
Location: NSW Australia
Device: none
Last Accessed Column

Is there a way I can get Calibre to update a Custom Date column (Last Accessed) whenever I "do" anything to a book - i.e add it, add a format, remove a format, convert it, read it, update metadata, upload to a reader etc.

Thanks BR
BetterRed is offline   Reply With Quote
Old 07-31-2012, 10:40 PM   #2
theducks
Grand Sorcerer
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: 14,432
Karma: 5560777
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by BetterRed View Post
Is there a way I can get Calibre to update a Custom Date column (Last Accessed) whenever I "do" anything to a book - i.e add it, add a format, remove a format, convert it, read it, update metadata, upload to a reader etc.

Thanks BR
There is a column Already that comes close: last_modified
(it does not update for read only functions like View, Send...
theducks is offline   Reply With Quote
Old 08-01-2012, 02:09 AM   #3
BetterRed
null operator
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: 3,021
Karma: 1682890
Join Date: Mar 2012
Location: NSW Australia
Device: none
Thumbs up

Quote:
Originally Posted by theducks View Post
There is a column Already that comes close: last_modified
(it does not update for read only functions like View, Send...
I've looked for Modified Date in Custom Columns & Book Details on more than one occasion, including just now, and I'm 99% sure it wasn't there. I've always been surprised, shocked even, not to find it, and I've been looking for it almost since the day I installed Calibre in February

But I just found it in the right click menu on the Columns Headings, I don't use that much. I don't recall ever looking in Show until just now.

When I selected Modified nothing happened, yes I scrolled over to the extreme right. So I restarted Calibre and there it was, on the extreme right where I expected it to be. And what's more its now in the Custom Columns and the Book Details Layout lists.

I'm sure it wasn't there before. If I had been looking for Last Accessed then I might have missed it, but I was looking for Modified because that's what I was expecting to find. I only thought of Last Accessed today when making this thread.

And before creating this thread I searched in the manual for 'Last Modified" the only meaningful result was in the FAQ section

Quote:
You can also create “virtual columns” that contain combinations of the metadata from other columns. In the add column dialog use the Quick create links to easily create columns to show the book ISBN, formats or the time the book was last modified. For more details, see The calibre template language.
I interpret that as meaning Last Modified must be derived. For me that meant writing some win32 C to interrogate the properties of each file in a book folder to determine most recent Last Modified date and then figuring out how to call into the resultant dll from within The Calibre Template Language. That seemed bizarro to me

The default settings include the Date (Created) column, but not Date Modified, which strikes me as odd. Most (all ?) file based applications I've ever used (and IMO Calibre is primarily file based) put more emphasis on Modified Date than Create Date.

I'm happy to have discovered it was there all the time

But BR is very puzzled

Last edited by BetterRed; 08-01-2012 at 02:42 AM.
BetterRed is offline   Reply With Quote
Old 08-01-2012, 03:14 AM   #4
kiwidude
calibre/Sigil Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,224
Karma: 1334002
Join Date: Oct 2010
Location: London, UK
Device: Kindle Paperwhite 3G, iPad 3, iPad Air
It is nothing to do with the "last modified" value of the physical file. It can't possibly be that because of course you can have multiple book formats associated with a single book record. Instead the modified column represents "mostly" what you asked for in your first post, of a date when that book *record* was modified by editing of the metadata, adding/removing formats or conversions in calibre. However since the other things you mention like "last sent to device" or "last read" do not actually modify a book record then of course they will not result in that modified date changing.
kiwidude is offline   Reply With Quote
Old 08-01-2012, 10:04 AM   #5
BetterRed
null operator
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: 3,021
Karma: 1682890
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by kiwidude View Post
It is nothing to do with the "last modified" value of the physical file. It can't possibly be that because of course you can have multiple book formats associated with a single book record. Instead the modified column represents "mostly" what you asked for in your first post, of a date when that book *record* was modified by editing of the metadata, adding/removing formats or conversions in calibre. However since the other things you mention like "last sent to device" or "last read" do not actually modify a book record then of course they will not result in that modified date changing.
kiwidude, Did you read my most recent post mate - the issue is resolved, Now that I found Date Modified with a nudge from theducks.

I'm not going to regress back to February to find out why the Date Modified column went AWOL. The Last Accessed suggestion was my ideal given I couldn't find what I expected. The Date Modified is more than good enough, especially after 6 months of saying "I cant believe Kovid left this out"

The issue was exacerbated by ambiguities in the Manual.

BR

Last edited by BetterRed; 08-01-2012 at 10:06 AM.
BetterRed is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PRS-T1 Can gmail be accessed? petercreasey Sony Reader 5 06-13-2012 06:15 PM
Q: multi-column PDF to single column mobi format converstion auburn1975 Calibre 7 01-28-2012 06:11 PM
Whispernet.com accessed my mail from US: Is this normal? Bruce Wells Amazon Kindle 6 01-17-2011 06:17 AM
Server shows column headers, but not books, when accessed via mobile phone browser Starson17 Calibre 7 12-29-2009 04:49 PM
How Compact Flash on iLiad accessed? bard69 iRex 6 07-10-2008 08:57 AM


All times are GMT -4. The time now is 11:13 PM.


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