08-18-2014, 04:37 AM | #16 |
Grand Sorcerer
Posts: 6,233
Karma: 11768331
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
Thank you very much, @Mini, this is exactly what I was looking for. I've adapted a bit the method (rating + HalfS => Rating+, so I don't have to repeat wating, and as I'm drawing challenged, coud you please add an icon in rating_icons_2 for 2.5 stars? If you can't that's right but if I don't ask...
Anyway, thank you very much again. |
08-18-2014, 12:46 PM | #17 | |
Groupie
Posts: 197
Karma: 318144
Join Date: Jul 2013
Location: Well, there will always be a big time delay because I'm not living in the US! And there could be some communication difficulties too because I'm not a native speaker!
Device: Sony PRS-T3S
|
Quote:
I also added a 0star icon. See original post here and see edit_part2 text. Mini |
|
Advert | |
|
08-18-2014, 01:28 PM | #18 |
Grand Sorcerer
Posts: 6,233
Karma: 11768331
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
Thank you very much I've played around with some specific columns and half star are up A slightly different way but it works like a charm, thanks again
Last edited by Terisa de morgan; 08-18-2014 at 01:33 PM. |
08-19-2014, 04:19 AM | #19 | |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
An example template for an advanced icon rule that returns the name of the desired png file is: Code:
program: # Set r to the value in a float field containing the rating r = raw_field('#myfloat'); # Return the name of the png that corresponds to the value. The .01 stuff # is used to avoid having to enter the png name twice, once for less-than # and once for equals first_non_empty( cmp(r, 1.01, '1-star-rating.png', '', ''), cmp(r, 2.01, '2-star-rating.png', '', ''), cmp(r, 3.01, '3-star-rating.png', '', ''), cmp(r, 3.51, '3-star-plus-rating.png', '', ''), cmp(r, 4.01, '4-star-rating.png', '', ''), cmp(r, 4.51, '4-star-plus-rating.png', '', ''), cmp(r, 5.01, '5-star-rating.png', '', '') ) |
|
08-19-2014, 12:18 PM | #20 | |
Groupie
Posts: 197
Karma: 318144
Join Date: Jul 2013
Location: Well, there will always be a big time delay because I'm not living in the US! And there could be some communication difficulties too because I'm not a native speaker!
Device: Sony PRS-T3S
|
Quote:
Could you explain to me what to put where in the advanced rule? Because I never worked with it before But I would really like to know Mini |
|
Advert | |
|
08-19-2014, 12:52 PM | #21 | |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
To explain a bit further, an advanced rule must return the name of the file containing the image to be displayed. If you want more than one image displayed by this one rule, return a list of image names separated by colons. If you want the results of this rule to be composed with other rules (use the results of multiple rules), pick one of the "composed" types. In your case where you have a single image for each rating group, the advanced rule would return one name. That is what the sample template I provided does. |
|
08-19-2014, 01:44 PM | #22 |
Grand Sorcerer
Posts: 6,233
Karma: 11768331
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
But take into account that you must change the rules for choosing according to the value of Rating+, not the float column that chaley has analyzed.
|
08-19-2014, 04:15 PM | #23 | |
Groupie
Posts: 197
Karma: 318144
Join Date: Jul 2013
Location: Well, there will always be a big time delay because I'm not living in the US! And there could be some communication difficulties too because I'm not a native speaker!
Device: Sony PRS-T3S
|
Quote:
I will try it out. Thanks! And thanks for that info too because as I rushed over it, I actually did miss that part. Though it makes perfectly sense now that I think about it. |
|
04-06-2015, 12:27 PM | #24 |
Zealot
Posts: 126
Karma: 50000
Join Date: Mar 2015
Device: none
|
I'm trying to get finer decimal ratings (for half star or finer ratings like 4.5, 4.9, etc), too, but I'm not clear on the instructions for how to do this so far. I've made a column called ratings and set it to floating point as described. But then what? I just have an empty column now, how do I get the data from the ratings column into the decimal column? Where is the decimal rating behind the graphical stars located? Is there actual decimal data with the built in metadata download or do I need some plugin to actually grab the raw ratings again from Amazon?
|
04-06-2015, 12:36 PM | #25 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
You can transfer values from one column to another with bulk metadata search and replace.
Transferring "rating" introduces some complexity because it normally isn't a column that one can operate on. However, "template" mode lets us get its value then store it in another column. The following screen capture shows you how. |
04-06-2015, 05:09 PM | #26 |
Zealot
Posts: 126
Karma: 50000
Join Date: Mar 2015
Device: none
|
Could you explain what is going on in these fields? What is template mode, I don't see it in the dropdown or anywhere in the window.
|
04-06-2015, 05:19 PM | #27 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Set the search mode to regular expression and all the options/fields/dropdowns shown in the screen capture will be available to you.
|
Tags |
rating, stars |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
{Rating} multiplied by two? | anamardoll | Calibre | 4 | 04-19-2011 11:24 AM |
I have not given this book a star rating as there isn't an option for a negative | Nada y Nadie | Writers' Corner | 6 | 04-12-2011 05:04 PM |
Rating automatic when adding files? | peaceridge | Calibre | 2 | 12-06-2010 01:53 PM |
Kindle users give 1 star rating to book with delayed ebook release | anurag | News | 203 | 01-29-2010 07:33 PM |
Star Trek vs. Star Wars | daffy4u | Lounge | 48 | 12-04-2008 10:06 AM |