How to change Genre of a book in the Library?

vmsda · 02-09-2015, 09:01 AM

Is it possible to do it without deleting and reloading it? Thanks.

rkomar · 02-10-2015, 04:24 AM

It might be possible. The information would be stored in a database file on the device. It looks to me like it could be in /system/explorer-2/explorer-2.db, which is an SQLITE database file. If you know a thing or two about databases, and especially SQLITE, then you could probably change the genre value for a particular book in the database. I don't know how long it would last before the book was probed and the database updated again with the original genre value.

vmsda · 02-10-2015, 05:18 AM

Thank you.

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-09-2015, 09:01 AM	#1
vmsda Enthusiast Posts: 26 Karma: 29748 Join Date: Sep 2012 Device: Pocketbook	How to change Genre of a book in the Library? Is it possible to do it without deleting and reloading it? Thanks.

02-10-2015, 05:44 PM	#4
rkomar Wizard Posts: 2,986 Karma: 18343081 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Recommendations for Your Favorite Book Genre	dreams	Reading Recommendations	2	01-06-2016 05:33 AM
Transfer Calibre Library to another PC keeping the Genre	looki	Conversion	3	11-19-2012 10:13 AM
Standard Book Genre	rjmac	General Discussions	18	08-20-2012 06:47 PM
New Book, New Genre	Terry Odell	Self-Promotions by Authors and Publishers	0	12-06-2011 01:27 PM
Genre Heirarchy Problem- Sub Genre Showing up in different main genre	collin8579	Library Management	3	08-10-2011 11:11 AM

02-10-2015, 04:24 AM	#2
rkomar Wizard Posts: 2,986 Karma: 18343081 Join Date: Oct 2010 Location: Sudbury, ON, Canada Device: PRS-505, PB 902, PRS-T1, PB 623, PB 840, PB 633	It might be possible. The information would be stored in a database file on the device. It looks to me like it could be in /system/explorer-2/explorer-2.db, which is an SQLITE database file. If you know a thing or two about databases, and especially SQLITE, then you could probably change the genre value for a particular book in the database. I don't know how long it would last before the book was probed and the database updated again with the original genre value.

02-10-2015, 05:18 AM	#3
vmsda Enthusiast Posts: 26 Karma: 29748 Join Date: Sep 2012 Device: Pocketbook	Thank you.

Advert