Touch How transfer "Books Read" and "Hours Read" data

Abrakadabra77 · 01-26-2015, 04:14 AM

I had to do factory reset, and of course I lost my reading stats ... I saved the file KoboReader.sqlite. Is it possible to transfer only the number of books read together with the number of hours read? A simple transfer KoboReader.sqlite makes the reader stops working properly (not able to open the library, etc.)
I tried using a program SQliteExpertPersonal to edit this information, i managed to only reach that after uploading changes I've got what I wanted but as I open a book counters are reset.
Ps.
Sorry for my poor and funny english but this is not my natural language

davidfor · 01-26-2015, 06:43 AM

If the backup of the database is not corrupt, it should be restoreable to the device. But, unless you put the same books back on the device in the same place, then it will have trouble. It should just remove the missing books and add any new ones, but, there could be a problem doing this in bulk.

Restoring just the reading stats is fairly easy, but I don't know how reliable it is. The reading stats come from the table "Event". The "EventType" column contains what the event is for. For the reading stats, I believe it is using the rows with EventType=5. I think just copying these rows will do what you want, but I haven't tried it.

Abrakadabra77 · 01-26-2015, 07:27 AM

Oh BIG thx! I got exactly what i wanted

And indeed it was easy. Once again- VERY thank you for helping

davidfor · 01-26-2015, 07:42 AM

Just to check, did you simply extract and load the EventType=5 rows? It would be good to have what you did do recorded for the next time this question is asked.

Abrakadabra77 · 01-26-2015, 08:04 AM

I replace all EVENT database to new, working KoboRead.sqlite and have my stats

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

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

What eventType is this ?

01-26-2015, 04:14 AM	#1
Abrakadabra77 Junior Member Posts: 7 Karma: 10 Join Date: Mar 2014 Device: Kobo Touch	How transfer "Books Read" and "Hours Read" data I had to do factory reset, and of course I lost my reading stats ... I saved the file KoboReader.sqlite. Is it possible to transfer only the number of books read together with the number of hours read? A simple transfer KoboReader.sqlite makes the reader stops working properly (not able to open the library, etc.) I tried using a program SQliteExpertPersonal to edit this information, i managed to only reach that after uploading changes I've got what I wanted but as I open a book counters are reset. Ps. Sorry for my poor and funny english but this is not my natural language Last edited by Abrakadabra77; 01-26-2015 at 04:22 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there a way to transfer "Read" tag to reader?	Ripplinger	Calibre	13	09-14-2012 02:35 PM
PRS-T1 Change homescreen to show "Recently Read" instead of "Recently Added"	benze	Sony Reader	3	07-18-2012 06:48 PM
How change "Read" to "UnRead" on a SubForum?	unboggling	Feedback	3	05-20-2012 02:48 AM
How to remove "Fully read" books from "Last Open" list?	pjeanetta	PocketBook	4	12-08-2010 10:30 AM

01-26-2015, 06:43 AM	#2
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	If the backup of the database is not corrupt, it should be restoreable to the device. But, unless you put the same books back on the device in the same place, then it will have trouble. It should just remove the missing books and add any new ones, but, there could be a problem doing this in bulk. Restoring just the reading stats is fairly easy, but I don't know how reliable it is. The reading stats come from the table "Event". The "EventType" column contains what the event is for. For the reading stats, I believe it is using the rows with EventType=5. I think just copying these rows will do what you want, but I haven't tried it.

01-26-2015, 07:27 AM	#3
Abrakadabra77 Junior Member Posts: 7 Karma: 10 Join Date: Mar 2014 Device: Kobo Touch	Oh BIG thx! I got exactly what i wanted And indeed it was easy. Once again- VERY thank you for helping

01-26-2015, 07:42 AM	#4
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	Just to check, did you simply extract and load the EventType=5 rows? It would be good to have what you did do recorded for the next time this question is asked.

01-26-2015, 08:04 AM	#5
Abrakadabra77 Junior Member Posts: 7 Karma: 10 Join Date: Mar 2014 Device: Kobo Touch	I replace all EVENT database to new, working KoboRead.sqlite and have my stats

02-16-2015, 03:30 AM	#6
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 ?

Advert

Advert