Thread: Using OnDevice to set the value of a custom column
View Single Post
Old 10-23-2011, 04:25 PM   #3
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: 31,083
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by WendyR14 View Post
I wonder if anyone could give me some help. I've just begun to explore customising Calibre and I'm finding it tricky; I spotted a throw away comment in a thread (sorry can't find it now) where the poster said breezily that they used a custom column to record which books are loaded onto their Kindle so that they know what's what even when the device isn't connected.

Just what I want I thought.

I found this post https://www.mobileread.com/forums/sho...03&postcount=6 and that of course work well to do it manually. But I feel sure that I should be able to set it automatically using the ondevice() funtion explained in the user manual and mentioned here https://www.mobileread.com/forums/sho...6&postcount=15

I guess I need a composite column but does it need to behave like a tag or not; or does it not matter? I presume I need to put the expression into the template box - but what exactly do I need to type into there?

Ideally I should like my new column to be updated when I connect my device so that if I delete things from the kindle itself the value of the column reflects that, and of course the value needs to persist after I unplug the device.
You are making way too much out of it

Make a True/False column (mydevice) in the Library if one does not exist.
Connect your device and wait for the device task to finish.

Stage 1) un-mark previous saved status for missing/removed from device books.
Enter this search:
Code:
ondevice:false and formats:true
(change true to a specific format if that is what you choose) and press Enter

1) Clear previous values if it was previously used by Selecting All (ctrl+A).
Bulk Meta-data edit: Custom metadata tab: set mydevice to No
OK

Stage 2) Mark those found on the device.
Set the search:
Code:
ondevice:true
2) Set values for on device books Selecting All (ctrl+A).
Bulk Meta-data edit: Custom metadata tab: set mydevice to Yes
OK


you have now saved your current status
theducks is offline   Reply With Quote