Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 01-09-2022, 02:27 AM   #1
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,580
Karma: 74000001
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
I love using column colours on a ratings column

I just found out I can do this. I love the way it looks.

Click image for larger version

Name:	2022-01-09 03_26_11-calibre — __ My Books __ Read __.png
Views:	198
Size:	2.9 KB
ID:	191459
ownedbycats is online now   Reply With Quote
Old 01-09-2022, 04:42 AM   #2
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,581
Karma: 12595249
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Quote:
Originally Posted by ownedbycats View Post
I just found out I can do this. I love the way it looks.

Attachment 191459
So, you color a column based on value? Or is is something special for ratings? I like it.
Terisa de morgan is offline   Reply With Quote
Advert
Old 01-09-2022, 04:57 AM   #3
Karellen
Wizard
Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.
 
Karellen's Avatar
 
Posts: 1,592
Karma: 9499994
Join Date: Sep 2021
Location: Australia
Device: Kobo Libra 2
I didn't know you could do half star ratings in Calibre.

My drop down box only allows me to select 1-5 stars. How do you get half star ratings?
Karellen is offline   Reply With Quote
Old 01-09-2022, 11:52 AM   #4
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,580
Karma: 74000001
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Quote:
Originally Posted by Terisa de morgan View Post
So, you color a column based on value? Or is is something special for ratings? I like it.
Ratings is just a fancy-looking integer column. Here's how I did it:

Code:
program:

	r = $#ratings;

	if r >=#4 then '#00ff00' 
	elif r >=#2 then '#ffff7f'
	elif r >=#0 then '#ffaa00'

	fi
Quote:
Originally Posted by Karellen View Post
I didn't know you could do half star ratings in Calibre.

My drop down box only allows me to select 1-5 stars. How do you get half star ratings?
You need to use a custom ratings column instead of the default one. I switched because a 10-point scale is a bit more useful to me.

Click image for larger version

Name:	2022-01-09 12_54_06-Edit custom column.png
Views:	177
Size:	12.6 KB
ID:	191467

Click image for larger version

Name:	2022-01-09 12_57_26-Edit metadata - Tailchaser's Song -  [1 of 304].png
Views:	210
Size:	628.4 KB
ID:	191468

Last edited by ownedbycats; 01-09-2022 at 11:58 AM.
ownedbycats is online now   Reply With Quote
Old 01-09-2022, 01:46 PM   #5
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,581
Karma: 12595249
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Quote:
Originally Posted by ownedbycats View Post
Ratings is just a fancy-looking integer column. Here's how I did it:

Code:
program:

	r = $#ratings;

	if r >=#4 then '#00ff00' 
	elif r >=#2 then '#ffff7f'
	elif r >=#0 then '#ffaa00'

	fi


You need to use a custom ratings column instead of the default one. I switched because a 10-point scale is a bit more useful to me.

Attachment 191467

Attachment 191468

Thank you!
Terisa de morgan is offline   Reply With Quote
Advert
Old 01-09-2022, 02:29 PM   #6
Karellen
Wizard
Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.
 
Karellen's Avatar
 
Posts: 1,592
Karma: 9499994
Join Date: Sep 2021
Location: Australia
Device: Kobo Libra 2
Quote:
Originally Posted by ownedbycats View Post
You need to use a custom ratings column instead of the default one. I switched because a 10-point scale is a bit more useful to me.
Ok, thanks
Karellen is offline   Reply With Quote
Old 01-16-2022, 12:32 AM   #7
Penny_Dreadful
She/Her
Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.
 
Penny_Dreadful's Avatar
 
Posts: 87
Karma: 142774
Join Date: Aug 2009
Location: Perth, Australia
Device: Kindle PW5 (G001PX) PW3 PW1
Thanks I love this idea 💚
Attached Thumbnails
Click image for larger version

Name:	calibre ratings.png
Views:	77
Size:	2.0 KB
ID:	191617  
Penny_Dreadful is offline   Reply With Quote
Old 01-16-2022, 03:36 AM   #8
un_pogaz
Chalut o/
un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.
 
un_pogaz's Avatar
 
Posts: 437
Karma: 145424
Join Date: Dec 2017
Device: Kobo
So, that's cool, but the only thing that interests me here is :
How did you get this unified interface for metadata? NEED!

Oh my god, I can feel you creating your own build calibre for this. Dammit.
An option for that would be cool. Much better, a minimum configuration for the position of the groups would be so powerful (but so much to pull out your hair)
un_pogaz is offline   Reply With Quote
Old 01-16-2022, 04:42 AM   #9
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,311
Karma: 7957679
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by un_pogaz View Post
So, that's cool, but the only thing that interests me here is :
How did you get this unified interface for metadata? NEED!

