Quote:
Originally Posted by NoBiscuit
Is there anyway I can get Calibre to display all books with duplicate titles?
|
I'm not aware of any way inside calibre. I do it by opening up the metadata.db file in sqlitespy and using an sql query.
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.