[GUI Plugin] Multi-Column Search

[Tanjamuse]

Can I use the plugin to search for books with the same title but different publishers? I looked over the plugin but couldn't figure out how to do it?

[DaltonST]

Originally Posted by Tanjamuse

Can I use the plugin to search for books with the same title but different publishers? I looked over the plugin but couldn't figure out how to do it?

MCS executes "Inter-Book" Searches using "equals", not "does not equal".

The easiest way to do what you want to do that I can think of is to create a Calibre Catalog of only Title & Publisher columns in a .csv format.

Import that .csv into a spreadsheet application, and format all of the data as Text.

Then, use standard spreadsheet functionality to sort by Title then Publisher, and then to summarize and group the data first by Title and then by Publisher.

After all of the grouping has been accomplished, and Titles with only a single Publisher have been removed, Titles with multiple Publishers should remain.

You can then copy the final Titles (only) that you are interested in into your clipboard, then use the Job Spy GUI Tool "Search for Book Title List Currently in System Clipboard" to find all of the matching Calibre Books.



DaltonST

[DaltonST]

Version 1.0.76 - 12 December 2019 Similarity Queries Tab.

See the attached image.

ToolTips are required reading; hover your mouse over each area of the window.



DaltonST

[Tanjamuse]

Thanks a lot. Could it perhaps be expanded so that it's more than just one column? Also what's the percentage for find duplicate's "similar" ?

[DaltonST]

Originally Posted by Tanjamuse

Thanks a lot. Could it perhaps be expanded so that it's more than just one column? Also what's the percentage for find duplicate's "similar" ?

[1] The unique similarity group ID custom column is tag-like, so there only needs to be one (1) of it. To compare multiple columns for each book, simply execute the query for each column sequentially. The image shows that many queries for different comparison value columns have already been executed, with the many unique similarity group IDs for each book, if any, so indicated.


[2] The Value Comparison Percentage specifies how similar a comparison value has to be for one book to another book for a specific comparison value from the specified comparison value column. 100% means "identical".


Attached is an example that includes the Debug Log.




DaltonST

[Tanjamuse]

At 88% it says Three Block South is the same as Three Block North for title.

Can you add author as well?

Thanks so much for your work

[Tanjamuse]

Can you perhaps add an option where different percentages adds a letter or something? That way if I run it with different percentages it doesn't overwrite the tag.

[DaltonST]

The titles differ only by the letters n, s, r, u. Raise the % and rerun, or ignore it. Human judgement is required.

[Tanjamuse]

It wasn't a complain ... Thanks again

[DaltonST]

Originally Posted by Tanjamuse

Can you perhaps add an option where different percentages adds a letter or something? That way if I run it with different percentages it doesn't overwrite the tag.

I could, but that would greatly complicate automatic housekeeping that it does to remove orphan or obsolete Similarity Group ID Tags.


A far better solution is for you to add a 2nd Similarity Group Custom Column, and use #1 some purposes, and #2 for other purposes. You would have history that could easily be deleted via Bulk Metadata Edit when you are finished.


DaltonST

[Tanjamuse]

Thanks again.

[DaltonST]

Version 1.0.77 - 13 December 2019 Similarity Queries: 'Authors' Added; Search Speed Optimized.


DaltonST

[DaltonST]

Version 1.0.78 - 03 January 2020 Technical changes after Python 3.8 testing with Calibre 4.99.2.



DaltonST

[Angelo.Mascaro]

I searched the table _mcs_authors_by_book with DB Browser for SQLite with this query:
SELECT authorname, count(book) AS totalbook
FROM _mcs_authors_by_book
GROUP BY authorname
ORDER BY totalbook DESC
because I wanted to know the authors with more books.
I discovered that this table does not reflect the true content of the library and all the deleted/moved books are still considered. The field book in this table points to id of books that are no longer in the table books.
Would it be possible to fix this modifying the TRIGGER books_delete_trg in one of the next versions? Or maybe there is a way to realign the table to the library?

[Angelo.Mascaro]

I just discovered that the plugin was installed only on the MAC, thus maybe using the window installation of Calibre without the plugin caused the weird behavior.