Not able to view csv data in influxdb

grafana
influxdb
telegraf

#1

Hi, i m using TIG stack . I want to display my csv data which is generated from my application. Curently i m trying to send some sample csv file to influxdb to check if it works. But I am not able to see data inj influxdb. I dont get any error while running telegraf conf file but i also dont see any data in influxdb.

this is my telegraf.conf

Global Agent Configuration

[agent]
hostname = “csv_data”
#flush_interval = “10s”
interval = “1s”

Input Plugins

[[inputs.file]]
files = [“file.csv”]
data_format = “csv”
csv_header_row_count = 0
csv_column_names = [“id”,“id2”,“id3”,“id4”,“id5”,“end”]

Indicates the number of rows to skip before looking for header information.

csv_skip_rows = 0

Indicates the number of columns to skip before looking for data to parse.

These columns will be skipped in the header as well.

csv_skip_columns = 0

The seperator between csv fields

By default, the parser assumes a comma (",")

csv_delimiter = “,”

The character reserved for marking a row as a comment row

Commented rows are skipped and not parsed

csv_comment = “”

If set to true, the parser will remove leading whitespace from fields

By default, this is false

csv_trim_space = false

Columns listed here will be added as tags. Any other columns

will be added as fields.

csv_tag_columns = []

The column to extract the name of the metric from

csv_measurement_column = “”

The column to extract time information for the metric

csv_timestamp_format must be specified if this is used

csv_timestamp_column = “”

The format of time data extracted from csv_timestamp_column

this must be specified if csv_timestamp_column is specified

csv_timestamp_format = “”

Output Plugin InfluxDB

[[outputs.influxdb]]
database = “test”
urls = [ “http://localhost:8086” ]
username = “ubuntu”
password = “csv@123”

And my csv file
10,99045825,99045826,4953,4752,0.00,0,0.00,0,END
11,99005784,99005784,4951,4753,0.00,0,0.00,0,END
12,99005837,99005839,4951,4752,0.00,0,0.00,0,END
13,99045876,99045877,4953,4752,0.00,0,0.00,0,END
14,99001840,99001841,4951,4752,0.00,0,0.00,0,END
15,99001832,99001833,4951,4752,0.00,0,0.00,0,END
16,99005822,99005823,4951,4752,0.00,0,0.00,0,END
17,99041840,99041842,4953,4752,0.00,0,0.00,0,END
18,99001841,99001842,4951,4752,0.00,0,0.00,0,END
19,99001836,99001838,4951,4752,0.00,0,0.00,0,END
20,99045837,99045838,4953,4752,0.00,0,0.00,0,END
21,99009826,99009827,4951,4752,0.00,0,0.00,0,END
22,99045848,99045849,4953,4753,0.00,0,0.00,0,END
23,99001831,99001832,4951,4752,0.00,0,0.00,0,END
24,99001831,99001832,4951,4752,0.00,0,0.00,0,END
25,99001841,99001842,4951,4752,0.00,0,0.00,0,END
26,99041837,99041838,4953,4752,0.00,0,0.00,0,END
27,99001846,99001846,4951,4752,0.00,0,0.00,0,END
28,99045841,99045842,4953,4752,0.00,0,0.00,0,END
29,99001823,99001830,4951,4752,0.00,0,0.00,0,END
30,99045844,99045845,4953,4753,0.00,0,0.00,0,END
31,99049860,99049860,4953,4753,0.00,0,0.00,0,END
32,99001836,99001837,4951,4752,0.00,0,0.00,0,END
33,99045841,99045842,4953,4753,0.00,0,0.00,0,END
34,99045879,99045880,4953,4753,0.00,0,0.00,0,END
35,99045860,99045861,4953,4752,0.00,0,0.00,0,END
36,99001778,99001779,4951,4752,0.00,0,0.00,0,END
37,99041810,99041818,4953,4752,0.00,0,0.00,0,END

Currently m sending a static file but at runtime the data will be appended to this csv file which will need to be mapped.
What am i doing wrong
I dont get any error when i start telegraf with this conf file.


#2

First try running in --test mode, it will show what the inputs collect but does not send any data:

telegraf --input-filter file --test