The simpler media website CMS
I know there already are some discussions (like this or this) concerning change dates of images, but I haven't found a good answer to this topic yet.
My goal is to get a list of all images changed since a certain timestamp to sync these with a remote CMS. Those changes should include editing metadata, refreshing metadata from file (EXIF, IPTC, …) and filesystem operations like moving images to another album.
Looking at the database table
images I noticed the fields
mtime, but these seem to correspond to the date/time an image was taken and the modification timestamp of the file respectively. Obviously metadata fields like
EXIFDateTime aren't useable for this purpose either. The field
publishdate sounded most promising, but is only used to schedule publishing an image in the future.
I also thought about using
custom_data, but then it couldn't be used for anything else and couldn't even store serialized data because that would prohibit sorting.
Given that this seems to be a common question and that the topic comes up every now and then: Is there a best practice approach you guys would recommend? Is there anything planned for a future release?