Curious: column icons storage

BetterRed · Yesterday, 07:45 PM

@chaley - Are column icons ever stored anywhere other than the cc_icons folder in the calibre config folder — e.g. as encoded strings in the database.

I 'lost' my %appdata%\calibre\cc_icons\transparent_square.png (moved it instead of copying it), but its presence seemed to show up in some column-icon rules but not others.

theducks · Yesterday, 09:26 PM

Wouldn't it need to be IN the DB as the icons could be different for different libraries?

SQL spy might lead you there

BetterRed · Yesterday, 10:31 PM

The png's in cc_icons are a common resource - I use the same icons across multiple libraries - usually for similar purpose, e.g. transparent_square as a visual place holder.

I spotted this one, not sure what that encoding is about, its the only rule that has it,

Code:

[
      "icon",
      "authors",
      "program:\n# BasicColorRule():5b226d6167617a696e652e706e67222c205b5b22666f726d617473222c2022686173222c2022455055424649584544225d5d5d\ntest(str_in_list(field('formats'), ',', \"EPUBFIXED\", '1', ''), 'magazine.png', '');\n"
    ],

My problem was due to me moving a png from cc_icons to the desktop rather than copying it.

Comfy.n · Today, 06:21 AM

Out of curiosity, I made a test with an icon rule, like this:

- ran a search that would match the rule. icon shows.(just to confirm the rule is ok)
- deleted the icon from cc_icons (while keeping the recycle bin folder open on explorer, calibre kept open as well)
- ran same search by hitting the search button again, icon is gone.
- restored the icon from recycle bin, hit search button again. icon shows.

This was a non transparent icon. Then I renamed a transparent icon in cc_icons to match the same rule and test gave same results

Yesterday, 07:45 PM	#1
BetterRed null operator (he/him) Posts: 22,044 Karma: 30277960 Join Date: Mar 2012 Location: Sydney Australia Device: none	Curious: column icons storage @chaley - Are column icons ever stored anywhere other than the cc_icons folder in the calibre config folder — e.g. as encoded strings in the database. I 'lost' my %appdata%\calibre\cc_icons\transparent_square.png (moved it instead of copying it), but its presence seemed to show up in some column-icon rules but not others. Last edited by BetterRed; Yesterday at 10:34 PM. Reason: spelling error

Yesterday, 10:31 PM	#3
BetterRed null operator (he/him) Posts: 22,044 Karma: 30277960 Join Date: Mar 2012 Location: Sydney Australia Device: none	The png's in cc_icons are a common resource - I use the same icons across multiple libraries - usually for similar purpose, e.g. transparent_square as a visual place holder. I spotted this one, not sure what that encoding is about, its the only rule that has it, Code: [ "icon", "authors", "program:\n# BasicColorRule():5b226d6167617a696e652e706e67222c205b5b22666f726d617473222c2022686173222c2022455055424649584544225d5d5d\ntest(str_in_list(field('formats'), ',', \"EPUBFIXED\", '1', ''), 'magazine.png', '');\n" ], My problem was due to me moving a png from cc_icons to the desktop rather than copying it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Uses for column icons	ownedbycats	Library Management	4	10-21-2021 10:19 AM
Composed column icons: Is there a way to make it appear after non-composed icons?	ownedbycats	Calibre	3	07-13-2020 07:06 PM
Tip for those using emblems/column colouring/column icons	ownedbycats	Library Management	0	07-05-2020 08:07 PM
added custom column icons render larger than original icons	masp	Library Management	12	01-22-2019 05:07 PM
customized column icons now Micro-icons	Gary_M_Mugford	Calibre	10	09-05-2016 05:05 AM

Yesterday, 09:26 PM	#2
theducks Well trained by Cats Posts: 31,325 Karma: 62025226 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Wouldn't it need to be IN the DB as the icons could be different for different libraries? SQL spy might lead you there

Today, 06:21 AM	#4
Comfy.n want to learn what I want Posts: 1,688 Karma: 7908443 Join Date: Sep 2020 Device: none	Out of curiosity, I made a test with an icon rule, like this: - ran a search that would match the rule. icon shows.(just to confirm the rule is ok) - deleted the icon from cc_icons (while keeping the recycle bin folder open on explorer, calibre kept open as well) - ran same search by hitting the search button again, icon is gone. - restored the icon from recycle bin, hit search button again. icon shows. This was a non transparent icon. Then I renamed a transparent icon in cc_icons to match the same rule and test gave same results

Advert