[GUI Plugin] Consolidate All Library Metadata (CALM)

[Sue_]

Popped right up, pretty fast too.
I have not repeated the calibre wipe and reinstall since the last test with CALM, so everything should be the same as it was then. All source libraries in the Job Spy window were shown in the correct case, as they are named, tried exporting to clipboard too, that was fine.
So, something CALM is using, but Job Spy doesn't is changing the case, so the attach can't find the libraries??

Log here, but nothing in it, no problem with finding Library.

susan@localhost:~> calibre-debug --gui
calibre 6.11 embedded-python: False
Linux-6.1.8-1-default-x86_64-with-glibc2.36 Linux ('64bit', 'ELF')
('Linux', '6.1.8-1-default', '#1 SMP PREEMPT_DYNAMIC Tue Jan 24 06:29:25 UTC 2023 (baebfe0)')
Python 3.10.9
Interface language: None
Successfully initialized third party plugins: Consolidate All Library Metadata (2, 0, 45) && Job Spy (1, 0, 202) && MultiColumnSearch (1, 0, 96) && View Manager (1, 10, 2)
QPA platform: xcb
devicePixelRatio: 1.0
logicalDpi: 96.0 x 96.0
physicalDpi: 102.23899371069182 x 102.35820895522387
ApplicationPaletteChange event ignored
Using calibre Qt style: True
[0.00] Starting up...
[0.00] Showing splash screen...
[0.04] splash screen shown
[0.04] Initializing db...
[0.06] db initialized
[0.06] Constructing main UI...
Screens currently in system:
{'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Restoring geometry for: calibre_main_window_geometry
{'frame_geometry': {'height': 1036, 'width': 1920, 'x': 0, 'y': 0},
'full_screened': False,
'geometry': {'height': 1005, 'width': 1920, 'x': 0, 'y': 31},
'maximized': True,
'normal_geometry': {'height': 487, 'width': 1322, 'x': 454, 'y': 160},
'screen': {'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080,
'width': 1920,
'x': 0,
'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080,
'width': 1920,
'x': 0,
'y': 0}}}
Matching screen: {'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Setting widget geometry to: {'height': 1005, 'width': 1920, 'x': 0, 'y': 31}
Restoring widget to maximized
CALM: initialization_complete............
Job Spy has begun initialization...
Calibre, and hence Job Spy, was gracefully shut down last time? False
Last time daemon started: never
Last time daemon failed: never
Total daemon starts inception_to_date: 0
Total daemon failures inception-to-date: 0
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
JS: ===>>> change_gui_alternating_row_colors()
Job Spy has finished initialization...
[0] un-optimized number of undesirable characters accumulated: 756
[1] optimized number of undesirable characters accumulated: 596
MCS has finished initialization...
[1.54] main UI initialized...
[1.54] Hiding splash screen
Starting QuickView
[1.69] splash screen hidden
[1.69] Started up in 1.69 seconds with 467 books

[DaltonST]

Please run this tool: JS+ GUI Tool - Vacuum/Compress metadata.db En Masse as anothet multi-library attach test.

I wonder if it is a btrfs system file encoding difference and JS handles it but CALM, not so much.

Is its encoding utf-8 or utf-16? Or?

DaltonST

[Sue_]

Vacuum/Compress en masse works fine too.
Why would Jobspy be ok, but CALM end up internally changing the library name case, so it can't find the real ones?

[BetterRed]

Long shot, and again - ignore if irrelevant.

In the calibre configuration folder: do a search on all files in all subdirectories, for one of the spurious library names e.g. LanguageandWriting, and another search for the matching authentic library name, e.g. languageandwriting

And of course, post results.

BR

[Sue_]

Wrong way around
But, as to the result: only the real names show up, I checked manually too.
That includes the CALM json in there, it has the correct names.....?

[DaltonST]

As I stated in my previous post, I suspect it is a BTRFS filesystem encoding issue for CALM. JS was 100% "future-proofed" in that regard (i.e., future operating systems), but CALM had a few holes in it.

I have plugged those holes and added more debugging information to tell us exactly what the filesystem encoding is in your system.

For my Windows 11 system:

filesystem_encoding is:  utf-8

The BTRFS encoding could easily mess with the upper/lower cases, and a lot more, including transliteration errors in paths. Think of "ASCII versus Unicode" differences.

Attached is a revised test version for you.


Please post a full debug log of your testing.



DaltonST

[Sue_]

Same thing happened, at autopopulate and attach the case was changed, but everywhere else it is correct:

susan@localhost:~> calibre-debug --gui
calibre 6.11 embedded-python: False
Linux-6.1.8-1-default-x86_64-with-glibc2.36 Linux ('64bit', 'ELF')
('Linux', '6.1.8-1-default', '#1 SMP PREEMPT_DYNAMIC Tue Jan 24 06:29:25 UTC 2023 (baebfe0)')
Python 3.10.9
Interface language: None
Successfully initialized third party plugins: Consolidate All Library Metadata (2, 0, 45) && Job Spy (1, 0, 202) && MultiColumnSearch (1, 0, 96) && View Manager (1, 10, 2)
QPA platform: xcb
devicePixelRatio: 1.0
logicalDpi: 96.0 x 96.0
physicalDpi: 102.23899371069182 x 102.35820895522387
ApplicationPaletteChange event ignored
Using calibre Qt style: True
[0.00] Starting up...
[0.00] Showing splash screen...
[0.04] splash screen shown
[0.04] Initializing db...
[0.06] db initialized
[0.06] Constructing main UI...
Screens currently in system:
{'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Restoring geometry for: calibre_main_window_geometry
{'frame_geometry': {'height': 1036, 'width': 1920, 'x': 0, 'y': 0},
'full_screened': False,
'geometry': {'height': 1005, 'width': 1920, 'x': 0, 'y': 31},
'maximized': True,
'normal_geometry': {'height': 1005, 'width': 1920, 'x': 0, 'y': 31},
'screen': {'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080,
'width': 1920,
'x': 0,
'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080,
'width': 1920,
'x': 0,
'y': 0}}}
Matching screen: {'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Setting widget geometry to: {'height': 1005, 'width': 1920, 'x': 0, 'y': 31}
Restoring widget to maximized
CALM: initialization_complete............
Job Spy has begun initialization...
Calibre, and hence Job Spy, was gracefully shut down last time? False
Last time daemon started: never
Last time daemon failed: never
Total daemon starts inception_to_date: 0
Total daemon failures inception-to-date: 0
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
JS: ===>>> change_gui_alternating_row_colors()
Job Spy has finished initialization...
[0] un-optimized number of undesirable characters accumulated: 756
[1] optimized number of undesirable characters accumulated: 596
MCS has finished initialization...
[1.56] main UI initialized...
[1.56] Hiding splash screen
Starting QuickView
[1.72] splash screen hidden
[1.72] Started up in 1.72 seconds with 467 books
CALM_DB_VERSION_METADATA_DB 2
CALM_DB_VERSION_METADATA_TOOLS_DB 2
CALM_DB_VERSION_UPGRADE_FORCE_UPGRADE False
CALM_DB_VERSION_UPGRADE_SUPPRESS_INFO_DIALOGS False
CALM_FORCE_RECONSOLIDATION False
CALM_LAST_CONSOLIDATION_JOB_DATETIME ...NEVER...
CALM_LAST_CONSOLIDATION_NUMBER_BOOKS 0
CALM_LAST_CONSOLIDATION_NUMBER_LIBRARIES 0
CALM_LAST_CONSOLIDATION_TARGET_DB_FULL_PATH ZZ:
CALM_MCS_INDEX_CONSOLIDATION False
CALM_TARGET_DB_FULL_PATH /home/susan/Calibre/CALM/metadata.db
CALM_TARGET_DB_GENERATING_NONCALM_LIBRARY_PATH ZZ:||>>>||ZZ:
CALM_TARGET_DB_LAST_CHOSEN_LIBRARY_DIRECTORY ZZ:
CALM_TARGET_DB_MUST_BE_REFRESHED False
CALM_TARGET_PARENT_DIRECTORY /home/susan/Calibre
CALM_USER_STATUS USER
Number of keys in self.mysourceprefs in 'load_source_prefs_init' : 128
Number of keys in self.mysourceprefs in 'load_source_prefs' : 128
my_db.library_path: /home/susan/Calibre/LanguageandWriting
self.target_db: /home/susan/Calibre/CALM/metadata.db
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
LIBRARY_PATH_03 : /home/susan/Calibre/LanguageandWriting
LIBRARY_PATH_04 : /home/susan/Calibre/New Library
LIBRARY_PATH_05 : /home/susan/Calibre/NewBooksForCalibre
LIBRARY_PATH_06 : /home/susan/Calibre/Testlibrary
number_source_libraries: 4
n_last_to_show: 6
n_tools_size = os.path.getsize(tools_path): 2260992
filesystem_encoding is: utf-8
metadata_tools.db is good to go.
CALM_DB_VERSION_METADATA_DB 2
CALM_DB_VERSION_METADATA_TOOLS_DB 2
CALM_DB_VERSION_UPGRADE_FORCE_UPGRADE False
CALM_DB_VERSION_UPGRADE_SUPPRESS_INFO_DIALOGS False
CALM_FORCE_RECONSOLIDATION False
CALM_LAST_CONSOLIDATION_JOB_DATETIME ...NEVER...
CALM_LAST_CONSOLIDATION_NUMBER_BOOKS 0
CALM_LAST_CONSOLIDATION_NUMBER_LIBRARIES 0
CALM_LAST_CONSOLIDATION_TARGET_DB_FULL_PATH ZZ:
CALM_MCS_INDEX_CONSOLIDATION False
CALM_TARGET_DB_FULL_PATH /home/susan/Calibre/CALM/metadata.db
CALM_TARGET_DB_GENERATING_NONCALM_LIBRARY_PATH ZZ:||>>>||ZZ:
CALM_TARGET_DB_LAST_CHOSEN_LIBRARY_DIRECTORY ZZ:
CALM_TARGET_DB_MUST_BE_REFRESHED False
CALM_TARGET_PARENT_DIRECTORY /home/susan/Calibre
CALM_USER_STATUS USER
Number of keys in self.mysourceprefs in 'load_source_prefs_init' : 128
Number of keys in self.mysourceprefs in 'load_source_prefs' : 128
my_db.library_path: /home/susan/Calibre/LanguageandWriting
self.target_db: /home/susan/Calibre/CALM/metadata.db
Number of keys in self.mysourceprefs in 'save_source_preferences' : 128
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
Number of keys in self.mysourceprefs in 'optimize_source_prefs' [1] : 128
Saved: LIBRARY_PATH_03 /home/susan/Calibre/LanguageandWriting
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_03_IS_ACTIVE True
Saved: LIBRARY_PATH_04 /home/susan/Calibre/New Library
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_04_IS_ACTIVE True
Saved: LIBRARY_PATH_05 /home/susan/Calibre/NewBooksForCalibre
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_05_IS_ACTIVE True
Saved: LIBRARY_PATH_06 /home/susan/Calibre/Testlibrary
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_06_IS_ACTIVE True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/LanguageandWriting True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/New Library True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/NewBooksForCalibre True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/Testlibrary True
for row in tmp_sorted_list: !00
for row in tmp_sorted_list: !01
for row in tmp_sorted_list: !02
for row in tmp_sorted_list: /home/susan/Calibre/LanguageandWriting
for row in tmp_sorted_list: /home/susan/Calibre/New Library
for row in tmp_sorted_list: /home/susan/Calibre/NewBooksForCalibre
for row in tmp_sorted_list: /home/susan/Calibre/Testlibrary
Number of keys in self.mysourceprefs in 'optimize_source_prefs' [2] : 128
Number of keys in self.mysourceprefs in 'save_real_prefs_source': 128
Number of keys in self.mysourceprefs in 'load_source_prefs' : 128
Number of keys in self.mysourceprefs in 'save_source_preferences' : 128
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
Number of keys in self.myparentprefs in 'save_real_prefs_parent' : 128
autopopulate: k, : /home/susan/calibre/languageandwriting
autopopulate: k, : /home/susan/calibre/new library
autopopulate: k, : /home/susan/calibre/newbooksforcalibre
autopopulate: k, : /home/susan/calibre/testlibrary
filesystem_encoding is: utf-8
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/calibre/languageandwriting/metadata.db' AS 'SOURCE' ;
length of path: 50
Attaching to New Source Library: /home/susan/calibre/languageandwriting/metadata.db
NOT Attached: /home/susan/calibre/languageandwriting/metadata.db
CantOpenError: unable to open database: /home/susan/calibre/languageandwriting/metadata.db
^^^^^^^ Source Library was NOT found: /home/susan/calibre/languageandwriting
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/calibre/testlibrary/metadata.db' AS 'SOURCE' ;
length of path: 43
Attaching to New Source Library: /home/susan/calibre/testlibrary/metadata.db
NOT Attached: /home/susan/calibre/testlibrary/metadata.db
CantOpenError: unable to open database: /home/susan/calibre/testlibrary/metadata.db
^^^^^^^ Source Library was NOT found: /home/susan/calibre/testlibrary
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/calibre/newbooksforcalibre/metadata.db' AS 'SOURCE' ;
length of path: 50
Attaching to New Source Library: /home/susan/calibre/newbooksforcalibre/metadata.db
NOT Attached: /home/susan/calibre/newbooksforcalibre/metadata.db
CantOpenError: unable to open database: /home/susan/calibre/newbooksforcalibre/metadata.db
^^^^^^^ Source Library was NOT found: /home/susan/calibre/newbooksforcalibre
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/calibre/new library/metadata.db' AS 'SOURCE' ;
length of path: 43
Attaching to New Source Library: /home/susan/calibre/new library/metadata.db
NOT Attached: /home/susan/calibre/new library/metadata.db
CantOpenError: unable to open database: /home/susan/calibre/new library/metadata.db
^^^^^^^ Source Library was NOT found: /home/susan/calibre/new library
filesystem_encoding is: utf-8
source library path added to set: /home/susan/Calibre/LanguageandWriting
source library path added to set: /home/susan/Calibre/New Library
source library path added to set: /home/susan/Calibre/NewBooksForCalibre
source library path added to set: /home/susan/Calibre/Testlibrary
adding source to table _source_libraries: /home/susan/Calibre/LanguageandWriting
adding source to table _source_libraries: /home/susan/Calibre/NewBooksForCalibre
adding source to table _source_libraries: /home/susan/Calibre/New Library
adding source to table _source_libraries: /home/susan/Calibre/Testlibrary
number_source_libraries_0: 4
number_source_libraries = unicode_type(col): 0
number_source_libraries = unicode_type(col): 0
Number of keys in self.myparentprefs in 'save_real_prefs_parent' : 128

[DaltonST]

The "accommodate" case-sensitive filesystems code in CALM was missing a couple of lines that were never discovered or reported from 2015 until now by you. The lower-case version of all library paths is used as a critical Target Library custom table matching key in the actual consolidation job, but was erroneously also being used instead of the original mixed-case library path. My Windows never blinked, because it is not case-sensitive and couldn't tell the difference.

CALM still does not support multiple library paths that are identical except for a few case differences.

Let me know if this works for you now, and I can then release it.


DaltonST

[Sue_]

I would've thought other linux/any case sensitive os users would have the same issue???

Anyways, so far so good on the get custom columns button, NO error popups and the log says all good in attach, so it seems to be working All of the test libraries show up, with their custom columns.

Here's the log, in case I missed something:

susan@localhost:~> calibre-debug --gui
calibre 6.11 embedded-python: False
Linux-6.1.8-1-default-x86_64-with-glibc2.36 Linux ('64bit', 'ELF')
('Linux', '6.1.8-1-default', '#1 SMP PREEMPT_DYNAMIC Tue Jan 24 06:29:25 UTC 2023 (baebfe0)')
Python 3.10.9
Interface language: None
Successfully initialized third party plugins: Consolidate All Library Metadata (2, 0, 45) && Job Spy (1, 0, 202) && MultiColumnSearch (1, 0, 96) && View Manager (1, 10, 2)
QPA platform: xcb
devicePixelRatio: 1.0
logicalDpi: 96.0 x 96.0
physicalDpi: 102.23899371069182 x 102.35820895522387
ApplicationPaletteChange event ignored
Using calibre Qt style: True
[0.00] Starting up...
[0.00] Showing splash screen...
[0.03] splash screen shown
[0.03] Initializing db...
[0.04] db initialized
[0.04] Constructing main UI...
Screens currently in system:
{'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Restoring geometry for: calibre_main_window_geometry
{'frame_geometry': {'height': 1036, 'width': 1920, 'x': 0, 'y': 0},
'full_screened': False,
'geometry': {'height': 1005, 'width': 1920, 'x': 0, 'y': 31},
'maximized': True,
'normal_geometry': {'height': 1005, 'width': 1920, 'x': 0, 'y': 31},
'screen': {'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080,
'width': 1920,
'x': 0,
'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080,
'width': 1920,
'x': 0,
'y': 0}}}
Matching screen: {'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Setting widget geometry to: {'height': 1005, 'width': 1920, 'x': 0, 'y': 31}
Restoring widget to maximized
CALM: initialization_complete............
Job Spy has begun initialization...
Calibre, and hence Job Spy, was gracefully shut down last time? True
Last time daemon started: never
Last time daemon failed: never
Total daemon starts inception_to_date: 0
Total daemon failures inception-to-date: 0
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
JS: ===>>> change_gui_alternating_row_colors()
Job Spy has finished initialization...
[0] un-optimized number of undesirable characters accumulated: 756
[1] optimized number of undesirable characters accumulated: 596
MCS has finished initialization...
[1.60] main UI initialized...
[1.60] Hiding splash screen
Starting QuickView
[1.75] splash screen hidden
[1.75] Started up in 1.75 seconds with 467 books
CALM_DB_VERSION_METADATA_DB 2
CALM_DB_VERSION_METADATA_TOOLS_DB 2
CALM_DB_VERSION_UPGRADE_FORCE_UPGRADE False
CALM_DB_VERSION_UPGRADE_SUPPRESS_INFO_DIALOGS False
CALM_FORCE_RECONSOLIDATION False
CALM_LAST_CONSOLIDATION_JOB_DATETIME ...NEVER...
CALM_LAST_CONSOLIDATION_NUMBER_BOOKS 0
CALM_LAST_CONSOLIDATION_NUMBER_LIBRARIES 0
CALM_LAST_CONSOLIDATION_TARGET_DB_FULL_PATH ZZ:
CALM_MCS_INDEX_CONSOLIDATION False
CALM_TARGET_DB_FULL_PATH /home/susan/Calibre/CALM/metadata.db
CALM_TARGET_DB_GENERATING_NONCALM_LIBRARY_PATH ZZ:||>>>||ZZ:
CALM_TARGET_DB_LAST_CHOSEN_LIBRARY_DIRECTORY ZZ:
CALM_TARGET_DB_MUST_BE_REFRESHED False
CALM_TARGET_PARENT_DIRECTORY /home/susan/Calibre
CALM_USER_STATUS USER
Number of keys in self.mysourceprefs in 'load_source_prefs_init' : 128
Number of keys in self.mysourceprefs in 'load_source_prefs' : 128
my_db.library_path: /home/susan/Calibre/LanguageandWriting
self.target_db: /home/susan/Calibre/CALM/metadata.db
filesystem_encoding is: utf-8
filesystem_encoding is: utf-8
Attaching to Tools DB: /home/susan/Calibre/CALM/metadata_tools.db
n_tools_size = os.path.getsize(tools_path): 2260992
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
LIBRARY_PATH_03 : /home/susan/Calibre/LanguageandWriting
LIBRARY_PATH_04 : /home/susan/Calibre/New Library
LIBRARY_PATH_05 : /home/susan/Calibre/NewBooksForCalibre
LIBRARY_PATH_06 : /home/susan/Calibre/Testlibrary
number_source_libraries: 4
n_last_to_show: 6
n_tools_size = os.path.getsize(tools_path): 2260992
filesystem_encoding is: utf-8
metadata_tools.db is good to go.
CALM_DB_VERSION_METADATA_DB 2
CALM_DB_VERSION_METADATA_TOOLS_DB 2
CALM_DB_VERSION_UPGRADE_FORCE_UPGRADE False
CALM_DB_VERSION_UPGRADE_SUPPRESS_INFO_DIALOGS False
CALM_FORCE_RECONSOLIDATION False
CALM_LAST_CONSOLIDATION_JOB_DATETIME ...NEVER...
CALM_LAST_CONSOLIDATION_NUMBER_BOOKS 0
CALM_LAST_CONSOLIDATION_NUMBER_LIBRARIES 0
CALM_LAST_CONSOLIDATION_TARGET_DB_FULL_PATH ZZ:
CALM_MCS_INDEX_CONSOLIDATION False
CALM_TARGET_DB_FULL_PATH /home/susan/Calibre/CALM/metadata.db
CALM_TARGET_DB_GENERATING_NONCALM_LIBRARY_PATH ZZ:||>>>||ZZ:
CALM_TARGET_DB_LAST_CHOSEN_LIBRARY_DIRECTORY ZZ:
CALM_TARGET_DB_MUST_BE_REFRESHED False
CALM_TARGET_PARENT_DIRECTORY /home/susan/Calibre
CALM_USER_STATUS USER
Number of keys in self.mysourceprefs in 'load_source_prefs_init' : 128
Number of keys in self.mysourceprefs in 'load_source_prefs' : 128
my_db.library_path: /home/susan/Calibre/LanguageandWriting
self.target_db: /home/susan/Calibre/CALM/metadata.db
Number of keys in self.mysourceprefs in 'save_source_preferences' : 128
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
Number of keys in self.mysourceprefs in 'optimize_source_prefs' [1] : 128
Saved: LIBRARY_PATH_03 /home/susan/Calibre/LanguageandWriting
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_03_IS_ACTIVE True
Saved: LIBRARY_PATH_04 /home/susan/Calibre/New Library
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_04_IS_ACTIVE True
Saved: LIBRARY_PATH_05 /home/susan/Calibre/NewBooksForCalibre
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_05_IS_ACTIVE True
Saved: LIBRARY_PATH_06 /home/susan/Calibre/Testlibrary
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_06_IS_ACTIVE True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/LanguageandWriting True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/New Library True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/NewBooksForCalibre True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/Testlibrary True
for row in tmp_sorted_list: !00
for row in tmp_sorted_list: !01
for row in tmp_sorted_list: !02
for row in tmp_sorted_list: /home/susan/Calibre/LanguageandWriting
for row in tmp_sorted_list: /home/susan/Calibre/New Library
for row in tmp_sorted_list: /home/susan/Calibre/NewBooksForCalibre
for row in tmp_sorted_list: /home/susan/Calibre/Testlibrary
Number of keys in self.mysourceprefs in 'optimize_source_prefs' [2] : 128
Number of keys in self.mysourceprefs in 'save_real_prefs_source': 128
Number of keys in self.mysourceprefs in 'load_source_prefs' : 128
Number of keys in self.mysourceprefs in 'save_source_preferences' : 128
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
... def autopopulate_source_library_custom_columns_table() ...
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
Number of keys in self.myparentprefs in 'save_real_prefs_parent' : 128
autopopulate: k, : /home/susan/Calibre/LanguageandWriting /home/susan/calibre/languageandwriting
autopopulate: k, : /home/susan/Calibre/New Library /home/susan/calibre/new library
autopopulate: k, : /home/susan/Calibre/NewBooksForCalibre /home/susan/calibre/newbooksforcalibre
autopopulate: k, : /home/susan/Calibre/Testlibrary /home/susan/calibre/testlibrary
filesystem_encoding is: utf-8
Original Case Library Name used for APSW Path: /home/susan/Calibre/Testlibrary
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/Calibre/Testlibrary/metadata.db' AS 'SOURCE' ;
length of path: 43
Attaching to New Source Library: /home/susan/Calibre/Testlibrary/metadata.db
Now Attached to New Source Library: /home/susan/Calibre/Testlibrary/metadata.db
PRAGMA SOURCE.busy_timeout = 4000;
Finished: apsw_attach_to_source
number of rows found in source.custom_columns: 26
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (1, 'audiocomment', 'AudioBook Comments', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (2, 'audiolistened', 'Listened', 'datetime', 0, 1, '{"description": "", "date_format": "yyyy"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (3, 'audiopubplusyear', 'Audio Publisher & Year', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (4, 'collection_bundle', 'Collection/Bundle', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (5, 'contents', 'Contents', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (6, 'genre', 'Genre', 'text', 0, 1, '{"is_names": false, "description": ""}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (7, 'koboreadpct', 'Kobo Read Percentage', 'int', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (8, 'koboreadpctsusan', 'Kobo Read percentage Susan', 'int', 0, 1, '{"number_format": null, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (9, 'lastread', 'Last Read', 'datetime', 0, 1, '{"description": "", "date_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (10, 'lastreadsusan', 'Last Read Susan', 'datetime', 0, 1, '{"date_format": null, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (11, 'links', 'links', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (12, 'myshelves', 'My Shelves', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (13, 'narrator', 'Narrator', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (14, 'owner', 'Owner', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (15, 'price', 'Price', 'float', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (16, 'pseudonym', 'Pen Name', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (17, 'purchase_date', 'Bought', 'datetime', 0, 1, '{"date_format": "dd MMM yyyy"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (18, 'ratingsusan', 'Rating Susan', 'rating', 0, 1, '{"description": ""}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (19, 'readstatus', 'Reading Status', 'composite', 0, 1, '{"composite_template": "{#koboreadpct:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "contains_html": false, "make_category": true, "use_decorations": 0, "composite_sort": "text"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (20, 'readstatussusan', 'Read Status Susan', 'composite', 0, 1, '{"composite_template": "{#koboreadpctsusan:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "composite_sort": "text", "contains_html": false, "use_decorations": 0, "make_category": true, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (21, 'series_separate', 'Series Separate', 'series', 0, 1, '{}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (22, 'shelfname', 'Shelf Name', 'composite', 0, 1, '{"composite_template": "{:\'first_non_empty(field(\'#myshelves\'), field(\'Series\'), \'Uncategorized\')\'}", "composite_sort": "text", "contains_html": false, "make_category": false, "use_decorations": 0}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (23, 'storesitesource', 'Source', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (24, 'tbr', 'TBR', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (25, 'type', 'Type', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (26, 'unabridged', 'Unabridged', 'bool', 0, 1, '{}', 0, 0)
Previously Attached Source Library Detached: /home/susan/Calibre/Testlibrary
Original Case Library Name used for APSW Path: /home/susan/Calibre/New Library
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/Calibre/New Library/metadata.db' AS 'SOURCE' ;
length of path: 43
Attaching to New Source Library: /home/susan/Calibre/New Library/metadata.db
Now Attached to New Source Library: /home/susan/Calibre/New Library/metadata.db
PRAGMA SOURCE.busy_timeout = 4000;
Finished: apsw_attach_to_source
Previously Attached Source Library Detached: /home/susan/Calibre/New Library
Original Case Library Name used for APSW Path: /home/susan/Calibre/NewBooksForCalibre
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/Calibre/NewBooksForCalibre/metadata.db' AS 'SOURCE' ;
length of path: 50
Attaching to New Source Library: /home/susan/Calibre/NewBooksForCalibre/metadata.db
Now Attached to New Source Library: /home/susan/Calibre/NewBooksForCalibre/metadata.db
PRAGMA SOURCE.busy_timeout = 4000;
Finished: apsw_attach_to_source
number of rows found in source.custom_columns: 28
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (1, 'price', 'Price', 'float', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (2, 'narrator', 'Narrator', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (3, 'ratingsusan', 'Rating Susan', 'rating', 0, 1, '{"description": ""}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (4, 'shelfname', 'Shelf Name', 'composite', 0, 1, '{"use_decorations": 0, "composite_template": "{:\'first_non_empty(field(\'#myshelves\'), field(\'Series\'), \'Uncategorized\')\'}", "composite_sort": "text", "contains_html": false, "make_category": false}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (5, 'tbr', 'TBR', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (6, 'readstatus', 'Reading Status', 'composite', 0, 1, '{"use_decorations": 0, "composite_template": "{#koboreadpct:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "composite_sort": "text", "contains_html": false, "make_category": true}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (7, 'collection_bundle', 'Collection/Bundle', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (8, 'koboreadpctsusan', 'Kobo Read percentage Susan', 'int', 0, 1, '{"number_format": null, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (9, 'audiopubplusyear', 'Audio Publisher & Year', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (10, 'audiocomment', 'AudioBook Comments', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (11, 'genre', 'Genre', 'text', 0, 1, '{"is_names": false, "description": ""}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (12, 'lastreadsusan', 'Last Read Susan', 'datetime', 0, 1, '{"date_format": null, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (13, 'owner', 'Owner', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (14, 'series_separate', 'Series Separate', 'series', 0, 1, '{}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (15, 'links', 'links', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (16, 'type', 'Type', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (17, 'koboreadpct', 'Kobo Read Percentage', 'int', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (18, 'lastread', 'Last Read', 'datetime', 0, 1, '{"date_format": null, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (19, 'unabridged', 'Unabridged', 'bool', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (20, 'audiolistened', 'Listened', 'datetime', 0, 1, '{"date_format": "yyyy", "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (21, 'pseudonym', 'Pen Name', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (22, 'purchase_date', 'Bought', 'datetime', 0, 1, '{"date_format": "dd MMM yyyy"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (23, 'readstatussusan', 'Read Status Susan', 'composite', 0, 1, '{"composite_template": "{#koboreadpctsusan:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "composite_sort": "text", "contains_html": false, "description": "", "use_decorations": 0, "make_category": true}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (24, 'storesitesource', 'Source', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (25, 'contents', 'Contents', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (26, 'myshelves', 'My Shelves', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (27, 'orig_backed_up', 'Originals Backed Up', 'bool', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (28, 'printyear', 'Print Publisher & Year', 'text', 0, 1, '{"is_names": false}', 1, 1)
Previously Attached Source Library Detached: /home/susan/Calibre/NewBooksForCalibre
Original Case Library Name used for APSW Path: /home/susan/Calibre/LanguageandWriting
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/Calibre/LanguageandWriting/metadata.db' AS 'SOURCE' ;
length of path: 50
Attaching to New Source Library: /home/susan/Calibre/LanguageandWriting/metadata.db
Now Attached to New Source Library: /home/susan/Calibre/LanguageandWriting/metadata.db
PRAGMA SOURCE.busy_timeout = 4000;
Finished: apsw_attach_to_source
number of rows found in source.custom_columns: 26
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (1, 'audiolistened', 'Listened', 'datetime', 0, 1, '{"description": "", "date_format": "yyyy"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (2, 'ratingsusan', 'Rating Susan', 'rating', 0, 1, '{"description": ""}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (3, 'narrator', 'Narrator', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (4, 'koboreadpct', 'Kobo Read Percentage', 'int', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (5, 'type', 'Type', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (6, 'genre', 'Genre', 'text', 0, 1, '{"description": "", "is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (7, 'lastread', 'Last Read', 'datetime', 0, 1, '{"description": "", "date_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (8, 'purchase_date', 'Bought', 'datetime', 0, 1, '{"date_format": "dd MMM yyyy"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (9, 'series_separate', 'Series Separate', 'series', 0, 1, '{}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (10, 'lastreadsusan', 'Last Read Susan', 'datetime', 0, 1, '{"description": "", "date_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (11, 'links', 'links', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (12, 'pseudonym', 'Pen Name', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (13, 'contents', 'Contents', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (14, 'readstatus', 'Reading Status', 'composite', 0, 1, '{"make_category": true, "composite_template": "{#koboreadpct:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "use_decorations": 0, "contains_html": false, "composite_sort": "text"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (15, 'price', 'Price', 'float', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (16, 'audiocomment', 'AudioBook Comments', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (17, 'koboreadpctsusan', 'Kobo Read percentage Susan', 'int', 0, 1, '{"description": "", "number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (18, 'myshelves', 'My Shelves', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (19, 'unabridged', 'Unabridged', 'bool', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (20, 'readstatussusan', 'Read Status Susan', 'composite', 0, 1, '{"make_category": true, "description": "", "composite_template": "{#koboreadpctsusan:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "use_decorations": 0, "contains_html": false, "composite_sort": "text"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (21, 'collection_bundle', 'Collection/Bundle', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (22, 'shelfname', 'Shelf Name', 'composite', 0, 1, '{"make_category": false, "composite_template": "{:\'first_non_empty(field(\'#myshelves\'), field(\'Series\'), \'Uncategorized\')\'}", "use_decorations": 0, "contains_html": false, "composite_sort": "text"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (23, 'audiopubplusyear', 'Audio Publisher & Year', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (24, 'owner', 'Owner', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (25, 'storesitesource', 'Source', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (26, 'tbr', 'TBR', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
Previously Attached Source Library Detached: /home/susan/Calibre/LanguageandWriting
filesystem_encoding is: utf-8
source library path added to set: /home/susan/Calibre/LanguageandWriting
source library path added to set: /home/susan/Calibre/New Library
source library path added to set: /home/susan/Calibre/NewBooksForCalibre
source library path added to set: /home/susan/Calibre/Testlibrary
adding source to table _source_libraries: /home/susan/Calibre/New Library
adding source to table _source_libraries: /home/susan/Calibre/LanguageandWriting
adding source to table _source_libraries: /home/susan/Calibre/NewBooksForCalibre
adding source to table _source_libraries: /home/susan/Calibre/Testlibrary
number_source_libraries_0: 4
number_source_libraries = unicode_type(col): 3
number_source_libraries = unicode_type(col): 3



Clicked all the other buttons, get, list and all the mass activate/deactivate seem ok, but got an error on Selectively activate: It doesn't like "float"

calibre, version 6.11.0
ERROR: Unhandled exception: <b>TypeError</b>:setColumnWidth(self, column: int, width: int): argument 2 has unexpected type 'float'

calibre 6.11 embedded-python: False
Linux-6.1.8-1-default-x86_64-with-glibc2.36 Linux ('64bit', 'ELF')
('Linux', '6.1.8-1-default', '#1 SMP PREEMPT_DYNAMIC Tue Jan 24 06:29:25 UTC 2023 (baebfe0)')
Python 3.10.9
Interface language: None
Successfully initialized third party plugins: Consolidate All Library Metadata (2, 0, 45) && Job Spy (1, 0, 202) && MultiColumnSearch (1, 0, 96) && View Manager (1, 10, 2)
Traceback (most recent call last):
File "calibre_plugins.consolidate_all_library_metadata. cc_activation_list_editor", line 210, in resizeEvent
self.table.setColumnWidth(c, w)
TypeError: setColumnWidth(self, column: int, width: int): argument 2 has unexpected type 'float'

[DaltonST]

Version 2.0.46 -2023-02-05 Case-sensitive filesystems, like BTRFS, are now supported. Qt6 compatibility when resizing columns via the mouse cursor in the list editors for selectively activating custom columns and tag rules.

Sue_, thank you for both your testing and the feedback of your results. Rare & Priceless.



DaltonST

[Sue_]

Glad to.
Thanks for working so hard on these plugins, library wrangling without them???? Nope.