Csv import (cli): error invalid boolean?

InfluxDB 2 Dashboards
1

Try to import a csv file formatted in UTF-8 via CLI.

#datatype measurement,field,dateTime:number
m,riseorset,time
Sunstate,Sunrise,1440995661293
Sunstate,Sunrise,1441082164141
Sunstate,Sunrise,1441168666901
Sunstate,Sunrise,1441255169574
Sunstate,Sunrise,1441341672164
Sunstate,Sunrise,1441428174675

What could be the reason?

get this error:

unable to parse 'Sunstate riseorset=Sunrise 2494308808726': invalid boolean

THX

2

Solution which works:

#datatype dateTime:number,measurement,field
_time,_measurement,helper_value
1640936473564000000,Sunrise,0
1641022866651000000,Sunrise,0
1641109256158000000,Sunrise,0
1641195642107000000,Sunrise,0

what was wrong:

  1. field value has to be a number not a string.
  2. unix timeformat was in ms, has to be in ns, 000000 attached.