Cleaning up Database of smaller JPEGs

[StanleyLeary]

When creating my database, I selected many hard drives and only imported the JPEGs. Therefore, no RAW, Movies, PDFs, PNGs, GIFs, or documents were imported, only jpegs.

The problem is that it imported so many smaller versions of a larger file.

What is the best and easiest way to get rid of all jpegs lower than 2000 pixels on the long side?

I want to select the entire database of 751000 images and then purge those smaller jpegs. I know it will probably take time, but thinking I could start the process and go to bed and wake up to all those images at least selected to then purge from the database.

Any tips are much appreciated.

[Kirk Baker]

Stanley,

When creating my database, I selected many hard drives and only imported the JPEGs. Therefore, no RAW, Movies, PDFs, PNGs, GIFs, or documents were imported, only jpegs.

The problem is that it imported so many smaller versions of a larger file.

What is the best and easiest way to get rid of all jpegs lower than 2000 pixels on the long side?

I want to select the entire database of 751000 images and then purge those smaller jpegs. I know it will probably take time, but thinking I could start the process and go to bed and wake up to all those images at least selected to then purge from the database.

This search query should result in a contact sheet that has all of the images that either side is less than 2000 pixels on a side:

(width < 2000) and (height < 2000)

There is no way to query the 'long side' directly.  There will be no other images in the contact sheet but what matches this query.

If you delete the items (Remove) from the database and do not also delete them on disk, then they'll all return if you do a Scan to Catalog or a Catalog Sync.

If you need these smaller versions but don't want them in the catalog again, you could put them into a named folder and then use the pattern matching feature of Catalog Sync to ignore those named folders.

-Kirk

[StanleyLeary]

Thank you so very much. Your suggestion helped to clean up my database a great deal.