[Metadata Source Plugin] Goodreads_rating

[Pr.BarnArt]

This plugin is deprecated, because the original goodreads-plugin now offers the same function.

There were several who asked for a plugin which can get and store the decimal rating of goodreads.
I gave it a try, just because I like to tackle a problem. But I am not a very good programmer. So this is more or less for fun and there sure will be better/smarter ways to solve this.

For this you need two plugins:
1. Goodreads_rating
I changed the original plugin ( thanks to Kiwidude) just a little.
The publisher-field now contains the publishersname, followed bij '#PrB.rating#' and then followed by the rating of goodreads.

2. F_rating
You can find it here or download it within calibre->preferences->plugins.

INSTALLATION (Thanks to arialvetica)

1. Download both linked plugins (current version is always at the bottom of the original post).
2. Install both linked plugins. To do this, click on "Preferences," then under the "Advanced" heading click on "Plugins." For each plugin, click on "Load plugin from file." Find the ZIP file you just downloaded, click "Open." Click "Yes" on the "Are you sure?" dialogue. Restart calibre after installing plugins.
3. There will be a new icon (looks like an orange starburst) in the main menu, called Frating. It has a menu with two options:
- Set decimal rating;
- Check and create custum column;

But you can also click the icon itself and it will run: set decimal rating;
This will check if there is already a custom column for this.
If not it wil create one and you have to restart calibre.
If the check is true, it will go on with putting the decimal rating in the custom column.

