Blank "Average pages per minute"

[stp]

Hi,

This is not really a major issue, just curious if somebody knows the reason behind it.

In the "Activity" tab, the field that shows "Average pages per minute" is always blank for all the books I read/open (like in this image, not mine, just to illustrate what I mean).

All my books are converted to kepub using kepubify.

I have a Kobo Clara BW set up with side load mode enabled, plus I added this trigger to the KoboReader.sqlite database out of privacy concerns:

DROP INDEX IF EXISTS analytics_events_timestamp;
 
CREATE TRIGGER IF NOT EXISTS delete_analytics
after INSERT ON AnalyticsEvents BEGIN
  DELETE FROM AnalyticsEvents;
END;

I wonder if that statistic is derived from data that this trigger removes. I guess I can do the test myself by removing the trigger, but I wanted to see if any of you have a clue first.

Cheers!

[stp]

Sorry, the link to the image seems to be shorten by the forum for some odd reason.

It is the image on this message on reddit.

[DNSB]

Originally Posted by stp

Sorry, the link to the image seems to be shorten by the forum for some odd reason.

It is the image on this message on reddit.

Generally speaking, it's better to use the Paperclip tool or the Manage Attachments buttons to save images to Mobileread.

[stp]

Thanks for the tip DNSB

The picture I refer to is that of the white Kobo Glo in your attachments.

Let me add that I have set up another Kobo Clara BW for a friend in the same way as mine: side load mode enabled, trigger to delete entries into the AnalyticsEvents table, and "fake" entry into the User table too, just to avoid creating a Kobo account / getting rid of the "Discover" tab.

INSERT OR REPLACE INTO USER
  (UserID, UserKey)
VALUES
  ('-', '-');

It is strange that all other metrics are updated correctly (hours of reading, average minutes per session, total hours of reading...) but not average pages per minute

[rashkae]

I can confirm that average pages per minute does not update when reading sideloaded kepub for a very long time, (if it ever worked, I am not sure.). You will see this in sideloaded mode, (or with a blank registration,) and has nothing to do with your trigger.

Edit: The Kobo awards, for example, have never worked with sideloaded kepub that are not synced.

[stp]

Thanks rashkae!

If I understood correctly, in order to have the "Average pages per minute" updated one has to either (or both?):

• Disable side load mode.
• Create an account.

Then transfer epubs/kepubs/pdfs/etc as usual using Calibre/drag & drop.

Finally, not that I care about the Kobo awards, but what do you mean by "kepub that are not synced"? Synced to a Kobo account?

Cheers!

[JSWolf]

Originally Posted by stp

Thanks rashkae!

If I understood correctly, in order to have the "Average pages per minute" updated one has to either (or both?):

• Disable side load mode.
• Create an account.

Then transfer epubs/kepubs/pdfs/etc as usual using Calibre/drag & drop.

Finally, not that I care about the Kobo awards, but what do you mean by "kepub that are not synced"? Synced to a Kobo account?

Cheers!

Why would you not have an account? There's is no reason at all not to have an account.

[rashkae]

Originally Posted by stp

Finally, not that I care about the Kobo awards, but what do you mean by "kepub that are not synced"? Synced to a Kobo account?

Cheers!

The Awards and average page count, (by extension, very accurate estimated time to read) used to work when I was reading Epub files. At some time, after I switched to Kepub, I noticed those features were no longer working. I have not gone back to figure out if it was always broken, or the result of me switching to Kepub.

I *assume* these features work when reading books purchased (and synced) from Kobo store.

[stp]

@JSWolf, it is just personal preference and one of the reasons why I bought a Kobo, because I could use it without an account

@rashkae, alright then! I will report back if I have time to look more closely into this. I think I will try to test epubs and/or PDFs to check if it works with these formats. Thanks again for the feedback!

[DNSB]

The stats seem to show for sideloaded epubs and kepubs synced from Kobo for the last 6 books I read. I seldom generate kepubs locally unless the book has images that I would want to be able to zoom.

[JSWolf]

Originally Posted by stp

@JSWolf, it is just personal preference and one of the reasons why I bought a Kobo, because I could use it without an account

@rashkae, alright then! I will report back if I have time to look more closely into this. I think I will try to test epubs and/or PDFs to check if it works with these formats. Thanks again for the feedback!

If you try to hack the database and not have an account, eventually you will lose everything as some firmware update will cause your Kobo to wipe itself. This has happened at least 2 time in the past.