# Cannot get csv data to load into elasticsearch

**URL:** <https://discuss.elastic.co/t/cannot-get-csv-data-to-load-into-elasticsearch/32112>\
**Category:** Logstash\
**Created:** [October 13, 2015, 7:16pm UTC](https://discuss.elastic.co/t/cannot-get-csv-data-to-load-into-elasticsearch/32112 "2015-10-13T19:16:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deepak\_Paramanand](https://avatars.discourse-cdn.com/v4/letter/d/ee59a6/32.png) [@Deepak\_Paramanand](https://discuss.elastic.co/u/Deepak_Paramanand)\
**Post date:** [October 13, 2015, 7:16pm UTC](https://discuss.elastic.co/t/cannot-get-csv-data-to-load-into-elasticsearch/32112/1 "2015-10-13T19:16:38Z")

</div>

Hi,

I have a CSV file that I want to index into Elasticsearch and I also want to see what has been written to elasticsearch, so I have created a conf file as below:

input {

file {  
path =\> ["C:\Work\Kodiak\ATT\Data\RAR\test.txt"]  
start\_position =\> "beginning"  
}  
}

filter {  
csv {  
separator =\> ","  
}  
}

output {

elasticsearch {  
index =\> "samples4"  
}

file {  
path =\> "C:\Work\Kodiak\ATT\Data\RAR\test.txt"  
}

}

When I execute the logstash command, this is what shows up:

D:\Work\logstash-1.5.4\bin\>logstash -f "D:\Work\logstash-1.5.4\rar.conf"  
io/console not supported; tty will not be manipulated  
Logstash startup completed

I have started elasticsearch-1.7.2. and the command

GET \_cat/indices

does not show my index

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [October 13, 2015, 7:18pm UTC](https://discuss.elastic.co/t/cannot-get-csv-data-to-load-into-elasticsearch/32112/2 "2015-10-13T19:18:47Z")

</div>

Almost exactly the same question was asked about five minutes ago:

> [@Unable to send data to elasticsearch](https://discuss.elastic.co/t/unable-to-send-data-to-elasticsearch/32109):
>
> This question has probably been answered a million times, btu I can't find a satisfactory answer, nor do I understand what I'm doing wrong. Curling elasticsearch I get: { "status" : 200, "name" : "poc", "cluster\_name" : "poc", "version" : { "number" : "1.7.2", "build\_hash" : "e43676b1385b8125d647f593f7202acbd816e8ec", "build\_timestamp" : "2015-09-14T09:49:53Z", "build\_snapshot" : false, "lucene\_version" : "4.10.4" }, "tagline" : "You Know, for Search" } So I kn…

---

<div class="post-metadata">

**Author:** ![Deepak\_Paramanand](https://avatars.discourse-cdn.com/v4/letter/d/ee59a6/32.png) [@Deepak\_Paramanand](https://discuss.elastic.co/u/Deepak_Paramanand)\
**Post date:** [October 13, 2015, 7:49pm UTC](https://discuss.elastic.co/t/cannot-get-csv-data-to-load-into-elasticsearch/32112/3 "2015-10-13T19:49:14Z")

</div>

I changed the windows settings to show the hidden files, but I cant seem to find the .sincedb file, could you please point me to it or mention where it usually hangs out?

Thank You,  
Deepak

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [October 13, 2015, 8:30pm UTC](https://discuss.elastic.co/t/cannot-get-csv-data-to-load-into-elasticsearch/32112/4 "2015-10-13T20:30:59Z")

</div>

According to the documentation the sincedb files are by default saved in the directory pointed to by the HOME environment variable (reading the code, it actually prefers SINCEDB\_DIR but falls back to HOME if SINCEDB\_DIR is unset).

If you crank up the loglevel by starting Logstash with `--verbose` it'll tell you the location of the sincedb file it's using.

---

<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:** [July 6, 2017, 5:26am UTC](https://discuss.elastic.co/t/cannot-get-csv-data-to-load-into-elasticsearch/32112/5 "2017-07-06T05:26:38Z")

</div>