See "on device" when not connected

Keltari · 08-23-2011, 03:21 AM

Is there a way to enable to column "on device" even when the device is not connected? Ive been doing a lot of library management lately and moving books to my Kobo. There are times when I just want to look at the database and see that a particular book was transferred.

My guess is that the state of the device is not stored, however this wouldnt be a hard thing to implement. A few new fields in the database.

Sweetpea · 08-23-2011, 04:06 AM

It is only stored on the device itself. A new field in the database wouldn't be handy. What if you have multiple devices? Which would you store in the DB?

I made a custom column: "updated", which I change to "Yes", when I add a book, or update a book. And once it's transferred to my various devices, I'll turn it back to "No".

HarryT · 08-23-2011, 04:16 AM

Yes, as Sweetpea says, the issue would be those people who use multiple devices. You'd need to store an "on-device" status separately for each device, and that could be complex.

DoctorOhh · 08-23-2011, 06:01 AM

Quote:

Originally Posted by Keltari

My guess is that the state of the device is not stored, however this wouldnt be a hard thing to implement. A few new fields in the database.

You are correct the state of the device is not stored. Kovid has given you the tools to implement this yourself with custom columns. Create a custom column connect the device, highlight all On Device books then use the edit metadata window to fill in the custom column with On Device and your good to go.

Keltari · 08-23-2011, 12:23 PM

I guess Ill just do it myself. Its trivial if you have one device. For multiple devices it should be simple. I guess the only question is whether or not there is a simple way to uniquely identify the device.

theducks · 08-23-2011, 01:52 PM

Quote:

Originally Posted by Keltari

I guess Ill just do it myself. Its trivial if you have one device. For multiple devices it should be simple. I guess the only question is whether or not there is a simple way to uniquely identify the device.

Use a Tag type column.
search: ondevice:true, select all
Bulk metadata edit: add (your tag field) <device name>
End edit
search: ondevice:false and formats:true
select all
Bulk metadata edit: Remove (your tag field) <device name>
End edit

PeterT · 08-23-2011, 04:25 PM

Could you create a custom list using Kiwidude's "Reading List" plugin that would keep track of what books are on the device?

Keltari · 08-23-2011, 05:20 PM

Can you suggest a good GUI for looking at modifying the database? I havent used sqllite before.

PeterT · 08-23-2011, 07:46 PM

I'm not at all sure you even want to look at modifying the database OUTSIDE of Calibre!

Discussions on custom columns are related to columns made within the Calibre preferences; not via an external GUI.

08-23-2011, 03:21 AM	#1
Keltari Junior Member Posts: 7 Karma: 10 Join Date: Aug 2011 Device: Kobo	See "on device" when not connected Is there a way to enable to column "on device" even when the device is not connected? Ive been doing a lot of library management lately and moving books to my Kobo. There are times when I just want to look at the database and see that a particular book was transferred. My guess is that the state of the device is not stored, however this wouldnt be a hard thing to implement. A few new fields in the database.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Touch Kobo touch frozen on "connected and charging" screen	EricLandes	Kobo Reader	18	01-07-2013 01:57 AM
Touch Horizontal white streaky lines - on "Connected and Charging" screen	beautifulsoup	Kobo Reader	0	07-27-2011 06:47 PM
SONY pocket edition: "Device locked" + "charge battery" obstacles?	hermes	Devices	3	06-02-2011 03:32 AM
No data in "In Library" and "On Device" columns after upgrade	ily426	Library Management	8	04-03-2011 02:53 PM
ATT: Nearly 900K "Connected Devices" Activated (Kindle, Nook)	kjk	News	2	07-23-2010 11:11 AM

08-23-2011, 04:06 AM	#2
Sweetpea Grand Sorcerer Posts: 9,707 Karma: 32763414 Join Date: Dec 2008 Location: Krewerd Device: Pocketbook Inkpad 4 Color; Samsung Galaxy Tab S6	It is only stored on the device itself. A new field in the database wouldn't be handy. What if you have multiple devices? Which would you store in the DB? I made a custom column: "updated", which I change to "Yes", when I add a book, or update a book. And once it's transferred to my various devices, I'll turn it back to "No".

08-23-2011, 04:16 AM	#3
HarryT eBook Enthusiast Posts: 85,544 Karma: 93383099 Join Date: Nov 2006 Location: UK Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6	Yes, as Sweetpea says, the issue would be those people who use multiple devices. You'd need to store an "on-device" status separately for each device, and that could be complex.

08-23-2011, 12:23 PM	#5
Keltari Junior Member Posts: 7 Karma: 10 Join Date: Aug 2011 Device: Kobo	I guess Ill just do it myself. Its trivial if you have one device. For multiple devices it should be simple. I guess the only question is whether or not there is a simple way to uniquely identify the device.

08-23-2011, 04:25 PM	#7
PeterT Grand Sorcerer Posts: 13,292 Karma: 78876004 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	Could you create a custom list using Kiwidude's "Reading List" plugin that would keep track of what books are on the device?

08-23-2011, 05:20 PM	#8
Keltari Junior Member Posts: 7 Karma: 10 Join Date: Aug 2011 Device: Kobo	Can you suggest a good GUI for looking at modifying the database? I havent used sqllite before.

08-23-2011, 07:46 PM	#9
PeterT Grand Sorcerer Posts: 13,292 Karma: 78876004 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	I'm not at all sure you even want to look at modifying the database OUTSIDE of Calibre! Discussions on custom columns are related to columns made within the Calibre preferences; not via an external GUI.

Advert

Advert