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-07-2015, 03:56 PM   #16
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
@enkirkby:

Are you saying that you have a Custom Column with a user-friendly name of "Original_name" that has a "Search/Lookup Name" of "#original_title"? Why isn't the name "Original Title"? Or is the name really "#original_name"?

Please post a screen snip of your Calibre > Preferences > Add Your Own Columns > Edit Settings for your "#original_title" column. I need to see what kind of Custom Column it is (TEXT or COMMENT). It must be identical to the type that "title" is, TEXT. If not, and it is a COMMENT type, it may have HTML tags in it, and will never be identical to pure text. In that case, you need to create a new TEXT version, and use that instead.

In the meantime, test using an Operator of "contains" instead of "=". That might work if the value is contiguous (not separated by any HTML tags).

[EDIT:] But "SWAP" the right side of your parameters "vertically" so the question is: "Is title contained in #original_title", not the reverse.


DaltonST

Last edited by DaltonST; 09-07-2015 at 03:59 PM. Reason: [EDIT:] But "SWAP" the right side ...
DaltonST is offline   Reply With Quote
Advert
Old 09-07-2015, 04:12 PM   #17
enkirkby
Junior Member
enkirkby began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Sep 2015
Device: kindle paperwhite
See my setting of custom column in attached picture.
When I changed "=" to "contains", the search produced just one result, the book where the title is equal to #original_title.
When I swap right side vertically, search will produce the same as in reverse order.

[Image violates Posting Guidelines for size - MODERATOR]

Quote:
Originally Posted by DaltonST View Post
@enkirkby:

Are you saying that you have a Custom Column with a user-friendly name of "Original_name" that has a "Search/Lookup Name" of "#original_title"? Why isn't the name "Original Title"? Or is the name really "#original_name"?

Please post a screen snip of your Calibre > Preferences > Add Your Own Columns > Edit Settings for your "#original_title" column. I need to see what kind of Custom Column it is (TEXT or COMMENT). It must be identical to the type that "title" is, TEXT. If not, and it is a COMMENT type, it may have HTML tags in it, and will never be identical to pure text. In that case, you need to create a new TEXT version, and use that instead.

In the meantime, test using an Operator of "contains" instead of "=". That might work if the value is contiguous (not separated by any HTML tags).

[EDIT:] But "SWAP" the right side of your parameters "vertically" so the question is: "Is title contained in #original_title", not the reverse.


DaltonST

Last edited by Dr. Drib; 09-07-2015 at 08:02 PM. Reason: corrected mistake
enkirkby is offline   Reply With Quote
Old 09-07-2015, 04:16 PM   #18
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
@enkirkby:

You said:
Quote:
I want to find all books which has the same author
MCS is for comparing different columns (standard or custom). It can also compare columns to text values (e.g. Jules Verne). It cannot "find all books that have the same author", unless you specify the author's name (e.g. Jules Verne).

Standard Calibre has functionality to "find all books that have the same author".

MCS does what Standard Calibre cannot do.

You should SWAP "sideways", putting your Title parameters on the left. Then, change the middle boolean logic operator to "inactive". That means "inactive for this search; disregard it; just use the parameters on the left side".

Simplifying your parameters may solve your problem.


DaltonST
DaltonST is offline   Reply With Quote
Old 09-07-2015, 04:25 PM   #19
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
It produces the same result swapped vertically because (now we know) your custom column is TEXT, not COMMENT. The purpose of the swap was to compensate for it being COMMENT. No need to swap vertically if is TEXT.

See my other post about swapping horizontally, and inactivating the author = author side.
DaltonST is offline   Reply With Quote
Old 09-07-2015, 04:36 PM   #20
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
@enkirkby:

You are trying to find a book that has a Title = Custom Column Value of Another Book.

MCS looks at one (1) book at a time. MCS compares columns for a single book to other columns within that same, single book.

It does not compare every column for every book to the same column for every other book in the library.

I guess I could add major new functionality to MCS to do what you are asking, but it will be October until I can even think about it.



DaltonST
DaltonST is offline   Reply With Quote
Advert
Old 09-07-2015, 04:40 PM   #21
enkirkby
Junior Member
enkirkby began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Sep 2015
Device: kindle paperwhite
Jules Verne is just an example. I have many books translated and also in original language. So I can't specify the author by name.
So I want to display all books which has the same author and same #original_title. The author is crucial for comparison, as the same title/#original_title can have multiple authors. So I will filter out all books for which I have translation.

Example or returned result:
Author ------------------ Name ------------------------- #original_title
Jules Verne ---- Five weeks in ballon -------------- Cinq semaines en ballon
Jules Verne ---- Cinq semaines en ballon --------- Cinq semaines en ballon
Victor Hugo ---- Notre-Dame de Paris --------------- Notre-Dame de Paris
Victor Hugo ---- The Hunchback of Notre-Dame ---- Notre-Dame de Paris

