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-2018, 11:33 PM   #1
please55
Enthusiast
please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.
 
Posts: 47
Karma: 72010
Join Date: Nov 2014
Device: none
Tweak Series To Achieve non Alphabetic Sort?

I'm trying to reorder a series column so it ends up sorting differently.

Example:
Book 1 -> Sword of Truth.Chainfire [1]
Book 2 -> Sword of Truth.Darken Rahl [1]

In this case I would like Book 2 to show up first in library. What different methods could I use to achieve that?
please55 is offline   Reply With Quote
Old 08-13-2018, 12:25 AM   #2
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 4,827
Karma: 21644938
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Aura One, Aura H2O, Aura HD, Nexus 7 HD, iPad Air, Tolino epos
Quote:
Originally Posted by please55 View Post
I'm trying to reorder a series column so it ends up sorting differently.

Example:
Book 1 -> Sword of Truth.Chainfire [1]
Book 2 -> Sword of Truth.Darken Rahl [1]

In this case I would like Book 2 to show up first in library. What different methods could I use to achieve that?
You might try adding the book position in the Sword of Truth series to the first part of the series though, at least for me, this involves a subseries column.

I.e. Sword of Truth [03] is the main series and Darken Rahl [01] is the subseries for Sword of Truth, Sword of Truth [11] is the main series and Chainfire [01] is the subseries for Chainfire, Sword of Truth [10] and Pristinely Ungifted [02] for the Naked Empire.

At one point, I did redo what I own of the series so that the main series order is chronological. That is The First Confessor: The Legend of Magda Searus is Sword of Truth [01] and Prequel [01].
DNSB is offline   Reply With Quote
Old 08-13-2018, 01:10 AM   #3
please55
Enthusiast
please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.
 
Posts: 47
Karma: 72010
Join Date: Nov 2014
Device: none
Very cool. Just to make sure, your method necessitates a second custom column to do right? No way to keep it all together even using the "." hierarchy?
please55 is offline   Reply With Quote
Old 08-13-2018, 10:43 AM   #4
please55
Enthusiast
please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.
 
Posts: 47
Karma: 72010
Join Date: Nov 2014
Device: none
Any other takers on this problem? Still doing my own research, found a post to old forums suggesting this.

Quote:
Numerical Pathing: Use numbers in a specific format to account for series position. Various output methods: "Universe 1, Saga 3, Book 12", 001-003-012, or anything else that works for you. Three or four digits, with preceding zeros to force correct display, can account for the longest running publications (mags, comics, etc). Note the text between numbers is a "divider" and consistently displayed, allowing no variability (null values are not displayed).
Numerical Subgrouping: Basically as above, but subgrouping might deal with forking better as it allows data to be a cross-section of the records. Appears as: 001.003.012.
(http://www.mobileread.mobi/forums/sh...d.php?t=203689 ; post 6)

I wanted to try numerical subgrouping to have a feel of it. Series column doesn't allow multiple periods. So sounds like a job for a custom column? Should I use comma separated text, like tags?
please55 is offline   Reply With Quote
Old 08-13-2018, 12:47 PM   #5
please55
Enthusiast
please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.please55 did not drink the Kool Aid.
 
Posts: 47
Karma: 72010
Join Date: Nov 2014
Device: none
Okay here's what I've settled on so far. Don't know if its most elegant or how I could improve on it. Please let me know.

Ex.
Wizard's First Rule (Part of Darken Rahl saga which is 1st)
Phantom (Part of Chainfire saga which comes 2nd).

Note that the saga order naturally doesn't follow alphabetical order.

So I've decided to use hierarchies in series column to classify them respectively:
Sword of Truth.Darken Rahl [1] (Wizard's First Rule)
Sword of Truth.Chainfire [2] (Phantom)

This tells me that Wizard's is the first book in Darken Rahl Saga of Sword of Truth universe and Phantom is the second book in the Chainfire Saga.

Ideally I would just use a subseries custom column but I don't want to add yet another column to the book list view to see at a glance which universe/saga a book is a part of.

Instead I created a hidden column seriessort (I don't know which column type I should use, I went with long text. Should I do otherwise?). Then for Wizard's First Rule I set it to 001.001. Phantom would be 002.002.

Now I can sort by Author, then Seriessort. This way Darken Rahl saga will show up first instead of Chainfire.

Last edited by please55; 08-13-2018 at 05:04 PM.
please55 is offline   Reply With Quote
Old 08-13-2018, 03:35 PM   #6
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 4,827
Karma: 21644938
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Aura One, Aura H2O, Aura HD, Nexus 7 HD, iPad Air, Tolino epos
Quote:
Originally Posted by please55 View Post
Very cool. Just to make sure, your method necessitates a second custom column to do right? No way to keep it all together even using the "." hierarchy?
I've been using a custom column. For me, it was the easiest solution.
DNSB 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
Author Sort Name Algorithm Tweak phossler Calibre 3 07-05-2018 12:02 PM
alphabetic sort on title field jcarlier Calibre 6 09-18-2013 12:26 PM
Tweak: Sort Columns at Startup Coronach Library Management 3 10-15-2012 02:11 PM
FYI @Charles: article sort tweak and autosort/automerge Starson17 Calibre 7 10-22-2010 07:55 AM
Article tweak for title sort not working Manichean Calibre 2 10-04-2010 11:56 AM


All times are GMT -4. The time now is 05:30 PM.


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