Thread: Library full of Duplicates
View Single Post
Old 03-31-2017, 10:48 AM   #3
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 79,796
Karma: 146391129
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Quote:
Originally Posted by hotwired View Post
I have 3-4 of each book with a number in parenthesis after it. For example in my Stephen King folder I might have
A Face in the Crowd (869)
A Face in the Crowd (2)

Approximately 85% of my library is duplicates like this basically from sloppy "quick" conversion using Calibre (my sloppines, not Calibres). However, when using the find duplicates plugin, and trying every parameter possible, it shows NO DUPLICATES. I tried ccCleaner and that finally found them all but it's only finding them by folder. Only ONE folder has .mobi file in it while the DUPLICATE folder has .epubs so I can't just check off random duplicates in cccleaner because I might be deleting the only folder containing the .mobi which is my preferred format.

Thanks for any tips or alternate pieces of software ... I could take a week off work and do alot of "point, click and delete" but I'd rather not if I don't have to! Thanks all!!

Quote:
Originally Posted by DaltonST View Post
Hotwired:

The Find Duplicates plug-in uses metadata.db. Your library's metadata.db apparently no longer reflects reality due to (forbidden) manual changes to the the library's OS directory structure and contents.

Try this:

[1] Stop manually changing the library's directory structure and contents.

[2] Click Library > Library Maintenance > Check Library and then let Calibre thoroughly check your library, show you what is wrong, and then fix it. Repeat this step as many times as needed until your library is "clean".

[3] Using Bulk Edit Metadata for 100% of your books, "Automatically Set Author Sort", "Change Title to Title Case", and then finally "Update Title Sort".

[4] Using the Quality Check plug-in, standardize the Author Names as FN LN or LN,FN (your choice), but make all of the books comply with your choice.

[5] Using the Quality Check plug-in, standardize the Author Initials.

[6] Run Find Duplicates again.
A slightly different solution is after you clean up your database using DaltonST's directions, don't do step 6 just yet. Instead...

1. Sort by title
2. Pick one of the different formats with the correct metadata
3. On the other formats, right click and select Open containing folder.
4. On the picked entry, select and then press E. This will open the metadata editor.
5. Drag/drop the other format into the Medata editor dialog in the upper right
6. Once you see the other format, close Windows Explorer and delete that format's entry
7. Do this for every format of the same eBook
8. Now run a find duplicate
JSWolf is offline   Reply With Quote