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 04-16-2011, 08:58 AM   #1
20LEgend
Connoisseur
20LEgend began at the beginning.
 
Posts: 50
Karma: 10
Join Date: Jan 2011
Location: UK
Device: kindle 3
Need help putting series books in order, plz

Having built up quite a library with Calibre/Kindle I find I have numerous books by the same authors. Some of these may be part of a series and so I want to read them in order. Is there an easy way to place the titles in order, eg drag and drop, or do I have to edit titles, eg title-1, title-2 etc, to know which to read first?
20LEgend is offline   Reply With Quote
Old 04-16-2011, 09:27 AM   #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,225
Karma: 5940081
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by 20LEgend View Post
Having built up quite a library with Calibre/Kindle I find I have numerous books by the same authors. Some of these may be part of a series and so I want to read them in order. Is there an easy way to place the titles in order, eg drag and drop, or do I have to edit titles, eg title-1, title-2 etc, to know which to read first?
A Kindle user will have to help with the Kindle collections part.

NB On a filename based system like my PEz, you put the series index First (using Save to disk/Device Templates): 01-WOT, 02-WOT, 798- WOT so that it sorts in order

But you have to lay the foundation before any the solutions will work.
(Remember the old computer phrase: GIGO. Garbage in = Garbage out)

You need to populate the Series field and THEN set the book number correctly for each title in the list in the Metadata editor.

Series info Does Not belong in the Title of a book in Calibre's Library view.

Check your work (Quality?) it the Series section of the Tag editor. If you see the Series name 2 or more times: Typo or spelling error.
(There is a possible case where two different (author)series have the same name. (I have been lucky to Not have this issue ) You will have to Make the names different Deliberately)

So work on getting all your ducks in a row for when a Kindle specific answer come back.
theducks is online now   Reply With Quote
 
Advertisement
Old 04-16-2011, 09:47 AM   #3
kiwidude
calibre/Sigil Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,230
Karma: 1345754
Join Date: Oct 2010
Location: London, UK
Device: Kindle Paperwhite 3G, iPad 3, iPad Air
As theducks says, getting your Series column in Calibre populated correctly is the key to the best approach.

You might be interested in the Manage Series plugin to assist with that. That will let you drag/drop books into whatever order you like with the intent of setting the series column value correctly. It is just a more powerful/flexible alternative to manually typing in series values or using the edit metadata dialogs.

Once you have done that, then you look to how to order them correctly on your Kindle. The approach I use is with the Metadata plugboards feature (Preferences->Metadata plugboards). Look on the forums, there are examples for Kindle in the sticky thread. I setup a plugboard which means the title metadata inside the book stored on the kindle has series prefixed before it, so you can sort by it. In my case the plugboard I use is this one:
{series:|| }{series_index:0>2s|[|] - }{title}

So I get titles appearing on the Kindle like this:
The First Law [1] - The Heroes

Hope that helps.
kiwidude is offline   Reply With Quote
Old 04-16-2011, 10:57 AM   #4
Lady Fitzgerald
Wizard
Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.
 
Lady Fitzgerald's Avatar
 
Posts: 2,013
Karma: 251649
Join Date: Apr 2010
Location: Tempe, AZ, USA, Earth
Device: JetBook Lite (away from home) + 1 spare, 32" TV (at home)
Quote:
Originally Posted by theducks View Post
...You need to populate the Series field and THEN set the book number correctly for each title in the list in the Metadata editor.

