Import CSV into InfluxDB

Store
1

I am trying to import CSV data into influxdb. I’ve already created the database and table. I tried many options available and have finally picked csv2influx

I am facing an error while performing the import, pls refer to the screenshot below

image
image673×723 10.7 KB

Here is the config file I am using for this utility

{
“measurementName”: “data”,
“influxdbUrl”: “http://127.0.0.1:8086/test”,
“username” : “admin”,
“password” : “admin”,
“mapping”: {
“time”: {
“from”: [“Record Start Date”, “Record Start Time”],
“type”: “timestamp”,
“format”: “jsDate”
},
“fieldSchema”: {
“Broker Name”: {
“from”: “Broker Name”,
“type”: “string”
},
“Broker UUID”: {
“from”: “Broker UUID”,
“type”: “string”
},
“EG Name”: {
“from”: “EG Name”,
“type”: “string”
},
“EG UUID”: {
“from”: “EG UUID”,

How can I pass the user credentials in the InfluxDB URL?

I tried http://localhost:8086/test?u=admin,p=admin but it doesnt work!

Pls help! Thanks!

2

Hi @radnat,

Sorry you’re frustrated. your url for passing authentication is almost correct. :slight_smile:

I tried http://localhost:8086/test?u=admin,p=admin but it doesnt work!

Instead, try http://localhost:8086/test?u=admin&p=admin and see if that doesn’t work better.

Best regards,
dg