Jump to content
bmenk

How to search XMP modify dates

Recommended Posts

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

 

Share this post


Link to post
Share on other sites

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.

image.png.4e4648968becc36f2f9c1fcb878129d5.png

 

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...