# Import CSV file to Logstash on windows10 **URL:** \ **Category:** Logstash\ **Created:** [August 11, 2019, 11:34pm UTC](https://discuss.elastic.co/t/import-csv-file-to-logstash-on-windows10/194770 "2019-08-11T23:34:39Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![aahtysh2525](https://avatars.discourse-cdn.com/v4/letter/a/53a042/32.png) [@aahtysh2525](https://discuss.elastic.co/u/aahtysh2525)\ **Post date:** [August 11, 2019, 11:34pm UTC](https://discuss.elastic.co/t/import-csv-file-to-logstash-on-windows10/194770/1 "2019-08-11T23:34:39Z")
Hi, I am trying to import a CSV file to elasticsearch using logstash, but with no success. Windows 10 Logstash 7.3.0/Elasticsearch 7.3.0/Kibana 7.3.0 // Config File is as below input { file { path =\> ["E:\Softwares\ES\UU\_Telemetry.csv"] start\_position =\> "beginning" sincedb\_path =\> "NUL" } } filter { csv { separator =\> "," columns =\> ["Site", "Process\_Area", "Asset", "Description", "Alarms", "Alarm\_Priority", "date\_created"] ``` } mutate {convert => ["Alarm_Priority", "integer"]} ``` } output { elasticsearch { hosts =\> ["localhost:9200"] index =\> "UU\_Telemetry" } stdout {} } //config file end //Output @ power shell PS E:\Softwares\ES\> .\logstash-7.3.0\bin\logstash -f .\logstash-UU\_Tele.conf Thread.exclusive is deprecated, use Thread::Mutex Sending Logstash logs to E:/Softwares/ES/logstash-7.3.0/logs which is now configured via log4j2.properties [2019-08-11T22:16:05,585][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified [2019-08-11T22:16:05,599][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"7.3.0"} [2019-08-11T22:16:06,743][INFO][org.reflections.Reflections] Reflections took 32 ms to scan 1 urls, producing 19 keys and 39 values [2019-08-11T22:16:08,780][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=\>{:removed=\>, :added=\>[[http://localhost:9200/](http://localhost:9200/)]}} [2019-08-11T22:16:09,009][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[http://localhost:9200/](http://localhost:9200/)"} [2019-08-11T22:16:09,052][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es\_version=\>7} [2019-08-11T22:16:09,055][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=\>7} [2019-08-11T22:16:09,078][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[//localhost:9200](https://localhost:9200)"]} [2019-08-11T22:16:09,142][INFO][logstash.outputs.elasticsearch] Using default mapping template [2019-08-11T22:16:09,183][WARN][org.logstash.instrument.metrics.gauge.LazyDelegatingGauge] A gauge metric of an unknown type (org.jruby.specialized.RubyArrayOneObject) has been create for key: cluster\_uuids. This may result in invalid serialization. It is recommended to log an issue to the responsible developer/development team. [2019-08-11T22:16:09,187][INFO][logstash.javapipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>8, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50, "pipeline.max\_inflight"=\>1000, :thread=\>"#\"} [2019-08-11T22:16:09,227][INFO][logstash.outputs.elasticsearch] Attempting to install template {:manage\_template=\>{"index\_patterns"=\>"logstash-_", "version"=\>60001, "settings"=\>{"index.refresh\_interval"=\>"5s", "number\_of\_shards"=\>1}, "mappings"=\>{"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"}}}}}}} [2019-08-11T22:16:09,809][INFO][logstash.javapipeline] Pipeline started {"pipeline.id"=\>"main"} [2019-08-11T22:16:09,877][INFO][logstash.agent] Pipelines running {:count=\>1, :running\_pipelines=\>[:main], :non\_running\_pipelines=\>} [2019-08-11T22:16:09,880][INFO][filewatch.observingtail] START, creating Discoverer, Watch with file and sincedb collections [2019-08-11T22:16:10,230][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600} //END Please help Thanks in advance ---
**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\ **Post date:** [August 12, 2019, 5:11am UTC](https://discuss.elastic.co/t/import-csv-file-to-logstash-on-windows10/194770/2 "2019-08-12T05:11:08Z")
Hi thanks for try Logstash on windows > [@aahtysh2525](#): > > path =\> ["E:\Softwares\ES\UU\_Telemetry.csv"] Try `path => ["E:/Softwares/ES/UU_Telemetry.csv"]` Also in the future if you use the `` button at the top of the editor it will format your code correctly and make it easier for others to help. Hope this helps... ---
**Author:** ![aahtysh2525](https://avatars.discourse-cdn.com/v4/letter/a/53a042/32.png) [@aahtysh2525](https://discuss.elastic.co/u/aahtysh2525)\ **Post date:** [August 12, 2019, 10:29pm UTC](https://discuss.elastic.co/t/import-csv-file-to-logstash-on-windows10/194770/3 "2019-08-12T22:29:27Z")
That did the job. Thanks ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 9, 2019, 10:29pm UTC](https://discuss.elastic.co/t/import-csv-file-to-logstash-on-windows10/194770/4 "2019-09-09T22:29:29Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.