Sorting the book titles (Feature Request)

Ortep · 11-28-2009, 04:26 AM

When sorting the books on title that is done by alphabet. That is normaly fine, but there are a lot of bookts that start with the word 'The' So they are all grouped together. Is it possible to sort on the second word and move the first wordt to the back?

So a title like 'The Adventures of John Doe' would become 'Adventures of John Doe, The'

And if it is possible, it would be nice be able to be able to make a list of words that are handled this way. In Dutch we have two of 'those' words, De and Het. Perhaps the French would like something like this for Le and La

HarryT · 11-28-2009, 04:30 AM

Quote:

Originally Posted by Ortep

When sorting the books on title that is done by alphabet. That is normaly fine, but there are a lot of bookts that start with the word 'The' So they are all grouped together. Is it possible to sort on the second word and move the first wordt to the back?

So a title like 'The Adventures of John Doe' would become 'Adventures of John Doe, The'

Could you not simply enter your titles in this format, if that's what you prefer to do?

rhmorrison · 11-28-2009, 05:40 AM

Quote:

Originally Posted by Ortep

When sorting the books on title that is done by alphabet. That is normaly fine, but there are a lot of bookts that start with the word 'The' So they are all grouped together. Is it possible to sort on the second word and move the first word to the back?

So a title like 'The Adventures of John Doe' would become 'Adventures of John Doe, The'

I don't know about other languages but in calibre 0.6.24 it sorts just as you want:

pdurrant · 11-28-2009, 05:52 AM

While one could re-write the titles as a work-around, it's quite common for lists of titles (in English) to ignore "A" and "The".

So it sounds like a reasonable feature request to me. Ideally there's would be a list of excluded words for each language, and it would also be good to add the book's language to the metadata.

Quote:

Originally Posted by HarryT

Could you not simply enter your titles in this format, if that's what you prefer to do?

Javed · 11-28-2009, 07:16 AM

Quote:

Originally Posted by rhmorrison

I don't know about other languages but in calibre 0.6.24 it sorts just as you want:

Yes it already ignores "the" as a prefix in the title.

Kirtai · 11-28-2009, 07:32 AM

Doesn't that happen by default with both The and A?

Ortep · 11-28-2009, 08:14 AM

Quote:

Originally Posted by Javed

Yes it already ignores "the" as a prefix in the title.

I never realised that it already worked like that in the English version. I only used the example to make my point. It would be great if the words that are treated in this way could be on a user controlled list. Then it would be completely language independent and people who don't want this behaviour simply keep he list empty.

JayCeeEll · 11-28-2009, 09:28 AM

You may be interested in the paper by 2007 Ig Noble winner Glenda Browne

Quote:

for her study of the word "the" -- and of the many ways it causes problems for anyone who tries to put things into alphabetical order

available at The Indexer, vol 22, no. 3 (pdf)

kovidgoyal · 11-28-2009, 10:19 AM

For non english languages this feature will have to wait until support for book language is added to the metadata. As this requiresd atabase changes, it is a low priority, but it will happen eventually.

EliNoah · 11-28-2009, 10:37 AM

I don't know if this is the place or not, but I would LOVE to be able to print a booklist from Calibre.

I try to keep lists of what I read so that I know if I have read that book or not. (read a lot of authors like Nora Roberts, etc) I hate reading books twice, but it happens.

Being able to print all my titles would help with this.

Then I would have a lists of both ebooks and paperbooks when I go to a bookstore.

I tried highlighting and copying and pasting, but it did not work. Having a print function would be GREAT!

theducks · 11-28-2009, 11:08 AM

Quote:

Originally Posted by EliNoah

I don't know if this is the place or not, but I would LOVE to be able to print a booklist from Calibre.

I try to keep lists of what I read so that I know if I have read that book or not. (read a lot of authors like Nora Roberts, etc) I hate reading books twice, but it happens.

Being able to print all my titles would help with this.

Then I would have a lists of both ebooks and paperbooks when I go to a bookstore.

I tried highlighting and copying and pasting, but it did not work. Having a print function would be GREAT!

Use the command line utilities:
I made a batch ( .bat ) file that contained my desired options.

Code:

calibredb list -w 132 -f authors,series,series_index,title,timestamp  --sort-by timestamp --ascending > foo.txt

foo.txt is my output file that can be view/edited or printed (landscape since I made it 132 chars wide so as to not wrap/truncate)

