bmenk Posted July 5, 2019 Report Share Posted July 5, 2019 We preserve the original Exif modfication dates by checking that option in our server preferences. We would like to find a way to do a monthly search to get the number of records that have been modified by staff. It looks like the exif tool might be able to do this, but there doesn't seem to be any documentation for using it to search specifically for XMP data. Can anyone point me in the right direction for using it to query XMP modify date without also looking at EXIF modified date? Thanks. Bobb Menk Quote Link to comment Share on other sites More sharing options...
WilfriedB Posted July 8, 2019 Report Share Posted July 8, 2019 mediaitems On 7/5/2019 at 8:57 PM, bmenk said: We preserve the original Exif modfication dates by checking that option in our server preferences. Bobb, you mean you checked "Preserve file modified date when updating metadata"? Not sure this refers to the EXIF modification date, I always believed this is the Change Date maintained by Windows, but I might be wrong. Anyway, watching at all tags I get from ExifTool, I found these results: 'EXIF:ModifyDate': '2019:07:07 22:25:48' 'XMP:MetadataDate': '2019:07:07 22:25:48+02:00' 'XMP:ModifyDate': '2019:07:07 22:25:48+02:00' I wonder, whether you see different dates and time stamps in your case caused by the above setting. I addition, if you are SQL savvy, the files table contains the columns modifiedtime, propertieschangedate and the mediaitems table has lastchange. All these fields can have different time stamps (according to my experience and if I remember correctly). Hope this helps regards Wilfried Quote Link to comment Share on other sites More sharing options...
Uwe Posted July 8, 2019 Report Share Posted July 8, 2019 Hello, Wilfried is right. The "Preserve file modified..." of the Preferences belongs to the Windows File system management and not to any "internal" metadata of the file. It is changed if anything of the file was modified. That also means that if you change matadata (e.g. keyword) save the changes and remove them again, the date corresponds to your last action: the remove. The "internal" dates of the metadata (EXIF/XMP) are adjusted by the Adobe XMP toolkit that is used by Daminion to manage the metadata. If you are working with RAW files and its sidecar files the RAW file is not changed (depends on you settings in the Preferences - see screenshot in Wilfrieds post) but the XMP sidecar. That mean that the RAW file keeps its modify date and the XMP sidecar file gets a new one - the date of the last modification. Regards, Uwe Quote Link to comment Share on other sites More sharing options...
bmenk Posted July 8, 2019 Author Report Share Posted July 8, 2019 Thanks to both of you for the advice. This should be enough for us to go on. Bobb Menk 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.