[psycake]

Hello, hope you all are doing fine!

My Kobo Clara Colour was recently stolen and I replaced it with a Libra Colour. Thankfully I had a recent backup of its full storage (including the main KoboReader.sqlite database) so I didn't really lose any data.

My first thought was to just copy everything from the Clara backup over to the Libra but since they are different models I figured it would be best to keep the default files/db of the Libra and only copy what I really need.

I retransferred my books with Calibre then simply thought of copying all entries in the relevant tables of the KoboReader.sqlite database. I see highlights (and notes and bookmarks) are stored in the Bookmark table, while saved words are stored in WordList.

Copying over the entries in WordList was successful and I was able to get them all back, being linked to the correct book (which I see is identified by its route). However, I can't seem to get the highlights copied over.

I did notice that every entry has an associated UserID, the same as the one in the user table. This ID has changed for me as I had to create a new account to "sign out" of the stolen Clara, so I made sure to change that column on every entry. Still, the Libra doesn't seem to show the transferred highlights, and the entries for the highlights of synced books (i.e. not sideloaded) even get deleted after a sync.

(Just as a sidenote, yes, I want to copy over the highlights for my synced books, since this move to the new account made me lose them as well.)

The book routes in columns VolumeID and ContentID seem correct and match the file structure in the Libra, so I'm not sure what I'm missing?

Tangentially, I have also tried to transfer the time spent reading of my books by changing the TimeSpentReading column for every book in the content table, but it doesn't seem to work.

Any guidance? Thanks in advance!