Exported catalog title sort order

tranquilo2 · 08-20-2020, 02:07 PM

I have a custom numerical column "Order". Within the library it works fine, but when creating an epub catalog I would like to show the titles sorted by the Order column and, if possible, to show the Order number as a prefix to the Title; something like this:

1. Z x x xxx
2. A xxx x x
3. G x x x x
etc.

Can this be done?

Thank you!

theducks · 08-20-2020, 02:39 PM

Look at the commandline tool: calibredb --list
it has (lots of others too) sort options
Then use your FAV spreadsheet to format and add anything else.

tranquilo2 · 08-20-2020, 03:19 PM

Thank You. If I understand correctly I have to first create a spreadsheet, edit it so the rows are sorted as required and the columns show the text I want. Then I use that spreadsheet as input to Calibre and convert it to epub. Correct?

theducks · 08-20-2020, 05:02 PM

Calibredb --list should already be sorted if you used the right arguments.
but, yes, you need to jump thru hoops to get Your arbitrary sort. (but you wanted Line numbers.

Look at some of the output options in your office suite (I use Libre Office), that may give you word processing output options

Nope, the Reading List PI only allows Calibre viewing

tranquilo2 · 08-20-2020, 05:39 PM

Yes, it looks like there's no easy way to do it from within Calibre so I think I will roll my own epub catalog, built from scratch using html exported by Calibre as source, and then edited as needed.
Thank You!

08-20-2020, 02:07 PM	#1
tranquilo2 Member Posts: 23 Karma: 10 Join Date: Jan 2015 Device: none	Exported catalog title sort order I have a custom numerical column "Order". Within the library it works fine, but when creating an epub catalog I would like to show the titles sorted by the Order column and, if possible, to show the Order number as a prefix to the Title; something like this: 1. Z x x xxx 2. A xxx x x 3. G x x x x etc. Can this be done? Thank you!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing sort order and title	jgt1942	Library Management	9	12-08-2023 03:47 PM
Save to disk title sort order different for series vs standalone books?	threebluestars	Library Management	0	01-06-2020 11:36 PM
Catalog, sort sequence for Title in german language	Divingduck	Library Management	1	07-06-2012 08:33 AM
Help!, PRS650, Plugboard, book sort order rearranged into a new title	Glubbish	Calibre	11	11-30-2010 03:38 PM
[Old Thread] Incorrect title sort order	SkyDream	Calibre	12	07-07-2010 03:03 AM

08-20-2020, 02:39 PM	#2
theducks Well trained by Cats Posts: 29,809 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Look at the commandline tool: calibredb --list it has (lots of others too) sort options Then use your FAV spreadsheet to format and add anything else.

08-20-2020, 03:19 PM	#3
tranquilo2 Member Posts: 23 Karma: 10 Join Date: Jan 2015 Device: none	Thank You. If I understand correctly I have to first create a spreadsheet, edit it so the rows are sorted as required and the columns show the text I want. Then I use that spreadsheet as input to Calibre and convert it to epub. Correct?

08-20-2020, 05:02 PM	#4
theducks Well trained by Cats Posts: 29,809 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Calibredb --list should already be sorted if you used the right arguments. but, yes, you need to jump thru hoops to get Your arbitrary sort. (but you wanted Line numbers. Look at some of the output options in your office suite (I use Libre Office), that may give you word processing output options Nope, the Reading List PI only allows Calibre viewing

08-20-2020, 05:39 PM	#5
tranquilo2 Member Posts: 23 Karma: 10 Join Date: Jan 2015 Device: none	Yes, it looks like there's no easy way to do it from within Calibre so I think I will roll my own epub catalog, built from scratch using html exported by Calibre as source, and then edited as needed. Thank You!

Advert

Advert