Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 05-24-2017, 09:52 AM   #1
gabryele
Connoisseur
gabryele began at the beginning.
 
Posts: 53
Karma: 10
Join Date: Sep 2016
Device: Kobo Aura one
KoboReader.sqlite: export and reimport annotations or edit

question 1: is there a way to export annotations from a KoboReader.sqlite and reimport those annotations in a new KoboReader.sqlite?

question 2: is there a way to edit some values in the database?

question 3: is possibile to put the KoboReader.sqlite from a device to another without problems? for example from H2o to Aura One?
gabryele is offline   Reply With Quote
Old 05-25-2017, 12:15 AM   #2
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by gabryele View Post
question 1: is there a way to export annotations from a KoboReader.sqlite and reimport those annotations in a new KoboReader.sqlite?

question 2: is there a way to edit some values in the database?

question 3: is possibile to put the KoboReader.sqlite from a device to another without problems? for example from H2o to Aura One?
Yes, all of those things are possible and discussed here quite a few times in the past. It's not hard, but not guaranteed to work, especially the last one. The main issue is that the file name and location of sideloaded books is used as keys in the database. Unless these are identical on the old and new device, then the device will remove the existing rows and process the books as new.

A search here should show find the previous discussions, but in short:

For 2: Any SQLite database manager can make changes to the database. But, if the purpose is to modify the metadata on the device, calibre plus my Kobo Utilities plugin is probably the better option.

For 1: You can export the contents of one database using the SQLite database manager and then import it into the other. You can modify the data during this if needed.

For 3: This has been done with varying success. Some people have simply copied the database. Some needed to export the data from the user table from the new device and put it into the database being copied. A search for this should give more details.
davidfor is offline   Reply With Quote
Advert
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Aura KoboReader.Sqlite help (stats lost) Skyfall Kobo Developer's Corner 6 03-29-2015 05:21 AM
Glo koboreader.sqlite File LaLaLia Kobo Reader 3 10-05-2014 08:05 PM
Is there a way to export annotations... jojoba Amazon Kindle 4 01-24-2014 10:55 AM
Found sqlite annotations database in Kindle for Android beeblebrox Kindle Formats 6 12-04-2013 06:17 AM
Koboreader.sqlite gundged maxwelledison Kobo Reader 21 01-12-2011 08:24 AM


All times are GMT -4. The time now is 10:52 AM.


MobileRead.com is a privately owned, operated and funded community.