Quote:
Originally Posted by davidfor
You can export the table "Bookmarks" from one database and import it into the other. SQLite Expert Personal should have something to do that. If you have any purchased books, select just the sideloaded books and export them. These have the "ContentID" starting with "file://".
|
I couldn't find how to do that in SQLite Expert Personal but I installed SQLiteStudio and DB Browser and it is possible to do it there. I made a test export in csv format and it worked fine (yay). I even was able to modify the bookmarks in the database (filepath) for one book which had been accidentally transferred at the root of the memory, so I could put it in the "books" folder where it belongs without losing the annotations.
However then I tried to import the exported table back to the database, just to check how it worked and I got that bleeding unique error again:
Code:
Error while importing data: UNIQUE constraint failed: Bookmark.BookmarkID
Is this because the database I'm importing into has that error (not a problem since I am not keeping it), or is the Bookmarks table itself corrupted (problem)? I tried to sort the csv file by BookmarkID and then skim quickly the file to see if I could find the duplicate and I didn't see one (using a proportional-width font so that 2 same IDs would be easy(-ier) to see) but that doesn't mean it definitely isn't there.
Quote:
Originally Posted by davidfor
The date added and the last reading date are stored separately for each book. And I specifically wanted to be able to do this, so I made sure it worked.
|
Brilliant, thank you for that.
Quote:
Originally Posted by davidfor
In one of the recent firmware versions, Kobo changed to put the text file in a directory "Exported Annotations". But, there isn't any way to connect them other than the names. As you are using calibre, you could add the text file to the book in the library as a second format. Calibre will then maintain them together.
|
Oh excellent, that's a great idea, I hadn't thought of adding them in Calibre.
I must not have the latest firmware because I don't have the "Exported Annotations" folder, should I update first? Will the database error be affected one way or another if I do?