Custom Column to display Virtual Libraries

thinkblot · 12-28-2016, 12:57 AM

Hi all,

I've been trying to create a custom column in Calibre that displays the virtual libraries to which each book belongs. I want to do this so I can see/use my virtual libraries in Calibre Companion.

I've followed these instructions exactly: http://cc_faq.multipie.co.uk/index.php?solution_id=1023

But it keeps resulting in this error:

Code:

#collection:"=TEMPLATE ERROR maximum recursion depth exceeded while calling a Python object"

After trying it out a few times (and variations based on what I read in the manual on templates), I decided to try the option "Column built from other columns" (without the "behaves like tags" part) and..it worked! I don't understand!

It would be better if I could get this custom column to behave like tags (so each combination is not treated as separate). Am I missing something here? I used the exact same template function. Not sure why I can't get it to work.

I'd appreciate any help or advice!

chaley · 12-28-2016, 02:52 AM

The template works for me, so unfortunately it isn't obvious why it doesn't work for you.

Questions:

How many virtual libraries do you have?
What version of calibre are you running?
Do any other columns built from other columns reference #collection

The easiest way to debug this is probably for you to send me a copy of your metadata.db, preferably one that contains the error. I need only the db file, no books. Send it to calibre-bugs at charles dot haleys dot org. If it is large, more than a megabyte or so, please zip it first.

thinkblot · 12-28-2016, 02:09 PM

Thank you, chaley!

Your response (and the part about other columns referencing #collection) got me thinking about why it wouldn't work for my library.

I had used a custom column with the lookup name #collection before, when I was manually sorting books into different virtual libraries. I had deleted it, so I thought I could re-use the lookup name.

It turns out that I had defined #collection as "hierarchical" elsewhere in the preferences and that hadn't been deleted. Once I removed that, everything worked as expected.

Thank you for your help!!

12-28-2016, 12:57 AM	#1
thinkblot Junior Member Posts: 4 Karma: 10 Join Date: Dec 2016 Device: iPad	Custom Column to display Virtual Libraries Hi all, I've been trying to create a custom column in Calibre that displays the virtual libraries to which each book belongs. I want to do this so I can see/use my virtual libraries in Calibre Companion. I've followed these instructions exactly: http://cc_faq.multipie.co.uk/index.php?solution_id=1023 But it keeps resulting in this error: Code: #collection:"=TEMPLATE ERROR maximum recursion depth exceeded while calling a Python object" After trying it out a few times (and variations based on what I read in the manual on templates), I decided to try the option "Column built from other columns" (without the "behaves like tags" part) and..it worked! I don't understand! It would be better if I could get this custom column to behave like tags (so each combination is not treated as separate). Am I missing something here? I used the exact same template function. Not sure why I can't get it to work. I'd appreciate any help or advice!

12-28-2016, 02:52 AM	#2
chaley Grand Sorcerer Posts: 12,525 Karma: 8065948 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	The template works for me, so unfortunately it isn't obvious why it doesn't work for you. Questions: How many virtual libraries do you have? What version of calibre are you running? Do any other columns built from other columns reference #collection The easiest way to debug this is probably for you to send me a copy of your metadata.db, preferably one that contains the error. I need only the db file, no books. Send it to calibre-bugs at charles dot haleys dot org. If it is large, more than a megabyte or so, please zip it first.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Please help with virtual libraries and custom filters/categories	cazatomada	Library Management	4	07-11-2016 10:21 AM
Custom Column not needed in other Libraries	MerlinMama	Calibre	9	06-01-2016 08:09 PM
Display Custom Column at Startup	MULTIVAC	Calibre	6	04-21-2015 12:45 PM
Custom column virtual library	MerlinMama	Library Management	3	11-04-2014 12:09 PM
Custom Columns and Virtual Libraries	Soxendom	Library Management	3	05-25-2013 10:43 AM

12-28-2016, 02:09 PM	#3
thinkblot Junior Member Posts: 4 Karma: 10 Join Date: Dec 2016 Device: iPad	Thank you, chaley! Your response (and the part about other columns referencing #collection) got me thinking about why it wouldn't work for my library. I had used a custom column with the lookup name #collection before, when I was manually sorting books into different virtual libraries. I had deleted it, so I thought I could re-use the lookup name. It turns out that I had defined #collection as "hierarchical" elsewhere in the preferences and that hadn't been deleted. Once I removed that, everything worked as expected. Thank you for your help!!

Advert