# Error Uploading a CSV file to Logstash

**URL:** <https://discuss.elastic.co/t/error-uploading-a-csv-file-to-logstash/184638>\
**Category:** Logstash\
**Created:** [June 6, 2019, 5:30pm UTC](https://discuss.elastic.co/t/error-uploading-a-csv-file-to-logstash/184638 "2019-06-06T17:30:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rohn07](https://avatars.discourse-cdn.com/v4/letter/r/f14d63/32.png) [@Rohn07](https://discuss.elastic.co/u/Rohn07)\
**Post date:** [June 6, 2019, 5:30pm UTC](https://discuss.elastic.co/t/error-uploading-a-csv-file-to-logstash/184638/1 "2019-06-06T17:30:18Z")

</div>

**ELK\_carsdata.conf**

input{  
file{  
path =\> "D:/ELK\_Data/carsdata/cars.csv"  
start\_position =\> "beginning"  
sincedb\_path =\> "NUL"  
}  
}

filter{  
csv{  
separator =\> ","  
columns =\> ["mpg","cylinders"," cubicinches","hp","weightlbs"," time-to-60","year","brand"]  
}  
mutate{convert =\> ["mpg", "float"]}  
mutate{convert =\> ["cylinders", "interger"]}  
mutate{convert =\> ["cubicinchies", "interger"]}  
mutate{convert =\> ["hp", "interger"]}  
mutate{convert =\> ["weightlbs", "interger"]}  
mutate{convert =\> ["time-to-60", "interger"]}  
mutate{convert =\> ["year", "interger"]}  
}

output{  
elasticsearch{  
hosts =\> ["localhost:9200"]  
index =\> "cars"  
document\_type =\> "cars\_details"  
}  
stdout{}  
}

**Error**

[2019-06-06T22:23:45,178][ERROR][logstash.javapipeline] Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\<LogStash::ConfigurationError: translation missing: en.logstash.agent.configuration.invalid\_plugin\_register\>, :backtrace=\>["C:/ELK/logstash-7.1.1/vendor/bundle/jruby/2.5.0/gems/logstash-filter-mutate-3.4.0/lib/logstash/filters/mutate.rb:219:in `block in register'", "org/jruby/RubyHash.java:1419:in`each'", "C:/ELK/logstash-7.1.1/vendor/bundle/jruby/2.5.0/gems/logstash-filter-mutate-3.4.0/lib/logstash/filters/mutate.rb:217:in `register'", "org/logstash/config/ir/compiler/AbstractFilterDelegatorExt.java:56:in`register'", "C:/ELK/logstash-7.1.1/logstash-core/lib/logstash/java\_pipeline.rb:191:in `block in register_plugins'", "org/jruby/RubyArray.java:1792:in`each'", "C:/ELK/logstash-7.1.1/logstash-core/lib/logstash/java\_pipeline.rb:190:in `register_plugins'", "C:/ELK/logstash-7.1.1/logstash-core/lib/logstash/java_pipeline.rb:446:in`maybe\_setup\_out\_plugins'", "C:/ELK/logstash-7.1.1/logstash-core/lib/logstash/java\_pipeline.rb:203:in `start_workers'", "C:/ELK/logstash-7.1.1/logstash-core/lib/logstash/java_pipeline.rb:145:in`run'", "C:/ELK/logstash-7.1.1/logstash-core/lib/logstash/java\_pipeline.rb:104:in `block in start'"], :thread=\>"#\<Thread:0x689d43f8 run\>"}  
[2019-06-06T22:23:45,753][ERROR][logstash.agent] Failed to execute action {:id=\>:main, :action\_type=\>LogStash::ConvergeResult::FailedAction, :message=\>"Could not execute action: PipelineAction::Create, action\_result: false", :backtrace=\>nil}

---

<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:** [June 6, 2019, 5:34pm UTC](https://discuss.elastic.co/t/error-uploading-a-csv-file-to-logstash/184638/2 "2019-06-06T17:34:00Z")

</div>

> [@Rohn07](#):
>
> mutate{convert =\> ["cylinders", "interger"]}

That's not how you spell "integer".

Also, mutate+convert expects a hash, not an array. You can combine them into a single filter call.

```
mutate{
    convert => {
        "mpg" => "float"
        "cylinders" => "integer"
        "cubicinchies" => "integer"
        "hp" => "integer"
        "weightlbs" => "integer"
        "time-to-60" => "integer"
        "year" => "integer"
    }
}

```

---

<div class="post-metadata">

**Author:** ![Rohn07](https://avatars.discourse-cdn.com/v4/letter/r/f14d63/32.png) [@Rohn07](https://discuss.elastic.co/u/Rohn07)\
**Post date:** [June 6, 2019, 7:20pm UTC](https://discuss.elastic.co/t/error-uploading-a-csv-file-to-logstash/184638/3 "2019-06-06T19:20:33Z")

</div>

Thanks you so much. I made a silly typo error. And thanks for the explanation given on the mutate command.

Now i have been able to upload the data to the logstash and create an index into kibana.

Thank you so much..!!!

---

<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 4, 2019, 7:20pm UTC](https://discuss.elastic.co/t/error-uploading-a-csv-file-to-logstash/184638/4 "2019-07-04T19:20:35Z")

</div>

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