Creating a Catalog of Books Question

[GreywolfofKansas]

Please forgive me if this has been asked by others, I had asked this in another post and felt that perhaps it needed it's own topic to be seen by more experienced techies out there. I have gotten my settings where I get the author and title sorts the way I want them: Titles with the prefix on the end of the name such as The, A, An, etc.. And I have my Authors showing up First Name Last Name.. That's all fine.. What I can't figure out is how to have it output the SERIES name the same as the title, where the prefixes are applied to the end of the series name. It makes it so hard when trying to go through the list and have a load of books show up under A for A or An being the prefix, or T for THE. Is there any way to tweak the actual SERIES output in the create a catalog so that we have this option. We have the title and title_sort, Author and Author_sort, but only have Series. I think this is something that Calibre really should at least offer in the future, or if someone knows how to configure the internal settings to do so, I would greatly appreciate it.

[BetterRed]

Well, the data exists in the SQLite database (see attachment), and it appears to be used if you sort on Series, but it doesn't seem to available as a calibre column - Publisher is in the same boat. I wonder why they're not regular columns?

Maybe there's a way of exposing the series.sort SQLite column as calibre custom column via a template.

Failing that try asking DaltonST if he could add a SeriesSort and a PublisherSort feature to his Job Spy plugin.

BR

[chaley]

There is a series_sort template function. Depending on what the OP is doing, one can use the function directly in a template or create a composite custom column containing the series_sort value.

The series sort value in the database is kept up to date but is not used AFAICT.

The publisher sort in the database is not kept up to date. AFAIK the notion of publisher sort distinct from publisher doesn't exist in calibre.

[BetterRed]

Originally Posted by chaley

There is a series_sort template function. Depending on what the OP is doing, one can use the function directly in a template or create a composite custom column containing the series_sort value.

The series sort value in the database is kept up to date but is not used AFAICT.

The publisher sort in the database is not kept up to date. AFAIK the notion of publisher sort distinct from publisher doesn't exist in calibre.

- just noticed, you've relocated

@GreywolfofKansas create a custom column thusly:



The Template value must be {:'series_sort()'} precisely, ftr those are straight quotes. After adding, changing or removing a custom column you must restart.

et voilà, the Series Sort column should now be in the CSV Field list.

BR

[GreywolfofKansas]

AWESOME Job! Thank you all so much for the help!!

[chaley]

Originally Posted by BetterRed

- just noticed, you've relocated

Yea, just in time to get thrown out on March 29.

The move is why I haven't been able to keep up with things. All of our stuff is still in storage, and are flat is full of construction dust. Maybe in 3 months or so...