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 08-12-2014, 11:50 AM   #1
tobiasj
building an e-Bookcase
tobiasj began at the beginning.
 
Posts: 30
Karma: 11
Join Date: Dec 2006
Device: PRS-500 / PRS-505 / Franklin Rocket e-book
Sort library on multiple fields

I have been looking for a way to sort on multiple fields in the library. For example, I want all of an authors books together, but I want them sorted by Series and series index. Is there some way to accomplish this in Calibre or is there a plugin that sorts on multiple fields? I seem only to be able to sort by series or author and not by both with author first.

-John
tobiasj is offline   Reply With Quote
Old 08-12-2014, 12:06 PM   #2
theducks
Grand Sorcerer
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: 15,301
Karma: 6022735
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by tobiasj View Post
I have been looking for a way to sort on multiple fields in the library. For example, I want all of an authors books together, but I want them sorted by Series and series index. Is there some way to accomplish this in Calibre or is there a plugin that sorts on multiple fields? I seem only to be able to sort by series or author and not by both with author first.

-John
Just click each column head you want sorted in order:
eg. Authors then Title

Series sorts include the index order in the sort

FWIW, you may read series by only 1 author. Many have different authors, making a Series<>Author sort iffy

just like you can't do a series<>Title sort (well you CAN do the sort operation, it won't render wonderful results )

Note: There is a sort on start up option where you can enter the column names to always do.
Preferences: Tweaks: <sort_columns_at_startup> selection from right
theducks is offline   Reply With Quote
Old 08-12-2014, 12:16 PM   #3
tobiasj
building an e-Bookcase
tobiasj began at the beginning.
 
Posts: 30
Karma: 11
Join Date: Dec 2006
Device: PRS-500 / PRS-505 / Franklin Rocket e-book
Quote:
Originally Posted by theducks View Post
Just click each column head you want sorted in order:
eg. Authors then Title

Series sorts include the index order in the sort

FWIW, you may read series by only 1 author. Many have different authors, making a Series<>Author sort iffy
This doesn't seem to work the way you suggest, if I click on the Author column first then click on Series, it changes from an author sort to a series sort, it doesn't um, stack the sorts. Though I may misunderstand what your suggesting I do.

I am not worried about series with different authors, I do have a couple of those but whatever order they end up in doesn't bother me. Having the 20+ books by the same author all over the library rather than together annoys me since my default sort is by series Yes, I know I can create vlibraries or search to accomplish this on a smaller scale but I want the entire library to sort that way. There may simply not be a way to do it, and that's too bad.
tobiasj is offline   Reply With Quote
Old 08-12-2014, 12:20 PM   #4
tobiasj
building an e-Bookcase
tobiasj began at the beginning.
 
Posts: 30
Karma: 11
Join Date: Dec 2006
Device: PRS-500 / PRS-505 / Franklin Rocket e-book
Quote:
Originally Posted by theducks View Post
Note: There is a sort on start up option where you can enter the column names to always do.
Preferences: Tweaks: <sort_columns_at_startup> selection from right

This however seems to have worked exactly the way I was looking for. I am going to play with it some more, but simply adding [('authors', 0), ('series', 0)] it seems to sort the way I expected...

Thanks!
tobiasj is offline   Reply With Quote
Old 08-12-2014, 12:24 PM   #5
theducks
Grand Sorcerer
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: 15,301
Karma: 6022735
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by tobiasj View Post
This doesn't seem to work the way you suggest, if I click on the Author column first then click on Series, it changes from an author sort to a series sort, it doesn't um, stack the sorts. Though I may misunderstand what your suggesting I do.

I am not worried about series with different authors, I do have a couple of those but whatever order they end up in doesn't bother me. Having the 20+ books by the same author all over the library rather than together annoys me since my default sort is by series Yes, I know I can create vlibraries or search to accomplish this on a smaller scale but I want the entire library to sort that way. There may simply not be a way to do it, and that's too bad.
It does here.

Your Authors may have slight differences (Jonn Smith vs John Q. Smith)
Your Author sort field may be erratic (shows red)

Get the Quality check Plugin. It has all sorts of Metadat checks to help you identify books that need more Metadata help
theducks is offline   Reply With Quote
Old 08-12-2014, 12:33 PM   #6
tobiasj
building an e-Bookcase
tobiasj began at the beginning.
 
Posts: 30
Karma: 11
Join Date: Dec 2006
Device: PRS-500 / PRS-505 / Franklin Rocket e-book
Quote:
Originally Posted by theducks View Post
It does here.

Your Authors may have slight differences (Jonn Smith vs John Q. Smith)
Your Author sort field may be erratic (shows red)

Get the Quality check Plugin. It has all sorts of Metadat checks to help you identify books that need more Metadata help
I have already spent the last week or so cleaning up all the meta data. Like I said in my second reply, setting the start-up sort works exactly as I wanted it to which means to me that the meta data must be correct. Either way you got me exactly where I wanted to be sort-wise in my library. Thanks!
tobiasj is offline   Reply With Quote
Old 08-12-2014, 02:00 PM   #7
chaley
"chaley", not "charley"
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: 5,927
Karma: 1673776
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by tobiasj View Post
This doesn't seem to work the way you suggest, if I click on the Author column first then click on Series, it changes from an author sort to a series sort, it doesn't um, stack the sorts. Though I may misunderstand what your suggesting I do.
Do the clicks in the opposite order. The last column you click is the major sort order. The second-to-last is the sort used if the values in the last column you clicked are equal. And so on.
chaley is offline   Reply With Quote
Old 08-12-2014, 06:34 PM   #8
BetterRed
null operator
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: 4,041
Karma: 2925589
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by tobiasj View Post
I have already spent the last week or so cleaning up all the meta data. Like I said in my second reply, setting the start-up sort works exactly as I wanted it to which means to me that the meta data must be correct. Either way you got me exactly where I wanted to be sort-wise in my library. Thanks!
@tobiasj - this may do some/all of what you want, has facility to save/reuse multiple 'columns to display' and 'columns to sort' setups ==>> [GUI Plugin] View Manager

