Upload csv data into influxdb

AVVS_Sudheer · July 25, 2023, 4:40am

Hi,

I am able to upload the csv data into Influxdb with the date format as ‘2023-07-18T04:13:40Z’. But is there other method to load the csv data with date like ‘2023-07-18 04:13:40’ into influx db

Anaisdg · August 4, 2023, 1:22am

Hello @AVVS_Sudheer,
Yes you can use telegraf

github.com

influxdata/telegraf/blob/master/plugins/parsers/csv/README.md

# CSV Parser Plugin

The `csv` parser creates metrics from a document containing comma separated
values.

## Configuration

```toml
[[inputs.file]]
  files = ["example"]

  ## Data format to consume.
  ## Each data format has its own unique set of configuration options, read
  ## more about them here:
  ##   https://github.com/influxdata/telegraf/blob/master/docs/DATA_FORMATS_INPUT.md
  data_format = "csv"

  ## Indicates how many rows to treat as a header. By default, the parser assumes
  ## there is no header and will parse the first row as data. If set to anything more
  ## than 1, column names will be concatenated with the name listed in the next header row.

This file has been truncated. show original

See the csv_timestamp_format option

Topic		Replies	Views
Import csv into influxDB. Datetime field parsing error InfluxDB 2 csv , cli , timestamp , parser	2	1973	December 23, 2021
Data ingestion continuously Telegraf telegraf	2	885	November 25, 2019
Csv time format Telegraf telegraf , csv	8	2227	February 2, 2022
CSV file data into InfluxDB via Telegraf No time on CSV file Telegraf telegraf	4	1307	February 1, 2022
CSV file data into InfluxDB via Telegraf Telegraf influxdb , telegraf	9	7100	August 5, 2019

Upload csv data into influxdb

Related Topics