Series info Does Not belong in the Title of a book in Calibre's Library view...
Excuse me? I agree that in the OP's case that the default series column (and a custom subseries column if necessary) is the proper way to go but I strongly disagree with your statement that series info Does Not belong in the title of a book. I always put the series info into the titles of my books and they work just fine in calibre's library view (I also have the info properly entered in series and subseries columns which is what I use for sorting). This way the series info gets carried over into my JBL. It may not appear in order (it would if I did series name, series number, then title but that would destroy caliber's ability to sort by title) but at least I can still select the next book in a series I am reading. If it is a long series, I can always add the series number to the beginning of each title once I copied the books to the
SD card to make finding the next book easier (I haven't found that necessary yet). I realize it is probably different for Kindle and the way I'm doing it probably won't work (I wouldn't be caught dead using Kindle anyway) but to flat say that series info doesn't belong in the title is just wrong.

In my comic library, I'm using a custom series column that is unnumbered (i.e. Archie Comics, Disney Comics, etc.) and just put the series number in the title (i.e. Jughead and Archie Digest No. 034; the title is essentially a subseries name). It works just fine and is way easier to input. Since the title of each comic is the same for all comics in a subseries, as long as I use three digit numbers for the comic number, they will sort just fine in the title column.
Lady Fitzgerald is offline   Reply With Quote
Old 04-16-2011, 11:21 AM   #5
kiwidude
calibre/Sigil Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,230
Karma: 1345754
Join Date: Oct 2010
Location: London, UK
Device: Kindle Paperwhite 3G, iPad 3, iPad Air
Hi Jeannie,

Funnily enough at virtually the same time a user has posted in the Search the Internet plugin thread an example of one "issue" that putting series information into the title caused them.

I know nothing about your device, but it does make it a problem if you ever have a need for just the "raw" title again (which things like metadata searches, plugins etc can all make use of).

You are absolutely correct in terms of Calibre allowing you to do it and if you are happy with it go for it. But I would agree with theducks that it isn't an approach that I personally would recommend unless you are fully aware of all the downstream issues of that choice
kiwidude is offline   Reply With Quote
Old 04-16-2011, 11:32 AM   #6
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,225
Karma: 5940081
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by Lady Fitzgerald View Post
Excuse me? I agree that in the OP's case that the default series column (and a custom subseries column if necessary) is the proper way to go but I strongly disagree with your statement that series info Does Not belong in the title of a book. I always put the series info into the titles of my books and they work just fine in calibre's library view (I also have the info properly entered in series and subseries columns which is what I use for sorting). This way the series info gets carried over into my JBL. It may not appear in order (it would if I did series name, series number, then title but that would destroy caliber's ability to sort by title) but at least I can still select the next book in a series I am reading. If it is a long series, I can always add the series number to the beginning of each title once I copied the books to the
SD card to make finding the next book easier (I haven't found that necessary yet). I realize it is probably different for Kindle and the way I'm doing it probably won't work (I wouldn't be caught dead using Kindle anyway) but to flat say that series info doesn't belong in the title is just wrong.

In my comic library, I'm using a custom series column that is unnumbered (i.e. Archie Comics, Disney Comics, etc.) and just put the series number in the title (i.e. Jughead and Archie Digest No. 034; the title is essentially a subseries name). It works just fine and is way easier to input. Since the title of each comic is the same for all comics in a subseries, as long as I use three digit numbers for the comic number, they will sort just fine in the title column.
We differ.

The 'Title' is what the Author and the copyright page says it is.

Metadata look-up usually fails to retrieve when extra stuff appears in the 'Title'.
OTOH there are exceptions: Like Magazines, where the title is the same and the Volume# or Issue is part of the copyright
Then there is the 'series' that the author declared "Is Not a Series" (MZB about Darkover. In most cases, there is not a 'reading order')
theducks is online now   Reply With Quote
Old 04-16-2011, 12:32 PM   #7
mdietz39
Member
mdietz39 doesn't littermdietz39 doesn't littermdietz39 doesn't litter
 
mdietz39's Avatar
 
Posts: 19
Karma: 200
Join Date: Feb 2011
Location: New Mexico
Device: Kindle v3.1
Quote:
Originally Posted by kiwidude View Post
As theducks says, getting your Series column in Calibre populated correctly is the key to the best approach.

You might be interested in the Manage Series plugin to assist with that. That will let you drag/drop books into whatever order you like with the intent of setting the series column value correctly. It is just a more powerful/flexible alternative to manually typing in series values or using the edit metadata dialogs.

Once you have done that, then you look to how to order them correctly on your Kindle. The approach I use is with the Metadata plugboards feature (Preferences->Metadata plugboards). Look on the forums, there are examples for Kindle in the sticky thread. I setup a plugboard which means the title metadata inside the book stored on the kindle has series prefixed before it, so you can sort by it. In my case the plugboard I use is this one:
{series:|| }{series_index:0>2s|[|] - }{title}

So I get titles appearing on the Kindle like this:
The First Law [1] - The Heroes

Hope that helps.
I have followed Kiwi's suggestion on using a plugboard to prepend the series data to the title on the Kindle display. That way the search the Internet plugin works since the title on Calibre is the title without any additional coding.

However I have one small problem with the template as Kiwi has it. One of my series is "The Chronicles of Narnia". If I use that as the series name on the Kindle I get seven books with a title similar to "The Chronicles of Narnia [01] Th". The series name is too long.

I fixed it by creating a custom column heading of "Series Code" with a type of "Text column for keeping series-like information" and a lookup name of "series_code". This will also create another custom column called "Series Code Index". My template is
"{#seriesname:|| }{#seriesname_index:0>2s|[|] - }{title}"
(all without the quote marks).

Using the value of CN as the series code the Kindle displays the book as "CN [01] - The Lion, The Witch and th". Still missing part because the title is so long but much better than before. Also remember you have to place the correct numeric value in the Series Code index.

Thank you Kiwi for the help. Now if you could only let me know what the next Powerball numbers are I would be an extremely happy camper.
mdietz39 is offline   Reply With Quote
Old 04-16-2011, 06:16 PM   #8
Lady Fitzgerald
Wizard
Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.
 
Lady Fitzgerald's Avatar
 
Posts: 2,013
Karma: 251649
Join Date: Apr 2010
Location: Tempe, AZ, USA, Earth
Device: JetBook Lite (away from home) + 1 spare, 32" TV (at home)
Quote:
Originally Posted by kiwidude View Post
Hi Jeannie,

Funnily enough at virtually the same time a user has posted in the Search the Internet plugin thread an example of one "issue" that putting series information into the title caused them.

I know nothing about your device, but it does make it a problem if you ever have a need for just the "raw" title again (which things like metadata searches, plugins etc can all make use of).

You are absolutely correct in terms of Calibre allowing you to do it and if you are happy with it go for it. But I would agree with theducks that it isn't an approach that I personally would recommend unless you are fully aware of all the downstream issues of that choice
I fail to see what problems can result since I haven't run into any. Here is a sample of a title with series info: The Princes of Dublin (The Dublin Saga, Book 1). Mayhap the way I put it in makes a difference. I have had no trouble when doing title searches.
Lady Fitzgerald 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
putting in books woodmansnow Calibre 3 04-08-2011 03:06 PM
Series which don't have to be read in order? ficbot General Discussions 13 09-04-2010 12:37 AM
series without clear order mkaut Calibre 2 07-06-2009 01:02 AM
Putting a series in numerical order. desertgrandma Calibre 20 03-25-2009 05:19 PM
help: Reading order of Halo series mgrunk Reading Recommendations 13 02-18-2009 03:47 PM


All times are GMT -4. The time now is 08:44 AM.


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