Pocket Book Sync Koreader book progress with library

[jrw174]

Originally Posted by EastEriq

yes thanks, with cd /mnt/ext1/applications now it works as .app as well. I have still to understand though under what refresh conditions the librarian shows the updated percentage - if just after changing view a number of times or after a device reboot. I'll keep experimenting a bit.
On a side note: I would have written the log file in /tmp/, so not to clutter the application directory.
Compliments for the work, in any event!

It seems the book percentage updates after the script. How is a good question. My guess would be a script that detects changes to the database and does an inkview refresh of sorts. There are no triggers in the explorer3.db so it must be an external script.

Good idea moving the log file. Will do

[EastEriq]

Good chances are that with an initial `cd /tmp` one would neither need `cd /mnt/ext1/applications` nor an absolute path for the logfile, and with an absolute path of the logfile one would not need the initial cd. Mainly a matter of taste I'd say (and perhaps, of having the logfile survive a reboot in case you fear that the script may crash the device or something the like).

[EastEriq]

Some minor changes:

• use variables for pathnames to database files and logfile, for readability
• TRIM() the title of the book. I did run into a pathological case of an epub generated from Wikisource, whose title had a trailing space. That was causing it not to be found in the Pocketbook database.

[the_Pan]

Indeed, a very useful add-on!

[ckdot]

Hey jrw174,

thanks for your effort!

I've found out that page_stat_data doesn't necessarly get updated once book.last_open get's updated. So there's a change that the total pages get mixed up.

I hope you don't mind that I've created a github repository with your app. This makes changes easier to track:
https://github.com/ckilb/koreader-po...sync/tree/main

I've fixed the issue I've mentioned by adding the book ID to the query that reads out the total number of pages. Also, I've simplified the queries a bit:
https://github.com/ckilb/koreader-po...1a437059515821

One question: As the log file path got changed to /tmp, how to read the log file now? If the device is attached to my computer I can't access /tmp.

[ckdot]

Me again...
I just implemented a KOReader plugin that will use the script to automatically update the reading progress.
The plugin executes the script with every page turn. KOReader isn't updating page_stat_data with every page turn so it's not perfect yet.

If you know when exactly KOReader updates that table I might trigger that event in the plugin each time. I couldn't dig in too deep yet.

[ckdot]

OK, I couldn't resist and digged deeper. (Is this already spamming?)

I found a way to trigger the logic that saves page stats. But the function implementing this only performs a database insert if the duration is > 0. I don't know how exactly the duration is measured, in the end it doesn't matter: Because of this we basically know that we can't rely on the page_stat_data always being up to date.

That's the bad news.

The good news is that it's actually super easy to get the current page number inside KOReader with each page turn. This is faster (because no database operations on page_data_stats are required) and more reliable.

The only thing I had to do is to change the script to get the page namber as an command line argument instead of fetching it from the database.
Because the script isn't meant to be executed as a stand-alone I moved it to a different location and changed the extension.

I've pushed the latest changed. Feel free to test & give me some feedback. For me it works quite well now.

[the_Pan]

@ckdot
your new version works well for me, thank you!

[conquerli]

@ckdot

You did a great job!

My Pocket Book is Android OS (PB742). I've installed Koreader which version is koreader-android-arm-v2023.06.1. Can you make the plugin working on this device?

Thanks.

[conquerli]

Originally Posted by conquerli

@ckdot

You did a great job!

My Pocket Book is Android OS (PB742). I've installed Koreader which version is koreader-android-arm-v2023.06.1. Can you make the plugin working on this device?

Thanks.

@jrw174，Thanks a lot for your tools.

[neil_swann80]

Nice one @ckdot, works nicely

[iupiter]

is there a way to auto update the plugin or do you have to manually update it with your computer?

[reuerendo]

Hi. If an epub book contains non-linear fragments and the “hide non-linear fragments” option is enabled in the koreader, then the book is not marked as readed at the end

[liskin]

Originally Posted by reuerendo

Hi. If an epub book contains non-linear fragments and the “hide non-linear fragments” option is enabled in the koreader, then the book is not marked as readed at the end

I implemented a fix for this in my fork of the plugin: https://github.com/liskin/koreader-p...48a9ae7a70fd7b
Can you test this please?
https://github.com/liskin/koreader-p...ae7a70fd7b.zip is the version with all my fixes.

[reuerendo]

Thank you. The book is marked as read in the library, but on the home page the progress bar does not reach 100%