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!
D
Solved! Go to Solution.
Hi @DominicRoberge2,
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
Hi @DominicRoberge2,
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
Thank you Jordan!
working perfectly!👏