A CLI tool for importing csv file to influxdb database. You can map csv fields to influxdb columns in config file.
See examples
npm install -g csv2influx
Usage:
csv2influx init Creates template config file
csv2influx [options] data.csv Imports file data.csv to your influxDB
Options:
-c, --config /path/to/config.json [optional] Specifies path to your config file.
Default: ./csv2influx.conf.json
-q, --quiet [optional] Makes output quiet (progress bar instead of written to DB values)
{
"influxdbUri": "http://127.0.0.1:8086/database_name", // Database has to exist
// URI format: http://user:pass@localhost:port,anotherhost:port,yetanother:port/mydatabase
"measurementName": "measurment_name",
"mapping": {
"time": { // specifies CSV-fields used to get time.
// In case it's not defined you get WARNING and
// current time is written to DB
"from": "date",
"type": "timestamp",
"format": "jsDate" // field "format" is required for timestamp.
// in this case means that string will by parsed as
// JavaScript date string format
// https://www.w3schools.com/js/js_date_formats.asp
},
"fieldSchema": {
"name": { // fields "from" and "type" are required
"from": "name",
"type": "string" // influxdb string target type
},
"latitude": {
"from": "lat", // we use field "lat" from CSV to fill up field "latitude" in DB
"type": "float" // influxdb float target type
},
"longitude": {
"from": "lng", // we use field "lng" from CSV to fill up field "longitude" in DB
"type": "float"
}
},
"tagSchema": {
"location": {
"from": "location",
"type": "*" // type of tag can be "*" (any value) or array of possible values
// see https://vicanso.github.io/influxdb-nodejs/Client.html#schema
}
}
},
"csv": { // Parser options from http://csv.adaltas.com/parse/
"delimiter": ','
}
}See examples.
- Fix bad import of string like
"3rd district, Silver Spring"-- with quotes and commas
- Optional "Time" field in config.
- Tags support
- Merging CSV-fields using template-sting-like-syntax
- hastic.io -- tool for analysing metrics from tsdbs with python and grafana
- @corpglory/tsdb-kit -- library for extracting metrics from influx and other tsdbs
- https://corpglory.com/s/grafana-data-exporter/ -- a way to extract big datasets from Grafana to csv
The project developed by CorpGlory Inc., a company which provides high quality software development, data visualization, Grafana and monitoring consulting.