I am currently trying to make a workbench which matches jpeg_exif_datetime attributes to a time interval from a google sheets document.
I have a list of start times and end times stored as attributes which I have converted to FME datetime format and FME datetime interval.
I have also exposed the jpeg exif data and converted this
So far I've tried two methods and feel like I'm getting close but can't quite get it to work.
I tried using an inline querier but I haven't managed to get that to work.
I can get a tester to filter the ranges using a published parameter of the datetime string and the Date/Time comparison mode. I tried running this workspace using a workspace runner but that didn't seem to output any results although it ran without errors.
If anyone has got any ideas about how I can best approach this it would be greatly appreciated.