Oh my god, I can feel you creating your own build calibre for this. Dammit.
An option for that would be cool. Much better, a minimum configuration for the position of the groups would be so powerful (but so much to pull out your hair)
Do you mean the metadata edit dialog shown in post #4? Preferences / Behavior / Edit metadata (single) layout: All on 1 tab.

Also see the tweaks:
  • Order of custom column(s) in edit metadata (ID: metadata_edit_custom_column_order)
  • Edit metadata custom column label width and elision point (ID: metadata_edit_elide_labels)
chaley is offline   Reply With Quote
Old 01-16-2022, 07:07 AM   #10
un_pogaz
Chalut o/
un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.
 
un_pogaz's Avatar
 
Posts: 437
Karma: 145424
Join Date: Dec 2017
Device: Kobo
Thanks.
In "Behavior"? I would have said "Look & Feel", strange choice.

Arf, the cover on the right I would not get used to it... and you can't grab the groups of metadata to change their size, like with the Default.
Not sure of using it and some improvement to suggest (to Kovid), but I keep this option.
un_pogaz is offline   Reply With Quote
Old 01-17-2022, 06:34 PM   #11
dunhill
Guru
dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.
 
dunhill's Avatar
 
Posts: 854
Karma: 409968
Join Date: Sep 2017
Location: Buenos Aires, Argentina
Device: moon+ reader, kindle paperwhite
I couldn't get it to work for me
Can you give me screenshots?
dunhill is offline   Reply With Quote
Old 01-17-2022, 06:56 PM   #12
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,580
Karma: 74000001
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
If you mean my template, did you change line 3 '$#ratings' to '$rating'? I use a custom column.
ownedbycats is online now   Reply With Quote
Old 01-17-2022, 09:30 PM   #13
Penny_Dreadful
She/Her
Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.Penny_Dreadful is my North, my South, my East and West.
 
Penny_Dreadful's Avatar
 
Posts: 87
Karma: 142774
Join Date: Aug 2009
Location: Perth, Australia
Device: Kindle PW5 (G001PX) PW3 PW1
Quote:
Originally Posted by dunhill View Post
I couldn't get it to work for me
Can you give me screenshots?
I edited the code a bit so I could use the default rating column and change the colour for each number of stars.



Code:
program: 

     r = $rating;
 

     if r >=#5 then '#2EAB64'
     elif r >=#4 then '#94E4C9'
     elif r >=#3 then '#FE657D'    
     elif r >=#2 then '#FCB2A9'
     elif r >=#1 then '#FEDC78'
 

     fi

Go to Settings> Look and Feel> Column Colouring> Add Advanced Rule (it's a button at the bottom left of the dialogue box)


Change "Set the colour of the column" to the ratings column and paste the code into the template box and you should be good to go.

Ans so much thanks to ownedbycats your idea is genius! I love ideas to make calibre prettier.

Last edited by Penny_Dreadful; 01-17-2022 at 09:41 PM.
Penny_Dreadful is offline   Reply With Quote
Old 01-18-2022, 04:32 AM   #14
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,311
Karma: 7957679
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by Penny_Dreadful View Post
I edited the code a bit so I could use the default rating column and change the colour for each number of stars.



Code:
program: 

     r = $rating;
 

     if r >=#5 then '#2EAB64'
     elif r >=#4 then '#94E4C9'
     elif r >=#3 then '#FE657D'    
     elif r >=#2 then '#FCB2A9'
     elif r >=#1 then '#FEDC78'
 

     fi
FWIW: this template will have better performance because the sequence of comparisons is done in python instead of the template interpreter.
Code:
program:
	first_matching_cmp(
		$rating,
		1.1, '#FEDC78',
		2.1, '#94E4C9',
		3.1, '#FE657D',
		4.1, '#94E4C9',
			 '#2EAB64')
I used 1.1 instead of 1 etc. because the comparisons are 'less than'. I should have made it <= when I added first_matching_cmp() to the template language. Oh well, too late now.
chaley is offline   Reply With Quote
Old 01-18-2022, 04:40 AM   #15
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,580
Karma: 74000001
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Would it break existing things to change it to <= instead of <?
ownedbycats is online now   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with ratings column Tanjamuse Library Management 13 09-19-2016 10:04 AM
Custom Column for Half-Star Ratings Loosheesh Calibre 2 09-14-2016 01:45 PM
My Ratings column MerlinMama Calibre 5 09-08-2016 07:20 AM
grouping does not work for custom column type ratings comox Calibre Companion 2 09-24-2014 01:54 PM
Rename the Ratings column? mlevin77 Library Management 5 04-13-2012 09:36 PM


All times are GMT -4. The time now is 01:33 PM.


MobileRead.com is a privately owned, operated and funded community.