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.