View Single Post
Old 12-13-2022, 11:07 AM   #1063
Fiammifero
Junior Member
Fiammifero began at the beginning.
 
Posts: 4
Karma: 10
Join Date: Dec 2022
Device: Several
Hello again
For the information of whoever interested -
Eventually, I found a way to delete quickly a list of 1000 probable duplicates:

Find Duplicates plugin with same titles but similar authors : 2000 rows.
I selected only the epub books. I move them to a temporary library (slow but automatic).

Then I export that list to excel (through Create a catalog / CSV).
With excel formulas, I find the lines where the same line has the same title and a similar number of pages (threshold of 80 pages).
I export them to a CSV file, keeping the columns : UUID, title, authors.

Then I use the Import List Plugin to import this CSV with matching method = UUID. I import that in a DUP list created with the Reading List plugin. Then I delete the 1000 books at once in the DUP list.

Thus I manage by hand only a few cases needing special attention.
Many thanks again
Fiammifero is offline   Reply With Quote