I sorted my list with the NEWER stuff at the top (timestamp --ascending)
The command line documentation has the full list of fields and options you can use.

rhmorrison · 11-28-2009, 01:01 PM

Quote:

Originally Posted by Kirtai

Doesn't that happen by default with both The and A?

YES, both 'The' and 'A' are ignored by the sorting in Calibre.

banjomike · 11-28-2009, 02:08 PM

Quote:

Originally Posted by theducks

Code:

calibredb list -w 132 -f authors,series,series_index,title,timestamp  --sort-by timestamp --ascending > foo.txt

I sorted my list with the NEWER stuff at the top (timestamp --ascending)
The command line documentation has the full list of fields and options you can use.

If I use your code I get a list sorted with the newest stuff at the bottom. I removed '--ascending' and get the list with with the newest at the top.

Neat idea though.

theducks · 11-28-2009, 02:59 PM

Quote:

Originally Posted by banjomike

If I use your code I get a list sorted with the newest stuff at the bottom. I removed '--ascending' and get the list with with the newest at the top.

Neat idea though.

Top <-> Bottom

I wanted top

and probably forgot to fix the bat file....
Doing so, right now. Done

Seemed to be a convoluted way

to get a list on my PEz of the latest additions.

EliNoah · 11-29-2009, 10:01 AM

Quote:

Originally Posted by theducks

Use the command line utilities:
I made a batch ( .bat ) file that contained my desired options.

Code:

calibredb list -w 132 -f authors,series,series_index,title,timestamp  --sort-by timestamp --ascending > foo.txt

foo.txt is my output file that can be view/edited or printed (landscape since I made it 132 chars wide so as to not wrap/truncate)

I sorted my list with the NEWER stuff at the top (timestamp --ascending)
The command line documentation has the full list of fields and options you can use.

I am sorry, but I don't know what this means...where do I find the command line utilities? Is it the search function?

11-28-2009, 04:26 AM	#1
Ortep Fanatic Posts: 527 Karma: 470 Join Date: Sep 2007 Location: The Netherlands Device: Kindle Oasis	Sorting the book titles (Feature Request) When sorting the books on title that is done by alphabet. That is normaly fine, but there are a lot of bookts that start with the word 'The' So they are all grouped together. Is it possible to sort on the second word and move the first wordt to the back? So a title like 'The Adventures of John Doe' would become 'Adventures of John Doe, The' And if it is possible, it would be nice be able to be able to make a list of words that are handled this way. In Dutch we have two of 'those' words, De and Het. Perhaps the French would like something like this for Le and La

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Feature Request - replace "screensavers" with randomly selected book covers from libr	nathander13	Calibre	3	12-02-2009 12:21 PM
Feature request	mrmikel	EPUBReader	4	11-20-2009 11:49 AM
Request/Questions About Sorting and Navigation	movieking	Calibre	13	08-26-2009 02:55 PM
[Feature Request] Folder sorting schemes for people with HUGE collections	PotentChr0nic	Calibre	1	06-22-2009 07:18 PM
Sorting Titles on PDA	mifty12@ntlworl	Reading and Management	0	09-04-2007 01:11 AM

11-28-2009, 07:32 AM	#6
Kirtai Addict Posts: 304 Karma: 2454436 Join Date: Sep 2008 Device: PRS-505, PRS-650, iPad, Samsung Galaxy SII (JB), Google Nexus 7 (2013)	Doesn't that happen by default with both The and A?

11-28-2009, 10:19 AM	#9
kovidgoyal creator of calibre Posts: 43,835 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	For non english languages this feature will have to wait until support for book language is added to the metadata. As this requiresd atabase changes, it is a low priority, but it will happen eventually.

11-28-2009, 10:37 AM	#10
EliNoah Enthusiast Posts: 34 Karma: 10 Join Date: Oct 2009 Device: Sony ereader Pocket Edition	I don't know if this is the place or not, but I would LOVE to be able to print a booklist from Calibre. I try to keep lists of what I read so that I know if I have read that book or not. (read a lot of authors like Nora Roberts, etc) I hate reading books twice, but it happens. Being able to print all my titles would help with this. Then I would have a lists of both ebooks and paperbooks when I go to a bookstore. I tried highlighting and copying and pasting, but it did not work. Having a print function would be GREAT!

Advert

Advert