Problem with damaged images and trying to sort for them in a large database

[drschilling]

Hi,

 

I have an odd problem.  I've imported about 1.1 million images into filemaker pro.

 

I've got the main image on the left and the thumbnail image on the right and they are in container fields.

 

Here's what it looks like:  http://screencast.com/t/nZ2CWMK749H

 

As you can see there are two examples of the "damaged file" showing up as "blank white boxes" rather than as images of a book cover.

 

Actually when I right click on a "good" image in the container I can "export" it.  When I right click on the "damaged" file, I don't get the "export" choice, so perhaps this means there is no "damaged" file there and that it's just a blank container?

 

Right now I am scrolling down through 1.1 million images and marking the items that have the "error" ie: no image so I can deal with them separately ie: sort for them once I've marked them as blank or damaged.

 

The problem is there is no way to "sort" for a blank white image that is in a container field.

 

I just don't know how to isolate them so I can deal with them.

 

Any ideas?

 

Thanks,

 

David

[normanicus]

Use the Python PIL package on the images before importing. It's as easy as this for one file:

 

 

from PIL import Image 

v_image = Image.open(file) 
v_image.verify()

 

You could add a way to loop through a folder of images.

 

There are probably ways to do this with less learning.

 

Easier using OS X as Python is already there.