Kobo Collections from Calibre column names with prefix?

[rhalina]

Hey

I just received my new Kobo Aura One (and I'm extremely happy with it). I configured Calibre according to https://wiki.mobileread.com/wiki/Kob...nd_Collections to create collections based on the tags and series field in calibre.

What I would love to do is add a prefix to the collection name in order to end up with something like:
"Series: Relevation Space" or
"Tag: Science Fiction"

From how I understand the collection creation works I don't think this is possible because I can either create a collection based on a value within a predefined column or I can add my own column, but there I cannot reference another. If you understand what I mean

Am I overlooking something or is it really not possible?

Please move the thread if it rather belongs to the calibre forum, I wasn't sure.

Thank you!

[davidfor]

You should be able to do this with a custom column. I'm sure I've seen the suggestion before, most likely in the original collections discussion thread.

[JSWolf]

Originally Posted by davidfor

You should be able to do this with a custom column. I'm sure I've seen the suggestion before, most likely in the original collections discussion thread.

Can't this be automated with the tags and series columns? I know it can be done manually.

[Terisa de morgan]

Originally Posted by JSWolf

Can't this be automated with the tags and series columns? I know it can be done manually.

Automated in what sense? At this moment, you can create collections which any columns you like. My collections, indeed, look like:

• #C:Jan 2018
• #C: Holidays
• Romance / Suspense - A
• S: Psy & Changeling

And all of them are created automatically... after the first time I created the custom column.

[Terisa de morgan]

Originally Posted by rhalina

What I would love to do is add a prefix to the collection name in order to end up with something like:
"Series: Relevation Space" or
"Tag: Science Fiction"

From how I understand the collection creation works I don't think this is possible because I can either create a collection based on a value within a predefined column or I can add my own column, but there I cannot reference another. If you understand what I mean

Am I overlooking something or is it really not possible?

I think what you're missing here is that you can create columns which are related to others, so, if you define for adding that prefix and create the collections based on that column, you can have all the information you like.

[rhalina]

Originally Posted by Terisa de morgan

I think what you're missing here is that you can create columns which are related to others, so, if you define for adding that prefix and create the collections based on that column, you can have all the information you like.

Exactly! That's what I want to do. In order to be able to do that I'd need to define a column name which contains another column name. And I don't know a way in which calibre could quote a column name.

[oren64]

Originally Posted by rhalina

What I would love to do is add a prefix to the collection name in order to end up with something like:
"Series: Relevation Space" or
"Tag: Science Fiction"

Originally Posted by rhalina

Exactly! That's what I want to do. In order to be able to do that I'd need to define a column name which contains another column name. And I don't know a way in which calibre could quote a column name.

In the series it easy, add custom column, type column build from other columns, and add this template:

{series:|Series: |}

In tags it a little complicate, do you want to make prefix to all tags or only for a few?

Here for one tag.

program:str_in_list(field('tags'),",", "Science Fiction", "Tag: Science Fiction","")

[rhalina]

Thank you! That is what I was looking for
If I can do it for the series it's already really helpful.

[oren64]

Originally Posted by rhalina

Thank you! That is what I was looking for
If I can do it for the series it's already really helpful.

Go to setting > add your own column > add custom column.

Lookup name: myseries
Column heading: My Series
Column type: Column built from other columns
Template: {series:|Series: |}

ok > apply > restart calibre.

Go to KoboTouch or Kobo Touch Extended driver > Collections > Collections columns > type #myseries.

[rhalina]

Your fist hint was already successful But maybe it's also helpful for other people to have that documented.

Thanks!

[oren64]

Here a template for all tags:

Use a column type: Column built from other columns, behaves like tags.

program:strcat(test(field('tags'), "Tag: ", ""),re(field('tags'),", ", ", Tag: "))

Here a template for specific tags, for example "Mystery, Thriller" you can add more if you like:

program:strcat(test(list_intersection(field('tags'),"Mystery, Thriller", ", "), "Tag: ", ""), re(list_intersection(field('tags'),"Mystery, Thriller", ", "),", ", ", Tag: "))

[davidfor]

Originally Posted by oren64

Here a template for more fore all tags:

program:strcat("Tag: ",re(field('tags'),", ", ", Tag: "))

Slightly simpler (because I can't count all those quotes and commas):

program: strcat('Tag: ', raw_list('tags', ', Tag: '))

I think that's right, but I can't test it right now.

[oren64]

Originally Posted by davidfor

Slightly simpler (because I can't count all those quotes and commas):

program: strcat('Tag: ', raw_list('tags', ', Tag: '))

I think that's right, but I can't test it right now.

It works okay.
I add a test function, to prevent the show of "Tag: " if there is no tags.