CODEWITHSUNDEEP
databasecsvtime-seriesinfluxdbinfluxdb-2
rollercoaster
rollercoaster

Reputation: 15

InfluxDB CSV Upload via the UI for InfluxDB version 2.7.11 OSS

I'm trying to upload some data via the InfluxDB UI. The current data format is in .csv format. As i understand correctly it needs to follow a certain format like adding annotations to it. Currently i'm in the process of learning also and for that i rather upload the files via the UI than play with the CLI or endpoints, at least while testing.

This is my current format for the .csv file

#group,false,false,false,false
#datatype,dateTime:RFC3339,long,string,string
#default,,,,
,_time,_value,_field,_measurement
,2023-01-01T09:30:00Z,100000,AAPL,candlestick

and i get this error consistenly for any order/option i've made:

Failed to upload the selected CSV: runtime error @3:14-3:32: to: no time column detected

I understand that maybe i'm missing a crucial point here, but can someone guide me where i'm making the mistake, while on the other hand the file/data from this documentation:

https://docs.influxdata.com/influxdb/cloud/reference/syntax/annotated-csv/

works and imports without any issues.

#group,false,false,true,true,false,false,true,true,true,true
#datatype,string,long,dateTime:RFC3339,dateTime:RFC3339,dateTime:RFC3339,double,string,string,string,string
#default,mean,,,,,,,,,
,result,table,_start,_stop,_time,_value,_field,_measurement,host,region
,,0,2022-12-31T05:41:24Z,2023-01-31T05:41:24.001Z,2023-01-01T00:52:00Z,15.43,mem,m,A,east
,,1,2022-12-31T05:41:24Z,2023-01-31T05:41:24.001Z,2023-01-01T00:52:00Z,59.25,mem,m,B,east
,,2,2022-12-31T05:41:24Z,2023-01-31T05:41:24.001Z,2023-01-01T00:52:00Z,52.62,mem,m,C,east

Upvotes: 0

Views: 22

Answers (0)

Related Questions