02-15-2010, 04:41 PM | #1 |
Junior Member
Posts: 5
Karma: 10
Join Date: Feb 2010
Device: Sony PRS-505
|
Show Duplicate Titles
Hi
Is there anyway I can get Calibre to display all books with duplicate titles? Thanks NoBiscuit |
02-15-2010, 04:44 PM | #2 |
Not scared!
Posts: 13,424
Karma: 81011643
Join Date: Mar 2009
Location: Midlands, UK
Device: Kindle Paperwhite 10, Huawei M5 10
|
If you sort by Title then any duplicates will be all together. Is that enough for your purposes?
|
Advert | |
|
02-15-2010, 04:52 PM | #3 | |
Junior Member
Posts: 5
Karma: 10
Join Date: Feb 2010
Device: Sony PRS-505
|
Quote:
Thanks anyway. |
|
02-15-2010, 04:54 PM | #4 |
Not scared!
Posts: 13,424
Karma: 81011643
Join Date: Mar 2009
Location: Midlands, UK
Device: Kindle Paperwhite 10, Huawei M5 10
|
Ah - OK, sorry. I'm a kind of 'lowest common denominator' kind of guy. Hopefully somebody a bit more sophisticated in usage of Calibre will be along shortly.
|
02-15-2010, 05:36 PM | #5 |
Well trained by Cats
Posts: 30,372
Karma: 58053698
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Just to make your automatic problem more difficult:
1 character difference makes it a different title: Blue Moon vs Blue moon vs Blue_Moon Eyball Mk 1 is a wonderful thing. The other Gotcha is I have 2 different books with the same title..Different Authors Ouch! Btw sort Authors first, then sort Titles Calibre seems to bias the sort by the previous sort. (is this a Bubble sort?) |
Advert | |
|
02-15-2010, 06:06 PM | #6 | |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Quote:
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 Last edited by Starson17; 02-15-2010 at 06:09 PM. |
|
02-16-2010, 04:33 AM | #7 |
Junior Member
Posts: 5
Karma: 10
Join Date: Feb 2010
Device: Sony PRS-505
|
That is all part of my pain.
|
02-16-2010, 04:34 AM | #8 | |
Junior Member
Posts: 5
Karma: 10
Join Date: Feb 2010
Device: Sony PRS-505
|
Quote:
|
|
02-16-2010, 04:52 AM | #9 |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
|
02-16-2010, 08:16 AM | #10 |
Junior Member
Posts: 5
Karma: 10
Join Date: Feb 2010
Device: Sony PRS-505
|
|
09-19-2010, 02:39 AM | #11 |
Junior Member
Posts: 8
Karma: 22
Join Date: Aug 2010
Device: iPad
|
Still Working
Hi,
Does this method still work with 0.7.19? When I ran the query from bash, it gave me a blank result in dupes.txt. I tried to run a simple 'get * from books' and it threw me a couple paragraphs worth of errors, none of which seemed to be permission-based (I ran the query as SU). Thanks, ZR |
09-19-2010, 11:30 AM | #12 |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
|
05-30-2011, 01:45 AM | #13 | |
Junior Member
Posts: 1
Karma: 10
Join Date: May 2011
Device: Nook
|
Quote:
FWIW: judging from the command line code Starson17 has shown, it looks like it would work well in a 'nix environment, but for the windows users this would be more appropriate. Create a batch file using the following code: Code:
@echo off "%PROGRAMFILES%\Calibre2\calibre-debug" -c "from calibre.library.database2 import LibraryDatabase2; db = LibraryDatabase2('X:\Path\To\CalibreLibrary');dupes = db.conn.get('select title from books group by title having count(*) > 1;');print dupes;" > C:\dupe-titles.txt And for those using a 64-bit Windows machine, substitute "%PROGRAMFILES(X86)%" for the "%PROGRAMFILES%" path. Also be sure to include the quotes I have shown for the "%PROGRAMFILES%" path at the beginning. ---Cole |
|
05-30-2011, 03:20 AM | #14 |
Wizard
Posts: 4,553
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
|
The easiest way to find duplicates is to install and use the "Find Duplicates" plugin.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help With Duplicate Book Titles | pghaworth | Calibre | 25 | 09-17-2010 04:56 PM |
Duplicate series titles? | hairybiker | Calibre | 2 | 03-17-2010 06:27 AM |
PRS 300: Duplicate titles on reader (and growing!) | 747sardine | Sony Reader | 4 | 02-19-2010 04:37 PM |
PRS 300 and duplicate titles | rypleigh | Introduce Yourself | 1 | 12-27-2009 03:16 PM |
Duplicate titles on PRS700 with SD card | herbdb | Sony Reader | 5 | 01-26-2009 09:40 AM |