Thread: KoboReader.sqlite: export and reimport annotations or edit
View Single Post
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,905
Karma: 47303824
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