BR
BetterRed is offline   Reply With Quote
Old 08-15-2014, 10:16 AM   #9
cvlowe
Enthusiast
cvlowe began at the beginning.
 
Posts: 36
Karma: 10
Join Date: Jul 2014
Device: Calibre on laptop
An option that is sort of clunky, but works is to use the title sort field and manually enter the info in the way you want it to sort. It's not an optimal method by any means but it works.
cvlowe is offline   Reply With Quote
Old 08-15-2014, 01:35 PM   #10
fidvo
Zealot
fidvo ought to be getting tired of karma fortunes by now.fidvo ought to be getting tired of karma fortunes by now.fidvo ought to be getting tired of karma fortunes by now.fidvo ought to be getting tired of karma fortunes by now.fidvo ought to be getting tired of karma fortunes by now.fidvo ought to be getting tired of karma fortunes by now.fidvo ought to be getting tired of karma fortunes by now.fidvo ought to be getting tired of karma fortunes by now.fidvo ought to be getting tired of karma fortunes by now.fidvo ought to be getting tired of karma fortunes by now.fidvo ought to be getting tired of karma fortunes by now.
 
Posts: 121
Karma: 775442
Join Date: Jun 2012
Device: none
Quote:
Originally Posted by BetterRed View Post
@tobiasj - this may do some/all of what you want, has facility to save/reuse multiple 'columns to display' and 'columns to sort' setups ==>> [GUI Plugin] View Manager

BR
Keep in mind that, at least the last time I checked, View Manager can't sort on more than 3 fields. It will let you check more than 3 boxes, but the sorting doesn't work past 3.

It was months ago since I noticed this, so it might have changed since then.
fidvo is offline   Reply With Quote
Old 08-15-2014, 07:44 PM   #11
BetterRed
null operator
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: 4,041
Karma: 2925589
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by fidvo View Post
Keep in mind that, at least the last time I checked, View Manager can't sort on more than 3 fields. It will let you check more than 3 boxes, but the sorting doesn't work past 3.

It was months ago since I noticed this, so it might have changed since then.
@fidvo - I don't think the PI has changed, functionally, since June last year. I have about a dozen views but none have more than 3 sort fields - maybe that's why I have have about a dozen views

It would be nice if one could associate views with Virtual Libraries.

I'm mouse shy so I find clicking on column headers a PITA.

BR
BetterRed is offline   Reply With Quote
Old 08-16-2014, 01:55 AM   #12
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: 8,909
Karma: 12755553
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
I'm not at my machine, but IIRC the number of sort levels is controlled by a tweak. I have that tweak set to 5, but I don't know that it translates to this plugin.

Last edited by DoctorOhh; 08-16-2014 at 08:32 AM.
DoctorOhh is offline   Reply With Quote
Old 08-16-2014, 06:07 AM   #13
dickloraine
Zealot
dickloraine ought to be getting tired of karma fortunes by now.dickloraine ought to be getting tired of karma fortunes by now.dickloraine ought to be getting tired of karma fortunes by now.dickloraine ought to be getting tired of karma fortunes by now.dickloraine ought to be getting tired of karma fortunes by now.dickloraine ought to be getting tired of karma fortunes by now.dickloraine ought to be getting tired of karma fortunes by now.dickloraine ought to be getting tired of karma fortunes by now.dickloraine ought to be getting tired of karma fortunes by now.dickloraine ought to be getting tired of karma fortunes by now.dickloraine ought to be getting tired of karma fortunes by now.
 
Posts: 137
Karma: 331650
Join Date: Apr 2013
Location: Berlin
Device: PRS 350, Kobo Aura
If anything else fails, there is always the possibility to sort through a custom column. Make a custom column that consists of other columns and use this to sort.
dickloraine is offline   Reply With Quote
Old 08-20-2014, 12:45 AM   #14
pjmpjm
Member
pjmpjm began at the beginning.
 
Posts: 16
Karma: 10
Join Date: Sep 2013
Device: Kindle
Multiple Sorts

Quote:
Originally Posted by theducks View Post
It does here.

Your Authors may have slight differences (Jonn Smith vs John Q. Smith)
Your Author sort field may be erratic (shows red)

Get the Quality check Plugin. It has all sorts of Metadat checks to help you identify books that need more Metadata help
Thanks to everyone for the sorting feedback. Once you try it out, it's easier than it sounds. Much appreciated.
pjmpjm is offline   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
Problem: Calibre automatically using "sort" fields on devices lavina Library Management 4 03-18-2013 07:27 AM
Parse one field to extract strings for multiple fields with S&R RotAnal Library Management 2 09-29-2012 11:13 AM
Need help with multiple fields freggel99 Library Management 1 06-13-2012 10:54 AM
Multiple Sort martin.hickling Library Management 5 03-13-2011 05:57 AM
Edit MultiData Search and Replace to multiple fields Doug-W Library Management 1 02-22-2011 04:17 PM


All times are GMT -4. The time now is 11:09 AM.


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