When we attempt to upload a timeseries using Pointzilla we get the error (shown below) whenever we attempt to use a TimeOnly field. We have tried different formats but cannot successfully load our data. DateTime and DateOnly fields work as expected, it is only when the -CsvTimeOnlyField and -CsvTimeOnlyFormat are used.
It appears that there is something wrong in the way that the code interprets TimeOnlyFormats.
An example that has caused this error is:
-CsvDateOnlyField=1 -CsvDateOnlyFormat="M/d/yyyy" -CsvTimeOnlyField=2 -CsvTimeOnlyFormat="h:mm:ss tt"
Date,Time,ms,LEVEL,TEMPERATURE
3/5/2021, 12:48:27 pm, 0, 8.6480, 8.431
When we attempt to upload a timeseries using Pointzilla we get the error (shown below) whenever we attempt to use a TimeOnly field. We have tried different formats but cannot successfully load our data. DateTime and DateOnly fields work as expected, it is only when the -CsvTimeOnlyField and -CsvTimeOnlyFormat are used.
It appears that there is something wrong in the way that the code interprets TimeOnlyFormats.
An example that has caused this error is:
-CsvDateOnlyField=1 -CsvDateOnlyFormat="M/d/yyyy" -CsvTimeOnlyField=2 -CsvTimeOnlyFormat="h:mm:ss tt"
Date,Time,ms,LEVEL,TEMPERATURE
3/5/2021, 12:48:27 pm, 0, 8.6480, 8.431