Mungo Smash: Finding Duplicate Images in Aperture

April 08, 2006

Finding Duplicate Images in Aperture

While playing around with the Aperture database I decided to try to make something useful. The result is an Automator workflow that looks for duplicate master image names.

Here's the result. Disclaimer: it's not pretty and the output goes so TextEdit instead of some fancy Cocoa application or Aperture album. Please give it a try and let me know if anything goes wrong.

Find Aperture Duplicates v0.1

Print the project in which each duplicate exists
Figure out how to create a 'duplicates' album with AppleScript
Figure out how to do the query using AppleScript instead of sqlite3 and direct database access
Use capture date to eliminate false positives

Posted by sean at April 8, 2006 07:47 PM

Comments

Hi,

just wondering.. wouldn't it be better to compare the checksums?

Something like this:
sqlite> select distinct A.ZVERSIONNAME, A.ZNAME, b.zname from zrkfile a, zrkfile b where a.ZCHECKSUM = b.ZCHECKSUM and A.ZPROJECTUUID <> B.ZPROJECTUUID ;

I've got some duplicates also, really wish it wouldn't import those :(

please let me know what you think.

Regards,

Frank

Posted by: Frank Ederveen at April 14, 2006 04:49 AM

Hi,