[Library Closed Plugin] Save Composite Custom Columns - Page 2

Terisa de morgan · 09-18-2016, 04:30 AM

Well, my bad, I haven't read that sentence

Sorry to have bothered you. As you have seen, my custom column are quite "eclectic". I'll make the change you've proposed. Thank you very much.

Edit: I've made the change and it already works. Thank you again.

chaley · 09-18-2016, 04:40 AM

Quote:

Originally Posted by Terisa de morgan

Well, my bad, I haven't read that sentence

Sorry to have bothered you. As you have seen, my custom column are quite "eclectic". I'll make the change you've proposed. Thank you very much.

Edit: I've made the change and it already works. Thank you again.

You are very welcome.

I will submit a change to calibre to print the lookup name of the column where the error happened. Having that name might save lots of future debug time.

Terisa de morgan · 09-18-2016, 04:43 AM

Quote:

Originally Posted by chaley

You are very welcome.

I will submit a change to calibre to print the lookup name of the column where the error happened. Having that name might save lots of future debug time.

Yeeeees, it would be very useful, thank you very much

kcarscadden · 04-10-2020, 02:12 PM

@chaley, as you see from thread searching for books modified in forum Calibre, I would like to try searching on a custom date column created by program: select(formats_modtimes('yyyy-MM-dd'), 'EPUB'). I installed [Library Closed Plugin] Save Composite Custom Columns and customized it to run. However, it doesn't actually populate metadata.db from this column. Can you explain? Is there a way to get this column populated in the database?

chaley · 04-10-2020, 04:40 PM

I don't think this plugin does what you want, unless you are willing to write code. The data stored is in JSON, one dictionary per book. It would be very difficult to write a query in SQL.

As for not populating: it works for me. I can think of two possible problems:
1) You haven't enabled the plugin for the library you are using. To enable the plugin for the current library go to Preferences / Plugins / Library Closed Plugins / Save Composite Columns / Customize Plugin.
2) You are running calibre with python 3. I haven't tested the plugin in that environment.

You can see what is happening by running calibre in debug mode. When you quit calibre you should see a message similar to

Code:

plugin Save Composite Custom Columns library C:\...\...\Library.test_small: updated 77 books in 0:00:00.082000

DaltonST · 04-10-2020, 05:25 PM

MCS now can use table books_plugin_data.

See https://www.mobileread.com/forums/sh...4&postcount=25.

kcarscadden · 04-10-2020, 06:14 PM

@chaley, so far as I can see, it appears that the problem with the column not populating was that I was not shutting calibre down in the appropriate way. I usually shut it down by using the Windows X on the GUI screen. However, I shut it down with calibre-debug -s once, and it now appears that it is updating each time I shut it down.

Whatever has changed, it appears OK now, and I will work on a search.

Thanks for your help.

chaley · 04-11-2020, 07:09 AM

Released Version 1.1.1 (11/April/2020)
* Python 3 compatibility

09-18-2016, 04:30 AM	#16
Terisa de morgan Grand Sorcerer Posts: 6,227 Karma: 11768331 Join Date: Jun 2009 Location: Madrid, Spain Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2	Well, my bad, I haven't read that sentence Sorry to have bothered you. As you have seen, my custom column are quite "eclectic". I'll make the change you've proposed. Thank you very much. Edit: I've made the change and it already works. Thank you again. Last edited by Terisa de morgan; 09-18-2016 at 04:33 AM. Reason: Added info

04-10-2020, 04:40 PM	#20
chaley Grand Sorcerer Posts: 11,733 Karma: 6690881 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	I don't think this plugin does what you want, unless you are willing to write code. The data stored is in JSON, one dictionary per book. It would be very difficult to write a query in SQL. As for not populating: it works for me. I can think of two possible problems: 1) You haven't enabled the plugin for the library you are using. To enable the plugin for the current library go to Preferences / Plugins / Library Closed Plugins / Save Composite Columns / Customize Plugin. 2) You are running calibre with python 3. I haven't tested the plugin in that environment. You can see what is happening by running calibre in debug mode. When you quit calibre you should see a message similar to Code: plugin Save Composite Custom Columns library C:\...\...\Library.test_small: updated 77 books in 0:00:00.082000

04-10-2020, 05:25 PM	#21
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	MCS now can use table books_plugin_data. MCS now can use table books_plugin_data. See https://www.mobileread.com/forums/sh...4&postcount=25.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Color coding and designing composite columns	ElMiko	Library Management	12	01-04-2015 08:55 PM
Composite column problem combining two tag type columns	At_Libitum	Recipes	1	08-29-2013 12:31 PM
composite custom columns sorted numerically	Doug-W	Library Management	2	02-18-2011 02:16 AM
Custom Composite Column	silentguy	Calibre	4	11-24-2010 10:28 AM

04-10-2020, 02:12 PM	#19
kcarscadden Zealot Posts: 138 Karma: 13776 Join Date: Jan 2007 Location: semi-north Ontario, Canada (N 45.41 W -79.67) Device: iPad Air 5, Samsung Galaxy S20 FE	@chaley, as you see from thread searching for books modified in forum Calibre, I would like to try searching on a custom date column created by program: select(formats_modtimes('yyyy-MM-dd'), 'EPUB'). I installed [Library Closed Plugin] Save Composite Custom Columns and customized it to run. However, it doesn't actually populate metadata.db from this column. Can you explain? Is there a way to get this column populated in the database?

04-10-2020, 06:14 PM	#22
kcarscadden Zealot Posts: 138 Karma: 13776 Join Date: Jan 2007 Location: semi-north Ontario, Canada (N 45.41 W -79.67) Device: iPad Air 5, Samsung Galaxy S20 FE	@chaley, so far as I can see, it appears that the problem with the column not populating was that I was not shutting calibre down in the appropriate way. I usually shut it down by using the Windows X on the GUI screen. However, I shut it down with calibre-debug -s once, and it now appears that it is updating each time I shut it down. Whatever has changed, it appears OK now, and I will work on a search. Thanks for your help.

04-11-2020, 07:09 AM	#23
chaley Grand Sorcerer Posts: 11,733 Karma: 6690881 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Released Version 1.1.1 (11/April/2020) * Python 3 compatibility