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 11-11-2015, 06:44 AM   #1
Phssthpok
Evangelist
Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.
 
Posts: 432
Karma: 95229
Join Date: Nov 2014
Device: Horrible Kindle
Books in multiple series

Can anyone suggest a good way to manage books which are part of more than one series? For example, later Isaac Asimov books which are part of both the Robots and Foundation series; Larry Niven's "Fate of Worlds", which is the conclusion of both the "Fleet of Worlds" and "Ringworld" series; various books by P.G. Wodehouse which are both Blandings Castle and Jeeves books; and so on. The result is that I end up with what seem to be gaps in various series, even though the gaps are filled (but by a book from a different series).

Since I can't label books as belonging to more than one series (unless Kovid is willing to completely change his database design, which I strongly doubt!), I'm at a loss what to do.

Of course, I blame the authors for letting their characters flit around with such disregard for their confused audience...

How do other people deal with this? Is there anything I can do apart from shut up and live with it?

TIA for any advice...
Phssthpok is offline   Reply With Quote
Old 11-11-2015, 09:15 AM   #2
mbovenka
Wizard
mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.mbovenka ought to be getting tired of karma fortunes by now.
 
Posts: 1,759
Karma: 6543219
Join Date: Oct 2007
Location: Almere, The Netherlands
Device: Kobo Forma
Quote:
Originally Posted by Phssthpok View Post
Since I can't label books as belonging to more than one series (unless Kovid is willing to completely change his database design, which I strongly doubt!), I'm at a loss what to do.
Custom column? I think you can make one that behaves like the series one.
mbovenka is offline   Reply With Quote
Advert
Old 11-11-2015, 10:30 AM   #3
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,285
Karma: 83106505
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
I use the series column for the "main" series, which tracks that universe.


Then I use a custom column that acts like a series, called #subseries.
This contains the individual series', e.g. individual trilogies.
eschwartz is offline   Reply With Quote
Old 11-11-2015, 10:53 AM   #4
Turtle91
A Hairy Wizard
Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.
 
Turtle91's Avatar
 
Posts: 1,781
Karma: 11941128
Join Date: Dec 2012
Location: Charleston, SC today
Device: iPhone X/6/iPad 1,2 & Air/Surface Pro/Kindle PW
Just wondering. If you perform a search or a filter on the series field or tag will it also pickup the sub-series custom column?
Turtle91 is offline   Reply With Quote
Old 11-11-2015, 11:02 AM   #5
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,285
Karma: 83106505
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
No, because when you limit a search to a specific column it doesn't also search other columns with similar-sounding names...
eschwartz is offline   Reply With Quote
Advert
Old 11-11-2015, 11:03 AM   #6
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: 85,536
Karma: 82356324
Join Date: Nov 2006
Location: UK
Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6
Quote:
Originally Posted by Turtle91 View Post
Just wondering. If you perform a search or a filter on the series field or tag will it also pickup the sub-series custom column?
It would only do so if you included the column in the search. ie "series=x or subseries=x" (using whatever the correct search syntax is, of course!)
HarryT is offline   Reply With Quote
Old 11-11-2015, 11:17 AM   #7
Turtle91
A Hairy Wizard
Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.
 
Turtle91's Avatar
 
Posts: 1,781
Karma: 11941128
Join Date: Dec 2012
Location: Charleston, SC today
Device: iPhone X/6/iPad 1,2 & Air/Surface Pro/Kindle PW
I wonder if it would be too difficult to identify a custom column as a "sub" of another column during the creation process? I would think that would make it easier to search/filter on columns/tags and their subs.

An alternate thought would be to enable multiple series in the same column like they do with multiple authors...


edit: stinkin' broken "t" button on my keyboard ...
Turtle91 is offline   Reply With Quote
Old 11-11-2015, 11:22 AM   #8
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: 23,270
Karma: 24326584
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by Turtle91 View Post
Just wondering. If you perform a search or a filter on the series field or tag will it also pickup the sub-series custom column?
For Similar... (in the context menu)
Preferences: Searching (near the bottom) Define as needed, as both columns

edit

BTW you can use this definition name instead of the column in regular searches

Last edited by theducks; 11-11-2015 at 11:23 AM. Reason: Added BTW
theducks is offline   Reply With Quote
Old 11-11-2015, 11:28 AM   #9
chaley
Grumpy old git
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: 8,964
Karma: 2737706
Join Date: Jan 2010
Location: UK
Device: Many android devices
Quote:
Originally Posted by Turtle91 View Post
Just wondering. If you perform a search or a filter on the series field or tag will it also pickup the sub-series custom column?
Yes, if you use calibre's "grouped search terms" feature (Preferences / Searching). You create a "search term", which is in effect a pseudo-column that contains all the values in the columns it references. For example, you can create the term all_series that references the columns series, #mysubseries, and #mysubseries2. When you search using all_series:foo, calibre will look for foo in all three of the series columns.
chaley is offline   Reply With Quote
Old 11-11-2015, 11:32 AM   #10
Turtle91
A Hairy Wizard
Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.Turtle91 ought to be getting tired of karma fortunes by now.
 
