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 09-22-2013, 01:28 PM   #1
phlois
Junior Member
phlois began at the beginning.
 
Posts: 4
Karma: 10
Join Date: Sep 2013
Device: Kobo Touch
Column Title sort

Hello,

I have a column "Title" but I want create and display a column "Title sort" but I dont know how to do.

Please, help me
phlois is offline   Reply With Quote
Old 09-22-2013, 01:54 PM   #2
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: 31,054
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by phlois View Post
Hello,

I have a column "Title" but I want create and display a column "Title sort" but I dont know how to do.

Please, help me
? Why

Sort problems (red in the title sort box in the editor) can be found using the Quality Check Plugin, usually allowing to allow a quick fix with Bulk edit
theducks is offline   Reply With Quote
Old 09-22-2013, 02:54 PM   #3
phlois
Junior Member
phlois began at the beginning.
 
Posts: 4
Karma: 10
Join Date: Sep 2013
Device: Kobo Touch
No, it isnt a sort problem, I just want to create a column where it is displayed the fields "Title sort" of the metadata.
phlois is offline   Reply With Quote
Old 09-22-2013, 03:17 PM   #4
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: 31,054
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by phlois View Post
No, it isnt a sort problem, I just want to create a column where it is displayed the fields "Title sort" of the metadata.
If you set the Title sort Tweak to "Strictly Alphabetical" you won't need the column.

If I come across negative: there are many reasons NOT to do what you try.

Performance: if using a calculated field on large libraries
data integrity(timeliness): If using a static field
confusion, 'I edited the title sort' because edits don't post back to the real field
theducks is offline   Reply With Quote
Old 09-22-2013, 10:00 PM   #5
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 9,896
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen
Quote:
Originally Posted by theducks View Post
confusion, 'I edited the title sort' because edits don't post back to the real field
I don't believe you can edit a column built from other columns except to change the column it is derived from.

Quote:
Originally Posted by phlois View Post
No, it isnt a sort problem, I just want to create a column where it is displayed the fields "Title sort" of the metadata.
Go to Preferences - Add your own columns, click the plus icon to the right and follow the image below.



After you create the column you may have to right click any column header and select Show column the select Title sort to see the column.
Attached Thumbnails
Click image for larger version

Name:	titlesortcolumn.jpg
Views:	836
Size:	37.3 KB
ID:	111887  

Last edited by DoctorOhh; 09-22-2013 at 10:09 PM.
DoctorOhh is offline   Reply With Quote
Old 09-23-2013, 03:15 AM   #6
Sabardeyn
Guru
Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.
 
Sabardeyn's Avatar
 
Posts: 644
Karma: 1242364
Join Date: May 2009
Location: The Right Coast
Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)
Phlos,
If you are looking to create a unique sort order for your library you will have to do as DoctorOhh has suggested, which is to create a custom column or derived custom column to store the data.

What theducks was talking about might not have been clear. You mentioned columns title and title_sort - which already exist in the calibre database and are reserved column names. So your request to create a "title sort" looks like you want to simply change the way calibre handles sorting.

To change the existing title_sort function there are a few tweaks under Preferences>Tweaks that can be changed. This includes whether or not Articles of Speech (A, The, An, etc) appearing at the beginning of a book title is used or ignored for the purpose of displaying books in order in the main book view. Another tweak allows you to specify user language and that language's equivalents to the Articles of Speach. Or you can add completely new words to the Articles listing. There are others as well.

Perhaps we've misunderstood what you wanted to accomplish with your request to add a "title sort"? In that case, post a few of the problem books. Give us the correct title and the incorrect title so that we can see what is wrong and recommend how it can be fixed.

Last edited by Sabardeyn; 09-23-2013 at 03:18 AM.
Sabardeyn is offline   Reply With Quote
Old 09-23-2013, 04:38 AM   #7
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 9,896
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen
Quote:
Originally Posted by Sabardeyn View Post
Quote:
Originally Posted by phlois View Post
Quote:
Originally Posted by theducks View Post
Quote:
Originally Posted by phlois View Post
Hello,

I have a column "Title" but I want create and display a column "Title sort" but I dont know how to do.

Please, help me
? Why

Sort problems (red in the title sort box in the editor) can be found using the Quality Check Plugin, usually allowing to allow a quick fix with Bulk edit
No, it isnt a sort problem, I just want to create a column where it is displayed the fields "Title sort" of the metadata.
Perhaps we've misunderstood what you wanted to accomplish with your request to add a "title sort"?
I'm going to go out on a limb here, but the request seems clearly stated to me. What the OP wants to accomplish is to create and display a column called "Title sort."

Despite what has been stated there is no Title Sort column in calibre. If he wants a column called "Title Sort" great!

Why? Who the heck cares?

For the life of me I just don't understand trying to psychoanalyze a simple request for assistance. If the answer ends up not being exactly what the OP wants I'm sure he will come back for additional assistance in a new thread.

Last edited by DoctorOhh; 09-23-2013 at 04:45 AM.
DoctorOhh is offline   Reply With Quote
Old 09-23-2013, 08:23 AM   #8
Sabardeyn
Guru
Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.Sabardeyn ought to be getting tired of karma fortunes by now.
 
Sabardeyn's Avatar
 
Posts: 644
Karma: 1242364
Join Date: May 2009
Location: The Right Coast
Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)
I read Phlois' request and interpreted it to mean that (s)he might have wanted a custom sorting scheme. However, with limited comments it was difficult to tell for sure. Further comments from Phlois will make the issue clear, if needed.
Sabardeyn is offline   Reply With Quote
Old 09-23-2013, 10:59 AM   #9
phlois
Junior Member
phlois began at the beginning.
 
Posts: 4
Karma: 10
Join Date: Sep 2013
Device: Kobo Touch
Quote:
Originally Posted by DoctorOhh View Post
Go to Preferences - Add your own columns, click the plus icon to the right and follow the image below.
....
After you create the column you may have to right click any column header and select Show column the select Title sort to see the column.
Hurray, that's exactly what I want !!!!

Thank you all for your help.
I'm french and my english is not perfect, that's why my explanations are also not perfect, but, you have undersand my request.
phlois 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
Set title sort to be the same as title lizzielou Library Management 19 02-14-2018 05:30 AM
change 'sort by title' with 'title' jcarlier Calibre 17 09-20-2013 06:26 AM
Is it possible to sort a custom column like authors or title? arspr Library Management 2 03-15-2011 04:44 PM
Can I auto enter numbers to title/title sort? blu- Library Management 19 02-16-2011 01:01 PM
Multi column sort? nexus100 Calibre 1 07-11-2010 11:19 PM


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


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