Quote:
Originally Posted by davidfor
None of the annotation export options are automatic. You have to run them either on the device or when the device is connected to a PC. The export annotations on the device can be run from any of the book lists. Long-press on the book and it should be on the menu.
|
Okay, that's what I thought but I don't think I had noticed I could export them without opening the book (and changing the read date), so that is useful information. I'll have to go through all the "finished" books and export them all and then try and remember to do that immediately from now on.
Quote:
Originally Posted by davidfor
If you have all the columns configured in the book status fetch, then you can restore the status and the reading position. Which includes the last read date. That is the case for both read and unread books. But, if you are opening the book and then marking it as unread to get it to the top of the "Recent" sort, then that is not stored.
|
That is good news. I'm not marking the opened books as "unread", I just leave them in the "currently reading" list until I get to them. The only thing missing now would be the date first imported but maybe I can figure out something with the dates in Calibre even if it's not a perfect match.
Quote:
Originally Posted by davidfor
After I posted the SQL statement, it occurred to me that it might not give the desired result because the index was corrupt. The query is probably optimised to use the index, which would give the wrong result.
|
Ha right, that makes sense. I actually am glad to know that since if it's down to the broken database it's not me who couldn't manage to do it correctly.
Quote:
Originally Posted by davidfor
There are no tools that I know of that export the annotations in a way that can be imported again. You can be done by exporting the table and importing it into a new database.
|
Yes, I understood that. I am just wondering if it's very complicated to export the table / import it to a new database (i.e. worth me trying to figure it out or way beyond what I could conceivably manage).
Quote:
Originally Posted by davidfor
For the "Recent" sort, if I populate the device again, I use the "Update metadata in the device library" to set the "Date Added" to one of the dates in the calibre library. If you are opening and then marking books as unread, it won't help.
|
That is a good option, it won't be a perfect match but it is better than having all the books with the same add date. As long as the date added doesn't override the reading date / status (like I said, I don't mark the books as unread after I open them, I just leave them in the reading list) that is a big improvement to just lumping them all together on the same date.
Quote:
Originally Posted by davidfor
At this point, I'm not sure if it can be fixed. If I had a copy of the database, I could try. It would involve dropping the indexes, finding the duplicates as above followed by some cleanup and then recreating the indexes. That should work, but, there is a lot to do.
|
If that is an offer, I very much appreciate it
but since there is a lot to do, I wouldn't want to make you spend all that time after you've already spent so much time answering my questions (and thank you again for all the help).
A last question about annotations: when I export them to a .txt file, they wind up at the root of the device storage. Are they linked to the original epub file at all? Or can I move them to a folder without causing any problems? I don't like the mess.
