[GUI Plugin] Multi-Column Search

[Tanjamuse]

Everytime I use a custom column to search from, it doesn't return anything.

I've tried with several different custom columns. Maybe it's me who's doing this the wrong way. But I've used the settings I've shown you earlier.

1. Checkmark in CL Duplicates.

2. Execute Search [Another Library: All Books]

3. Log window shows up empty.

When I use Calibre's own Authors column it always shows up. It even shows a book in which the author isn't the same but the title is.

[DaltonST]

Good testing. I will take it from here. Thanks.

[DaltonST]

@Tanjamuse:

Beta #2 is attached, as well as an example of my test results

It is not optimized for speed yet, by the way. It has to work properly before I can optimize it.


DaltonST

[Tanjamuse]

It seems to be working ok.

Although I don't quite understand that I can use a custom column that doesn't exist in a library to search for duplicates in another library

Also, if I use the standard author-column it finds all the stories allthough the authors aren't spelled the same.

[DaltonST]

Originally Posted by Tanjamuse

It seems to be working ok.

[1] Although I don't quite understand that I can use a custom column that doesn't exist in a library to search for duplicates in another library

[2] Also, if I use the standard author-column it finds all the stories allthough the authors aren't spelled the same.

[1] In Calibre, you can search for anything in the Search Bar, even if it does not exist. In MCS, for CL Intra-Book searches, it does not yet know what the other library has or does not have. So, the validation is lax. It is up to the user to drive responsibly. I added nothing special for CL Duplicates in that regard.

[2] You must be referring to a book with multiple authors. Each individual author is spelled the same. It is the sort that is different. Calibre shows it by sequence added in the current library, but MCS shows them sorted alphabetically. Same authors, though.


DaltonST

[Tanjamuse]

I'll PM you with the 2 libraries?

[DaltonST]

Perhaps what you see is related to the author sort. Use bulk edit to set all author sorts automatically in both libraries. Titles too. Then retest.

MCS does not use the sort fields.

FN LN or LN, FN might be involved.

[Tanjamuse]

I've sent you the libraries in a PM ... I still see the authors even though the names aren't the same.

[Tanjamuse]

I've tried on another couple of libraries and there I get the following error:

calibre, version 2.56.0
ERROR: Unhandled exception: <b>TypeError</b>:'NoneType' object is not iterable

calibre 2.56 [64bit]  embedded-python: True is64bit: True
Windows-7-6.1.7601-SP1 Windows ('64bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Count Pages && EpubMerge && Find Duplicates && Save Composite Custom Columns && Reading List && MultiColumnSearch && FanFicFare && User Category && Generate Cover && Modify ePub
Traceback (most recent call last):
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 417, in search_another_library
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 375, in execute_mcs
  File "calibre_plugins.multi_column_search.ui", line 351, in search_request_control
  File "calibre_plugins.multi_column_search.ui", line 6165, in search_request_control_cl_duplicates
  File "calibre_plugins.multi_column_search.ui", line 6256, in cl_duplicates_search_control
  File "calibre_plugins.multi_column_search.ui", line 6602, in cl_duplicates_compare_cc_col1
TypeError: 'NoneType' object is not iterable

Do the libraries have to have exactly the same columns, because that would be a problem for me.

[DaltonST]

No, they do not have to have the same columns. I will fix that error. Thanks.

[Tanjamuse]

You're welcome

As long as I use my custom author-columns I think the plugin works.

I'll test with these new libraries and see if they still add all the authors that aren't the same.

[DaltonST]

Beta #3 is attached. It fixes everything you have mentioned so far.

[Tanjamuse]

I got a new error:

PHP Code:

calibre, version 2.56.0
ERROR: Unhandled exception: <b>TypeError</b>:object of type 'NoneType' has no len()

calibre 2.56 [64bit]  embedded-python: True is64bit: True
Windows-7-6.1.7601-SP1 Windows ('64bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Modify ePub && FanFicFare && MultiColumnSearch && Reading List && Count Pages && EpubMerge && Generate Cover && Find Duplicates && Save Composite Custom Columns && User Category
Traceback (most recent call last):
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 417, in search_another_library
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 375, in execute_mcs
  File "calibre_plugins.multi_column_search.ui", line 351, in search_request_control
  File "calibre_plugins.multi_column_search.ui", line 6165, in search_request_control_cl_duplicates
  File "calibre_plugins.multi_column_search.ui", line 6256, in cl_duplicates_search_control
  File "calibre_plugins.multi_column_search.ui", line 6614, in cl_duplicates_compare_cc_col1
TypeError: object of type 'NoneType' has no len() 


[DaltonST]

try this one attached.

[Tanjamuse]

And yet another error:

PHP Code:

calibre, version 2.56.0
ERROR: Unhandled exception: <b>TypeError</b>:object of type 'NoneType' has no len()

calibre 2.56 [64bit]  embedded-python: True is64bit: True
Windows-7-6.1.7601-SP1 Windows ('64bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Count Pages && Reading List && Modify ePub && FanFicFare && EpubMerge && Generate Cover && Save Composite Custom Columns && Find Duplicates && MultiColumnSearch && User Category
Traceback (most recent call last):
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 417, in search_another_library
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 375, in execute_mcs
  File "calibre_plugins.multi_column_search.ui", line 351, in search_request_control
  File "calibre_plugins.multi_column_search.ui", line 6165, in search_request_control_cl_duplicates
  File "calibre_plugins.multi_column_search.ui", line 6256, in cl_duplicates_search_control
  File "calibre_plugins.multi_column_search.ui", line 6614, in cl_duplicates_compare_cc_col1
TypeError: object of type 'NoneType' has no len()