Quote:
Originally Posted by DaltonST View Post
@enkirkby:

You said:


MCS is for comparing different columns (standard or custom). It can also compare columns to text values (e.g. Jules Verne). It cannot "find all books that have the same author", unless you specify the author's name (e.g. Jules Verne).

Standard Calibre has functionality to "find all books that have the same author".

MCS does what Standard Calibre cannot do.

You should SWAP "sideways", putting your Title parameters on the left. Then, change the middle boolean logic operator to "inactive". That means "inactive for this search; disregard it; just use the parameters on the left side".

Simplifying your parameters may solve your problem.


DaltonST
enkirkby is offline   Reply With Quote
Old 09-07-2015, 04:47 PM   #22
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
@enkirkby:

You are trying to find a book that has a Title = Custom Column Value of Another Book.

MCS looks at one (1) book at a time. MCS compares columns for a single book to other columns within that same, single book.

It does not compare every column for every book to the same column for every other book in the library.


DaltonST
DaltonST is offline   Reply With Quote
Old 09-07-2015, 04:47 PM   #23
enkirkby
Junior Member
enkirkby began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Sep 2015
Device: kindle paperwhite
You hit the head of nail. :-)
I thought that this functionality is implemented and MCS can do the work.
As I know we all have many other important things to do, this is not what I must have. But if you find it useful for others and consider to add this functionality in the future relases, it would be great.
Many thanx for your time and helping hand.
EKB

Quote:
Originally Posted by DaltonST View Post
@enkirkby:

You are trying to find a book that has a Title = Custom Column Value of Another Book.

MCS looks at one (1) book at a time. MCS compares columns for a single book to other columns within that same, single book.

It does not compare every column for every book to the same column for every other book in the library.

I guess I could add major new functionality to MCS to do what you are asking, but it will be October until I can even think about it.



DaltonST
enkirkby is offline   Reply With Quote
Old 09-07-2015, 08:01 PM   #24
Dr. Drib
Grand Sorcerer
Dr. Drib ought to be getting tired of karma fortunes by now.Dr. Drib ought to be getting tired of karma fortunes by now.Dr. Drib ought to be getting tired of karma fortunes by now.Dr. Drib ought to be getting tired of karma fortunes by now.Dr. Drib ought to be getting tired of karma fortunes by now.Dr. Drib ought to be getting tired of karma fortunes by now.Dr. Drib ought to be getting tired of karma fortunes by now.Dr. Drib ought to be getting tired of karma fortunes by now.Dr. Drib ought to be getting tired of karma fortunes by now.Dr. Drib ought to be getting tired of karma fortunes by now.Dr. Drib ought to be getting tired of karma fortunes by now.
 
Dr. Drib's Avatar
 
Posts: 41,104
Karma: 28985469
Join Date: Jan 2007
Location: San Borja (Lima), Peru
Device: Kindle: Oasis 3G, Voyage WiFi;FireHD; Kobo: Aura One, Glo HD
Moderator Notice

enkirkby
Please take a few moments to read our Posting Guidelines, in particular the part about the maximum image size allowed (600x600 pixels). Images that violate those guidelines will be deleted.

It is every member's responsibility to read our Posting Guidelines and follow them.

Thanks.
Dr. Drib is offline   Reply With Quote
Old 10-31-2015, 12:35 PM   #25
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
One of Your Personal Regular Expressions Not Working?

If you have specified one of your Regular Expressions to be used as a search criterion, and nothing is being found, and you 'know' there should be something found, it may be due to a Regular Expression compile error.

MCS just 'ignores' regex compile errors, and moves on, returning nothing.

MCS assumes that you have previously tested your regexes before trying to use them.

To easily test your Regular Expressions, go to https://pythex.org/ and test them there. If one is invalid, you will receive an error message. You could then tune it until it works for you, then copy and paste it back into the MCS Regular Expressions Settings Tab.

Another testing resource to use is: https://regex101.com/#python.



DaltonST
DaltonST is offline   Reply With Quote
Old 11-05-2015, 12:19 PM   #26
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: New 'Inter-Book Search Query' Example

Quote:
Originally Posted by enkirkby View Post
You hit the head of nail. :-)
I thought that this functionality is implemented and MCS can do the work.
As I know we all have many other important things to do, this is not what I must have. But if you find it useful for others and consider to add this functionality in the future relases, it would be great.
Many thanx for your time and helping hand.
EKB

@enkirkby:

Please review the attached image, and tell me whether or not this is exactly what you were looking for.

Note the new "Inter-Book Search" checkbox.

"Inter-Book" means "Cross-Book" or "Across All Other Books" in this specific context.

The current (original) version of MCS implicitly does only "intra-book" searches, meaning that it compares a single book's columns directly to each other. It processes a single book at a time, then moves on to the next book.

