Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 07-23-2012, 02:58 PM   #1
todwatts
Junior Member
todwatts began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Aug 2011
Location: Illinois
Device: Kindle
Finding books with multiple formats

Need help culling same book stored in different formats.

I have a library of books approaching 4,000 ... I'd like to cull or atleast be able to identify a book that is stored in multiple formats (say epub, mobi and lit).

By scrolling through my library, I've been able to delete some space ... but according to my format count ... I have some 32 books stored in multiple formats ... but for the life of me, I can't find them.

Is there a plug-in or a search method. I have "Find Duplicates" but it doesn't seem to point out the same book, stored in different formats.

Thanks for your help
todwatts is offline   Reply With Quote
Old 07-24-2012, 02:18 AM   #2
lar3ry
Enthusiast
lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.
 
Posts: 26
Karma: 6096
Join Date: Oct 2011
Location: Saskatchewan
Device: Kobo WiFi and Kobo Touch
Quote:
Originally Posted by todwatts View Post
Need help culling same book stored in different formats.

I have a library of books approaching 4,000 ...

By scrolling through my library, I've been able to delete some space ... but according to my format count ... I have some 32 books stored in multiple formats ... but for the life of me, I can't find them.
I would use the format tag in the tag browser. If you only have 32 books stored in multiple formats, it should be easy to do.

Bring up the tag browser, and click on "Formats". This will show you what formats are present.

Click on the format with the least number of entries. This will result in all those entries with that format in the book list.

Click on each one in turn, and have a look at the "Formats" line in "book details".

Delete any unwanted formats using "Remove Books of a specific format".

Repeat for any other formats you want to delete.
lar3ry is offline   Reply With Quote
Advert
Old 07-24-2012, 02:54 AM   #3
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 16,951
Karma: 26316392
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo,Aura H2O,Glo HD,Aura ONE,Clara HD,Forma;tolino epos
What lar3y said is a good idea, but we can extend it a bit.

If after clicking on a format to display all the books with that format, you CTRL-click (hold the CTRL key down while clicking) on another format, all books for both formats will be displayed. In the search bar will be something like:
Code:
formats:"=EPUB" or formats:"=MOBI"
The above show all books with either EPUB or MOBI formats.

If you remove the "or" from that line and press enter, this will change to doing an "and" between the two search conditions. So, it will only show books with both formats.

You can type the search in directly if you want and you know what the search terms are.
davidfor is offline   Reply With Quote
Old 07-24-2012, 09:01 AM   #4
lar3ry
Enthusiast
lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.lar3ry got an A in P-Chem.
 
Posts: 26
Karma: 6096
Join Date: Oct 2011
Location: Saskatchewan
Device: Kobo WiFi and Kobo Touch
Quote:
Originally Posted by davidfor View Post
Code:
formats:"=EPUB" or formats:"=MOBI"
The above show all books with either EPUB or MOBI formats.

If you remove the "or" from that line and press enter, this will change to doing an "and" between the two search conditions. So, it will only show books with both formats.
I like it! Works like a charm for Authors (as in collaborations or anthologies) as well, which is something I have wanted to do a few times.
lar3ry is offline   Reply With Quote
Old 07-24-2012, 09:18 AM   #5
chaley
Grumpy old git
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 8,964
Karma: 2737706
Join Date: Jan 2010
Location: UK
Device: Many android devices
Quote:
Originally Posted by todwatts View Post
I have a library of books approaching 4,000 ... I'd like to cull or atleast be able to identify a book that is stored in multiple formats (say epub, mobi and lit).
search for "formats:#>1" (no quotes) or for whatever number you want. The hash sign tells calibre to count the number of values instead of looking at the values.
chaley is offline   Reply With Quote
Advert
Old 07-24-2012, 10:23 AM   #6
todwatts
Junior Member
todwatts began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Aug 2011
Location: Illinois
Device: Kindle
davidfor>formats:"=EPUB" and formats:"=MOBI"

Worked like a charm! Thanks. About drove myself crazy looking one at a time for the 32 books stored in multiple formats in a 4000 library library.

I know deleting multiple formats are a small space saver ... but I back up my library to various external harddrives ... some of which are pretty tight.

You guys are GREAT!

chaley>"formats:#>1"

Thanks for that! Even though I've used boolean searches in dBASE, I didn't realize Calibre was so powerful.

Thanks for all the help!

Last edited by todwatts; 07-24-2012 at 10:26 AM.
todwatts is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding and Deleting Duplicate Files of different formats dpayment General Discussions 19 10-19-2011 03:02 PM
<Command Line> Add multiple books in multiple formats himitsu Calibre 8 09-25-2010 11:07 PM
Bug: entries with multiple formats trigger multiple conversions flinx1 Calibre 12 05-21-2010 06:23 AM
Multiple formats - What gets sent edbro Calibre 2 01-20-2010 08:38 PM
Duplicate books - multiple formats mranlett Calibre 5 09-26-2009 07:02 AM


All times are GMT -4. The time now is 11:26 PM.


MobileRead.com is a privately owned, operated and funded community.