MobileRead Forums - View Single Post - How to change Genre of a book in the Library?

rkomar · 02-10-2015, 05:44 PM

Just out of curiosity, I looked at explorer-2.db in more detail using the sqlite3 commandline program on my linux box. The books_impl table contains a book number for each title. The booktogenre table contains a genre value for each book number. The genres tables contains a genre title for each value. So, it does look like that is the place to change the genre of a book without changing the book. You would just have to change the right line in the booktogenre table.

If you were originally wondering if there was some way to do it in the Library UI, I haven't seen it. The metadata in the books seems to be unchangeable via the UI.

02-10-2015, 05:44 PM	#4
rkomar Wizard Posts: 3,055 Karma: 18821071 Join Date: Oct 2010 Location: Sudbury, ON, Canada Device: PRS-505, PB 902, PRS-T1, PB 623, PB 840, PB 633	Just out of curiosity, I looked at explorer-2.db in more detail using the sqlite3 commandline program on my linux box. The books_impl table contains a book number for each title. The booktogenre table contains a genre value for each book number. The genres tables contains a genre title for each value. So, it does look like that is the place to change the genre of a book without changing the book. You would just have to change the right line in the booktogenre table. If you were originally wondering if there was some way to do it in the Library UI, I haven't seen it. The metadata in the books seems to be unchangeable via the UI. Last edited by rkomar; 02-10-2015 at 05:47 PM.