[davidfor]

Originally Posted by compurandom

Right. I remember now, it's a field in the driver config, and I'm using a composite column. I suppose I should delete it from the plugboard so I'm not confused in the future.

I'm also tempted to modify the composite column to squash case to fix this problem permanently. Unfortunately, that might make some tags ugly.

You could use another column to do the case squashing. One is used in calibre for display and the other for collections. There is a performance hit, but, if you don't display the column anywhere, it should only happen when the collection management is being done.

Or add a tool to search for mixed case so it can be fixed. I've fixed it in tags manager a few times, but when there's multiple columns involved, it's messier. (Edit: I was fixing case within a hierarchical tag, not sure if tags manager would see it on the same tag?)

It's one of the things I don't like about the tag management in calibre. You can accidentally change the tag case while adding a tag to a book and the books with that tag are shown as modified. It is to easy to do.

Another possible solution would be to trick the kobo into not syncing side loaded shelves at all. (Driver option?) I tried doing this by changing the sync column in the database before disconnecting, but it only sometimes helped. Maybe it was too late by then and I already had the mixed case on the device half synced.

That won't work. That basically means that the collection hasn't been synced yet. It should only be false for a new collection until the next sync. The _SyncTime should get updated each time a sync happens. Though it might only happen when something is changed. The trick might be to set the sync time into the future. Depending on how the checks are done, it might skip any that are in the future. But, there is also risk in that if Kobo were to store that timestamp on their server. It might mean no syncing at all of collections until that time.