For creating the column you can also slect the menu option: "Check and create custom column." (Optional: You can change the Column Heading through Preferences: Add Your Own Columns. Double-click on the #gr1 column, and type whatever you prefer in the "Column Heading" field. Do NOT change the lookup name.)


USAGE

To download ratings for an individual book (good for checking if you've done setup correctly.)
1. Click on a book title in the main calibre window.
2. Click on "Edit metadata individually".
3. Next to "Download metadata," click on the Configure Download icon (looks like a "Preferences/Settings" icon, hover-text should read "Change how calibre downloads metadata.")
4. Ensure "Goodreads_Rating" is the ONLY checked Source, then Apply changes.
5. Click on "Download metadata".
6. When the download is complete, click "OK" first for the metadata, then "OK" again for the cover.
7. Click "OK" again to save changes and close the Edit Metadata window.
8. Click on the "Run frating" icon (looks like an orange starburst).
After this processes, you'll see a dialogue box either confirming whether it worked ("Finished extracting rating from publisherfield - for a total of X books") or not ("Finished extracting rating from publisherfield - for a total of 0 books"). Click OK to close the dialogue. Now, in the main calibre window, in this book's row and under the gr_ratings column, you should see a number ranging from 0.0 to 5.0.

To download ratings in bulk
1. Select a range of books in the main calibre window.
2. Click on "Download metadata and covers".
3. Click on "Configure Download".
4. Ensure "Goodreads_Rating" is the ONLY checked Source, then Apply changes.
5. Click on "Download only metadata".
6. When the download is complete, click "Yes".
7. Click "OK" again to save changes and close the Edit Metadata window.
8. Click on the "Run frating" icon (looks like an orange starburst).
9. Click on "Set decimal retings." After this processes, you'll see a dialogue box either confirming whether it worked ("Finished extracting rating from publisherfield - for a total of X books") or not ("Finished extracting rating from publisherfield - for a total of 0 books"). Click OK to close the dialogue. Now, in the main calibre window, in each book's row and under the gr_ratings column, you should see a number ranging from 0.0 to 5.0.

!NOTE: When downloading metadata from your usual sources (to get book covers, tags, etc), you'll need to go back to the "Configure Download" window and select your preferred sources. When downloading Goodreads Decimal Ratings, you'll need to repeat the steps to download ONLY from Goodreads_Rating.

Changes v. 4.0.0.
- update goodreads plugin 1.5.3. related to Calibre6 and qt6

Enjoy
Paypal Donations:

• If you find this plugin useful please feel free to show your appreciation.
  

Version History:

Spoiler:

2019-12-14
v. 3.0.0. based on Goodreads 1.4.0

2020-30-09
v.3.1.0 based on Goodreads 1.5.1

2022-7-13
v 4.0.0. based on Goodreads 1.5.3

[Rellwood]

Im not sure if you are watching this board, but I am having problems getting the ratings to populate in the columns - even if the publisher has the rating in it.

This is a new problem (within the past update) which I had to do because of other plugins requiring it.
Calibre 4.6

[Pr.BarnArt]

Originally Posted by Rellwood

Im not sure if you are watching this board, but I am having problems getting the ratings to populate in the columns - even if the publisher has the rating in it.

This is a new problem (within the past update) which I had to do because of other plugins requiring it.
Calibre 4.6

I see no issues when using 4.6.

Just to check:
using Goodreads_rating 3.0.0 ?
seperator between Publisher and rating: #PrB.rating# ?
using F_rating 3.1.0 ?
try F_rating.menu-> Check and create custom column.

what is the result if you click F-rating

[Lynnloi]

Hi.

Thank you for your most helpful plugin which I have used for some time.

I have not used the Calibre for several months and had just updated the plugins today. I noticed that the decimal ratings are no longer updated when I applied "frating" with the orange burst. I could see the decimal rating linked to the publisher e.g.

Tamara Gill#PrB.rating#4.36

However, the value is not transferred to the rating column anymore. Message given is:

calibre, version 4.8.0
Updated database: Finished extracting rating from publisherfield
- for a total of 0 books


Lynn

[Pr.BarnArt]

Originally Posted by Lynnloi

.
I applied "frating" with the orange burst. I could see the decimal rating linked to the publisher e.g.
Tamara Gill#PrB.rating#4.36

However, the value is not transferred to the rating column anymore.

I cannot reproduce this
I tested with calibre 4.8 and ( 4.99 Beta python 3) with no errors
Goodreads-rating seems to work ok , according to the Publisher field.
Did you update f_rating to 3.1.0 ?
It is renamed to Float-rating (F-rating)

[Lynnloi]

Hi BarnArt,

I just noticed there is a newer orange-burst button on top labeled 'F_frating', in addition to the older orange-burst labeled "frating". I had been clicking on the older button and expecting it to work. It works perfectly now that I am clicking on the newer 'F_frating'.

Thank you very much for your response.


-Lynn-

[Pr.BarnArt]

Originally Posted by Lynnloi

Hi BarnArt,

I just noticed there is a newer orange-burst button on top labeled 'F_frating', in addition to the older orange-burst labeled "frating". I had been clicking on the older button and expecting it to work. It works perfectly now that I am clicking on the newer 'F_frating'.

Thank you very much for your response.


-Lynn-

Good, you can remove the old plugin, it was a beta version. For the new one you will receive updates within Calibre

[Pr.BarnArt]

Update for Goodreads_rating , based on goodreads 1.5.1 , available at the start of this thread and within calibre.
For use with python 3.0

[dunhill]

Thank you very much for the update and I can switch to version 5

[stardot]

Thanks! Very useful! Saves me a lot of time. Good work!

Could you add the number of ratings?

[Pr.BarnArt]

Originally Posted by stardot

Could you add the number of ratings?

It is possible, but takes some extra tasks, but I dont know how much demand there is for this
It's not on my to do list right now.
You can give it yourself a try, feel free to us the plugin as base.
If you combine them in one column, the kind of the clumn has to be changed to text and that will be related to sorting.
For adding an extra column, you have to do an extra split and create the extra columns.

[Rob557]

A bulk determination of decimal-ratings and ratings-count are of interest both when deciding whether to select books to put into Calibre and when identifying a group of books within Calibre from which to select one for reading.

Prior to seeing this thread in mobileread.com, I was looking on the internet and came across the following March 2019 article. I don't have the technical ability to determine if the approach is similar to the approach used for the "F_frating" plugin, or might provide some related insights, so just posting the link here:
https://usman.io/goodreads-decimal-ratings-in-calibre/

I share the view expressed in that article and by others that the decimal-rating can be of questionable value without the rating-count. The article seems to make reference to using the ratings-count but I did not see where it was identifying how to bulk-download the ratings-count for Calibre.

Thank you for your work in creating the F-frating plugin. Its the first time I've seen that capability of downloading the decimal-ratings.

[Rob557]

PS. I now see that this "Goodreads_ratings" thread is one branch-off from the following thread that also addressed the "frating" plugin, and extended from 2013 to Dec 2019 (but is now closed):

[ORIGINAL] https://www.mobileread.com/forums/sh...d.php?t=223688

and, as noted in the starter-posting above, the other branch-off thread is the related renamed "F_rating" (Floating Rate) plugin thread:

https://www.mobileread.com/forums/sh...d.php?t=325652

[Pr.BarnArt]

Originally Posted by Rob557

https://usman.io/goodreads-decimal-ratings-in-calibre/

It is almost the same concept, except that I don't want to use the publisher field for it.
The other point is to combine the rating en the rating-count will create the need of a complex filter, which not every user will understand.
Therefore if also grabbing the rating count, it should be placed in a seperate column.

[Rob557]

Originally Posted by Pr.BarnArt

... if also grabbing the rating count, it should be placed in a separate column.

I fully agree that ratings count should be in a separate column.

It would seem that whatever methodology can download decimal ratings from Goodreads should be readily modifiable to download the ratings count as well ??

For many people it would be a very important, although sometimes misleading, criteria to help decide which books to read.