MobileRead Forums - View Single Post - Clara HD Clone old Kobo Glo inside a new Clara HD... how?

TradingBad · 01-21-2022, 05:40 PM

Ok, I've tried anything, and I think I've found where my problem is!

I've tried with Calibre, Kobo Utilities, and Annotations plugins... and now at least I have all my annotations on Calibre, but I can't find a way to send them on my Clara HD.
But this is normal, because I've read a lot on this forum and from what I understand: if we didn't have the method described in the link of Koboy... it would be impossible with Calibre to fetch the Annotations/bookmarks and then immediately send them to a new device... we can only fetch them to see them on Calibre.

So, I've found the issue on my Database, toying with SQLite Personal.
What we do in that link is modify the line in "Data", under "User" Database, but we keep the rest identical to the old Database from the old device.

Well, my problem is in "Data", under the "Bookmark" Database.
I have over 500 records with the path columns that start with file/mnt/sd... while it should be file/mnt/onboard... because the Clara doesn't have the Microsd slot, but only onboard!
I think, if I could modify the path for every one of the 500 records, replacing the SD with ONBOARD and keeping the rest identical... my problems would be solved!
So the question is: does anybody know how to "automate" the process of finding and replacing every "sd" with "onboard" on the data path column inside a Database?

01-21-2022, 05:40 PM	#5
TradingBad Junior Member Posts: 3 Karma: 10 Join Date: Jan 2022 Device: Kobo Glo	Ok, I've tried anything, and I think I've found where my problem is! I've tried with Calibre, Kobo Utilities, and Annotations plugins... and now at least I have all my annotations on Calibre, but I can't find a way to send them on my Clara HD. But this is normal, because I've read a lot on this forum and from what I understand: if we didn't have the method described in the link of Koboy... it would be impossible with Calibre to fetch the Annotations/bookmarks and then immediately send them to a new device... we can only fetch them to see them on Calibre. So, I've found the issue on my Database, toying with SQLite Personal. What we do in that link is modify the line in "Data", under "User" Database, but we keep the rest identical to the old Database from the old device. Well, my problem is in "Data", under the "Bookmark" Database. I have over 500 records with the path columns that start with file/mnt/sd... while it should be file/mnt/onboard... because the Clara doesn't have the Microsd slot, but only onboard! I think, if I could modify the path for every one of the 500 records, replacing the SD with ONBOARD and keeping the rest identical... my problems would be solved! So the question is: does anybody know how to "automate" the process of finding and replacing every "sd" with "onboard" on the data path column inside a Database?