03-20-2014, 08:44 PM | #1 |
Grand Sorcerer
Posts: 12,882
Karma: 35535698
Join Date: Nov 2010
Location: USA
Device: Nexus 7 2, Samsung Galaxy Tab A 8" (retired=Sony PRS650, Kobo Mini)
|
Creating Custom Column for Read and Date Read
I would like to use the new feature in Calibre Companion to sync the Read (yes/no) and Date Read with Calibre. But I do not have these custom columns in Calibre.
I have a customn date column in one of my Calibre libraries for date archived. So if I have two date custom columns how do I ensure CC syncs to the correct one? I know this is a basic question I should probably know the answer to, but... What do I use for Lookup Name, Column Heading, and and Column Type when I create these new custom columns to ensure they will sync with CC? Any help would be greatly appreciated. |
03-20-2014, 08:56 PM | #2 |
Member
Posts: 18
Karma: 12494
Join Date: Apr 2013
Device: Nexus 7, Kindle
|
OOOO! I totally know this one. (and you all thought I only came to bug you with problems)
To create a Read column, you want the lookup name to be something like #read, the heading to be Read, and the type to be yes/no. That last part is very important. For date read you would use #dateread for lookup, Date Read for the heading, and the type to be date. Then you go into settings on the CC app. Scroll down to Marking Books Read. This is where you tell CC which column to sync the info to. Don't forget to tell it to update the date read when read. The value for Sync Column for Read would be #read and the value for Sync column for Date Read would be #dateread if you use the names I used above. Edit: Obviously the names can vary just make sure that the sync columns have the right lookup names. The ones above are what I use. Last edited by LadyKoori; 03-20-2014 at 08:59 PM. Reason: clarification |
Advert | |
|
03-20-2014, 09:04 PM | #3 |
Grand Sorcerer
Posts: 12,882
Karma: 35535698
Join Date: Nov 2010
Location: USA
Device: Nexus 7 2, Samsung Galaxy Tab A 8" (retired=Sony PRS650, Kobo Mini)
|
Thanks!
ETA: One other quick question. Do I need to mark all the unread books with "no" in the Read column or will it treat blank as "no" (or at least not "yes")? Never mind I figured out to mark them yes and no using bulk reconvert. Last edited by library addict; 03-20-2014 at 09:52 PM. |
03-21-2014, 12:48 AM | #4 | |
Ex-Helpdesk Junkie
Posts: 19,422
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
|
Quote:
Anyway, each of the three options (yes/no/empty) will appear as an option to search by in the grouping drawer under "Read". What each of those mean is really up to you. See here (in the Calibre Companion FAQ): https://www.mobileread.com/forums/sho...3&postcount=43 So you can use "yes" to mean have-read, and "no"/"empty" to mean have-not-read. Or whatever else you want. Last edited by eschwartz; 03-21-2014 at 12:51 AM. |
|
03-21-2014, 03:27 AM | #5 |
Grand Sorcerer
Posts: 11,740
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
@library addict: given that you had questions and that now you have gone through this, could you take a look at the CC FAQ about Read info and tell me how it *didn't* answer you questions? Scroll down until you see "Marking books read and syncing that information with calibre". Now is the time for us to get this right, saving people confusion and frustration.
@LadyKoori: @eschwartz: my preference is Yes for read and empty for not-read because it is visually cleaner both in CC and calibre. I don't (yet) have a real use for No, but might use it as a priority not-read (next to be read). |
Advert | |
|
03-21-2014, 10:37 AM | #6 |
Well trained by Cats
Posts: 29,799
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
@chaley
No is reserved for books I (this is my read list) have no intention of completing. I do not discard books, someone else may want to take a peek at it Also I paid $ for it). A NO makes the data set complete, no repurchasing a missing title. |
03-21-2014, 03:45 PM | #7 | |
Grand Sorcerer
Posts: 12,882
Karma: 35535698
Join Date: Nov 2010
Location: USA
Device: Nexus 7 2, Samsung Galaxy Tab A 8" (retired=Sony PRS650, Kobo Mini)
|
Oops. Yes, Edit metadata in bulk is what I meant.
Quote:
|
|
03-21-2014, 05:10 PM | #8 |
Grand Sorcerer
Posts: 6,233
Karma: 11768331
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
If you don't mind I steal the thread I have a question, related to CC although it's really a Calibre question: Is there any way to create a CALCULATED yes/no column so I can sync it with CC?
|
03-22-2014, 02:51 AM | #9 | |
Grand Sorcerer
Posts: 11,740
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
You can have CC group on a composite column if you wish, which may satisfy your needs. In CC's settings, add its lookup name to the list of columns to group by. The column will appear in the grouping drawer. The values you see are those that were in effect the last time you transferred metadata (connected as a wireless device). |
|
03-22-2014, 03:20 AM | #10 |
Grand Sorcerer
Posts: 6,233
Karma: 11768331
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
Thank you, I supposed it but I wanted to confirm it. I will configure it now (and try to check why read date is not being sent).
|
03-22-2014, 03:48 AM | #11 |
Grand Sorcerer
Posts: 11,740
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Watch your device when you connect. When you connect, CC will pop up a message for a few seconds if the lookup name you are trying to sync is not in your library or is the wrong type, or if there is a problem with the version of calibre you are running.
|
03-22-2014, 05:33 AM | #12 |
Grand Sorcerer
Posts: 6,233
Karma: 11768331
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
Yes, I've seen it (a lot till I selected the right column ), and I've discovered MY mistake with the read date column, it works now like a charm, thank you very much.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calibre: Read Filename into Custom Column | juston | Library Management | 3 | 07-25-2019 12:34 AM |
Custom Read Status Column | PapaJohn | Devices | 23 | 05-22-2015 04:57 AM |
custom date column from two state column | Dopedangel | Library Management | 7 | 01-03-2012 08:20 AM |
Custom column read ? | pchrist7 | Calibre | 2 | 10-04-2010 02:52 AM |