Skip to main content
Solved

XML sensor readings via HTTP


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!

Best answer by stalknecht

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/

View original
Did this help you find an answer to your question?

6 replies

stalknecht
Contributor
Forum|alt.badge.img+19
  • Contributor
  • Best Answer
  • August 13, 2018

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/


stalknecht wrote:

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!

ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • August 14, 2018

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


ebygomm wrote:

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?

ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • August 14, 2018
elisaayalapanto wrote:

 

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)

 

 


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