Catalog Confusion

[BetterRed]

Originally Posted by Tanjamuse

I'm going with the LibraOffice solution.

I've also considered creating a db-file like sqlite but I don't know how to

<snip>

The DB Browser utility can import a csv into a sqlite database table, here's a 2 min video:



I'm not sure what you're doing with the CSV, but if you are examining it whilst looking at another library in the regular calibre GUI then maybe you could use CalibreSpy.

BR

[Tanjamuse]

I'll take a look at that later. Any chance of you knowing how to add the second custom column in the icon rule?

[BetterRed]

Originally Posted by Tanjamuse

Any chance of you knowing how to add the second custom column in the icon rule?

Not off the top of my head. I'm not entirely sure I understand what you want.

How about defining a 'dummy' column (integer) shown with no text, with two rules that show the same icon - 'uninteresting.png'. The first would interrogate 'Cloud' custom column, and the second the 'Lists' User Category.

BR

[Tanjamuse]

I have an user category called Uninteresting in that category are different kind of tags, relationships, and sometimes authors which aren't interesting.

The icon rule is set up to be anything that has information in the Cloud column shouldn't get the icon for Uninteresting.

I would like to add another column to that, one called Lists. So when I've added something to one of 2 different lists it wouldn't show the icon for uninteresting even if it has a tag of some kind already in the Uninteresting.

As I've asked in the thread for User Category, I would love to be able to add rules in the User Category but that's not possible I guess.

[BetterRed]

Sorry I have no idea, maybe chaley will drop in, he can probably give you a solution.

BR

[ilovejedd]

Originally Posted by Tanjamuse

The icon rule is set up to be anything that has information in the Cloud column shouldn't get the icon for Uninteresting.

I would like to add another column to that, one called Lists. So when I've added something to one of 2 different lists it wouldn't show the icon for uninteresting even if it has a tag of some kind already in the Uninteresting.

Should be this right?

icon = test (or(field ('#cloud'),field ('#lists')), '', 'list_uninteresting.png');

[Tanjamuse]

Yeah, thanks that did the trick

[ilovejedd]

Posting the PM here since you're likely to get more input and it might help others, too.

Originally Posted by Tanjamuse

I have the following category, which you gave me part of:

program:
    uc = user_categories();
    icon = test (or(field ('#cloud'),field ('#lists')), '', 'list_uninteresting.png');
    str_in_list(uc,',','Uninteresting',icon,'')

I have added sub categories to the Uninteresting category but would like to have this rule apply to all sub categories, do I have to add them all (and how do I formulate that) or can there be a rule for just the top one (Uninteresting) and then the rest of them will also use that?

I'm actually not sure. To be honest, I don't use icon rules and have only recently started dipping my toes into User Categories.

Looking at the Calibre function reference for str_in_list, it seems like it should only apply to the top Uninteresting category.

Perhaps you could use (contains) instead?

contains(uc,'Uninteresting',icon,'')

[Tanjamuse]

The "contains" solution looks to be working, I'll do some more tests and see if it holds up.

Thanks a bunch for solving it for me.