Clara HD Import Sqlite

[angeladottavio]

Hi everybody,

I have just bought a kobo clara hd and I am trying to import my annotations from my old kobo glo. I have successfully copied and pasted my old library, but when I paste the koboreader.sqlite something goes wrong. I get an error message (something like "critical error" and your annotations will be deleted) and the reader won't work properly (it won't go to standby, but only off). Morover, when I turn it off I have to reset the account. I've already tried to find the solution in the forum, but didn't manage I have a mac, calibre, and db browser for sqlite

[DNSB]

Originally Posted by angeladottavio

Hi everybody,

I have just bought a kobo clara hd and I am trying to import my annotations from my old kobo glo. I have successfully copied and pasted my old library, but when I paste the koboreader.sqlite something goes wrong. I get an error message (something like "critical error" and your annotations will be deleted) and the reader won't work properly (it won't go to standby, but only off). Morover, when I turn it off I have to reset the account. I've already tried to find the solution in the forum, but didn't manage I have a mac, calibre, and db browser for sqlite

Copying the database is iffy at best. It can work if both ereaders are on the same firmware revision. One of those it may work and if it doesn't, I haven't lost anything. You could try importing your annotations into calibre but that is a one way street.

As for the critical error, that will trigger a factory reset.

[geek1011]

If you just want annotations, I suggest you copy your books into the exact same structure on your new Kobo, let them import, copy just the bookmark table to the new database. Note that I've only tested this with kepub books, so I don't know how this will interact with other formats.

If you want reading stats, you can also copy rows from the event table with type 46 from the old DB, and they should work fine (the checksum doesn't include other data except for the row itself).

If you want collections, the best way to do so is to log in to your Kobo account (this will restore them as empty collections), then copy rows from the ShelfContent table with a ContentId starting with file:/// (this also depends on the directory structure remaining the same).

If you want read/unread states, copy the ReadStatus column where set for rows of the content table with a NULL BookId and a ContentId starting with file://.

If you want reading settings (font, last dictionary, search history, etc), copy rows from the content_settings table with a ContentId starting with file://.

If you want My Words, copy the wordlist table.

This covers most of the possible things you can copy from the DB (even between versions) without causing issues.

[angeladottavio]

Originally Posted by DNSB

You could try importing your annotations into calibre but that is a one way street.

Thank you for your answer. Could you tell me how to import annotations into calibre and then transfer them to the new Kobo?

[DNSB]

Originally Posted by DNSB

You could try importing your annotations into calibre but that is a one way street.

Originally Posted by angeladottavio

Thank you for your answer. Could you tell me how to import annotations into calibre and then transfer them to the new Kobo?

As I said, it is a one way street. You can import the annotations but there is no mechanism for exporting them back to your Kobo.

[angeladottavio]

Originally Posted by geek1011

If you just want annotations, I suggest you copy your books into the exact same structure on your new Kobo, let them import, copy just the bookmark table to the new database. Note that I've only tested this with kepub books, so I don't know how this will interact with other formats.

Thank you. I have been trying to figure out how to copy the bookmark table in the new database, but I haven't been able to understand it. Could you explain it, please?

[geek1011]

Originally Posted by angeladottavio

Thank you. I have been trying to figure out how to copy the bookmark table in the new database, but I haven't been able to understand it. Could you explain it, please?

One way would be to use .dump to dump the entire DB (warning: it's large), then copy the insert statements for the bookmark table to the other db.

The other way would be to use the ATTACH command to attach the other database, then copy between them using an INSERT and SELECT in the same statement.

If you're using a GUI, you might be able to copy the rows as-is.

[angeladottavio]

I have found a workaround with DB Browser for SQLite. First I copied all my books of my old Kobo in the same directory of my new one. Then I opened the bookmarks from the old KoboReader.Sqlite files, exported them in cvs and then imported them in the bookmarks of the new KoboReader.Sqlite. Apparently it works! I am so thrilled because the database thing was really puzzling me. Thanks geek1011 and DNSB for the hints!