# Parsing time from csv file to influxd

**URL:** <https://community.influxdata.com/t/parsing-time-from-csv-file-to-influxd/38904>\
**Category:** Telegraf\
**Tags:** influxdb, telegraf\
**Created:** [October 25, 2024, 1:26pm UTC](https://community.influxdata.com/t/parsing-time-from-csv-file-to-influxd/38904 "2024-10-25T13:26:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rumekintun](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/rumekintun/32/4675_2.png) [@rumekintun](https://community.influxdata.com/u/rumekintun)\
**Post date:** [October 25, 2024, 1:26pm UTC](https://community.influxdata.com/t/parsing-time-from-csv-file-to-influxd/38904/1 "2024-10-25T13:26:20Z")

</div>

my **telegraf.conf** file:  
**[agent]**  
interval = “1s”  
round\_interval = true  
metric\_batch\_size = 2200  
metric\_buffer\_limit = 22000  
collection\_jitter = “0s”  
flush\_interval = “5s”  
flush\_jitter = “0s”  
precision = “100ms”  
**[[outputs.influxdb]]**  
urls = [“[http://127.0.0.1:8086](http://127.0.0.1:8086)”]  
database = “gnss”  
skip\_database\_creation = true  
retention\_policy = “undia”  
write\_consistency = “any”  
timeout = “10s”  
username = “xxxxx”  
password = “xxxxx”  
**[[inputs.file]]**  
alias = “gnss”  
files = [“/GNSS/_202_.csv”]  
data\_format = “csv”  
csv\_header\_row\_count = 0  
**csv\_column\_names** = [“time”,“station”,“flag1”,“flag2”,“svnnum”,“xpos”,“ypos”,“zpos”,“vcvx”,“vcvy”,“vcvz”,“neux”,“neuy”,“neuz”]  
**csv\_column\_types** = [“string”,“string”,“int”,“int”,“int”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”,“float”]  
csv\_skip\_rows = 0  
csv\_delimiter = “,”  
csv\_comment = “”  
csv\_trim\_space = false  
csv\_tag\_columns = [“station”]  
csv\_timestamp\_column = “time”  
**csv\_timestamp\_format =** “2023-11-16T03:48:52Z”

and the gnss csv files are:  
**2024-10-24T23:34:51Z** ,BING,191,35,14,1862659.502882,-5366158.472191,-2891322.004354,0.017360,0.032537,0.021888,-0.003411,-0.003501,-0.004982  
**2024-10-24T23:34:52Z** ,BING,191,35,14,1862659.498743,-5366158.463335,-2891322.008339,0.017479,0.032687,0.022023,-0.004417,-0.011482,-0.011819  
2024-10-24T23:34:53Z,BING,191,35,14,1862659.500895,-5366158.469424,-2891322.007578,0.017599,0.032836,0.022156,-0.004380,-0.007859,-0.006417

When I start telegraph, I have the following errors:

**[inputs.file::gnss]**  **Error in plugin: could not parse** “/GNSS/AAAA20241024.csv”: **parsing time** “2024-10-24T23:34:51Z” as “2023-11-16T03:48:52Z”: cannot parse “-10-24T23:34:51Z” as “3”  
…

I’ve been searching the forums but have tried many configurations but none seem to work. I’m a little lost at this point…

Any ideas that can help me solve this problem?

---

<div class="post-metadata">

**Author:** ![rumekintun](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/rumekintun/32/4675_2.png) [@rumekintun](https://community.influxdata.com/u/rumekintun)\
**Post date:** [October 26, 2024, 3:27am UTC](https://community.influxdata.com/t/parsing-time-from-csv-file-to-influxd/38904/2 "2024-10-26T03:27:56Z")

</div>

this format corresponds to the “ **ISO 8601** ” standard, which in Go you can analyze with the format **“2006-01-02T15:04:05Z”**.