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 12-19-2010, 09:02 PM   #1
joegearhart
Junior Member
joegearhart began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Dec 2010
Device: Kindle 3 WiFi
Can't clear "custom" date field?

I'm setting up Calibre to work with the Kindle that I'm giving my wife on Christmas.

I wanted to create a custom date field called "Date Read", and did so with no problems.

Well, then I wanted to set up some custom searches related to that. To do so, I had to put in some dummy dates on a few books so that I could make sure the searches operated as expected.

#dateread:<2010
#dateread:<2010-05
#dateread:false
#dateread:true

These all worked PERFECTLY!

But now that I want to clear the date fields, I can't find a way to do so! I can only edit the "date read" field. I can't clear it out again.

I have tried deleting the value, right clicking and selecting "cut", I've gone to "Edit Metadata" > "Edit Metadata Individually" > "Custom Metadata" and tried to delete it there but just can't do it.

Is this a bug or am I missing something very simple?
joegearhart is offline   Reply With Quote
Old 12-19-2010, 09:26 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: 15,269
Karma: 6022733
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by joegearhart View Post
I'm setting up Calibre to work with the Kindle that I'm giving my wife on Christmas.

I wanted to create a custom date field called "Date Read", and did so with no problems.

Well, then I wanted to set up some custom searches related to that. To do so, I had to put in some dummy dates on a few books so that I could make sure the searches operated as expected.

#dateread:<2010
#dateread:<2010-05
#dateread:false
#dateread:true

These all worked PERFECTLY!

But now that I want to clear the date fields, I can't find a way to do so! I can only edit the "date read" field. I can't clear it out again.

I have tried deleting the value, right clicking and selecting "cut", I've gone to "Edit Metadata" > "Edit Metadata Individually" > "Custom Metadata" and tried to delete it there but just can't do it.

Is this a bug or am I missing something very simple?
Set a date with the year 0000
I also think 0101, but that might have changed
theducks is offline   Reply With Quote
Old 12-19-2010, 09:34 PM   #3
joegearhart
Junior Member
joegearhart began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Dec 2010
Device: Kindle 3 WiFi
Winner!!

I am amazed at how robust Calibre is. I've been playing with tweaks and stuff ALL day to make this as simple for the wife as possible.

Thanks theducks!
joegearhart is offline   Reply With Quote
Old 12-19-2010, 10:47 PM   #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,230
Karma: 1345754
Join Date: Oct 2010
Location: London, UK
Device: Kindle Paperwhite 3G, iPad 3, iPad Air
Quote:
Originally Posted by theducks View Post
Set a date with the year 0000
I also think 0101, but that might have changed
Oooh, now that is a cool trick, thx.

Next question related to this would be could someone point to the place(s) in the source code (since I haven't found it as an option) whereby we could set the publication date column to this when it is unknown? I'm not a fan of it setting the publication date to "today" for every new book - I would much rather it was set to "0000" and only set when an actual date is available in the metadata or you manually type one...
kiwidude is offline   Reply With Quote
Old 12-20-2010, 01:04 AM   #5
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: 15,269
Karma: 6022733
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by kiwidude View Post
Oooh, now that is a cool trick, thx.

Next question related to this would be could someone point to the place(s) in the source code (since I haven't found it as an option) whereby we could set the publication date column to this when it is unknown? I'm not a fan of it setting the publication date to "today" for every new book - I would much rather it was set to "0000" and only set when an actual date is available in the metadata or you manually type one...
Date is the day you create the Record
Publication_Date is from the Internal Meta-data (or Downloaded)

You might be able to use "Edit_Meta-data in Bulk" to set this (if you must)
BTW The date is probably set by a Trigger or defaults if not set in the DB

Last edited by theducks; 12-20-2010 at 01:07 AM.
theducks is offline   Reply With Quote
Old 12-20-2010, 04:32 AM   #6
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,909
Karma: 1217216
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by kiwidude View Post
Next question related to this would be could someone point to the place(s) in the source code (since I haven't found it as an option) whereby we could set the publication date column to this when it is unknown? I'm not a fan of it setting the publication date to "today" for every new book - I would much rather it was set to "0000" and only set when an actual date is available in the metadata or you manually type one...
One instance (I think the only one) is in database2 in add_books, line 2363. Leave the pubdate as None.

Note that programatically you reset the pubdate by setting it to None. If you need to manipulate a None date (e.g., for sorting), use utils.date.UNDEFINED_DATE.
chaley 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
Bug? "Insert metadata as page at start of book" doesnt encode Comments field properly rollercoaster Calibre 2 04-24-2010 11:40 PM
PRS-600 THE HORROR!!! - My 600 shipping date has been "rescheduled" jupstin Sony Reader 14 03-06-2010 02:57 PM
Rebuild "author sort" field enriquep Calibre 2 07-24-2009 12:21 PM
SONY PRS-700 "Date and Time" problems dda Sony Reader 8 06-11-2009 02:13 PM
Custom boot logo, "freezing" the screen guylhem Sony Reader Dev Corner 1 11-09-2008 12:45 PM


All times are GMT -4. The time now is 04:37 PM.


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