Finding Duplicate Images in Aperture

By

Sean

– April 8, 2006Posted in: Photography, Programming

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

TODO
• 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

Tags: Aperture, Photography

About Sean

Sean is a Technical Director at High Moon Studios where he creates console video games.

2 Comments

1. Reply

   Frank Ederveen

   Posted April 14, 2006 at 4:49 AM

   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

2. Reply

   Frank Ederveen

   Posted April 14, 2006 at 4:50 AM

   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