CSV import through UI

InfluxDB 2
, ,
1

Hi
I’m having an issue importing data from csv.

This is the first line of the csv file
#datatype measurement,dateTime,tag,tag,tag,double,double,double,double
asset,date,item,location,shop,ordered,qty,price,sold

Through the UI, I’m running

import "experimental/csv"

csv.from(url: "http://192.168.10.10/data.csv")
  |> to(bucket: "test", org: "myorg")

I keep getting:

 error in csv.from(): failed to read metadata: missing expected annotation datatype

I thought that I had made a mistake so I copied the following from the documentation and I’m still getting the same error:

#datatype measurement,tag,tag,field,field,ignored,time
m,cpu,host,time_steal,usage_user,nothing,time
cpu,cpu1,host1,0,2.7,a,1482669077000000000
cpu,cpu1,host2,0,2.2,b,1482669087000000000

What am I doing wrong?

I’m running the latest docker version.

2 Likes