# Failing to import a simple csv

**URL:** <https://discuss.elastic.co/t/failing-to-import-a-simple-csv/164820>\
**Category:** Logstash\
**Created:** [January 18, 2019, 3:33pm UTC](https://discuss.elastic.co/t/failing-to-import-a-simple-csv/164820 "2019-01-18T15:33:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gbosetti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gbosetti/32/49883_2.png) [@gbosetti](https://discuss.elastic.co/u/gbosetti)\
**Post date:** [January 18, 2019, 3:33pm UTC](https://discuss.elastic.co/t/failing-to-import-a-simple-csv/164820/1 "2019-01-18T15:33:13Z")

</div>

Hello, I'm trying to load some data from a cvs to start learning elastic. But I'm having problems since yesterday and I can't import the data. This is what I did:

I downloaded the zipfile and I extracted it. I'm using Windows 7. I uncommented the heap size variables from the config/jvm.options file:

> ```
> -Xms4g
> -Xmx4g
> 
> ```

I run the elasticsearch.exe and I visited [http://localhost:9200/](http://localhost:9200/) with my browser and I got:

> {  
> "name" : "D2-iPGl",  
> "cluster\_name" : "elasticsearch",  
> "cluster\_uuid" : "uRuuK5voT3uZ3QvoHzf3QQ",  
> "version" : {  
> "number" : "6.5.4",  
> "build\_flavor" : "default",  
> "build\_type" : "zip",  
> "build\_hash" : "d2ef93d",  
> "build\_date" : "2018-12-17T21:17:40.758843Z",  
> "build\_snapshot" : false,  
> "lucene\_version" : "7.5.0",  
> "minimum\_wire\_compatibility\_version" : "5.6.0",  
> "minimum\_index\_compatibility\_version" : "5.0.0"  
> },  
> "tagline" : "You Know, for Search"  
> }

Then I run

> bin\logstash -f files\logstash\_products.conf

Which has the content from **[https://github.com/pranav-shukla/learningelasticstack/tree/master/chapter-03#import-product-data-into-elasticsearch](https://github.com/pranav-shukla/learningelasticstack/tree/master/chapter-03#import-product-data-into-elasticsearch)**, which some modifications as the paths, since I'm running it on Windiows:

> input {  
> file {  
> path =\> "C:/Users/myusername/logstash-6.5.4/files/products.csv"  
> start\_position =\> "beginning"  
> sincedb\_path =\> "null"  
> codec =\> plain {  
> charset =\> "ISO-8859-1"  
> }  
> }  
> }  
> filter {  
> csv {  
> separator =\> ","  
> columns =\> ["id","title","description","manufacturer","price"]  
> }
> 
> mutate {  
> remove\_field =\> ["@version","@timestamp","path","host", "tags", "message"]  
> }  
> }  
> output {  
> elasticsearch {  
> hosts =\> "[http://localhost:9200](http://localhost:9200)"  
> index =\> "amazon\_products"  
> document\_type =\> "products"  
> }  
> stdout {}  
> }

And the output is always the same:

> [2019-01-18T16:18:09,682][INFO][logstash.pipeline] Pipeline started suc  
> cessfully {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x487627f8 run\>"}  
> [2019-01-18T16:18:09,754][INFO][logstash.agent] Pipelines running {:  
> count=\>1, :running\_pipelines=\>[:main], :non\_running\_pipelines=\>}  
> [2019-01-18T16:18:09,769][INFO][filewatch.observingtail] START, creating Disc  
> overer, Watch with file and sincedb collections  
> [2019-01-18T16:18:10,079][INFO][logstash.agent] Successfully started  
> Logstash API endpoint {:port=\>9600}

And then it kind of feezes.  
Where can I get more feedback to know what's wrong? What should I do?  
Thanks in advance,

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [January 18, 2019, 3:38pm UTC](https://discuss.elastic.co/t/failing-to-import-a-simple-csv/164820/2 "2019-01-18T15:38:04Z")

</div>

> [@gbosetti](#):
>
> sincedb\_path =\> "null"

That should be

```
sincedb_path => "NUL"

```

---

<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:** [February 15, 2019, 3:54pm UTC](https://discuss.elastic.co/t/failing-to-import-a-simple-csv/164820/4 "2019-02-15T15:54:30Z")

</div>

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