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

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 06-30-2010, 02:28 AM   #1
alexxx
Connoisseur
alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.
 
Posts: 67
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
alexxx is offline   Reply With Quote
Old 06-30-2010, 03:44 AM   #2
toddos
Guru
toddos ought to be getting tired of karma fortunes by now.toddos ought to be getting tired of karma fortunes by now.toddos ought to be getting tired of karma fortunes by now.toddos ought to be getting tired of karma fortunes by now.toddos ought to be getting tired of karma fortunes by now.toddos ought to be getting tired of karma fortunes by now.toddos ought to be getting tired of karma fortunes by now.toddos ought to be getting tired of karma fortunes by now.toddos ought to be getting tired of karma fortunes by now.toddos ought to be getting tired of karma fortunes by now.toddos ought to be getting tired of karma fortunes by now.
 
toddos's Avatar
 
Posts: 694
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"
Once you have the list of all books with MOBI-formatted files, you can sort by the Size column to put the 0-size files at the top (or bottom).
toddos is offline   Reply With Quote
Old 06-30-2010, 03:54 AM   #3
chaley
"chaley", not "charley"
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: 5,619
Karma: 857074
Join Date: Jan 2010
Location: France
Device: Many android devices
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 ...
chaley is offline   Reply With Quote
Old 06-30-2010, 04:57 AM   #4
alexxx
Connoisseur
alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.alexxx ought to be getting tired of karma fortunes by now.
 
Posts: 67
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
alexxx is offline   Reply With Quote
Old 06-30-2010, 06:21 AM   #5
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 14,839
Karma: 5654321
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by chaley View Post
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 ...
The data table has the formats and uncompressed_size.
Having the filter report the current "view" size (currently continues to report overall size would be )
theducks is offline   Reply With Quote
Old 06-30-2010, 09:48 AM   #6
chaley
"chaley", not "charley"
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: 5,619
Karma: 857074
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by alexxx View Post
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!
The second is out of my area.

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
If you are on windows, you might need to type
Code:
"\Program Files\GnuWin32\bin\find.exe" -name "*.mobi" -size 0
You will get a list of .mobi files with zero length. The path will tell you the author and title.
chaley is offline   Reply With Quote
Old 06-30-2010, 09:51 AM   #7
chaley
"chaley", not "charley"
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: 5,619
Karma: 857074
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by theducks View Post
The data table has the formats and uncompressed_size.
Having the filter report the current "view" size (currently continues to report overall size would be )
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.
chaley is offline   Reply With Quote
Old 06-30-2010, 10:02 AM   #8
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,103
Karma: 5101571
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.
kovidgoyal is offline   Reply With Quote
Old 06-30-2010, 10:18 AM   #9
chaley
"chaley", not "charley"
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: 5,619
Karma: 857074
Join Date: Jan 2010
Location: France
Device: Many android devices
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...)
chaley is offline   Reply With Quote
Old 06-30-2010, 01:21 PM   #10
chaley
"chaley", not "charley"
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: 5,619
Karma: 857074
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by chaley View Post
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 ...
Size has been added as a search term, along with multiplier suffixes K, M, and G. The multipliers have their normal computer meaning, 1024, 1024**2, and 1024**3.

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.
chaley 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
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


All times are GMT -4. The time now is 05:13 AM.


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