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 09-16-2013, 02:35 PM   #1
moonfaerie24
Junior Member
moonfaerie24 began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Sep 2013
Device: kindle
My library doesn't seem to sort correctly

I read in the Graphical User Interface's Search and Sort area that you should, for example, be able to click the Title column, then the Author column in order to sort by author and have all books by the same author sorted by title. What I actually want to sort by is Series, but I'm having some problems. At first it would not sort correctly by title or series, but after going through my entire library and fixing some inconsistencies this solved most, but not all, of my problems. I have one series that refuses to sort by Series, and another that won't recognize the title correctly. Since what I would like is to have all my books sorted by Author then by Series I'll start there.

If I click Series, then Author it will look like this:
Fire, Kristen Cashore, The Seven Kingdoms [2]
Bitterblue, Kristen Cashore, The Seven Kingdoms [3]
Graceling, Kristen Cashore, The Seven Kingdoms [1]

Instead of sorting 1, 2, 3 it goes 2, 3, 1. I've been into the metadata over and over again trying to make sure I didn't include an extra space somewhere or that I spelled everything exactly the same, or some other error like that, but have not been able to find anything.

The other problem I'm having is that for one book series it won't recognize that "The Amulet of Samarkand" is the same as "Amulet of Samarkand, The" which is the default for every other book in my library. For example when I look at metadata for "The Giver" and click the little arrow between title and title sort it automatically fills in with "Giver, The". When I try this with "The Amulet of Samarkand" it just puts "The Amulet of Samarkand" into title sort. This problem isn't as big of a deal for me as the other one, but it still shouldn't be happening so I would like to know the cause/ solution.

Any help, especially with the first problem, would be greatly appreciated.

Edit: Thanks to kovidgoyal my naming problem has been solved. For some strange reason those books were set to Spanish and not English.

Edit 2: Thanks to kovidgoyal (again) and DoctorOhh I've fixed the sorting problem as well. It was in fact the same problem for both issues: one of the books was randomly set to Spanish, so it failed to disregard the "The".

Last edited by moonfaerie24; 09-17-2013 at 11:15 AM.
moonfaerie24 is offline   Reply With Quote
Old 09-16-2013, 03:28 PM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 29,689
Karma: 54369090
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
You are telling it to do conflicting (multiple) sorts.
You have differing Authors, Differing Titles.
Series [index] ONLY relevant sort if you want series order

The only time you can (want to?) do 'Bias' (the prior sort) is when the INDEX is the same
Then a single (title or Author) prior (bias) sort is relevant.
Only when the author is IDENTICAL, and the series[index] are the same can you sort on Author (kind of redundant), then title, then Series
theducks is offline   Reply With Quote
Advert
Old 09-16-2013, 04:00 PM   #3
Adoby
Handy Elephant
Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.Adoby ought to be getting tired of karma fortunes by now.
 
Adoby's Avatar
 
Posts: 1,736
Karma: 26785668
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Thinkpad E595, Ubuntu Mate, Huawei Mediapad 5, Bouye Likebook Plus
If you want to sort on series, then you need to click on series last.

I think that you want to click title, then author, then series, to get the sort you want to have.

Also you have to make sure that author and series are spelled identical, otherwise all bets are off.
Adoby is offline   Reply With Quote
Old 09-16-2013, 06:09 PM   #4
itimpi
Wizard
itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.
 
Posts: 4,552
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
Also note that for author it is the author_sort field that is actually used for the sort. It is possible to have identical author fields that do not have the same author_sort value.
itimpi is offline   Reply With Quote
Old 09-17-2013, 12:58 AM   #5
moonfaerie24
Junior Member
moonfaerie24 began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Sep 2013
Device: kindle
Quote:
Originally Posted by theducks View Post
You are telling it to do conflicting (multiple) sorts.
You have differing Authors, Differing Titles.
Series [index] ONLY relevant sort if you want series order

The only time you can (want to?) do 'Bias' (the prior sort) is when the INDEX is the same
Then a single (title or Author) prior (bias) sort is relevant.
Only when the author is IDENTICAL, and the series[index] are the same can you sort on Author (kind of redundant), then title, then Series
I'm not sure what you mean by conflicting things. I want it to sort by author, then within author I would like it to sort by series. In my example all the book were by the same author, in the same series, and would not sort correctly.

Quote:
Originally Posted by Adoby View Post
If you want to sort on series, then you need to click on series last.

I think that you want to click title, then author, then series, to get the sort you want to have.

Also you have to make sure that author and series are spelled identical, otherwise all bets are off.
I want it to sort by author, then series, not just series, so I am clicking them in the right order for what I want, it's simply not ordering it correctly. And I have quadruple checked that all the author and series information is identical.

Quote:
Originally Posted by itimpi View Post
Also note that for author it is the author_sort field that is actually used for the sort. It is possible to have identical author fields that do not have the same author_sort value.
Yes, all my author and author sort fields are identical (green).

