View Single Post
Old 03-24-2013, 04:41 AM   #4
GeoffR
Wizard
GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.GeoffR ought to be getting tired of karma fortunes by now.
 
GeoffR's Avatar
 
Posts: 3,821
Karma: 19162882
Join Date: Nov 2012
Location: Te Riu-a-Māui
Device: Kobo Glo
Quote:
Originally Posted by murg View Post
Rename the .kepub to .zip. Unzip it. Edit the .opf file using any simple text file editor. Rezip the file. Rename the file back to .kepub.
But wouldthe device re-read the file or even notice that it was changed? I didn't try it out as modifying the database directly seems to work OK. Of course either way I lose the changes next time I log out of my account.

Quote:
Originally Posted by davidfor View Post
It has never caused me any problems. The main change I do is the series info, but I have changed most of the metadata in the database for kepubs.

For my curiosity, do you have the books loaded in calibre? Either the epub version or an empty book with the metadata filled in appropriately so that they match.
I have the epub versions in Calibre with the author name on both set to "Steven Erikson", Calibre matched them to the kepubs and set the series info for the kepubs from the epubs as expected.

I ran the following command from sqlite3 to change the author name, it seems to have worked as hoped, but I'll watch for problems for a while before I try any more changes.
Code:
UPDATE content
 SET Attribution='Steven Erikson'
 WHERE Attribution='Erikson, Steven';
GeoffR is offline   Reply With Quote