# Telegraf csv unsupported type problem

**URL:** <https://community.influxdata.com/t/telegraf-csv-unsupported-type-problem/14603>\
**Category:** Telegraf\
**Tags:** influxdb, telegraf\
**Created:** [June 1, 2020, 7:45am UTC](https://community.influxdata.com/t/telegraf-csv-unsupported-type-problem/14603 "2020-06-01T07:45:48Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![andbos](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/andbos/32/5049_2.png) [@andbos](https://community.influxdata.com/u/andbos)\
**Post date:** [June 1, 2020, 7:45am UTC](https://community.influxdata.com/t/telegraf-csv-unsupported-type-problem/14603/1 "2020-06-01T07:45:48Z")

</div>

Hi,

I’m trying to get CSV data into InfluxDB using Telegraf and inputs.tail. For several applications it works but for one I get “unsupported type”. Debug doesn’t say much more but it might possibly have to do with the timestamp format. Timestamp can be for instance 20200601070000 so in the telegraf.conf I configured

csv\_timestamp\_format = “20060102150405”

Is this a valid format?

Example from log file:

2020-06-01T07:30:00Z E! [inputs.tail] Malformed log line in “/var/log/metrics.csv”: [“20200601071500,app\_01,900,f,6,0,2,0,4,4,0,2,0,0,2,2,2,170,1010,0,2,0,0,1,0,0,0,1,1,0,0,15,18,11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.011111111,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0”]: unsupported type

From the configuration file:

csv\_column\_types = [“int”,“string”,“int”,“string”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”]  
csv\_timestamp\_column = “timestamp”  
csv\_timestamp\_format = “20060102150405”

Best regards,  
Andreas

---

<div class="post-metadata">

**Author:** ![Anaisdg](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/anaisdg/32/6401_2.png) [@Anaisdg](https://community.influxdata.com/u/Anaisdg)\
**Post date:** [June 1, 2020, 3:43pm UTC](https://community.influxdata.com/t/telegraf-csv-unsupported-type-problem/14603/2 "2020-06-01T15:43:42Z")

</div>

Hello @andbos,  
Welcome!  
Unfortunately that is not a supported timestamp option.  
The `csv_timestamp_column` option specifies the key containing the time value and `csv_timestamp_format` must be set to `unix` , `unix_ms` , `unix_us` , `unix_ns` , or a format string in using the Go “reference time” , `"2006-01-02T15:04:05Z07:00"`, which is defined to be the **specific time** : `Mon Jan 2 15:04:05 MST 2006` .

---

<div class="post-metadata">

**Author:** ![andbos](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/andbos/32/5049_2.png) [@andbos](https://community.influxdata.com/u/andbos)\
**Post date:** [June 2, 2020, 5:56am UTC](https://community.influxdata.com/t/telegraf-csv-unsupported-type-problem/14603/3 "2020-06-02T05:56:18Z")

</div>

Hi,

Thank you. I had hoped that csv\_timestamp\_format = “20060102150405” would be that specific time but yes, timezone is missing.  
Would it maybe be possible to modify the timestamp before writing to InfluxDB? I have seen example using inputs.logparser.grok but how to combine that with inputs.tail?

Best regards,  
Andreas

---

<div class="post-metadata">

**Author:** ![daniel](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/daniel/32/142_2.png) [@daniel](https://community.influxdata.com/u/daniel)\
**Post date:** [June 5, 2020, 5:31am UTC](https://community.influxdata.com/t/telegraf-csv-unsupported-type-problem/14603/4 "2020-06-05T05:31:24Z")

</div>

The `csv_timestamp_format` you have should work, I think you just need to set the timestamp column to parse as a string in csv\_column\_types:

```auto
csv_column_types = ["string", ...]

```

---

<div class="post-metadata">

**Author:** ![andbos](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/andbos/32/5049_2.png) [@andbos](https://community.influxdata.com/u/andbos)\
**Post date:** [June 5, 2020, 6:50am UTC](https://community.influxdata.com/t/telegraf-csv-unsupported-type-problem/14603/5 "2020-06-05T06:50:43Z")

</div>

Thanks, Daniel. Works like a charm now 🙂

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/3X/2/f/2feb065bdfd5e4b7728243aa3b9192ad3e8447c1.png) [@system](https://community.influxdata.com/u/system)\
**Post date:** [June 5, 2020, 7:50am UTC](https://community.influxdata.com/t/telegraf-csv-unsupported-type-problem/14603/6 "2020-06-05T07:50:51Z")

</div>

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.