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
Sean is a Technical Director at High Moon Studios where he creates console video games.
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
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