I am trying to upload an annotated CSV via the web interface (screenshot below just to be clear). My details are InfluxDB v2.3.0+SNAPSHOT.090f681737 Server: 090f681 Frontend: a2bd1f3
Initially I created a CSV using Unix epoch time (I tried with/without milliseconds and nanoseconds), and in all cases I got the following error:
Failed to upload the selected CSV: error in csv.from(): parsing time "1633885200000000000" as "number": cannot parse "1633885200000000000" as "number"
Here is my CSV that gave the above error:
#group,FALSE,FALSE,FALSE,FALSE,TRUE,TRUE #datatype,string,long,dateTime:number,double,string,string #default,mean,,,,, ,result,table,_time,_value,_field,_measurement ,,0,1633885200000000000,349.44,Usage_in_kWh,ElectricityUsageData ,,0,1633888800000000000,347.28,Usage_in_kWh,ElectricityUsageData ,,0,1633892400000000000,339.84,Usage_in_kWh,ElectricityUsageData
I then changed the timestamps to RFC3339 format and using some different dates…
#group,FALSE,FALSE,FALSE,FALSE,TRUE,TRUE #datatype,string,long,dateTime:RFC3339,double,string,string #default,mean,,,,, ,result,table,_time,_value,_field,_measurement ,,0,2019-09-01T05:00:00Z,349.44,Usage_in_kWh,ElectricityUsageData ,,0,2019-09-01T06:00:00Z,347.28,Usage_in_kWh,ElectricityUsageData ,,0,2019-09-01T07:00:00Z,339.84,Usage_in_kWh,ElectricityUsageData
The above worked (“Hooray” message appeared), but for reasons that are unclear to me, the timestamps have changed by 1 or 2 minutes…
I have found similar posts on this forum without any resolution. Is the CSV uploader tool fully debugged? It seems like the CLI is the preferred way to load a CSV, but I would prefer to use the web UI.
EDIT: I figured out why the _time value was appearing to be off by a few minutes. The Flux query built by the Data Explorer had this statement:
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
in there. Once I removed it, the _time values are exactly correct.
Still curious as to why the uploading annotated CSV does not work.