All Projects → CorpGlory → csv2influx

CorpGlory / csv2influx

Licence: MIT license
A CLI tool for importing CSV files into Influxdb

Programming Languages

javascript
184084 projects - #8 most used programming language

Projects that are alternatives of or similar to csv2influx

rtl433 influx
dump everything your rtl-sdr receives on 433MHz into an InfluxDB for easy graphing -- superseded by `rtl433 -F influx`
Stars: ✭ 27 (+68.75%)
Mutual labels:  influxdb, influx
effluence
Zabbix loadable module for real-time export of history to InfluxDB
Stars: ✭ 26 (+62.5%)
Mutual labels:  influxdb, influx
terraform-aws-influxdb
Deploys InfluxDB Enterprise to AWS
Stars: ✭ 29 (+81.25%)
Mutual labels:  influxdb, influx
influxdb-php-sdk
InfluxDB PHP SDK - UDP/IP or HTTP adapters for read and write data
Stars: ✭ 88 (+450%)
Mutual labels:  influxdb, influx
graphql-cli-load
A graphql-cli data import plugin to call mutations with data from JSON/CSV files
Stars: ✭ 63 (+293.75%)
Mutual labels:  import, csv-import
vscode-dart-import
A simple plugin for VSCode to change all Dart/Flutter imports to relative format.
Stars: ✭ 48 (+200%)
Mutual labels:  import
sensu-influxdb-handler
Sensu Go InfluxDB Metrics Handler
Stars: ✭ 14 (-12.5%)
Mutual labels:  influxdb
import-command
Imports content from a given WXR file.
Stars: ✭ 19 (+18.75%)
Mutual labels:  import
siren
Siren provides an easy-to-use universal alert, notification, channels management framework for the entire observability infrastructure.
Stars: ✭ 70 (+337.5%)
Mutual labels:  influx
ProcessMigrator
ProcessWire module that facilitates automated migration and sharing of page trees along with their templates and fields.
Stars: ✭ 29 (+81.25%)
Mutual labels:  import
DataDefinitions
Data Definitions Plugin for Pimcore
Stars: ✭ 70 (+337.5%)
Mutual labels:  import
IoT-system-PLC-data-to-InfluxDB
This project aim is to provide free software to fetch data from plcs (Siemens S7-300/400/1200/1500) and store it. Used stack is completly opensource. I used InfluDB as data storage, so application principle is following Big Data paradigm.
Stars: ✭ 26 (+62.5%)
Mutual labels:  influxdb
SmartHome
esp8266 IoT to mqtt bridge. Eastron SDM220, SDM230, SDM630 modbus; AZ7798; SenseAir s8; BME280; HDC1080; Plantower PMS5003, PMS7003, PMSA003
Stars: ✭ 50 (+212.5%)
Mutual labels:  influxdb
csv
The csv read/write tool based on java annotation.(基于 java 注解的 CSV 文件读写框架工具。)
Stars: ✭ 22 (+37.5%)
Mutual labels:  csv-import
sabnzbd-influxdb-export
Export SABnzbd stats to InfluxDB
Stars: ✭ 16 (+0%)
Mutual labels:  influxdb
bme680 to influxdb
Simple script that sends your BME680 temp, pressure, humidity and gas sensor data to InfluxDB.
Stars: ✭ 21 (+31.25%)
Mutual labels:  influxdb
importer-exporter
3D City Database client for high-performance import and export of 3D city model data
Stars: ✭ 104 (+550%)
Mutual labels:  import
air-quality
Air quality sensing and monitoring
Stars: ✭ 17 (+6.25%)
Mutual labels:  influxdb
consulator
Import and synchronize your Consul KV data from JSON and YAML
Stars: ✭ 27 (+68.75%)
Mutual labels:  import
eseries-perf-analyzer
This project provides an automated installation and deployment of Grafana, NetApp E-Series Web Services, and supporting software for performance monitoring of NetApp E-Series Storage Systems.
Stars: ✭ 19 (+18.75%)
Mutual labels:  influxdb

csv2influx

A CLI tool for importing csv file to influxdb database. You can map csv fields to influxdb columns in config file.

See examples

Install

npm install -g csv2influx

Usage

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)

Config example

{
  "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.

Changelog

1.0.0
  • Fix bad import of string like "3rd district, Silver Spring" -- with quotes and commas
0.0.13
  • Optional "Time" field in config.
0.0.12
  • Tags support
  • Merging CSV-fields using template-sting-like-syntax

See also

About CorpGlory Inc.

The project developed by CorpGlory Inc., a company which provides high quality software development, data visualization, Grafana and monitoring consulting.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].