topic Date Field issue from CSV file in ArcGIS GeoEvent Server Questions

Date Field issue from CSV file

DominicRobergeIADOT — Tue, 29 Jun 2021 20:26:22 GMT

Hello

I am trying to import a CSV file into an AGOL Hosted feature table. My Input has 4 fields: DateRead, readValue,Tower and UID

basic model

but my output doesn't return the Date info

I have tried this date format without success

Any help would be much appreciated.

thanks!

Re: Date Field issue from CSV file

Jordan — Wed, 30 Jun 2021 05:15:01 GMT

Hi @DominicRobergeIADOT,

I've always had issues parsing the milliseconds in GeoEvent. However, I have managed to get the rest of your input format of (2021-06-28 15:16:42) working if I use this date format in GeoEvent:
yyyy-MM-dd HH:mm:ss

The above format should work, even if your input format includes the milliseconds.

You shouldn't have the escaped 'T' in there, unless the T is a part of your input format, which looking at your sample input, it is not. The reason you sometimes see that is, if you're playing with the GeoEvent Simulator and set it to change the time to the current time, that will be the format it sets it to: yyyy-MM-dd'T'HH:mm:ss. It is also a time format I have come across in normal data feeds as well.

Cheers

Re: Date Field issue from CSV file

DominicRobergeIADOT — Thu, 01 Jul 2021 13:12:20 GMT

Thank you Jordan!

working perfectly!👏