# Logstash is failing to read a csv file

**URL:** <https://discuss.elastic.co/t/logstash-is-failing-to-read-a-csv-file/74133>\
**Category:** Logstash\
**Created:** [February 6, 2017, 10:04pm UTC](https://discuss.elastic.co/t/logstash-is-failing-to-read-a-csv-file/74133 "2017-02-06T22:04:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![danilo\_gimenez\_ramos](https://avatars.discourse-cdn.com/v4/letter/d/c6cbf5/32.png) [@danilo\_gimenez\_ramos](https://discuss.elastic.co/u/danilo_gimenez_ramos)\
**Post date:** [February 6, 2017, 10:04pm UTC](https://discuss.elastic.co/t/logstash-is-failing-to-read-a-csv-file/74133/1 "2017-02-06T22:04:56Z")

</div>

Hello,

I'm using logstash to read some csv files and then send to elastic, but I don't know why, the logstash can't read a file completely without a error.

I'm receiving various errors like these:  
":timestamp=\>"2017-02-06T19:54:54.943000-0200", :message=\>"Failed parsing date from field", :field=\>"data", :value=\>",00", :exception=\>"Invalid format: ",00"", :config\_parsers=\>"YYYY-MM-dd-HH:mm:ss", :config\_locale=\>"default=en\_US", :level=\>:warn}  
{:timestamp=\>"2017-02-06T19:54:56.540000-0200", :message=\>"Failed parsing date from field", :field=\>"data", :value=\>"nha Boardgames", :exception=\>"Invalid format: "nha Boardgames"", :config\_parsers=\>"YYYY-MM-dd-HH:mm:ss", :config\_locale=\>"default=en\_US", :level=\>:warn}  
{:timestamp=\>"2017-02-06T19:54:56.557000-0200", :message=\>"Failed parsing date from field", :field=\>"data", :value=\>"nda", :exception=\>"Invalid format: "nda"", :config\_parsers=\>"YYYY-MM-dd-HH:mm:ss", :config\_locale=\>"default=en\_US", :level=\>:warn}"

My logstash.conf is:  
input {  
file {  
path =\> "/var/odroid/Anuncios.csv\*"  
start\_position =\> beginning  
ignore\_older =\> 0  
}  
}

filter {  
csv {  
separator =\> ";"  
columns =\> ["data","jogo","tipo","obs","estado","preco"]  
}

```
date {
    match => ["data", "YYYY-MM-dd-HH:mm:ss"]
}

```

}

output {  
elasticsearch {  
hosts =\> ["localhost:9200"]  
action =\> "index"  
index =\> "logstash-%{+YYYY.MM.dd}"  
}  
}

And a sample of the Anuncios.csv:  
017-02-03-22:03:44;survive-escape-from-atlantis;Venda;Conclave;(Usado);R$ 200,00  
2017-02-03-22:03:44;through-the-ages-a-new-story-of-civilization;Venda;Caixinha Boardgames;(Lacrado);R$ 376,00  
2017-02-03-22:03:44;through-the-ages-a-new-story-of-civilization;Venda;Devir;(Lacrado);R$ 380,00  
2017-02-03-22:03:44;through-the-ages-a-new-story-of-civilization;Venda;TudeNerd;(Lacrado);R$ 370,00  
2017-02-03-22:03:44;through-the-ages-a-new-story-of-civilization;Venda;Comdado Jogos;(Lacrado);R$ 352,00  
2017-02-03-22:03:44;through-the-ages-a-story-of-civilization;Venda;como novo, sleevado;(Usado);R$ 249,00  
2017-02-03-22:03:44;through-the-ages-a-story-of-civilization;Venda;Cartas em Sleeves;(Usado);R$ 250,00  
2017-02-03-22:03:44;tides-of-time;Venda;Comdado Black Year;(Lacrado);R$ 32,00  
2017-02-03-22:03:44;tides-of-time;Venda;Caixinha Boardgames;(Lacrado);R$ 41,00  
2017-02-03-22:03:44;xia-legends-of-a-drift-system;Venda;;(Lacrado);R$ 550,00

What am I missing here?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 6, 2017, 10:04pm UTC](https://discuss.elastic.co/t/logstash-is-failing-to-read-a-csv-file/74133/2 "2017-03-06T22:04:58Z")

</div>

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