Add custom columns to Calibre catalog

Sirtel · 06-24-2015, 03:53 PM

I apologize if it's been answered elsewhere, I searched, but could find no definite answer. Is it possible to add multiple custom columns to epub or mobi catalog? Yes, you can replace Genre with a custom column, but what of multiple columns? You can also add prefixes and merge custom data with comments (and I'm very grateful for these options), but they are not sortable. I tried to make a composite column and replace Genre with that, but there is no option to replace Genre with a composite column... unless I missed something.
In short, I would like to know if such a thing is possible at all.
Thanks for any help.

Sirtel · 07-05-2015, 08:13 PM

So it seems not to be possible, as no one has answered. For example, if I want the books in my catalog sorted not only by author, title and genre, but also by reading status (custom column), it cannot be done? They can be sorted by genre OR by reading status (if I replace Genre with Status column), but not by both?

theducks · 07-05-2015, 09:15 PM

You can Filter

#read:true (or false)

Sirtel · 07-05-2015, 09:29 PM

Quote:

Originally Posted by theducks

You can Filter

#read:true (or false)

In the catalog? In Calibre, of course, I can filter and sort every way I want. But I can't filter in epub or mobi catalog, can I?
Perhaps my question was badly worded. I meant, is it possible to add multiple custom columns and sort by them in epub or mobi catalog, not in Calibre library itself.

theducks · 07-05-2015, 09:32 PM

Quote:

Originally Posted by Sirtel

In the catalog? In Calibre, of course, I can filter and sort every way I want. But I can't filter in epub or mobi catalog, can I?
Perhaps my question was badly worded. I meant, is it possible to add multiple custom columns and sort by them in epub or mobi catalog, not in Calibre library itself.

If you make a (pre) Filtered catalog
Create Catalog respects the Selected items
You will end up with a separate 'Read' catalog

Sirtel · 07-05-2015, 09:45 PM

Yes, that seems to be the only option, to make several separate catalogs (my reading status column isn't yes/no, unfortunately, there are many other choices). I would prefer all my data in one catalog. But if it can't be done, it can't.
Oh well. Perhaps it will be possible sometime in the future.

theducks · 07-05-2015, 09:49 PM

Quote:

Originally Posted by Sirtel

Yes, that seems to be the only option, to make several separate catalogs (my reading status column isn't yes/no, unfortunately, there are many other choices). I would prefer all my data in one catalog. But if it can't be done, it can't.
Oh well. Perhaps it will be possible sometime in the future.

True finds entries. false finds blanks (undefined)

you can use any valid query #read:<50

MiniMouse · 07-23-2015, 12:50 PM

Quote:

Originally Posted by Sirtel

Yes, that seems to be the only option, to make several separate catalogs (my reading status column isn't yes/no, unfortunately, there are many other choices). I would prefer all my data in one catalog. But if it can't be done, it can't.
Oh well. Perhaps it will be possible sometime in the future.

I don't know if this is still something of interest to you but I thought that might at least be a bit of help for your catalog.

Though you can't select a composite column to be sortable (and believe me, I really would love to have that too), you at least can change the title in the section lists by now and use a composite column for that (thanks again to @chaley for doing that for me... and of course for everyone who loves that function too

).

That gives you now a chance to see more info in your catalog as title. For example: I'm reading a lot of fanfiction, so the important infos for me are - word-count, series, rating, completed/in-progress and read yes/no. I made a composite column that gives me these infos. So for example the title 'Blood is Thicker' looks in my catalog

author and series section: Blood is Thicker - 5* (49,313) [C]
(I don't need the series info here because the info is already displayed in the calatog.)

title section: Blood is Thicker - 5* (49,313) - 001. Brothers [C]

And for read yes/no I use the prefixes in the catalog to give me a little 'x' before the title in every section when I have read a book.

I can't sort by that but I can at least see everything important for me in the title!

Maybe that helps.

Mini

Sirtel · 07-24-2015, 02:03 AM

Thank you for the idea, MiniMouse. It's certainly something to consider.

06-24-2015, 03:53 PM	#1
Sirtel Grand Sorcerer Posts: 10,142 Karma: 224760044 Join Date: Jan 2014 Location: Estonia Device: Kobo Sage & Libra 2	Add custom columns to Calibre catalog I apologize if it's been answered elsewhere, I searched, but could find no definite answer. Is it possible to add multiple custom columns to epub or mobi catalog? Yes, you can replace Genre with a custom column, but what of multiple columns? You can also add prefixes and merge custom data with comments (and I'm very grateful for these options), but they are not sortable. I tried to make a composite column and replace Genre with that, but there is no option to replace Genre with a composite column... unless I missed something. In short, I would like to know if such a thing is possible at all. Thanks for any help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Searching Calibre Custom Columns	BlueGoose1776	Library Management	1	02-09-2015 02:58 PM
Metadata(_('Unknown')) : How To Dynamically Add Custom Columns To Definition	DaltonST	Development	11	08-27-2014 01:29 AM
Custom Columns and metadata.calibre	cryzed	Library Management	0	06-04-2013 06:00 PM
Custom Columns do not appear when calibre restarted	bigbird1227	Calibre	20	11-11-2012 05:32 AM
including custom columns in epub catalog	Jade Aislin	Library Management	2	07-13-2012 09:36 AM

07-05-2015, 08:13 PM	#2
Sirtel Grand Sorcerer Posts: 10,142 Karma: 224760044 Join Date: Jan 2014 Location: Estonia Device: Kobo Sage & Libra 2	So it seems not to be possible, as no one has answered. For example, if I want the books in my catalog sorted not only by author, title and genre, but also by reading status (custom column), it cannot be done? They can be sorted by genre OR by reading status (if I replace Genre with Status column), but not by both?

07-05-2015, 09:15 PM	#3
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	You can Filter #read:true (or false)

07-05-2015, 09:45 PM	#6
Sirtel Grand Sorcerer Posts: 10,142 Karma: 224760044 Join Date: Jan 2014 Location: Estonia Device: Kobo Sage & Libra 2	Yes, that seems to be the only option, to make several separate catalogs (my reading status column isn't yes/no, unfortunately, there are many other choices). I would prefer all my data in one catalog. But if it can't be done, it can't. Oh well. Perhaps it will be possible sometime in the future.

07-24-2015, 02:03 AM	#9
Sirtel Grand Sorcerer Posts: 10,142 Karma: 224760044 Join Date: Jan 2014 Location: Estonia Device: Kobo Sage & Libra 2	Thank you for the idea, MiniMouse. It's certainly something to consider.

Advert

Advert