09-08-2017, 05:15 PM | #196 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
Thanks, I'll write down what to do to change between Duplicates in different libraries and duplicates in the same library.
|
09-29-2017, 12:38 PM | #197 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Duplicate Custom Column Values
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 |
Advert | |
|
09-29-2017, 12:55 PM | #198 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
I tried the following but it didn't work. I'm not sure if I added the specific custom column right:
Code:
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 ) |
09-29-2017, 01:00 PM | #199 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
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. |
09-29-2017, 01:06 PM | #200 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
Thanks.
Here's the files as requested. Last edited by Tanjamuse; 10-08-2017 at 10:11 AM. |
Advert | |
|
10-11-2017, 05:04 PM | #201 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.72 - Major Full-Text Search Enhancements.
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 |
10-12-2017, 08:03 AM | #202 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
I just ran the updated version of the plugin and got the following error:
Code:
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' |
10-12-2017, 09:06 AM | #203 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.73 - Configuration preferences change.
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: Code:
[0-9][0-9][0-9]+ The REGEX to use in the "main" specification area in the Tab is: Code:
Story URL: https://www.fanfiction.net/s/[0-9]+/[0-9]/|Story URL: http://www.fanfiction.net/s/[0-9]+/[0-9]/ DaltonST Last edited by DaltonST; 10-12-2017 at 10:09 AM. Reason: more info. |
10-12-2017, 03:03 PM | #204 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
I've just tried the updated version and it shows no results.
Below is a screenshot |
10-12-2017, 03:14 PM | #205 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Quote:
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: Code:
Story URL: https://www.fanfiction.net/s/[0-9]+/[0-9]/|Story URL: http://www.fanfiction.net/s/[0-9]+/[0-9]/ DaltonST |
|
10-12-2017, 03:20 PM | #206 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
I still get nothing. I've copied exactly what you wrote.
|
10-12-2017, 03:22 PM | #207 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Invert Selection using Job-Spy GUI Tool
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 |
10-12-2017, 03:25 PM | #208 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
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 |
10-12-2017, 03:29 PM | #209 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
As I posted previously, the REGEX that should be used to extract the story ID from the URL from the example is:
Code:
[0-9][0-9][0-9]+ DaltonST |
10-12-2017, 03:38 PM | #210 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
I've tried this:
Code:
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]+/ 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. |
Tags |
columns, search |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] Search the Internet | kiwidude | Plugins | 434 | 09-30-2024 03:04 AM |
[GUI Plugin] Clipboard Search | kiwidude | Plugins | 29 | 04-02-2024 10:05 PM |
[GUI Plugin] Walk Search History | kiwidude | Plugins | 38 | 03-17-2024 12:47 AM |
[GUI Plugin] Recoll Full Text Search | Satas | Plugins | 16 | 08-05-2016 03:54 AM |
[GUI Plugin] Full Text Search (SOLR) | peterpisljar | Plugins | 2 | 08-09-2015 08:16 AM |