08-22-2010, 07:08 AM | #1 |
Junior Member
Posts: 7
Karma: 10
Join Date: Aug 2010
Device: iPhone
|
Import Date: Bug or Feature?
Hi
I have a query about the date field within the Calibre Database. Last night (21-Aug), I imported some books into the Calibre Database, and this morning, (22-Aug), I searched for these books by using the search string 'date: yesterday' - I was a bit surprised when nothing appeared. However, by searching by one book's title, it appears that the date field has been set to '03-Jan-2010'! Is the above a feature or a bug? I using version 0.7.15 running on Vista Ultimate Regards DG |
08-22-2010, 09:09 AM | #2 | |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Quote:
I tested with 0.7.15 and my date field works correctly. Have you checked your computer date? |
|
08-22-2010, 10:26 AM | #3 |
Junior Member
Posts: 7
Karma: 10
Join Date: Aug 2010
Device: iPhone
|
Looking further into the problem, I have a lot of books which have a date set to before the date I even installed the Calibre program! And checking the physical file's creation, modified and accessed dates doesn't shed any light on the problem either.
However, I've just added about 400 books today, and they are all showing the correct date. And, yes, my system date is correct. DG |
08-22-2010, 10:49 AM | #4 |
Wizard
Posts: 4,552
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
|
If a date is set in the book's metadata then that value is used. Failing that today's date is used.
|
08-22-2010, 11:04 AM | #5 |
Junior Member
Posts: 7
Karma: 10
Join Date: Aug 2010
Device: iPhone
|
|
08-22-2010, 12:25 PM | #6 | |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Quote:
When Calibre saves a book out, that field is updated with whatever date is in the database. (assuming you have metadata updating turned on) As to what it means - I'd have to look it up in the EPUB definition, but for me it means "date added to Calibre." I always leave "Get metadata only from filename" turned on unless I am re-adding a book I've saved out, which has my "date added to Calibre" in that field. Last edited by Starson17; 08-22-2010 at 03:10 PM. |
|
08-22-2010, 01:41 PM | #7 |
Well trained by Cats
Posts: 29,792
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
|
08-22-2010, 02:41 PM | #8 |
Junior Member
Posts: 7
Karma: 10
Join Date: Aug 2010
Device: iPhone
|
Many thanks for the answers - that makes it all a lot clearer :-)
And as an aside, Calibe is an awesome bit of software! Regards DG |
08-22-2010, 02:59 PM | #9 |
ZCD BombShel
Posts: 4,793
Karma: 8293322
Join Date: Jan 2009
Location: The Frozen North (aka Illinois, USA)
Device: iPad, STB Kindle Oasis
|
I too am using that to show "what date I added the book to Calibre" but I had already caught it shifting that date on some things, so I've changed it back to the current date on those files. Thanks for explanation, itimpi, I didn't know why it was doing it, either. I have my columns as Title, Author, Series, Read?, Published (the date the book was published) and Date (date I added it to Calibre). Sometimes you have to watch that last one, but I do like having it like that.
|
08-22-2010, 03:09 PM | #10 | |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Quote:
There are two places you might think it "shifted" - in book metadata and in the Calibre database. Which one did you think was changed? (and if you know the answer - how did it get changed?) |
|
08-22-2010, 03:19 PM | #11 |
ZCD BombShel
Posts: 4,793
Karma: 8293322
Join Date: Jan 2009
Location: The Frozen North (aka Illinois, USA)
Device: iPad, STB Kindle Oasis
|
Starson I have no idea. I'd be merrily adding books, adding Series informatiion to the metadata window, and look at that field, and the date would be something completely off, as Dobra said. Unlike the behavior of the "Published" field, where I had to go into the "tweaks" file to let it let me change the date inputted by the metadata, this one just let me change it to the current date. I have a suspicion that itimpi is right, that in some books that date is set in the metadata.
|
08-22-2010, 05:41 PM | #12 |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
It is set in the metadata in formats that have metadata, but what does that have to do with it? It works like any other bit of metadata. I just don't understand how it could shift on you.
|
08-22-2010, 07:19 PM | #13 |
ZCD BombShel
Posts: 4,793
Karma: 8293322
Join Date: Jan 2009
Location: The Frozen North (aka Illinois, USA)
Device: iPad, STB Kindle Oasis
|
Ah! I think I understand the confusion here. It doesn't "shift" while I'm watching it, sometimes instead of the current (today's) date, it comes up with something totally different, for example one I got was "14 Feb 2003". I am assuming somehow that date was in the metadata. As I said, no biggie, it's only happened about six times and it's easy enough to change it.
|
08-22-2010, 08:35 PM | #14 | |
US Navy, Retired
Posts: 9,864
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
Quote:
It is non-intuitive for that date field to be part of the metadata (I know it is) the published date or created date are intuitive concepts but this is just some random date that doesn't seem tied to anything. I too thought that date column meant date added to the library, but every now and then it has a mind all it's own (because the date was set previously by another and entered in metadata). |
|
08-22-2010, 09:50 PM | #15 | |
ZCD BombShel
Posts: 4,793
Karma: 8293322
Join Date: Jan 2009
Location: The Frozen North (aka Illinois, USA)
Device: iPad, STB Kindle Oasis
|
Quote:
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bug or Feature? | capidamonte | Calibre | 5 | 07-27-2010 03:06 PM |
Bug/feature tracking mechanism? | CoolDragon | iRex | 8 | 06-08-2010 12:05 PM |
Feature Request at the import-function | ralphffm44 | Calibre | 4 | 04-02-2010 01:14 PM |
Bug with the date in subscription titles | copernicc | Calibre | 4 | 03-05-2009 01:22 PM |