Quote:
Originally Posted by pghaworth
I'm trying to clean up my Calibre library and merge formats. Is there any way I can tell Calibre to look for and bring up only duplicate [or similar titles], other than sorting by title?
|
I find duplicate titles by opening up the metadata.db file in sqlitespy and using an sql query.
Alternatively, this will also do it:
Code:
calibre-debug -c "from calibre.library.database2 import LibraryDatabase2; db = LibraryDatabase2('/path/to/library/folder');dupes = db.conn.get('select title from books group by title having count(*) > 1;');print dupes;">dupes.txt
Copy that long line, change the path to point to your library folder and paste it into a command window (terminal window, dos box, whatever you call it) and it will produce a file in the current directory called dupes.txt with all your duplicate titles in it. It's a list of dupe titles in unicode format.