Skip to main content

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.

 

Screenshot 2020-09-03 at 18.44.56

 

I have also exposed the jpeg exif data and converted this

 

Screenshot 2020-09-03 at 18.44.41

 

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.

What issues were you having with the InlineQuerier? It should be a fairly straightforward query

SELECT 
    p.exif_date, 
    i.start_date, 
    i.end_date, 
    i.name
FROM 
    Photos p,
    Intervals i
where 
    p.exif_date > i.start_date 
and 
    p.exif_date < i.end_date

 


Reply