search

marijnkampf / Random-Photo-Screensaver

Source of Random Photo Screensaver
http://www.abscreensavers.com/random-photo-screensaver/open-source
Other
44 stars 14 forks source link

Show Picture taken at a similar time of year #141

Closed HPSchoener closed 9 months ago

HPSchoener commented 9 months ago

Hallo, Marijn,

Thank you for creating the Random Photo Screensaver! I refer to the FAQ, explaining the RawSQL query for a filter:

rawSQL abs(strftime("%j", created) - strftime("%j", 'now')) < 15 "This selects photos that where taken the same time of the year of all your photos." This function does not work on my system.

I cannot figure out which metadata created is referring to, at least it is not DateTimeOriginal of the picture (which I would prefer to use). But it also does not seem to be the file creation date neither (which would also not do the function explained above, especially for my scanned slides - they contain correct DateTimeOriginal-Metadata, but the file creation date is something different).
Can you help me ? Thanks, Hans-Peter

HPSchoener commented 9 months ago

Assigning activley the date when the photograph was taken to 'FileCreateDate'

i.e. applying the following ExifTool command -FileCreateDate<$DateTimeOriginal -overwrite_original

to all files in the directory with the photos I want to show seems to solve the problem. So I need to bring this step into my normal photo processing procedure...