Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Plugins

Notices

Reply
 
Thread Tools Search this Thread
Old 09-08-2017, 05:15 PM   #196
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 886
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
Thanks, I'll write down what to do to change between Duplicates in different libraries and duplicates in the same library.
Tanjamuse is offline   Reply With Quote
Advert
Old 09-29-2017, 12:38 PM   #197
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 939
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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
DaltonST is offline   Reply With Quote
Old 09-29-2017, 12:55 PM   #198
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 886
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
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 )
Tanjamuse is offline   Reply With Quote
Old 09-29-2017, 01:00 PM   #199
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 939
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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.
DaltonST is offline   Reply With Quote
Old 09-29-2017, 01:06 PM   #200
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 886
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
Thanks.

Here's the files as requested.
Attached Files
File Type: zip Back To The Future.zip (221.3 KB, 9 views)

Last edited by Tanjamuse; 10-08-2017 at 10:11 AM.
Tanjamuse is offline   Reply With Quote
Old 10-11-2017, 05:04 PM   #201
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 939
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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
Attached Thumbnails
Click image for larger version

Name:	mcs_full_text_search_using_optional_filtering_and_cc_updating.jpg
Views:	16
Size:	1.48 MB
ID:	159406  
DaltonST is offline   Reply With Quote
Old 10-12-2017, 08:03 AM   #202
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 886
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
Red face

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'
It looks real good. Would you mind writing out the regular expression in the thread?
Tanjamuse is offline   Reply With Quote
Old 10-12-2017, 09:06 AM   #203
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 939
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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]+
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:

Code:
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

Last edited by DaltonST; 10-12-2017 at 10:09 AM. Reason: more info.
DaltonST is offline   Reply With Quote
Old 10-12-2017, 03:03 PM   #204
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 886
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
I've just tried the updated version and it shows no results.

Below is a screenshot
Attached Thumbnails
Click image for larger version

Name:	Skærmbillede 2017-10-12 21.02.42.png
Views:	7
Size:	41.2 KB
ID:	159422  
Tanjamuse is offline   Reply With Quote
Old 10-12-2017, 03:14 PM   #205
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 939
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Quote:
Originally Posted by Tanjamuse View Post
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:

Code:
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
DaltonST is offline   Reply With Quote
Old 10-12-2017, 03:20 PM   #206
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 886
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
I still get nothing. I've copied exactly what you wrote.
Attached Thumbnails
Click image for larger version

Name:	Skærmbillede 2017-10-12 21.18.54.png
Views:	10
Size:	41.8 KB
ID:	159424  
Tanjamuse is offline   Reply With Quote
Old 10-12-2017, 03:22 PM   #207
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 939
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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
DaltonST is offline   Reply With Quote
Old 10-12-2017, 03:25 PM   #208
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 939
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Quote:
Originally Posted by Tanjamuse View Post
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 is offline   Reply With Quote
Old 10-12-2017, 03:29 PM   #209
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 939
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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]+
In other words, RE #9 should be the above.


DaltonST
DaltonST is offline   Reply With Quote
Old 10-12-2017, 03:38 PM   #210
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 886
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
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]+/
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.
Attached Thumbnails
Click image for larger version

Name:	Skærmbillede 2017-10-12 21.35.18.png
Views:	8
Size:	42.5 KB
ID:	159425  
Tanjamuse is offline   Reply With Quote
Reply

Tags
columns, search

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] Search the Internet kiwidude Plugins 283 06-28-2017 05:54 PM
[GUI Plugin] Walk Search History kiwidude Plugins 12 01-01-2017 10:31 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
[GUI Plugin] Clipboard Search kiwidude Plugins 9 08-12-2014 03:36 AM


All times are GMT -4. The time now is 09:25 PM.


MobileRead.com is a privately owned, operated and funded community.