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 02-14-2014, 01:35 PM   #1
hroberts89436
Junior Member
hroberts89436 began at the beginning.
 
Posts: 4
Karma: 10
Join Date: Oct 2010
Device: nook
Series Management Help

Ok Here is what I am working on and hopefully someone can give me a simple way to make these changes.

I have over 8,000 books in Calibre. Most of them are parts of series. For instance. I have all of the Star Wars books. So trying to make changes to the Series layout so that they are in order. I have labeled them as such:
Star Wars 2.1: Darth Plagueis [1-??] (however many there are)
Star Wars 2.2: Legacy of the Jedi [1-??]
...

My Issue has come when I get to Star Wars 1.10: The Phantom Menace. This wants to list below 2.1 and before 2.2, so I figured I needed to go back in and add a 0 to the front of 2.1 and 2.2 to make it 2.01, and 2.02 so they list in order. This seems to work. However there are sometimes 15 or more books per series. Is there a way to edit the DB directly or somewhere else where I can make one change to the Series and all items with that series name changes to show the correction. And I have also noticed that I now need to add a 0 infront of 2.01 and 2.02 to make it 02.01, and 02.02 in order for the series to be in proper order.

Some of my other programs have each series listed within a separate DB where you can edit it there and make 1 change that affects the entire series, and not sure if that capability is within Calibre.
hroberts89436 is offline   Reply With Quote
Old 02-14-2014, 02:05 PM   #2
eschwartz
Irrational Optimist
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.
 
Posts: 6,176
Karma: 9911980
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch (Wifi only)
I use the series column to list such books in the overall series [Star Wars] order, then use a custom column called #subseries to put in the [Legacy of the Force]/[Fate of the Jedi]/etc. ordering. Then I sort by Series and they are all in order, but I can use individual series ordering and reference in the title via a plugboard.

Last edited by eschwartz; 02-14-2014 at 04:17 PM.
eschwartz is offline   Reply With Quote
 
Enthusiast
Old 02-14-2014, 04:11 PM   #3
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: 14,707
Karma: 5643657
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
or Hierarchical

Starwars.Fate of the Jedi
The series is only numbered on the last layer (Fate..)
theducks is online now   Reply With Quote
Old 02-14-2014, 04:14 PM   #4
eschwartz
Irrational Optimist
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.
 
Posts: 6,176
Karma: 9911980
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch (Wifi only)
Quote:
Originally Posted by theducks View Post
or Hierarchical

Starwars.Fate of the Jedi
The series is only numbered on the last layer (Fate..)
How does that let you choose which order each series goes into?
eschwartz is offline   Reply With Quote
Old 02-14-2014, 04:17 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: 14,707
Karma: 5643657
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by eschwartz View Post
How does that let you choose which order each series goes into?
It only belongs to Fates order
but does also allow a (double +) search in the Tag browser on Starwars, which shows all Starwars books
theducks is online now   Reply With Quote
Old 02-14-2014, 04:18 PM   #6
hroberts89436
Junior Member
hroberts89436 began at the beginning.
 
Posts: 4
Karma: 10
Join Date: Oct 2010
Device: nook
theducks: In order to actually read the series in order their are multiple layers of series orders Please see this link to see what I mean: http://en.wikipedia.org/wiki/List_of_Star_Wars_books

The same goes with the series Riftwar. They are designed to be read in a specific order from The riftwar saga 1-3, then The Empire Trilogy 1-3, and so forth. Large book series can have multiple series within them.

Eschwartz: How do you do this? In my thinking it seems like it would still place Fate of the Jedi before Legacy of the Jedi seeing as how F comes before L, when Legacy is number 2.2 in the series and Fate is 6.4 in the series.

Thanks for the replies.

Harold
hroberts89436 is offline   Reply With Quote
Old 02-14-2014, 04:18 PM   #7
eschwartz
Irrational Optimist
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.
 
Posts: 6,176
Karma: 9911980
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch (Wifi only)
Using my title plugboard, I end up with "Book Title (#subseries, Book #) (Star Wars, Book #)". In the library GUI the Series column keeps them all in order according to "series:Star Wars" which is where in the overall canon order the book goes. Although I admit I haven't actually gotten around to sorting the order out yet.

Similarly,
Code:
title:        Magician's End
Series:       Riftwar [27]
#subseries:   ChaosWar Saga [3]
For listing in order, go with main series/universe order. Then list #subseries (custom column, type "Text column for keeping series-like information") afterward, where it won't interfere with the sort order.

Last edited by eschwartz; 02-14-2014 at 04:27 PM.
eschwartz is offline   Reply With Quote
Old 02-14-2014, 04:26 PM   #8
hroberts89436
Junior Member
hroberts89436 began at the beginning.
 
Posts: 4
Karma: 10
Join Date: Oct 2010
Device: nook
What I would like to see is separate Linked Data Bases within Calibre. Where Series is one DB, Author is another, Publisher is another. That way I can edit the series in the Series DB, and the change populates to all of the books within that series. Take for instance the Rogue Angel series. Their are currently 43 books within the series. If I want to make a change to them. I have to make the change to 43 different books. Instead of making the change once.

Another reason behind this is. Lets say I have all of the rogue Angel books except number 15. I can't edit in bulk, and have calibre re number them for me because it would make #16 #15, #17 #16, and so forth down the line. If the name were in a separate linked DB, I could edit just the name and it would populate without affecting the series number.
hroberts89436 is offline   Reply With Quote
Old 02-14-2014, 04:30 PM   #9
eschwartz
Irrational Optimist
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.
 
Posts: 6,176
Karma: 9911980
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch (Wifi only)
Just add in the series number yourself. There is also this tweak:

Code:
ID: series_index_auto_increment

