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-02-2013, 03:41 AM   #1
jpcavri
Microelectronic, retired
jpcavri began at the beginning.
 
jpcavri's Avatar
 
Posts: 6
Karma: 10
Join Date: Jan 2013
Device: EEPAD ASUS transformer
sort books display with multiple criteria

I wonder if it is possible to sort books with more than one criteria like:
"Author" then "publication date" then ...
Thanks
jpcavri is offline   Reply With Quote
Old 01-02-2013, 04:29 AM   #2
bookworm2000
Junior Member
bookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the rough
 
Posts: 7
Karma: 7220
Join Date: Dec 2012
Device: Kindle 4, Kindle for Android
You can do this in at least three different ways:

1) Click on the head of the "Published" column, THEN "Author"...

2) For more complicated sorts prepare a custom column with a template like

Code:
{author_sort} - {series}{series_index:0>2s| - | - }{title_sort}
When you click on that column your books will be listed as Author last name-> first name -> series (if available) -> series index -> title

3) Install the View Manager plugin. With that you can configure different views (including sort orders).

Last edited by bookworm2000; 01-02-2013 at 04:32 AM.
bookworm2000 is offline   Reply With Quote
Old 01-02-2013, 04:38 AM   #3
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 63,656
Karma: 41565251
Join Date: Nov 2006
Location: UK
Device: PW2, iPad Retina Mini, iPhone 4, MS Surface Pro, Onyx T68, N7,
Note that you can set the default sort order in the "Tweaks". I have mine set by default to sort first by author, and then by series within author.
HarryT is offline   Reply With Quote
Old 01-02-2013, 10:32 AM   #4
jpcavri
Microelectronic, retired
jpcavri began at the beginning.
 
jpcavri's Avatar
 
Posts: 6
Karma: 10
Join Date: Jan 2013
Device: EEPAD ASUS transformer
Sort books disay

Thanks,
But I'm a bit lost:
1/If I click one one column, this one is selected and when I click to an other one, the fist is unselected and the second becomes the selected one.
2/ I cant understand how to write this magic formula
3/Where can I found this view manager plugin.
Sorry for my ignorance but I will do do my best to progress (there is a lot of room and I am retired).



Quote:
Originally Posted by bookworm2000 View Post
You can do this in at least three different ways:

1) Click on the head of the "Published" column, THEN "Author"...

2) For more complicated sorts prepare a custom column with a template like

Code:
{author_sort} - {series}{series_index:0>2s| - | - }{title_sort}
When you click on that column your books will be listed as Author last name-> first name -> series (if available) -> series index -> title

3) Install the View Manager plugin. With that you can configure different views (including sort orders).
jpcavri is offline   Reply With Quote
Old 01-02-2013, 10:52 AM   #5
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 63,656
Karma: 41565251
Join Date: Nov 2006
Location: UK
Device: PW2, iPad Retina Mini, iPhone 4, MS Surface Pro, Onyx T68, N7,
Quote:
Originally Posted by jpcavri View Post
Thanks,
But I'm a bit lost:
1/If I click one one column, this one is selected and when I click to an other one, the fist is unselected and the second becomes the selected one.
When you click first one column header, and then a second, the sort order of the first is preserved within the second. So if you want to sort by author, and then sort by title within author, click first the "Title" column header, and then the "Author" column header. ie, you work from the "inside out".
HarryT is offline   Reply With Quote
Old 01-02-2013, 01:00 PM   #6
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
HarryT's explanation above is absolutely correct, but let me go into a little more detail.

When you click on Author, the books are sorted by author, but for each author, the previous order of the books is preserved. So, for instance, if you have the following books:

Smith, John: Just Some Book 2, the Sequel (published 1923)
Johnson, Bob: This Is My Book (published 1920)
Smith, John: Just Some Book (published 1919)

If you sort by author, the books will end up like this:

Johnson, Bob: This Is My Book (published 1920)
Smith, John: Just Some Book 2, the Sequel (published 1923)
Smith, John: Just Some Book (published 1919)