Turtle91's Avatar
 
Posts: 1,781
Karma: 11941128
Join Date: Dec 2012
Location: Charleston, SC today
Device: iPhone X/6/iPad 1,2 & Air/Surface Pro/Kindle PW
Quote:
Originally Posted by chaley View Post
Yes, if you use calibre's "grouped search terms" feature (Preferences / Searching). You create a "search term", which is in effect a pseudo-column that contains all the values in the columns it references. For example, you can create the term all_series that references the columns series, #mysubseries, and #mysubseries2. When you search using all_series:foo, calibre will look for foo in all three of the series columns.
Sweet! Thanks Chaley/Ducks/Harry/Eschwartz!

Last edited by Turtle91; 11-11-2015 at 11:45 AM.
Turtle91 is offline   Reply With Quote
Old 11-11-2015, 01:58 PM   #11
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,285
Karma: 83106505
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
Quote:
Originally Posted by chaley View Post
Yes, if you use calibre's "grouped search terms" feature (Preferences / Searching). You create a "search term", which is in effect a pseudo-column that contains all the values in the columns it references. For example, you can create the term all_series that references the columns series, #mysubseries, and #mysubseries2. When you search using all_series:foo, calibre will look for foo in all three of the series columns.
Forgot to mention that part!
eschwartz is offline   Reply With Quote
Old 11-13-2015, 07:10 AM   #12
Phssthpok
Evangelist
Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.
 
Posts: 432
Karma: 95229
Join Date: Nov 2014
Device: Horrible Kindle
Quote:
Originally Posted by eschwartz View Post
I use the series column for the "main" series, which tracks that universe.
In most cases there isn't a main series in that sense; there are usually two well-defined series which occasionally overlap, where it wouldn't make sense to make one series a subseries of the other.
Phssthpok is offline   Reply With Quote
Old 11-13-2015, 07:16 AM   #13
Phssthpok
Evangelist
Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.
 
Posts: 432
Karma: 95229
Join Date: Nov 2014
Device: Horrible Kindle
Quote:
Originally Posted by chaley View Post
Yes, if you use calibre's "grouped search terms" feature (Preferences / Searching). You create a "search term", which is in effect a pseudo-column that contains all the values in the columns it references. For example, you can create the term all_series that references the columns series, #mysubseries, and #mysubseries2. When you search using all_series:foo, calibre will look for foo in all three of the series columns.
That sounds like it might be exactly what I'm looking for!

Next question: can I persuade the catalogue tool to use this all_series pseudo-column instead of the regular series column, so that the same book will appear twice (once for each series it belongs to) in the various series listings that it generates? (There's a list of series under each author, and also a separate stand-alone alphabetical list of series.)
Phssthpok is offline   Reply With Quote
Old 11-13-2015, 07:21 AM   #14
Phssthpok
Evangelist
Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.Phssthpok knows how to set a laser printer to stun.
 
Posts: 432
Karma: 95229
Join Date: Nov 2014
Device: Horrible Kindle
Quote:
Originally Posted by Turtle91 View Post
An alternate thought would be to enable multiple series in the same column like they do with multiple authors...
That would be ideal, but without knowing much about Calibre's database design I have no idea how easy it would be to implement...
Phssthpok is offline   Reply With Quote
Old 11-13-2015, 07:55 AM   #15
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,285
Karma: 83106505
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
Quote:
Originally Posted by Phssthpok View Post
In most cases there isn't a main series in that sense; there are usually two well-defined series which occasionally overlap, where it wouldn't make sense to make one series a subseries of the other.
Huh?

They are usually both a subseries of something.

Raymond E. Feist's Riftwar series, for example, some twenty-odd books in about 8 component trilogies, none of which IIRC are called "Riftwar".
The Legend of Drizzt, likewise a series of trilogies all of which are caled something different.

I am sure you are imaginative enough to figure something out.

Quote:
Originally Posted by Phssthpok View Post
That would be ideal, but without knowing much about Calibre's database design I have no idea how easy it would be to implement...
"Nontrivial".

The issue has come up before.
eschwartz 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
Enabling entry of multiple books of same series for Boxed Sets hashken Calibre 15 12-17-2017 09:31 PM
Sony problem - multiple books from series Perkin Devices 14 12-14-2014 12:31 AM
Multiple similar books series Noughty Calibre 4 02-01-2012 07:04 AM
Numbering Series - Multiple Books in One dunedragn Library Management 10 02-21-2011 10:51 AM
<Command Line> Add multiple books in multiple formats himitsu Calibre 8 09-25-2010 11:07 PM


All times are GMT -4. The time now is 06:32 AM.


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