Skip to main content
Question

How to match jpeg exif time/date to an interval?

  • September 3, 2020
  • 1 reply
  • 14 views
edwibberley
Contributor
Forum|alt.badge.img

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

ebygomm
Influencer
Forum|alt.badge.img+46
  • ebygommInfluencer
  • Influencer
  • September 4, 2020

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

1SELECT 
2    p.exif_date, 
3    i.start_date, 
4    i.end_date, 
5    i.name
6FROM 
7    Photos p,
8    Intervals i
9where 
10    p.exif_date > i.start_date 
11and 
12    p.exif_date < i.end_date

 

Helpful Members This Week

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.