# I m failing in getting csv data and index those on elastic using logstash on Windows

**URL:** https://discuss.elastic.co/t/i-m-failing-in-getting-csv-data-and-index-those-on-elastic-using-logstash-on-windows/158756
**Category:** Logstash
**Created:** [November 29, 2018, 12:31pm UTC](https://discuss.elastic.co/t/i-m-failing-in-getting-csv-data-and-index-those-on-elastic-using-logstash-on-windows/158756 "2018-11-29T12:31:52Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![lightonseo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lightonseo/32/38366_2.png) [@lightonseo](https://discuss.elastic.co/u/lightonseo)
#### Post date: [November 29, 2018, 12:31pm UTC](https://discuss.elastic.co/t/i-m-failing-in-getting-csv-data-and-index-those-on-elastic-using-logstash-on-windows/158756/1 "2018-11-29T12:31:52Z")

</div>

hi everybody, please apolgize me for my english

I’m new to ELK, running on **Windows 10** for the moment. I'm using wamp server (not sure if that's a relevant informations).

It’s two days now that I’m facing an issue that i tried to resole by reading a lot of threads about similar problems. But no ways, I m probably missing something that's why I m asking for help please 🙂

I succed in making the conexion between mysql data and elastic with logstash and creating indecies, but **no way to achieve that starting from a CSV file**.

In order to help who can helps me I m posting the content csv sample that i m trying to index on elastic, the logstash config, and the debug lines obtained with --debug

For informations I've found a lot of threads discussing the issue, especially things about since\_db. Please bear in mind that I’ve tried nearly all the different configs, ignoring since\_db, using "nul" as since\_db value (as I m running logstash on windows), I’ve also tried dev/null, but no ways to make it work, here is my config

Any help would be much appreciated, thank you !

The CSV Sample

```
"name","gender"
"john","m"
"alicia","f"
"dan","m"
"sara","f"

```

config file

```
   input {
  file {
    path => "D:\myuser\Clients\testfolder\retest.csv"
    start_position => "beginning"
	sincedb_path => "nul"
  }
}

filter {
  csv {
    separator => ","
    columns => ["name","gender"]
  }
}
output {
   elasticsearch {
     hosts => ["localhost:9200"]
     index => "blablaidx"
  }
	
	stdout { codec => dots }
}`

```

here are some debug lines (truncated)

```
 [2018-11-29T12:50:52,594][INFO][logstash.pipeline] Pipeline started successfully {:pipeline_id=>"main", :thread=>"#<Thread:0x2a1ae7ac sleep>"}
[2018-11-29T12:50:52,653][INFO][filewatch.observingtail] START, creating Discoverer, Watch with file and sincedb collections
[2018-11-29T12:50:52,654][INFO][logstash.agent] Pipelines running {:count=>1, :running_pipelines=>[:main], :non_running_pipelines=>[]}
[2018-11-29T12:50:52,687][DEBUG][logstash.agent] Starting puma
[2018-11-29T12:50:52,703][DEBUG][logstash.agent] Trying to start WebServer {:port=>9600}
[2018-11-29T12:50:52,760][DEBUG][logstash.api.service] [api-service] start
[2018-11-29T12:50:52,955][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=>9600}
[2018-11-29T12:50:53,960][DEBUG][logstash.instrument.periodicpoller.cgroup] One or more required cgroup files or directories not found: /proc/self/cgroup, /sys/fs/cgroup/cpuacct, /sys/fs/cgroup/cpu
[2018-11-29T12:50:54,206][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"}
[2018-11-29T12:50:54,209][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"}
[2018-11-29T12:50:57,604][DEBUG][logstash.pipeline] Pushing flush onto pipeline {:pipeline_id=>"main", :thread=>"#<Thread:0x2a1ae7ac sleep>"}

```

Any help would be much appreciated, thank you 🙂

---

<div class="post-metadata">

### Author: ![Eniqmatic](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Eniqmatic](https://discuss.elastic.co/u/Eniqmatic)
#### Post date: [November 29, 2018, 12:35pm UTC](https://discuss.elastic.co/t/i-m-failing-in-getting-csv-data-and-index-those-on-elastic-using-logstash-on-windows/158756/2 "2018-11-29T12:35:36Z")

</div>

Try this:

```
file {
    path => "D:/myuser/Clients/testfolder/retest.csv"
    start_position => "beginning"
	sincedb_path => "NUL"
  }
```

---

<div class="post-metadata">

### Author: ![lightonseo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lightonseo/32/38366_2.png) [@lightonseo](https://discuss.elastic.co/u/lightonseo)
#### Post date: [November 30, 2018, 8:48pm UTC](https://discuss.elastic.co/t/i-m-failing-in-getting-csv-data-and-index-those-on-elastic-using-logstash-on-windows/158756/3 "2018-11-30T20:48:59Z")

</div>

Hi Lewis

thank you so much for the help, it worked, now i I have my data indexed, not with the correct data\_type but that's a first good step. Thank you again 🙂

---

<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: [December 28, 2018, 8:49pm UTC](https://discuss.elastic.co/t/i-m-failing-in-getting-csv-data-and-index-those-on-elastic-using-logstash-on-windows/158756/4 "2018-12-28T20:49:08Z")

</div>

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