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

• Aperture
• Photography