[GUI Plugin] Multi-Column Search

[Tanjamuse]

Thanks, I'll write down what to do to change between Duplicates in different libraries and duplicates in the same library.

[DaltonST]

An example of using MCS to find duplicate Custom Column values in the current library has been attached to the Original Post: https://www.mobileread.com/forums/sh...d.php?t=261712

The attachment file name is: mcs_sql_search_duplicates_in_single_custom_column. jpg


MCS already has a special function for cross-library duplicates of Custom Columns, which has not changed. See the "CL Duplicates" checkbox in the middle of the Intra-Book/Inter-Book Query Tab of MCS.



DaltonST

[Tanjamuse]

I tried the following but it didn't work. I'm not sure if I added the specific custom column right:

SELECT book  FROM books_#story_ID_9_link 
 WHERE value IN
 ( SELECT value 
 FROM books_#story_ID_9_link 
 GROUP BY value 
 HAVING COUNT(*) > 1 )

[DaltonST]

books_#story_ID_9_link is invalid.

Use: books_custom_column_9_link

Only the custom column number changes. See the picture attached to the Original Post.

[Tanjamuse]

Thanks.

Here's the files as requested.

[DaltonST]

Version 1.0.72 - 11 October 2017 Major Full-Text Search Enhancements.

Option to additionally compare the initial search results to the value in a specified Custom Column (i.e., filter them), optionally using a Regular Expression to more precisely filter the initial search results text.

Another new option to update a Custom Column using the initial search results after (optionally) further refining the search results text to be updated by using a Regular expression.

These 2 options may be used separately or simultaneously.

Refer to the ToolTips in the MCS Full-Text Query Tab.

See the attached set of images for a Fan Fiction example having more detailed explanations.





DaltonST

[Tanjamuse]

I just ran the updated version of the plugin and got the following error:

calibre, version 3.6.0
ERROR: Unhandled exception: <b>KeyError</b>:u'OPTIONS_TEXT_ACTIVATE'

calibre 3.6 [64bit]  embedded-python: True is64bit: True
Windows-7-6.1.7601-SP1 Windows ('64bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.12+
Windows: ('7', '6.1.7601', 'SP1', u'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: Find Duplicates (1, 6, 3) && View Manager (1, 4, 3) && Reading List (1, 6, 6) && Save Composite Custom Columns (1, 1, 0) && User Category (1, 5, 3) && FanFicFare (2, 15, 0) && Tanja's Tools (0, 0, 6) && Count Pages (1, 8, 0) && Job Spy (1, 0, 75) && Import List (1, 2, 0) && Generate Cover (1, 5, 21) && Edit Columns (0, 0, 1) && MultiColumnSearch (1, 0, 72)
Traceback (most recent call last):
  File "calibre_plugins.multi_column_search.ui", line 336, in search_request_dialog
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 150, in __init__
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 4921, in __init__
  File "site-packages\calibre\utils\config.py", line 420, in __getitem__
KeyError: u'OPTIONS_TEXT_ACTIVATE'

It looks real good. Would you mind writing out the regular expression in the thread?

[DaltonST]

Version 1.0.73 - 12 October 2017 Configuration preferences change.

This should fix any issues.

By the way, the REGEX that should be used to extract the URL from the example FF text file is: blank.

The REGEX that should be used to extract the story ID from the URL from the example is:

[0-9][0-9][0-9]+

Note that a "comment" for a REGEX is in the form: (?# ) and will be ignored by the RE engine.

The REGEX to use in the "main" specification area in the Tab is:

Story URL: https://www.fanfiction.net/s/[0-9]+/[0-9]/|Story URL: http://www.fanfiction.net/s/[0-9]+/[0-9]/

Note that it will capture both https and http. It uses the "|" bar operator that is described in the ToolTip for that area.


DaltonST

[Tanjamuse]

I've just tried the updated version and it shows no results.

Below is a screenshot

[DaltonST]

Originally Posted by Tanjamuse

I've just tried the updated version and it shows no results.

Below is a screenshot

Your Regular Expression in the search criteria at the top is incorrect. Refer to my previous post. Copy and paste this to your search criteria:

Story URL: https://www.fanfiction.net/s/[0-9]+/[0-9]/|Story URL: http://www.fanfiction.net/s/[0-9]+/[0-9]/

Yours has /[0-9]/ instead of /[0-9]+/



DaltonST

[Tanjamuse]

I still get nothing. I've copied exactly what you wrote.

[DaltonST]

If the purpose of what you are doing is to find errors wherein the story ID in the metadata does not match the story ID in the text ebook file, you will want to "invert the selection" after MCS gives you the ebooks that properly match. Job Spy has a GUI Tool called just that.

Note that you could simply update the story ID "again" using the correct value from the text ebook. You don't have to match what is there first to do that.



DaltonST

[DaltonST]

Originally Posted by Tanjamuse

I still get nothing. I've copied exactly what you wrote.

You specified RE #9. What is your RE #9? There is no way that your #9 is the same as my #9. What did you make #9?

Follow my example posted above. It uses your text ebooks that you provided as test data, so if you are having problems then it is because you have not done something correctly.



DaltonST

[DaltonST]

As I posted previously, the REGEX that should be used to extract the story ID from the URL from the example is:

[0-9][0-9][0-9]+

In other words, RE #9 should be the above.


DaltonST

[Tanjamuse]

I've tried this:

Story URL: https://www.fanfiction.net/s/[0-9][0-9][0-9]+/|Story URL: http://www.fanfiction.net/s/[0-9][0-9][0-9]+/

I don't understand the number in the selection after story_id.

The only reason I inserted the 9 was because it was in your example image earlier.

If this is wrong, then I would appreciate some help.

Also some of the urls are http and some are https.