Telegraf incorrect time stamp

1

Screenshot from 2020-01-03 13-36-52
Screenshot from 2020-01-03 13-36-521615×903 331 KB

Hello

I am trying to import data from a CSV but I cant seem to get the time stamp correct.I have tried Unix,unix_ms,unix_us and unix ns.

this is my config file
###############################################################################

OUTPUT PLUGINS

###############################################################################
[[inputs.file]]
files = [“log.csv”]

Data format to consume.

data_format = “csv”
##csv_column_names = [“timestamp”]
##csv_column_types = [“string”, “float”]
##csv_timestamp_column = 2
##csv_timestamp_format = “unix”
csv_timestamp_column = “session”
csv_timestamp_format = “unix_ms”

##unix, unix_ms, unix_us, unix_ns

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.

If csv_column_names is specified, the column names in header will be overridden.

csv_header_row_count = 1

this is my terminal output file from sudo telegraf --config telegraf.conf --test

file,host=dennis-VirtualBox GPS\ Bearing=11.3,GPS\ Latitude=49.83719988260418,GPS\ Longitude=-119.65546879917383,GPS\ Speed=0.612,k146=-40,k15b=21.568628,k221564=26,k221942=0,k222411=49.80392,k222414=0,k222416=20,k222885=0.45,k2241a3=-8.566667,k2241b4=0,k2241b6=0,k22434f=14,k224356=0,k22436b=341.5,k22436c=21.45,k2243af=-0.39215687,k22801e=6.5,k22801f=-40.5,k228334=17.647058,ke3ee8c=0,ked22ae=7.3251753,kef253b=7.6616,session=1572740388982i,time=1572745282306i 1572740389000000000
file,host=dennis-VirtualBox GPS\ Bearing=11.3,GPS\ Latitude=49.83719594310969,GPS\ Longitude=-119.65547106228769,GPS\ Speed=1.6199999,k146=-40,k15b=21.568628,k221564=26,k221942=0,k222411=49.80392,k222414=0,k222416=20,k222885=0.45,k2241a3=-8.566667,k2241b4=0,k2241b6=0,k22434f=14,k224356=0,k22436b=341.5,k22436c=21.45,k2243af=-0.39215687,k22801e=6.5,k22801f=-40.5,k228334=17.647058,ke3ee8c=0,ked22ae=7.3251753,kef253b=7.6616,session=1572740388982i,time=1572745283307i 1572740389000000000

My data is entered in Influx it just all on the current time.

Any help would be greatly appretiated.

Thanks
Dennis Mitchell

2

It looks like the timestamp is being rounded, this is done based on the agent precision setting. You can change this, but it does apply to all plugins:

[agent]
  precision = "1ms"

We do have an issue to make this per plugin #3834, I’ll try to get this bumped up in priority.