View Single Post
Old 12-26-2018, 12:54 PM   #24
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 5,110
Karma: 19597086
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9
Quote:
Originally Posted by theducks View Post
It is at the bottom of the 'Check ePub Structure' menu.
I am not really sure what it uses for the detection template.

If you have a SQLlite browser look at the conversion_options table: Data column (blob will be set)
I know about the conversion_options table. That's why I tried conversion_options:true in Calibre search.

The "Check calibre conversion" in Quality Check PI only checks if an epub was converted with Calibre. It doesn't actually tell you if there are saved conversion options for a specific book. It does this by opening the OPF file inside the EPUB and checking for:
Code:
name="calibre:timestamp:

or

<dc:contributor opf:role="bkp">calibre


I just remembered that the MultiColumnSearch plugin has a tab for Raw SQL Queries.

This worked for checking which books have saved conversion settings:
Code:
SELECT id FROM books WHERE id IN (SELECT book FROM conversion_options)
ilovejedd is offline   Reply With Quote