"Use saved conversion settings" -- why?

[ilovejedd]

Originally Posted by BetterRed

Which "Restore defaults" are you referencing:

Preferences Attachment 168629 or Single Conversion Attachment 168630

I meant Preferences. Lol, I always do bulk conversion, never single.

Originally Posted by BetterRed

IMO the QC plugin would be the logical place to provide something that listed the books with one-off conversion settings, e.g. a Check individual conversion in the Check Epub structure group. But, given plugin is a) not being actively maintained, apart from making sure it continues to work, and b) it currently relies on the content of metadata.opf files for related checks, then this may not be easily done.

So, if it can't be done in via template function used in a custom column as suggested by DivingDuck, then IMO, the next logical place would be a new tool in DaltonSt's JobSpy plugin. Assuming there is someway to interrogate SQL database to get the right answer, as per ilovejedd's post #24.

The Quality Check plugin does rely on the database, too, for certain tools (e.g. Fix -> Check and repair book sizes, Check and rename book paths). As you said though, it's not being maintained anymore.

I expect a check for whether per book saved settings exist would be incredibly easy for DaltonST to add to JobSpy (e.g. what I did on post #24 using DaltonST's MultiColumnSearch plugin). Way simpler compared to Tag Scrubber.

I exported the data blob and it's just simple JSON. Alas, the order of conversion options isn't fixed/sorted so if it's to be compared to the conversion settings in Calibre Preferences, need to add extra code for that.

[BetterRed]

@ilovejedd - I would think for most users just knowing which books have specific stored conversion settings would suffice.

BR

[ilovejedd]

Originally Posted by BetterRed

@ilovejedd - I would think for most users just knowing which books have specific stored conversion settings would suffice.

BR

Probably.

Given Calibre saves conversion options with every single conversion, a query like the above wouldn't actually help determine if one is using modified/book-specific settings like @Divingduck wants.

I use EPUB on Android/iOS and MOBI (dual) on my Kindle so all my books have saved conversion settings. Or they would have if I didn't clear those out via bulk metadata edit quite regularly. (I try to clear saved settings immediately after conversion but sometimes I forget.)

[kovidgoyal]

yes the conversion_options table is where it is stored, and yes it is always stored there, regardless of whether any option is changed or not.

If you want to see which books have different options from the current defaults, you would need to write code to compare the options on a book by book basis. It should not be too hard, the options are stored as simple JSON dictionaries. You will need to exclude the metadata options such as cover, title, etc.

[Divingduck]

Originally Posted by ilovejedd

Might be possible with SQLiteBrowser.

Browse the conversion_options table and sort it by data column. Select Mode: Binary when viewing cell contents.

That's what I did to check what happen. I didn't take attention to this table before. By the way, thank you for pointing me in this direction.

Need to think about this a little more. I usually try to avoid manipulating the database outside from calibre as I can not be sure that I recognize all dependencies in the database. I don't want to loos bits over the time and don't recognize it until it is too late. The amount on entries in this table is a little bit bigger and additionally I don't want to loose the effort I spend for a lot of fine tuned conversion for individual books. I only want to know which books have a "individual conversion" where I need to take care about. I start some time last year with an additional column where I put this Information in manually after I recognize, that this can help me to find already existing solutions for other books in work (... as soon as I remember it ... ).

[Divingduck]

Originally Posted by kovidgoyal

If you want to see which books have different options from the current defaults, you would need to write code to compare the options on a book by book basis. It should not be too hard, the options are stored as simple JSON dictionaries. You will need to exclude the metadata options such as cover, title, etc.

Yes, it seems I need to find some time for it.

[BetterRed]

A search in stackoverflow etc will find a number of python JSON compare modules.

BR

[kovidgoyal]

well to get you started, here is how you can load both global and bookspecific options, run it using calibre-debug:

from calibre.library import db
db = db()
from calibre.ebooks.conversion.config import load_defaults, load_specifics
specifics = load_specifics(db, book_id)
page_defaults = load_defaults('page_setup')

You will need to load the defaults for all the different "pages" of the conversion dialog and ever individual format. look in the conversion sub-directory of the calibre config directory for the names to use. Both the above are basically python dictionaries. You can compare them using whatever methodology you like,