View Single Post
Old 04-02-2017, 11:13 PM   #3
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 9,897
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen
Quote:
Originally Posted by botmtl View Post
I really like custom columns, but I'm not too keen on their side-effects. The side effect i'm referring to is that when the custom column data changes, then the book metadata.opf gets updated and the book is considered "dirty" (changed) for the sake of synchronisation.
Making changes to calibre custom columns should not change any books in your library. The metadata.opf file in the book's directory within the calibre library will be updated because that is used for backup.

Quote:
Originally Posted by botmtl View Post
For example, let's take one a lot of people have, author_book_count. When the book count is updated, all the books in the library will be updated. When I next synchronize with a device, all the books will need to be resent (as then have changed since the last sync).
What device are you using and what program are you using to sync to that device? Some devices such as Android devices that use Calibre Companion will sync the changed metadata every time you connect to the device. Syncing the metadata is not the same as resending books. I have never had any books resent to my device because I updated a custom column.

Quote:
Originally Posted by botmtl View Post
Aside being a problem with syncs, is that some of those columns can contain private information that needs to be scrubbed if the file is ever to be shared (web content epubs for example).

I was wondering if there was any way (hidden tweak?) I could mark some columns as being "database only", i.e. that medatadata field wont be updated in the book files (and metadata.opf).
Again, the metadata.opf files in the calibre library's book directories is a non-issue since this file is used for backing up the library and used to reconstruct the database when needed.

Quote:
Originally Posted by botmtl View Post
(not sure i'm being clear so this is another way to ask exactly the same thing) -> Is there a column filter setting that can be used to identify columns that are not to be written in the book's metadata?
You're being clear. I think all metadata is written to the book when you send the book to the device. I don't know of anyway to selectively pick and choose which metadata is written to the device. I have never had any books on my device automatically updated whenever I change a custom column.
DoctorOhh is offline   Reply With Quote