Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 09-30-2015, 12:28 AM   #1
ivanm
e^bored
ivanm began at the beginning.
 
Posts: 44
Karma: 10
Join Date: Jun 2010
Device: Kobo Aura HD, BeBook Neo
Searching timestamp column

When I plug in my device, Calibre shows a column labelled "Date", and the tooltip says that the lookup/search name is called "timestamp"... but no matter what I do, I can't seem to search using it. Even searching for "timestamp:true" returns no results.

(What I'm actually trying to do - in case I've fallen afoul of the X-Y problem - is to find which devices I've since modified in my library after adding it to my device, so I can update the version on my device. Since I manually update the "date" column in Calibre every time I make a change to a book, I'm hoping I can do a search of "date:>timestamp" or some such.)
ivanm is offline   Reply With Quote
Old 09-30-2015, 12:39 AM   #2
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,421
Karma: 85400180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
Ah -- you can't compare two columns like that. And you can't compare two book records (the device one and the library one).

I suggest using a tag, or perhaps the Reading List plugin.

Last edited by eschwartz; 09-30-2015 at 12:42 AM.
eschwartz is offline   Reply With Quote
Advert
Old 09-30-2015, 12:50 AM   #3
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,252
Karma: 27110894
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
The manual has examples of searching on the date field

http://manual.calibre-ebook.com/gui....arch-interface
kovidgoyal is offline   Reply With Quote
Old 09-30-2015, 01:12 AM   #4
ivanm
e^bored
ivanm began at the beginning.
 
Posts: 44
Karma: 10
Join Date: Jun 2010
Device: Kobo Aura HD, BeBook Neo
Quote:
Originally Posted by kovidgoyal View Post
The manual has examples of searching on the date field

http://manual.calibre-ebook.com/gui....arch-interface
I tried using those, but it seems they don't work on the timestamp field though; is that deliberate or a bug? (Irrespective of what I want to do with it.)
ivanm is offline   Reply With Quote
Old 09-30-2015, 01:16 AM   #5
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,252
Karma: 27110894
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Where are you getting timestamp from? The lookup/search name for the Date column is date and for the published column is pubdate.
kovidgoyal is offline   Reply With Quote
Advert
Old 09-30-2015, 01:19 AM   #6
ivanm
e^bored
ivanm began at the beginning.
 
Posts: 44
Karma: 10
Join Date: Jun 2010
Device: Kobo Aura HD, BeBook Neo
When I have my device plugged in (a Kobo Aura HD in case that makes a difference) there's a column on the device page called "Date", and the tooltip says its lookup/search name is "timestamp".
ivanm is offline   Reply With Quote
Old 09-30-2015, 01:21 AM   #7
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,252
Karma: 27110894
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Ah you mean in the device view. Yeah searching in the device view is far more limited than in the library view. IIRC device view only supports plain substring searches.
kovidgoyal is offline   Reply With Quote
Old 09-30-2015, 03:20 AM   #8
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
ivanm: The way I handle what you are doing is with the Reading List plugin. With this you can create various types of lists including one that syncs to a device. This can happen automatically when the device is connected. For me, the list will also clear itself after the sync. That way, when I add a book to calibre or modify a book, I add it to this list. On the next connection, everything in the list is sent to the device.
davidfor is offline   Reply With Quote
Old 09-30-2015, 03:21 AM   #9
ivanm
e^bored
ivanm began at the beginning.
 
Posts: 44
Karma: 10
Join Date: Jun 2010
Device: Kobo Aura HD, BeBook Neo
Quote:
Originally Posted by davidfor View Post
ivanm: The way I handle what you are doing is with the Reading List plugin. With this you can create various types of lists including one that syncs to a device. This can happen automatically when the device is connected. For me, the list will also clear itself after the sync. That way, when I add a book to calibre or modify a book, I add it to this list. On the next connection, everything in the list is sent to the device.
I'm already using the reading list plugin for a "To Read" tag. In terms of using it for "update this book", can the plugin replace existing books or only add them again?
ivanm is offline   Reply With Quote
Old 09-30-2015, 07:39 AM   #10
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by ivanm View Post
I'm already using the reading list plugin for a "To Read" tag. In terms of using it for "update this book", can the plugin replace existing books or only add them again?
There are several options about the syncing. But, when the book is sent, it is sent just like if you sent the book manually. For my lists, I use "Add/overwrite all list items to the device" and "Clear this list after a sync to the device. With these options, the books get sent and the list is cleared.
davidfor is offline   Reply With Quote
Old 09-30-2015, 07:40 AM   #11
ivanm
e^bored
ivanm began at the beginning.
 
Posts: 44
Karma: 10
Join Date: Jun 2010
Device: Kobo Aura HD, BeBook Neo
Which could result in multiple copies of the book being present on the device though, doesn't it?
ivanm is offline   Reply With Quote
Old 09-30-2015, 07:56 AM   #12
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by ivanm View Post
Which could result in multiple copies of the book being present on the device though, doesn't it?
It shouldn't and it doesn't here. But, it will if you change the metadata that is used in the save template. I do this all the time. I fix spelling and layout errors, put the book in the send-on-connect list and the book is replaced the next time I connect.

I should add that resending a book that is already on a Kobo device only works properly if there are no structure changes. The books aren't reprocessed by the device, so any changes to the ToC or the internal file structure can cause problems. Plus, the metadata is not reread. If the changes are spelling, CSS or formatting, it works.
davidfor is offline   Reply With Quote
Old 09-30-2015, 09:53 AM   #13
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: 30,944
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
@ivanm

Remember, you can still SORT that column


My device (Astak) does not have a Timezone setting. Last night, it was returning Tomorrow's (-0) date-time
theducks is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Modified timestamp changed theducks Library Management 2 03-12-2012 11:52 PM
Job download timestamp column vivdev Calibre 1 01-17-2012 07:38 AM
Sorting/searching composite column causes slow startup [solved] capnm Library Management 0 11-08-2011 11:44 AM
PRS-T1 Timestamp issues luvduchovny Sony Reader 8 11-05-2011 04:39 PM
mi.timestamp set from imported book KariK Development 4 09-18-2011 11:58 AM


All times are GMT -4. The time now is 08:12 PM.


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