PocketBook get read information into calibre

Skeeve · 04-12-2017, 06:32 AM

Hi,

I know how PocketBook stores the read information.

Now I'd like to get that information out and store it automatically in calibre's (custom) read column.

Can someone please give me a hint where I can get all the information I require to enhance / create a plugin which can do this?

kovidgoyal · 04-12-2017, 06:58 AM

Take a look at the annotations plugin for an example of getting device based data into calibre

davidfor · 04-12-2017, 08:09 AM

You can also look at my Kobo Utilities. It can do this for the Kobo devices.

But, the real question is how the status is stored on the device. Is it in an accessible database?

Skeeve · 04-12-2017, 08:19 AM

Quote:

Originally Posted by davidfor

But, the real question is how the status is stored on the device. Is it in an accessible database?

Yes. It is an accessible SQLite DB.

Query is

Code:

select
    title,
    strftime('%Y-%m-%d', datetime(opentime, 'unixepoch')) AS FINISHED
from
    books_impl
join
    books_settings
on
    id=bookid
where
    completed = 1
order by 2 desc

Filename is <mountpoint>/system/explorer-3/explorer-3.db

davidfor · 04-12-2017, 08:59 AM

OK. Now the problem is to match the book in the database with that in the library. The KoboTouch driver does this during the connection, so fetching extra information in a plugin like this is easy. If there is a reference in the database to the book file, that should be usable. Otherwise, you have to ask to match the books when you retrieve the status. The Annotations plugin works that way for the Kindle devices.

If you want to look at the Kobo Utilities plugin, the starting method is store_current_bookmark in action.py. That does the fetch for the currently selected books. It generates the ids to search the device database. Then calls _store_current_bookmark which reads the database and updates the calibre library. There is also a batch mechanism so that the fetch runs in the background and can be triggered when the device is connected.

To use this, you would need to:
- Modify the device detection.
- Change the database id generation in store_current_bookmark
- Replace the database fetch in _store_current_bookmark

There is some clumsy code in there, but most of what you need is in there.

Skeeve · 04-13-2017, 04:08 AM

Thanks for your replies. I think I'll look into it over easter.

chris! · 01-05-2018, 04:27 AM

Did you find a solution regarding calibre and the read information?

04-12-2017, 06:32 AM	#1
Skeeve Zealot Posts: 142 Karma: 669192 Join Date: Nov 2013 Device: Kindle 4.1.1 no touch	PocketBook get read information into calibre Hi, I know how PocketBook stores the read information. Now I'd like to get that information out and store it automatically in calibre's (custom) read column. Can someone please give me a hint where I can get all the information I require to enhance / create a plugin which can do this?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CC Beta FAQ: Syncing Read information with calibre	chaley	Calibre Companion	0	02-27-2014 05:37 AM
Can not start recoll from calibre /opt/calibre/lib/libz.so.1: no version information	Satas	Development	5	04-19-2013 11:22 PM
Please help with Calibre Series Information	coaver	Calibre	4	01-14-2011 02:01 PM
IQ Any information about Pocketbook IQ?	katzki	PocketBook	99	01-14-2011 08:22 AM
Way to add additional information with Calibre?	MidknytOwl	Sony Reader	5	09-11-2009 01:53 PM

04-12-2017, 06:58 AM	#2
kovidgoyal creator of calibre Posts: 45,604 Karma: 28548974 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Take a look at the annotations plugin for an example of getting device based data into calibre

04-12-2017, 08:09 AM	#3
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	You can also look at my Kobo Utilities. It can do this for the Kobo devices. But, the real question is how the status is stored on the device. Is it in an accessible database?

04-12-2017, 08:59 AM	#5
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	OK. Now the problem is to match the book in the database with that in the library. The KoboTouch driver does this during the connection, so fetching extra information in a plugin like this is easy. If there is a reference in the database to the book file, that should be usable. Otherwise, you have to ask to match the books when you retrieve the status. The Annotations plugin works that way for the Kindle devices. If you want to look at the Kobo Utilities plugin, the starting method is store_current_bookmark in action.py. That does the fetch for the currently selected books. It generates the ids to search the device database. Then calls _store_current_bookmark which reads the database and updates the calibre library. There is also a batch mechanism so that the fetch runs in the background and can be triggered when the device is connected. To use this, you would need to: - Modify the device detection. - Change the database id generation in store_current_bookmark - Replace the database fetch in _store_current_bookmark There is some clumsy code in there, but most of what you need is in there.

04-13-2017, 04:08 AM	#6
Skeeve Zealot Posts: 142 Karma: 669192 Join Date: Nov 2013 Device: Kindle 4.1.1 no touch	Thanks for your replies. I think I'll look into it over easter.

01-05-2018, 04:27 AM	#7
chris! Junior Member Posts: 1 Karma: 10 Join Date: Jan 2018 Device: Pocketbook Touch HD	Did you find a solution regarding calibre and the read information?