11-26-2019, 01:39 AM | #256 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
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?
|
11-26-2019, 01:57 PM | #257 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Quote:
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 |
|
Advert | |
|
12-12-2019, 04:53 PM | #258 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.76 - New: Similarity Queries Tab
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 |
12-13-2019, 02:49 AM | #259 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
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" ?
|
12-13-2019, 09:48 AM | #260 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Similarity Queries
Quote:
[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 |
|
Advert | |
|
12-13-2019, 11:10 AM | #261 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
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 |
12-13-2019, 11:57 AM | #262 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
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.
|
12-13-2019, 12:02 PM | #263 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
The titles differ only by the letters n, s, r, u. Raise the % and rerun, or ignore it. Human judgement is required.
|
12-13-2019, 12:16 PM | #264 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
It wasn't a complain ... Thanks again
|
12-13-2019, 03:43 PM | #265 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
2nd Similarity Group Custom Column
Quote:
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 |
|
12-13-2019, 04:05 PM | #266 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
Thanks again.
|
12-13-2019, 05:21 PM | #267 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.77 'Authors' Added; Search Speed Optimized
Version 1.0.77 - 13 December 2019 Similarity Queries: 'Authors' Added; Search Speed Optimized.
DaltonST |
01-03-2020, 10:04 AM | #268 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.78 Technical changes after Python 3.8 testing with Calibre 4.99.2
Version 1.0.78 - 03 January 2020 Technical changes after Python 3.8 testing with Calibre 4.99.2.
DaltonST |
01-04-2020, 09:26 AM | #269 |
Junior Member
Posts: 6
Karma: 10
Join Date: Oct 2019
Location: Karlsruhe
Device: Kindle
|
the table _mcs_authors_by_book does not reflect the true content of the library
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? |
01-04-2020, 09:33 AM | #270 |
Junior Member
Posts: 6
Karma: 10
Join Date: Oct 2019
Location: Karlsruhe
Device: Kindle
|
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.
|
Tags |
columns, search |
Thread Tools | Search this Thread |
|
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 |