Skip to main content
  • EN

I'm getting the most current readings for streams via an xml table provided by http link. I want to make 2 tables of the readings: 1-with the most current readings and one with the history or previous days readings. What I have so far set-up in FME does the job but I cant seem to seperate "history" from "current". Also I need the time format to stay in UTC-GMT in the AttributeCreator_2 (see screenshots). I'm trying to make a live feed map in arcpro of the sensor readings so any help would be appreciated as I am totally new to FME ANYTHING!

Thanks!

To separate the two streams you need either a Tester or a TestFilter.

FME's format is UTC see: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/!Transformer_Parameters/standard_fme_date_time_format.htm

What's also handy when you begin is to look at the free training material: https://www.safe.com/training/recorded/fme-desktop-2018-basic-course/

To separate the two streams you need either a Tester or a TestFilter.

FME's format is UTC see: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/!Transformer_Parameters/standard_fme_date_time_format.htm

What's also handy when you begin is to look at the free training material: https://www.safe.com/training/recorded/fme-desktop-2018-basic-course/

 

Okay yes I found out that the DateTime Formatter was the best to use but I'm not quite sure what to but in the string. Also thank you for the help!

How are you defining most current readings? The most recent, ones taken today, ones taken in the past 24 hours?

If you want anything with a date that matches today you could test like this

How are you defining most current readings? The most recent, ones taken today, ones taken in the past 24 hours?

If you want anything with a date that matches today you could test like this

 

Ones taken the past 24 hours but I need the time to stay in UTC (GMT)
Also I have stream gauges and rain sites as 2 feature layers in arcmap/arcpro. FME is being used to generate the tables with the sensor information. I constantly have to Run Translation in FME to update the table in ArcCatalog but is there a way to have FME constantly running so the table is frequently updated with the most current sensor information?

 

Ones taken the past 24 hours but I need the time to stay in UTC (GMT)
The tester alters the format for the test but does not change the underlying data.

 

 

But if you want past 24 hours you want to test for greater than @DateTimeAdd(@DateTimeNow(),-PT24H)

 

 

Reply


Community Stats

31,758
Posts
120,641
Replies
39,382
Members

Latest FME

Terms & ConditionsCookie 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.