IoT-data-simulator icon indicating copy to clipboard operation
IoT-data-simulator copied to clipboard

Error parsing a ISO-8601 Date format from a CSV import file

Open dbeaugrand opened this issue 4 years ago • 1 comments
trafficstars

I have a CSV file with this format: datetime,temperature,humidity,pressure,carbon_dioxide,oxygen 2021-12-25T00:58:18Z,21,60,101.3,409.9,20 2021-12-25T00:58:19Z,21.05,60.1,101.6,410.3,20

I have defined the datetime (column 1) as a date type and a format of YYYY-MM-DDTHH:MM:SSZ. But it appears that the simulator is failing parsing this format. Is this an issue or is there a different way to define the datetime format for ISO-8601?

Error from log 2021-04-28 13:01:37Vehicle Simulationjava.lang.IllegalArgumentException: Illegal pattern character 'T'

Thanks for you help

dbeaugrand avatar Apr 28 '21 17:04 dbeaugrand

Try using the following format: yyyy-MM-dd'T'HH:mm:ssXXX

picobas avatar Oct 19 '21 13:10 picobas