View Single Post
Old 01-21-2023, 12:36 PM  
fritolays
Member
fritolays began at the beginning.
 
Posts: 18
Karma: 10
Join Date: Sep 2022
Device: Kindle Graphite DX, Kobo Clara 2E
Post Clearing Prelaoded via GUI

Quote:
Originally Posted by srid View Post
Kobo ships with about 100 preloaded books, which you can also download for free from sites like feedbooks.com. As there is no way to organize your books, navigating to your favourite book can be cumbersome.

I chose to delete the preloaded books and upload the handful of books that can be easily accessed.

On Mac OS X, I used the following command to delete the preloaded books.

sqlite3 /Volumes/KOBOeReader/.kobo/KoboReader.sqlite "delete from content where ___userid != 'adobe_user'"

Make sure that you make a backup of the "KoboReader.sqlite" file before modifying it.

Once you are done, eject the Kobo and "reset" it (see the pin hole at the back).
Sorry for adding to an old topic, but I wanted to include a method for all platforms via gui.

1. Download DB Browser for SQLite
- https://sqlitebrowser.org/
- there is a portableapps release available

2. Make a backup of your current database
- Copy KOBOeReader/.kobo/KoboReader.sqlite to someplace safe

3. Make a second copy of your current database
- this is the one we will modify

4. Run DB Browser for SQLite and open the second copy of KoboReader.sqlite
- should see the list of tables load

5. Goto the Execute SQL tab
- Type:
Code:
delete from content where ___userid != 'adobe_user'
6. Click the play button to execute the code
- should see output below of it finishing without errors and how many rows affected

7. Assuming no errors above, click Write Changes, then Close Database
- this will save and close the file

8. Now copy the modified database back to your kobo
- overwrite the existing KOBOeReader/.kobo/KoboReader.sqlite file

9. Eject/disconnect and reboot your device
- should see the importing content screen...
- i also rebooted my kobo


Hopefully, this helps some other folks out...
Attached Thumbnails
Click image for larger version

Name:	dbbrowser.jpg
Views:	86
Size:	164.9 KB
ID:	199163  
fritolays is offline   Reply With Quote