[davidfor]

Originally Posted by Boneist

Firstly, I'm trying to get the books in my H2O to show the titles as they are in Calibre, but I'm not having much luck. I have applied the fix from this post to remove the subtitles, but there are still books where the title in the database doesn't match the title I have set in Calibre.

That should work, but I added the subtitle as one of the fields that can be set from the the Kobo Utilities plugin.

I have updated the metadata both via Calibre and the Kobo Utilities plugin (the latter of which reported 0 books updated) and ejected and reloaded the ereader, but no joy.

Does anyone know why the update of the title isn't working? I'm on Calibre v2.84 (64 bit) and my H2O is at 4.3.8945. It appears to be affecting both downloaded straight from Kobo and side-loaded books (such as the 3 kindle books I converted to epubs this evening *{:-/ )

Again, this should work. If the result says that no books were updated, then it is because the plugin didn't find any changes to make. During the update it compare those in the device database with what is in the calibre library and only changes what is different.

Of course, there could be a bug. If it isn't working, run calibre in debug mode, select a couple of books to update that won't update and then run the metadata update. Then post calibre debug log for me to look at.

One thing, if changes are made, sometimes the device won't reflect them until the database is reread. The only way to force this is to restart the device. And, if the database is corrupt, then anything the plugin does to make changes will fail, but you should see an error message.

Secondly, I have an issue where I have two entries for lots of books, one is a copy on the device (with the title, series, etc from Calibre) the other is marked as "Download" (with the title, series, etc from Kobo itself). I suspect most of these are ones I downloaded on my old Sony PRS-T1 that were subsequently side-loaded into my H2O when I first started using it.

Is there a tried and tested method to combine these database entries, or am I doomed to either download the books manually, delete the old copy and then match the books in Calibre, or have to faff around doing potentially complicated updates/deletes directly in the database? (Last time I looked at this, I wasn't sure which rows would need to be amended, and IIRC there were differences between different books, so the same fix wouldn't work across all of them).

The books with "Download" are from the Kobo server. They are books you have bought from the Kobo store and not downloaded to the device. Or, in this case, are books you bought from the Sony shop and were migrated to Kobo when Sony closed down their store. There are three ways to handle them: download them, ignore them and delete them.

If you download them, they will be on the device and you can read them. They will be kepubs rather than epubs. The utilities plugin can change the metadata for these but there is an option that need to be chosen.

If you delete them, they are removed from the account proper and show in the "Archived" section of the library on the Kobo store. You have to do this one at a time on the device.

For all options, you are deciding if you want to read a sideloaded version of the book or that from Kobo. Personally, I read the downloaded version unless the formatting has to many problems. Then I fix it in the epub, sideload and read that. Having both versions on the device doesn't worry me.

An alternative is to use a separate Kobo account for the device. Have one to buy books, download to the PC and sideload. The other is on the device and you don't buy any books with it. Then, you won't see any books downloaded to the device at all.