Using a prefix-rule for rating in catalog

[drawson1]

I'm trying to set up a prefix rule ( --prefix-rules=() in 'calibredb catalog ....) for the rating field with no success. I've tried a couple of different options:

--prefix-rules="('Rating','rating','5','5')"

--prefix-rules="('Rating','rating',5,'5')"

which both return "string index out of range"

--prefix-rules="('Rating','rating',None,'0')"

which returns "object of type 'int' has no len()

Prefix rules I've set up for other fields work as expected based on the docs. Has anyone tried this?

Thanks!

dan

[BetterRed]

In what format do you want the catalog ?

Note that different catalog formats support different sets of options. To see the different options, specify the name of the output file and then the –help option.

See ==> calibredb catalog

BR

[dunhill]

I tested this command from the Linux Mint terminal: `calibredb list --search="rating:5" --with-library="/home/walter/Dropbox/Library Walter"`. This tells you which books have a rating of 5.

To generate the catalog, use: `calibredb list --search="rating:5" --with-library="/the path to your Calibre library"`

[Katja_hbg]

By whatever reason the field rating is not available in catalog for prefix or excluding. Anyhow for the most fields the value is yes/no and cannot be specified. Maybe the GUI catalog (menu icon book convert) make this more clear.

The workaround is to use an own customized field; one for each rating value. That should work.

[drawson1]

Originally Posted by BetterRed

In what format do you want the catalog ?



See ==> calibredb catalog

BR

I'm generating an EPUB catalog

[drawson1]

Originally Posted by Katja_hbg

By whatever reason the field rating is not available in catalog for prefix or excluding. Anyhow for the most fields the value is yes/no and cannot be specified. Maybe the GUI catalog (menu icon book convert) make this more clear.

The workaround is to use an own customized field; one for each rating value. That should work.

OK, thanks! ... I'll give the custom field a try.

[drawson1]

SOLVED.

The custom field is the key as follows:

• Add a custom column. I used a text column, limited to the values 0 - 5 (I called it "ratingcalc")
• Populate that column to match the rating. I'm on linux, so this was done with a 6-line shell script :-). One note - in my environment only "read" books have ratings, but not all read books have ratings. I only started adding the ratings a couple of years ago.
• Use the new text column in a prefix rule. This was done in my catalog generation shell script, but it also works fine in the GUI:

--prefix-rules="(\
                         ('Rating','#ratingcalc','False',''),\
                         ('Rating','#ratingcalc','5','5'),\
                         ('Rating','#ratingcalc','4','4'),\
                         ('Rating','#ratingcalc','3','3'),\
                         ('Rating','#ratingcalc','2','2'),\
                         ('Rating','#ratingcalc','1','1'),\
                         ('Read books','#read','True','✓'),\
                         ('Not Kobo','#to_kobo','False','×')\
                         )"

• Update the catalog script to also populate the new column for those books where the original rating field is populated.

The resulting EPUB catalog shows a check-mark as the prefix character for books that are "read" but have no rating, and a number for books that have a rating.

A few related notes:

• I tried using a few other column types with no success:
  • Composite column based on the original ratings field ( using '{ratings:ratings_to_stars()}' )
  • Integer column
  • Ratings column
• The scripts update this field using 'calibredb set_metadata'. If you pass a value outside the field limits (<0 or >5 in my example), set_metadata succeeds (ie, returns 0), but leaves the field value unchanged

:-))

HTH!

Dan