### Author:  [@paz](https://discuss.elastic.co/u/paz)
#### Post date: [October 4, 2018, 11:06am UTC](https://discuss.elastic.co/t/logstash-unable-to-load-csv-data-into-elasticsearch-on-windows/150964/2 "2018-10-04T11:06:00Z")
Since there are no errors on the Logstash output, and you haven't explicitly defined a since\_db file path in your file input, my guess is that this specific file is considered as read by Logstash and it won't reprocess it.
You can read more about since\_db files [here](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-file.html#_tracking_of_current_position_in_watched_files).
If you need to reprocess the whole file every time you start Logstash, you need to disable since\_db, like so:
```auto
input {
file {
path => ["C:\Users\smiccv0\Documents\software\ELK_Stack\data\KPI.csv"]
start_position => "beginning"
sincedb_path => "nul"
}
}
```
---
### Author:  [@cj\_vegi](https://discuss.elastic.co/u/cj_vegi)
#### Post date: [October 4, 2018, 12:03pm UTC](https://discuss.elastic.co/t/logstash-unable-to-load-csv-data-into-elasticsearch-on-windows/150964/3 "2018-10-04T12:03:03Z")
> [@paz](#):
>
> sincedb\_path =\> "nul"
Hi,
Thanks for the prompt response. I tried with the change suggested but still, did not work.
**logstash output**
```
[2018-10-04T07:53:52,881][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified
[2018-10-04T07:53:53,474][INFO][logstash.runner] Starting Logstash {"logstash.version"=>"6.4.2"}
[2018-10-04T07:53:58,080][INFO][logstash.pipeline] Starting pipeline {:pipeline_id=>"main", "pipeline.workers"=>8, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>50}
[2018-10-04T07:53:58,442][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=>{:removed=>[], :added=>[http://localhost:9200/]}}
[2018-10-04T07:53:58,442][INFO][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck_url=>http://localhost:9200/, :path=>"/"} [2018-10-04T07:53:58,631][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=>"http://localhost:9200/"}
[2018-10-04T07:53:58,660][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es_version=>6}
[2018-10-04T07:53:58,676][WARN][logstash.outputs.elasticsearch] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document _type {:es_version=>6}
[2018-10-04T07:53:58,692][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>["//localhost:9200"]}
[2018-10-04T07:53:58,707][INFO][logstash.outputs.elasticsearch] Using mapping template from {:path=>nil} [2018-10-04T07:53:58,738][INFO][logstash.outputs.elasticsearch] Attempting to install template {:manage_template=>{"template"=>"logstash-*", "version"=>60001, "settings"=>{"index.refresh_interval"=>"5s"}, "mappings"=>{"_default_"=>{"dynamic_templates"=>[{"message_field"=>{"path_match"=>"message", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>false}}}, {"string_fields"=>{"match"=>"*", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>false, "fields"=>{"keyword"=>{"type"=>"keyword", "ignore_above"=>256}}}}}], "properties"=>{"@timestamp"=>{"type"=>"date"}, "@version"=>{"type"=>"keyword"}, "geoip"=>{"dynamic"=>true, "properties"=>{"ip"=>{"type"=>"ip"}, "location"=>{"type"=>"geo_point"}, "latitude"=>{"type"=>"half_float"}, "longitude"=>{"type"=>"half_float"}}}}}}}} [2018-10-04T07:53:59,254][INFO][logstash.pipeline] Pipeline started successfully {:pipeline_id=>"main", :thread=>"#"} [2018-10-04T07:53:59,301][INFO][filewatch.observingtail] START, creating Discoverer, Watch with file and sincedb collections
[2018-10-04T07:53:59,301][INFO][logstash.agent] Pipelines running {:count=>1, :running_pipelines=>[:main], :non_running_pipelines=>[]} [2018-10-04T07:53:59,646][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=>9600}
```
Thanks
---
### Author:  [@tobias.berg](https://discuss.elastic.co/u/tobias.berg)
#### Post date: [October 4, 2018, 12:15pm UTC](https://discuss.elastic.co/t/logstash-unable-to-load-csv-data-into-elasticsearch-on-windows/150964/4 "2018-10-04T12:15:49Z")
I think therer's a spelling error in since\_db path, it should be "null" instead of "nul". But if you want to reprocess the whole file every time, you can set the mode to "read". You will also need to set a complete action. Like this:
> ```
> input {
> file {
> path => ["C:\Users\smiccv0\Documents\software\ELK_Stack\data\KPI.csv"]
> mode => "read"
> file_completed_action => "log"
> file_completed_log_path => "C:\Users\smiccv0\Documents\software\ELK_Stack\logs\logstash"
> }
> }
>
> ```
This will make logstash read the whole file when it starts, and log a complete action to the C:\Users\smiccv0\Documents\software\ELK\_Stack\logs\logstash folder. I also think you need to create this folder prior to starting logstash.
---
### Author:  [@cj\_vegi](https://discuss.elastic.co/u/cj_vegi)
#### Post date: [October 4, 2018, 12:40pm UTC](https://discuss.elastic.co/t/logstash-unable-to-load-csv-data-into-elasticsearch-on-windows/150964/5 "2018-10-04T12:40:05Z")
Hi,
Thanks for the response. I will try and update you.
However, having sincedb\_path =\> 'nul' and deleting uuid and nul file created before running logstash, I was able to push data to elasticsearch everytime.
On windows, specifying sincedb\_path =\> 'nul' and running logstash doesn't create any 'nul' file as in mac.
Not sure where the problem is.
Thanks
---
### Author:  [@paz](https://discuss.elastic.co/u/paz)
#### Post date: [October 4, 2018, 1:00pm UTC](https://discuss.elastic.co/t/logstash-unable-to-load-csv-data-into-elasticsearch-on-windows/150964/6 "2018-10-04T13:00:34Z")
On Windows "nul" is equal to "/dev/null" on Unix, meaning that Logstash won't create any since\_db and will always reprocess the file from the beginning. So it's expected that you don't see any file created.
---
### Author:  [@cj\_vegi](https://discuss.elastic.co/u/cj_vegi)
#### Post date: [October 4, 2018, 1:37pm UTC](https://discuss.elastic.co/t/logstash-unable-to-load-csv-data-into-elasticsearch-on-windows/150964/7 "2018-10-04T13:37:39Z")
OK. I still could not send my data to elasticsearch on windows. However, on my mac it seems to work without a glitch.
Let me know there is something i should try. I am using all the latest versions
Thanks
---
### Author:  [@tobias.berg](https://discuss.elastic.co/u/tobias.berg)
#### Post date: [October 10, 2018, 9:34am UTC](https://discuss.elastic.co/t/logstash-unable-to-load-csv-data-into-elasticsearch-on-windows/150964/8 "2018-10-10T09:34:16Z")
Ok, I didn't know the "nul" value was special on Windows. Good to know!
@cj_vegi did you try to set the mode to "read"?
---
### Author:  [@cj\_vegi](https://discuss.elastic.co/u/cj_vegi)
#### Post date: [October 10, 2018, 6:03pm UTC](https://discuss.elastic.co/t/logstash-unable-to-load-csv-data-into-elasticsearch-on-windows/150964/9 "2018-10-10T18:03:24Z")
Hi,
I tried mode, still unable to send into elasticsearch.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 7, 2018, 6:03pm UTC](https://discuss.elastic.co/t/logstash-unable-to-load-csv-data-into-elasticsearch-on-windows/150964/10 "2018-11-07T18:03:25Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.