The upcoming release will default to intra-book searches, changing to inter-book searches only when the new checkbox is checked.

When the checkbox is checked, the MCS Search Dialog automatically reconfigures itself (slightly) for inter-book searches. You will notice the descriptions in blue are different than for intra-book searches, because the interpretation of those fields changes when inter-book searches are desired.



DaltonST
Attached Thumbnails
Click image for larger version

Name:	mcs_inter_book_search_example.JPG
Views:	183
Size:	396.0 KB
ID:	143480  
DaltonST is offline   Reply With Quote
Old 11-05-2015, 01:39 PM   #27
enkirkby
Junior Member
enkirkby began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Sep 2015
Device: kindle paperwhite
Quote:
Originally Posted by DaltonST View Post
@enkirkby:

Please review the attached image, and tell me whether or not this is exactly what you were looking for.

Note the new "Inter-Book Search" checkbox.

"Inter-Book" means "Cross-Book" or "Across All Other Books" in this specific context.

The current (original) version of MCS implicitly does only "intra-book" searches, meaning that it compares a single book's columns directly to each other. It processes a single book at a time, then moves on to the next book.

The upcoming release will default to intra-book searches, changing to inter-book searches only when the new checkbox is checked.

When the checkbox is checked, the MCS Search Dialog automatically reconfigures itself (slightly) for inter-book searches. You will notice the descriptions in blue are different than for intra-book searches, because the interpretation of those fields changes when inter-book searches are desired.



DaltonST

Hello DaltonST,

that looks to be exactly what I was looking for. Can't wait to try it :-) What to say - marvelous ! Many thanx.

enkirkby is offline   Reply With Quote
Old 11-09-2015, 06:05 PM   #28
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
New Version 1.0.18 - New "Post-Search Actions" Tab

Version 1.0.18 - 09 November 2015 Major enhancement to support the Post-Search updating of a single Custom Column for books that are both 'Marked' and 'Selected'.

A new "Post-Search Actions" Tab allows highly selective updating of a Custom Column for some or all of the books that are currently "marked:true" by MCS after it returns search results. "Some or all" refers to the requirement that the books must also be manually selected to be considered for changing. So, a book must be both 'Marked' and 'Selected'.

This new functionality is a logical extension of the new-ish "Inter-Book Search" capability, although it also is useful with "Intra-Book Searches".

Page 5 of the revised User Guide provides more detailed information and images.



DaltonST
Attached Thumbnails
Click image for larger version

Name:	mcs_post_search_actions_tab.JPG
Views:	155
Size:	57.6 KB
ID:	143599  
DaltonST is offline   Reply With Quote
Old 11-10-2015, 04:12 AM   #29
mirikbb
Member
mirikbb began at the beginning.
 
Posts: 11
Karma: 10
Join Date: Jan 2012
Device: Kindle
Unhappy custom column update doesn't work :-(

Custom column update doesn't work to me :-(

Step1
As suggested, I have custom column original_title, where is original title of each book. I search in scope of all books where author is the same and #original_title.
The search produce what I was looking for. So far so good.

Step2
I have series like custom column Translation (#translation), to have possibility store Author name and index for books with translations.
So for example if duplicate search found Michael Crichton - Airframe and Michael Crichton - Drak as search result books, I can't get #translation custom column for both found books set to Crichton Michael with index 1 (for both book the same index).

I can pick up #translation custom column from drop down menu but once it is selected, the button "apply selected changes" disappear.

Why to have setup like that:
- series like column Translation will display in Tag browser
- the topics in Translation tag browser will be grouped by first letter
- same series index for the same books will logically put them together

How it could look like: http://s7.postimg.org/9uad7cuaj/mcs.jpg
mirikbb is offline   Reply With Quote
Old 11-10-2015, 07:33 AM   #30
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 mirikbb View Post
I can pick up #translation custom column from drop down menu but once it is selected, the button "apply selected changes" disappear.
@mirikbb:

The pushbutton "Apply Specified Changes [Selected and Marked Books Only]" disappears when you are trying to commingle incompatible data types. That is 'by design'.

You will note the "Target Column Data Type" just below the "Target Column" drop-down list, and "Source Column Data Type" beneath the "Source Column" drop-down list.

In your example, one is "text" and the other is "series". They are different, so the pushbutton "Apply Specified Changes [Selected and Marked Books Only]" disappears to keep you from using it. That is 'by design'.

You will note that if one is, for example, "integer" and the other is anything else except "integer", the pushbutton also disappears.

The only Data Types that MCS will allow you to commingle are Text and Comments. The pushbutton will not disappear for that combination. That too is 'by design'.

"Serieslike" metadata is comprised of 2 different values that are combined dynamically on the GUI for you to see, but are stored separately. You should use the Standard Calibre tools 'Search & Replace' and/or 'Edit Metadata', and not MCS, to do what you are trying to do.


DaltonST
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:35 AM.


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