Note that for John Smith, the books are in the wrong order by publication date, because they were in the wrong order by publication date before you sorted them.

How to fix this is to first sort by publication date:

Smith, John: Just Some Book (published 1919)
Johnson, Bob: This Is My Book (published 1920)
Smith, John: Just Some Book 2, the Sequel (published 1923)

This puts all the books in publication date order, so that when you sort by author:

Johnson, Bob: This Is My Book (published 1920)
Smith, John: Just Some Book (published 1919)
Smith, John: Just Some Book 2, the Sequel (published 1923)

this puts Bob Johnson before John Smith, but otherwise leaves the order of John Smith's alone, i.e. it preserves the publication date because that's how they were sorted before.

This works for three, four, or any number of sort order levels. Sort by the most specific criterion, then by the next most specific, and so on up to the most general. It's counterintuitive, but once you get used to it, it's really no big deal.
fidvo is offline   Reply With Quote
Old 01-02-2013, 01:31 PM   #7
bookworm2000
Junior Member
bookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the rough
 
Posts: 7
Karma: 7220
Join Date: Dec 2012
Device: Kindle 4, Kindle for Android
Quote:
Originally Posted by jpcavri View Post
2/ I cant understand how to write this magic formula
a) If you right-click on any column header a list of options appear. Choose "Add your own columns" (the last one). A new window will open, listing all your columns.

b) Press "Add a user-defined column" (at the bottom or the green "+").

c) Another window will appear. Choose a lookup name (e.g. "sort") and a column heading (e.g. "Sort"). For column type choose "Column built from other columns".

d) Copy the template from my first post to "Template". If you want to create your own templates I strongly recommend to read the Calibre template language manual.

e) Choose "Text" in the "Search column by" field.

SEE THE ATTACHED SCREENSHOT FOR AN OPTICAL REPRESENTATION OF THESE INSTRUCTIONS.

f) Click "OK". You will return to the last window. Click "Apply". When you're asked choose "Restart calibre now"

g) Calibre will restart. Your "Sort" column should now be visible. Click it's header once to sort ascending or twice to sort descending.
Attached Thumbnails
Click image for larger version

Name:	screenshot.jpg
Views:	48
Size:	102.1 KB
ID:	98622  
bookworm2000 is offline   Reply With Quote
Old 01-02-2013, 01:44 PM   #8
bookworm2000
Junior Member
bookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the roughbookworm2000 is a jewel in the rough
 
Posts: 7
Karma: 7220
Join Date: Dec 2012
Device: Kindle 4, Kindle for Android
Quote:
Originally Posted by jpcavri View Post
3/Where can I found this view manager plugin.
a) Click on "Preferences"

b) Choose "Plugins"

c) In the new window click on "Get new plugins".

d) Choose the "View Manager" plugin and click "Install".


I hope this helps.
bookworm2000 is offline   Reply With Quote
Old 01-03-2013, 02:14 AM   #9
jpcavri
Microelectronic, retired
jpcavri began at the beginning.
 
jpcavri's Avatar
 
Posts: 6
Karma: 10
Join Date: Jan 2013
Device: EEPAD ASUS transformer
Thanks to all,
You answers fulfill all my requests.
Calibre is really one of the best software!
Sorry for my English language but as you Frenches are among the worst foreign language speakers
Jean-Pierre
jpcavri 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
Multiple authors on one book won't sort JollyRoger Calibre 9 07-19-2012 09:43 AM
Author Sort Name Algorithm and multiple libraries texasnightowl Calibre 11 06-14-2012 10:34 PM
Author Name Display and Sort theducks Library Management 18 07-06-2011 09:50 AM
MOBI stuck on author sort display mdietz39 Library Management 2 05-14-2011 07:41 AM
Multiple Sort martin.hickling Library Management 5 03-13-2011 04:57 AM


All times are GMT -4. The time now is 08:57 PM.


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