Last edited by moonfaerie24; 09-17-2013 at 01:03 AM.
moonfaerie24 is offline   Reply With Quote
Advert
Old 09-17-2013, 01:12 AM   #6
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,864
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
Quote:
Originally Posted by moonfaerie24 View Post
If I click Series, then Author it will look like this:
Fire, Kristen Cashore, The Seven Kingdoms [2]
Bitterblue, Kristen Cashore, The Seven Kingdoms [3]
Graceling, Kristen Cashore, The Seven Kingdoms [1]

Instead of sorting 1, 2, 3 it goes 2, 3, 1. I've been into the metadata over and over again trying to make sure I didn't include an extra space somewhere or that I spelled everything exactly the same, or some other error like that, but have not been able to find anything.
One problem at a time.

First, you are doing it correctly and it should sort exactly as you expect. When you click on Series does the Series goes 1, 2, 3? Click on the series column and verify that the series is in proper order, it looks like you may have clicked on the column twice and actually have ascending series number.

If the Series order is correct then your problem is in the author sort area.

Either your first item in the list above:

Fire, Kristen Cashore, The Seven Kingdoms [2]

has an author sort different then the other two or the second two items may have multiple authors which will mess with author sorting within series.

Quote:
Originally Posted by theducks View Post
You are telling it to do conflicting (multiple) sorts.
I won't respond to the rest of your post because I can't make heads or tails out of it. Maybe I'm confused, but I don't think so.

She is telling it to do a simple multi-column sort. This kind of sort is why we have tweaks that allow how many sort levels there are or the default method we wish to sort in. What she describes above should work.

I sort by Title, then Series and finally Author which places all books by a given author in series order and any books by the author not in a series are in title order.

Quote:
Originally Posted by Adoby View Post
If you want to sort on series, then you need to click on series last.
If the series has multiple authors then the only way to get a series in order is to click on series last. But if the series has only a single author then what she is doing is fine.

Last edited by DoctorOhh; 09-17-2013 at 01:27 AM.
DoctorOhh is offline   Reply With Quote
Old 09-17-2013, 01:14 AM   #7
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: 20,459
Karma: 26645808
Join Date: Mar 2012
Location: Sydney Australia
Device: none
@moonfaerie24 - you might want to consider the View Manager plugin, I find it makes dealing with multi-column sorting much easier

Whether it will do want you want I can't say, but...

BR
BetterRed is offline   Reply With Quote
Old 09-17-2013, 01:15 AM   #8
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 43,778
Karma: 22666666
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
I'd guess that the language field is set incorrectly for the problem books. Make sure the language is set to english for all the books. Only if language is set to english will the leading The be treated as you expect.
kovidgoyal is offline   Reply With Quote
Old 09-17-2013, 01:21 AM   #9
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,864
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
You posted while I was formulating my post.

Quote:
Originally Posted by moonfaerie24 View Post
Yes, all my author and author sort fields are identical (green).
This is perplexing.

If you go to the tag browser and right click on the Author item then choose Manage Authors does the author and sort look correct in this list (see attached)?
Attached Thumbnails
Click image for larger version

Name:	manageauthors.jpg
Views:	243
Size:	80.3 KB
ID:	111194  
DoctorOhh is offline   Reply With Quote
Old 09-17-2013, 11:09 AM   #10
moonfaerie24
Junior Member
moonfaerie24 began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Sep 2013
Device: kindle
Quote:
Originally Posted by DoctorOhh View Post

First, you are doing it correctly and it should sort exactly as you expect. When you click on Series does the Series goes 1, 2, 3? Click on the series column and verify that the series is in proper order, it looks like you may have clicked on the column twice and actually have ascending series number.
I never thought to check that, but now that I have I find it interesting. If I ONLY sort by series it will go 2 then 3 then there are 7 more books, THEN it put 1. This implies to me the problem is definitely with the first book. I'm wondering how though when I typed the series name for book one and then used the drop down menu for the other two. They're definitely spelled the same. Maybe it's a language thing again?

Edit: Just checked and that was randomly set to Spanish too. Changing it to English fixed the problem again. Thank you so much to kovidgoyal and DoctorOhh.
moonfaerie24 is offline   Reply With Quote
Reply

Tags
metadata, series, sort, sorting

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Gentium Book font (ttf) doesn't render correctly therealjoeblow Kobo Reader 13 06-21-2015 09:24 AM
Web of Debt (WordPress blog) doesn't compile correctly Universe Man Recipes 2 08-30-2013 02:46 AM
Why doesn't it convert this TOC correctly? neonbible Calibre 2 05-30-2012 07:40 AM
Sub-Sort doesn't work. 0.7.23 Linux NeilBryant Calibre 2 01-19-2011 07:30 PM
How do I make the PRS-505 sort correctly? Djehuty Sony Reader 4 04-02-2009 01:13 AM


All times are GMT -4. The time now is 02:46 AM.


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