The algorithm used to assign a book added to an existing series a series number.
New series numbers assigned using this tweak are always integer values, except
if a constant non-integer is specified.
Possible values are:
next - First available integer larger than the largest existing number
first_free - First available integer larger than 0
next_free - First available integer larger than the smallest existing number
last_free - First available integer smaller than the largest existing number
Return largest existing + 1 if no free number is found
const - Assign the number 1 always
no_change - Do not change the series index
a number - Assign that number always. The number is not in quotes. Note that
0.0 can be used here.
Examples:
series_index_auto_increment = 'next'
series_index_auto_increment = 'next_free'
series_index_auto_increment = 16.5

Set the use_series_auto_increment_tweak_when_importing tweak to True to
use the above values when importing/adding books. If this tweak is set to
False (the default) then the series number will be set to 1 if it is not
explicitly set during the import. If set to True, then the
series index will be set according to the series_index_auto_increment setting.
Note that the use_series_auto_increment_tweak_when_importing tweak is used
only when a value is not provided during import. If the importing regular
expression produces a value for series_index, or if you are reading metadata
from books and the import plugin produces a value, than that value will
be used irrespective of the setting of the tweak.
eschwartz is offline   Reply With Quote
Old 02-14-2014, 04:31 PM   #10
eschwartz
Irrational Optimist
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.
 
Posts: 6,176
Karma: 9911980
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch (Wifi only)
Quote:
Originally Posted by theducks View Post
It only belongs to Fates order
but does also allow a (double +) search in the Tag browser on Starwars, which shows all Starwars books
That is not the goal.
eschwartz is offline   Reply With Quote
Old 02-14-2014, 04:39 PM   #11
hroberts89436
Junior Member
hroberts89436 began at the beginning.
 
Posts: 4
Karma: 10
Join Date: Oct 2010
Device: nook
Quote:
Originally Posted by eschwartz View Post
Just add in the series number yourself. There is also this tweak:

How do I use this code. Or where do I enter the Subseries information? Is there away to add another field to the DB/ Input Screen?
hroberts89436 is offline   Reply With Quote
Old 02-14-2014, 04:41 PM   #12
unboggling
by the bootstraps
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,052
Karma: 858115
Join Date: Jan 2011
Location: Southeast US
Device: PRS-T2, Nexus 7, KindleT, iPad1, Kindle3KB
For the Title "Krondor- The Assassins", this is in my only Series column:

Riftwar 05; Riftwar Legacy $ [2]

That construction is:
(broadest-series-name)(space)(most-specific-subseries#);(space)
(most-specific-subseries-name)(space)(varied-author-series-symbol)(space)
([series_index])

I use semicolon rather than period to indicate hierarchy because semicolon looks better and I don't need to see hierarchic breakdown in Tag Browser. The "$" indicates varied-author-series, a clue to sort by title within series rather than sort by title within series within author.

Edit: But that doesn't address the OP's question about automatically renumbering a chosen level of multi-level hierarchical series. Calibre can handle automatic renumbering of only one level per each series-like column, the level that the index applies to, one series-like column at a time.

Last edited by unboggling; 02-14-2014 at 05:41 PM.
unboggling is offline   Reply With Quote
Old 02-14-2014, 04:52 PM   #13
eschwartz
Irrational Optimist
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.
 
Posts: 6,176
Karma: 9911980
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch (Wifi only)
Preferences ==> Advanced ==> Tweaks. On the left, choose the option "Auto increment series index", see screenshot below (note that tweaks you have edited are bolded and appear on top).

Subseries is a custom column, created in Preferences ==> Interface ==> Add your own columns. (see screenshot 2) Name it whatever you want.
Attached Thumbnails
Click image for larger version

Name:	calibre-tweaks-series-increment.png
Views:	74
Size:	186.0 KB
ID:	119098   Click image for larger version

Name:	calibre-custom-series-column.png
Views:	61
Size:	35.5 KB
ID:	119100  
eschwartz is offline   Reply With Quote
Old 08-23-2014, 03:26 AM   #14
Ma'am-I-Am
Member
Ma'am-I-Am began at the beginning.
 
Ma'am-I-Am's Avatar
 
Posts: 13
Karma: 10
Join Date: Jun 2014
Location: Seattle, WA, USA
Device: Kindle Paperwhite
How do I edit the Series database? I prefer my Series as only the first letters capitalized: Star Wars. However, when Adding books, sometimes the series name is all caps - STAR WARS - which means if I add another book in that series it's all caps, too. Then I have to edit the metadata individually - which is OK, but I'd rather it defaulted to my preferred style.
Ma'am-I-Am is offline   Reply With Quote
Old 08-23-2014, 09:15 AM   #15
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: 14,707
Karma: 5643657
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by Ma'am-I-Am View Post
How do I edit the Series database? I prefer my Series as only the first letters capitalized: Star Wars. However, when Adding books, sometimes the series name is all caps - STAR WARS - which means if I add another book in that series it's all caps, too. Then I have to edit the metadata individually - which is OK, but I'd rather it defaulted to my preferred style.
Authors, Title and Series have a right click option to change case: <Title case> might meet your needs

The same case tool is also in the Metadata editor

AND
If in bulk mode: Only Title has a fix case tick box
theducks is online now   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
Series management.. Nova5 Nook Developer's Corner 0 01-09-2014 06:47 PM
Series Management Little_bear Library Management 5 11-20-2012 07:20 PM
Management of Large Series? TechSarge Library Management 3 08-09-2012 10:46 PM
Book management: Series vs Tags vs Cetegory citron Library Management 4 05-07-2012 11:05 PM
Book Series management centuryx476 Devices 5 01-28-2012 07:44 PM


All times are GMT -4. The time now is 12:34 PM.


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