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 02-04-2017, 05:48 PM   #181
KyBunnies
Book & Bunny Crazy
KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.
 
KyBunnies's Avatar
 
Posts: 1,072
Karma: 3575773
Join Date: Aug 2013
Location: USA
Device: K3 (x2), Fire HD 7-inch (x2), Fire HDX 8.9, Acer Android Tablet
Quote:
Originally Posted by DaltonST View Post
Just like Calibre itself, how MCS is used depends entirely on how and what you are trying to do. After you decide on a specific goal, read the Original Post, view its attached images, read the User Guide, then read the exhaustive ToolTips of the various Tabs within MCS itself. Then play with it, since you must teach yourself how to use it to do whatever it is you want to do. You cannot hurt anything by playing with it.

DaltonST
I am trying to find duplicate copies of books across all my libraries. It would be nice if SOMEONE could provide a little more info on how to actually use this plugin.
KyBunnies is offline   Reply With Quote
Advert
Old 02-04-2017, 06:40 PM   #182
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: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Quote:
I am trying to find duplicate copies of books across all my libraries.
MCS is not the proper tool for doing that. CALM is exactly the right tool for that job.

https://www.mobileread.com/forums/sh...d.php?t=265947


DaltonST
DaltonST is offline   Reply With Quote
Old 04-13-2017, 06:15 AM   #183
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: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
Is there any way I can set this search criteria as standard instead of author and title?

Thanks
Attached Thumbnails
Click image for larger version

Name:	SkŠrmbillede 2017-04-13 11.14.35.png
Views:	75
Size:	53.7 KB
ID:	156156  
Tanjamuse is offline   Reply With Quote
Old 04-13-2017, 09:06 AM   #184
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: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
2 types of Cross-Library Queries

Quote:
Originally Posted by Tanjamuse View Post
Is there any way I can set this search criteria as standard instead of author and title?
There are 2 types of Cross-Library Queries: CL Intra-Book and CL Duplicates. See the attached image.

MCS will automatically validate your parameters and tell you of any parameter errors when you click the "Save Criteria" button.

DaltonST
Attached Thumbnails
Click image for larger version

Name:	cl_intrabook_query_versus_cl_duplicates_query.jpg
Views:	64
Size:	822.9 KB
ID:	156158  
DaltonST is offline   Reply With Quote
Old 04-25-2017, 12:55 PM   #185
taratears
Connoisseur
taratears began at the beginning.
 
Posts: 71
Karma: 10
Join Date: Aug 2013
Device: Kindle Fire HD
I'm trying to figure out how to use this to do a full text search, and am apparently doing something incorrectly. Could I be walked thru the process of doing this, please?
taratears is offline   Reply With Quote
Advert
Old 04-25-2017, 01:39 PM   #186
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: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
The ToolTips are quite detailed and explain everything. I have attached them below.
Attached Thumbnails
Click image for larger version

Name:	mcs_fulltextsearch.jpg
Views:	55
Size:	371.4 KB
ID:	156368  
DaltonST is offline   Reply With Quote
Old 08-02-2017, 06:14 AM   #187
Katja_hbg
Enthusiast
Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.
 
Posts: 37
Karma: 118860
Join Date: Oct 2015
Device: Kobo Glo HD (landscape), Kobo Aura One
I try to see all books from an author when I mark at least one book of that author with 5 stars (my rating).
- intra book search with "all author books" does not work as search seems to work with text only
- intra book search (author left, my rating right with AND and =) does not show anything
- SELECT id FROM books WHERE id IN (SELECT id FROM custom_column_18 WHERE value = 5) while _18 is my rating normalized column does not show anything

So will this kind of search be possible and if so, please provide some guidance.
Thanks
Katja_hbg is offline   Reply With Quote
Old 08-02-2017, 11:21 AM   #188
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: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
MCS and Ratings

Quote:
Originally Posted by Katja_hbg View Post
I try to see all books from an author when I mark at least one book of that author with 5 stars (my rating).
Katja:

See the attached image.


DaltonST
Attached Thumbnails
Click image for larger version

Name:	mcs_ratings.jpg
Views:	33
Size:	461.7 KB
ID:	158219  
DaltonST is offline   Reply With Quote
Old 08-02-2017, 02:17 PM   #189
Katja_hbg
Enthusiast
Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.
 
Posts: 37
Karma: 118860
Join Date: Oct 2015
Device: Kobo Glo HD (landscape), Kobo Aura One
Thanks for your reply and help. It works now.

The tooltip did not help as I use rating with a custom column. Also that my column is offered in the drop down. Anyhow I got what I like with the SQL tab.

For those who like to copy and paste please find here my sql. Replace "18" with the proper number of your customn column as shown in the tooltip on your screen.

SELECT book FROM books_custom_column_18_link
WHERE value IN (SELECT id FROM custom_column_18 WHERE value >=10 )
Katja_hbg is offline   Reply With Quote
Old 09-08-2017, 06:01 AM   #190
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: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
How do I use the search in this screenshot in a single library instead of searching for duplicates in 2 libraries?
Attached Thumbnails
Click image for larger version

Name:	SkŠrmbillede 2017-09-08 10.58.13.png
Views:	21
Size:	55.6 KB
ID:	158919  
Tanjamuse is offline   Reply With Quote
Old 09-08-2017, 11:32 AM   #191
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: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Quote:
Originally Posted by Tanjamuse View Post
How do I use the search in this screenshot in a single library instead of searching for duplicates in 2 libraries?
[1] Uncheck the "CL Duplicates" checkbox. The screen will reconfigure itself for an "Intra-Book Search".

[2] If you want to do an "Inter-Book Search", check the "Inter-Book Search" checkbox, and the screen will reconfigure itself for an "Inter-Book Search".

[3] For example scenarios, see the many images attached to the Original Post of this thread.

[4] Hover your mouse over each area and widget in the screen to read their respective ToolTips.

[5] Remember to "Save Parameters", which will also validate your settings and issue any error messages.



DaltonST
DaltonST is offline   Reply With Quote
Old 09-08-2017, 05:43 PM   #192
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: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
I Think I've done as you suggested (see attached image) but I get an error when I select: Execute Search [all books].

The error is:

Code:
calibre, version 3.6.0
ERROR: MCS: Cross-Library Duplicates Searches are never for 'All Books'.  Use 'Another Library [All Books]' instead.                                                                Execution Canceled.
Attached Thumbnails
Click image for larger version

Name:	SkŠrmbillede 2017-09-08 22.41.42.png
Views:	15
Size:	63.6 KB
ID:	158928  
Tanjamuse is offline   Reply With Quote
Old 09-08-2017, 06:10 PM   #193
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: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
You need to Save your criteria before clicking Execute. It thinks you still have "CL Duplicates" checked. As a last resort, Save, Exit, then rerun MCS. Your saved criteria will appear.
DaltonST is offline   Reply With Quote
Old 09-08-2017, 06:12 PM   #194
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: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
Is it library specific settings or all-around?
Tanjamuse is offline   Reply With Quote
Old 09-08-2017, 06:13 PM   #195
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: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
What you see applies to MCS regardless of what the current library is.
DaltonST 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 06:54 PM
[GUI Plugin] Walk Search History kiwidude Plugins 12 01-01-2017 11:31 AM
[GUI Plugin] Recoll Full Text Search Satas Plugins 16 08-05-2016 04:54 AM
[GUI Plugin] Full Text Search (SOLR) peterpisljar Plugins 2 08-09-2015 09:16 AM
[GUI Plugin] Clipboard Search kiwidude Plugins 9 08-12-2014 04:36 AM


All times are GMT -4. The time now is 12:20 AM.


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