Aura H2O Backup of reading stats

Buhaj47 · 02-15-2015, 07:42 AM

How can I make a backup of my reading statistics (and annotations) in case I need to do factory reset or sign out of Kobo account?

davidfor · 02-15-2015, 08:16 AM

This has been discussed before and it can be done, but there is no automatic method. The last discussion was here with a suggestion. A search should find the older discussions but I don't remember them being any different.

xPrzybyLx · 02-16-2015, 03:29 AM

I just lost my Reading Stats and I want to manually enter Total Hours of reading...

What eventType is this ?

davidfor · 02-16-2015, 05:08 AM

The event type is 5, but it isn't as easy as that. The ExtraData column needs to be filled with valid data and so does the Checksum. I don't know how to fill these in.

xPrzybyLx · 02-16-2015, 11:12 AM

I have Kobo Aura HD and in KoboReader.sqlite in Event table I do not have any
EventType=5 there are other like: 0,1,3,36,,46,79 etc... I currently have 0,3h of total read (
that is what Kobo shows ) but I can't locate it in the DB ...

Also if I change some value in the Events how to recalculate checksum ?

davidfor · 02-16-2015, 05:58 PM

EventType=5 rows are added when you finish a book. As there is one for each book you finish, if you haven't finished one since you lost the stats, there won't be one

But, its a good point about the reading time. It has to be in one of the other events. It might be 3 as that is start a book and from memory the ExtraData looks like a series of timestamps. But there is another pair of events that are open and close a book, they might have the times. Or it might be in a singleton event that has the cumulative details. I have a list of events that I know about at home, and I've posted it in the past, but can't find it. I don't remember one I would have thought held the total time.

As to the checksum, I don't know how to calculate it. I've never really looked into it as I don't even know which columns in the table the checksum is over.

02-15-2015, 07:42 AM	#1
Buhaj47 Zealot Posts: 147 Karma: 278068 Join Date: Dec 2014 Location: Poland Device: Kindle PW3, Kobo Libra 2	Backup of reading stats How can I make a backup of my reading statistics (and annotations) in case I need to do factory reset or sign out of Kobo account?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Touch Backup reading stats and annotations	tivatranquio	Kobo Reader	3	09-22-2014 06:51 PM
Aura Is it possible to backup Reading Stats?	anesthezea	Kobo Reader	5	08-12-2014 09:31 PM
Glo Reading Life Reading Stats inaccuracy	Uschiekid	Kobo Reader	18	02-08-2014 08:57 PM
Glo How to access Reading Menu Stats reading sideloaded epubs	cinetici	Kobo Reader	23	05-27-2013 07:43 AM
Reading stats	Mear	Sony Reader	0	02-26-2012 07:53 PM

02-15-2015, 08:16 AM	#2
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	This has been discussed before and it can be done, but there is no automatic method. The last discussion was here with a suggestion. A search should find the older discussions but I don't remember them being any different.

02-16-2015, 03:29 AM	#3
xPrzybyLx Junior Member Posts: 9 Karma: 10 Join Date: Feb 2015 Device: Kobo Aura HD	I just lost my Reading Stats and I want to manually enter Total Hours of reading... What eventType is this ?

02-16-2015, 05:08 AM	#4
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	The event type is 5, but it isn't as easy as that. The ExtraData column needs to be filled with valid data and so does the Checksum. I don't know how to fill these in.

02-16-2015, 11:12 AM	#5
xPrzybyLx Junior Member Posts: 9 Karma: 10 Join Date: Feb 2015 Device: Kobo Aura HD	I have Kobo Aura HD and in KoboReader.sqlite in Event table I do not have any EventType=5 there are other like: 0,1,3,36,,46,79 etc... I currently have 0,3h of total read ( that is what Kobo shows ) but I can't locate it in the DB ... Also if I change some value in the Events how to recalculate checksum ?

02-16-2015, 05:58 PM	#6
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	EventType=5 rows are added when you finish a book. As there is one for each book you finish, if you haven't finished one since you lost the stats, there won't be one But, its a good point about the reading time. It has to be in one of the other events. It might be 3 as that is start a book and from memory the ExtraData looks like a series of timestamps. But there is another pair of events that are open and close a book, they might have the times. Or it might be in a singleton event that has the cumulative details. I have a list of events that I know about at home, and I've posted it in the past, but can't find it. I don't remember one I would have thought held the total time. As to the checksum, I don't know how to calculate it. I've never really looked into it as I don't even know which columns in the table the checksum is over.

Advert

Advert