Sorting books in a Catalog

[haino]

Hi

Is it possible to sort Book Descriptions in a catalog in a particular order.

For example, I want to create a catalog of my favourite 50 books and only include the book descriptions in the catalog. I know how to do this
However, I want to order the book descriptions so that my favourite book appears first, then my second, etc.
When I create the catalog it appears to sort the books by author surname as default
Is what I want possible. I know I can reorder the files manually in "Edit Book" or using Sigil but that way is very laborious

Any help would be appreciated.
Thanks
haino

[theducks]

Originally Posted by haino

Hi

Is it possible to sort Book Descriptions in a catalog in a particular order.

For example, I want to create a catalog of my favourite 50 books and only include the book descriptions in the catalog. I know how to do this
However, I want to order the book descriptions so that my favourite book appears first, then my second, etc.
When I create the catalog it appears to sort the books by author surname as default
Is what I want possible. I know I can reorder the files manually in "Edit Book" or using Sigil but that way is very laborious

Any help would be appreciated.
Thanks
haino

AFAIK The Catalog tool (right-click Convert:Catalog) only makes catalogs in a common field form. It does respect the "Selection" of books when launched.

You may need to grow your own
Use the CLI: calibredb.exe --list (options)
See the online CLI documentation for calibredb.exe for the available options include your #priority custom field

once you have the CSV output, use your favorite spreadsheet (Excel/Libre Office...) to sort, format and print

[haino]

Hi
Thanks for your reply
Sorry I dont really understand what you are suggesting or if it would do what I want. I want to end up with a Epub format catalog where the descriptions are in the order I set.
I do not want a a csv file.
Apologies if I have misunderstood what you are suggesting

Thanks

[BetterRed]

Originally Posted by haino

Hi
Thanks for your reply
Sorry I dont really understand what you are suggesting or if it would do what I want. I want to end up with a Epub format catalog where the descriptions are in the order I set.
I do not want a a csv file.
Apologies if I have misunderstood what you are suggesting

Thanks

@haino - There are an number of CSV->HTML converters (free standing and online).

I use a Windows utility called CSV File View, it can rearrange columns and sort them, it's not as fancy as a spreadsheet but 90% of the time it's perfectly adequate. Once you've rearranged and sorted the CSV, export it as HTML and import that into the calibre editor to make an epub.

If you want an arbitrary order then you could either assign a numeric value to a ranking column, or move rows around in a spreadsheet.

Caveat - it will be in the form of table.

BR

[theducks]

Originally Posted by haino

Hi
Thanks for your reply
Sorry I dont really understand what you are suggesting or if it would do what I want. I want to end up with a Epub format catalog where the descriptions are in the order I set.
I do not want a a csv file.
Apologies if I have misunderstood what you are suggesting

Thanks

You did fail to mention you wanted it in EPUB .
Using a spreadsheet would allow you to sort anyway you wanted. CSV is a common spreadsheet input format.
OTOH CSV format does not do cover images

What you want (custom col sort) is not possible as is. Given how long the Catalog has been stable, I don't see effort being done to add that feature.
You can include your Priority field (EPUB options:at bottom) in the comments