06-30-2010, 02:28 AM | #1 |
Connoisseur
Posts: 68
Karma: 479602
Join Date: Aug 2006
Device: Kindle DX
|
search for file size
having received my new kindle, I bulk-converted my ebooks to MOBI format.
As expected, I had a lot of conversion errors, which I'm trying to track down and I'm slowly solving by small changes in the source files (often HTML). My problem is how to find the problem ebooks, which can be defined as having MOBI file format with zero file size. Can I search for this in some way? alessandro |
06-30-2010, 03:44 AM | #2 |
Guru
Posts: 695
Karma: 822675
Join Date: May 2010
Device: Kobo Aura, Nokia Lumia 920 (Freda)
|
While the column header for size says that the search field is "size", it doesn't seem to actually work. However you can search for mobi formatted files using this in the search box (or using the handy categories on the left, under Formats)
Code:
formats:"=MOBI" |
Advert | |
|
06-30-2010, 03:54 AM | #3 |
Grand Sorcerer
Posts: 11,942
Karma: 7219261
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Note that 'size' is the sum of all the formats, not the size of the format searched for.
And yes, size isn't a valid search term. I could fix that, I suppose ... |
06-30-2010, 04:57 AM | #4 |
Connoisseur
Posts: 68
Karma: 479602
Join Date: Aug 2006
Device: Kindle DX
|
a fix for that would be useful...
an even better fix I guess would be not to create a new zero-size file when the conversion fails! alessandro |
06-30-2010, 06:21 AM | #5 | |
Well trained by Cats
Posts: 30,377
Karma: 58053698
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
Having the filter report the current "view" size (currently continues to report overall size would be ) |
|
Advert | |
|
06-30-2010, 09:48 AM | #6 | |
Grand Sorcerer
Posts: 11,942
Karma: 7219261
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
You could use a command-line command to find what you are looking for. The command is 'find'. If you are on windows, you need to install it from http://gnuwin32.sourceforge.net/packages/findutils.htm. Other systems will have it as a native command. Once installed, in a terminal/command box with the current directory at the top folder of the library (the one containing metadata.db), run the command Code:
find -name "*.mobi" -size 0 Code:
"\Program Files\GnuWin32\bin\find.exe" -name "*.mobi" -size 0 |
|
06-30-2010, 09:51 AM | #7 |
Grand Sorcerer
Posts: 11,942
Karma: 7219261
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Reporting the size of items found isn't something I am interested in doing. Size is a column in the books table, kept up-to-date when formats are added or removed, so searching on that would be easy. Recomputing 'size' dynamically would be expensive, as well as being a right bother to implement.
|
06-30-2010, 10:02 AM | #8 |
creator of calibre
Posts: 44,356
Karma: 23661992
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Actually, IIRC, size is the max of the sizes of the various formats, not the sum. Other than that, I agree with chaley.
|
06-30-2010, 10:18 AM | #9 |
Grand Sorcerer
Posts: 11,942
Karma: 7219261
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Kovid remembers correctly.
The select that builds the size field for the books view is SELECT MAX(uncompressed_size) FROM data WHERE book=books.id (edit: yes, I am using table & view interchangeably. Sloppy of me...) |
06-30-2010, 01:21 PM | #10 | |
Grand Sorcerer
Posts: 11,942
Karma: 7219261
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
Examples: size:>1.1M will find books with a format larger than 1.1 *1024*1024. size:<=1k finds those equal to smaller than 1 * 1024. The multipliers can be lower case. If you want to avoid the use of 1024, type the numbers out. For example, size:<1000000 will find sizes smaller than 1 million. |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
ePub file size | Adjust | ePub | 16 | 10-27-2010 11:55 AM |
Search capabilities with different file formats? | Doranwen | Astak EZReader | 8 | 06-30-2010 06:00 PM |
Book (file) size | irenas | Astak EZReader | 15 | 04-15-2010 03:21 PM |
Mac File Size | drofgnal | Calibre | 3 | 01-04-2010 08:09 PM |
Max file size? | Parastie | Sony Reader | 10 | 04-17-2009 06:28 PM |