Register Guidelines E-Books Today's Posts Search

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

Notices

Reply
 
Thread Tools Search this Thread
Old 08-11-2013, 03:49 AM   #1
Chris_Snow
Zealot
Chris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipse
 
Posts: 148
Karma: 8170
Join Date: Jul 2013
Device: kobo glo
Decimal "Rating" column (Custom) and Stars

Greetings,

I searched the forum looking for the possibility of a decimal "Rating" column. There are only a few posts - all seemingly to want to add on-line ratings to their collection. This is NOT what I want.

I only want to have the Rating Stars and a decimal number and input my own ratings on the books.

If this is possible, I need some help to implement it, as I'm very new to calibre and ebooks.

Calibre is a fantastic piece of software, so I'm surprised this isn't a standard feature (although I could be missing it??)

Thx in advance.
Chris_Snow is offline   Reply With Quote
Old 08-11-2013, 04:09 AM   #2
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,716
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
To stop ratings being downloaded - see attachment

Then you can can enter a number 1-5 in the Rating field in metadata edit. Or in the list, make the Rating cell current for book in question, Press F2 and enter 1-5.

If you want half stars or some such then you'll have to create a custom column and use Custom Icons - I haven't done it so I'll leave that to someone else, I'm pretty sure others have done that sort of thing.

There's a Custom Icons tab in Preferences-Look & Feel

BR
Attached Thumbnails
Click image for larger version

Name:	Capture.JPG
Views:	615
Size:	155.4 KB
ID:	109235  
BetterRed is offline   Reply With Quote
Advert
Old 08-11-2013, 04:20 AM   #3
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 9,896
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen
Quote:
Originally Posted by Chris_Snow View Post
I only want to have the Rating Stars and a decimal number and input my own ratings on the books.
The stars are already in place and you can choose from 1-5 stars.

If you prefer decimal then you can create your own column by going to Preferences - Add your own colums and click on the green plus sign. Now you can choose Rating and change the Column type to Integers then click OK and restart calibre.
DoctorOhh is offline   Reply With Quote
Old 08-11-2013, 05:38 PM   #4
Chris_Snow
Zealot
Chris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipse
 
Posts: 148
Karma: 8170
Join Date: Jul 2013
Device: kobo glo
Thx muchly for the help.

I've managed to get a custom column up and happening, so that is good.

Still surprised this isn't a standard option. There is too big a gap between say 3 and 4 stars (and the rest). All the sites/software I use have a decimal star rating. Don't want to sound too critical. It is free and a fantastic piece of kit.

Do you know how to make the custom column report a value out of 5? Say...4.2/5?? I'd like the "/5" part to be automatic.

Again, appreciate the help. Cheers.
Chris_Snow is offline   Reply With Quote
Old 08-11-2013, 10:00 PM   #5
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 9,896
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen
Quote:
Originally Posted by Chris_Snow View Post
Do you know how to make the custom column report a value out of 5? Say...4.2/5?? I'd like the "/5" part to be automatic.
Yes. Delete the column you just created and create a custom column (same steps as before) but pick floating point instead of integer. Then type {0:.1f}/5 in the box before clicking OK.
DoctorOhh is offline   Reply With Quote
Advert
Old 08-12-2013, 03:06 AM   #6
Chris_Snow
Zealot
Chris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipseChris_Snow can illuminate an eclipse
 
Posts: 148
Karma: 8170
Join Date: Jul 2013
Device: kobo glo
Quote:
Originally Posted by DoctorOhh View Post
Yes. Delete the column you just created and create a custom column (same steps as before) but pick floating point instead of integer. Then type {0:.1f}/5 in the box before clicking OK.
Thx DoctorOhh. That did the trick. I changed the formula (is that what you'd call regex??) from {0:.1f}/5 to {0:.1f}/5.0 and that gave me a decimal place on both sides. Thx again
Chris_Snow is offline   Reply With Quote
Old 04-06-2015, 12:25 PM   #7
truth1ness
Zealot
truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!truth1ness is faster than a rolling 'o,' stronger than silent 'e,' and leaps capital 'T' in a single bound!
 
Posts: 126
Karma: 50000
Join Date: Mar 2015
Device: none
Moderator Notice
This is a duplicate of https://www.mobileread.com/forums/sho...66#post3078066. Please do not double post.
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?

Last edited by chaley; 04-06-2015 at 12:40 PM.
truth1ness is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using "Build column from other column" custom-column type HFC3 Library Management 3 07-07-2013 03:11 AM
Calibre rating column displays lines not stars greenlees Calibre 3 12-06-2012 02:27 PM
Custom column not recognized in "Sending books to devices" cheveguerra Devices 4 12-05-2011 01:58 PM
Custom column: "Updated date", when adding new "versions" of the same file? enriquep Library Management 16 11-03-2011 10:46 AM


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


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