# Unable to filter csv file

**URL:** <https://discuss.elastic.co/t/unable-to-filter-csv-file/141169>\
**Category:** Logstash\
**Created:** [July 23, 2018, 12:15pm UTC](https://discuss.elastic.co/t/unable-to-filter-csv-file/141169 "2018-07-23T12:15:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jibinoosae](https://avatars.discourse-cdn.com/v4/letter/j/858c86/32.png) [@jibinoosae](https://discuss.elastic.co/u/jibinoosae)\
**Post date:** [July 23, 2018, 12:15pm UTC](https://discuss.elastic.co/t/unable-to-filter-csv-file/141169/1 "2018-07-23T12:15:11Z")

</div>

HI,

New to ELK

please help me to understand below error  
when i try to run logstash.conf file

[ERROR] 2018-07-23 11:26:37.161 [Converge PipelineAction::Create] csv - Unknown setting 'seperator' for csv  
[ERROR] 2018-07-23 11:26:37.176 [Converge PipelineAction::Create] csv - Unknown setting 'column' for csv  
[ERROR] 2018-07-23 11:26:37.287 [Converge PipelineAction::Create] agent - Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"LogStash::ConfigurationError", :message=\>"Something is wrong with your configuration.", :backtrace=\>["/usr/share/logstash/logstash-core/lib/logstash/config/mixin.rb:89:in `config_init'", "/usr/share/logstash/logstash-core/lib/logstash/filters/base.rb:128:in`initialize'", "/usr/share/logstash/logstash-core/lib/logstash/plugins/plugin\_factory.rb:36:in `filter_delegator'", "/usr/share/logstash/logstash-core/lib/logstash/plugins/plugin_factory.rb:95:in`plugin'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:110:in `plugin'", "(eval):12:in`'", "org/jruby/RubyKernel.java:994:in `eval'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:82:in`initialize'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:167:in `initialize'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline_action/create.rb:40:in`execute'", "/usr/share/logstash/logstash-core/lib/logstash/agent.rb:305:in `block in converge\_state'"]}

my logstash.conf file is as below:

input{  
file{  
path =\> "/home/santra/change\_requests\_V2-2018-06-26\_02\_15\_02.csv"  
start\_position =\> "beginning"  
sincedb\_path =\> "/dev/null"  
}  
}  
filter{  
csv{  
seperator =\> ","  
column =\> ["company","number","requested\_by","u\_category","u\_rfc","u\_device\_ref\_1","u\_service\_impact","u\_urgency\_lead\_time","requested\_by\_date","sys\_created\_on","closed\_at","u\_stagestate","u\_machx\_case\_reference","sys\_updated\_on","sys\_updated\_by","requested\_by.company","sys\_created\_by","opened\_at","opened\_by","closed\_by","u\_machx\_success\_date","u\_change\_ack\_time","u\_change\_successful","u\_device\_1","u\_device\_ref\_2","u\_device\_2","u\_device\_ref\_3","u\_device\_3","u\_device\_ref\_4","u\_device\_4","u\_device\_ref\_5","u\_device\_5","u\_device\_ref\_6",""]  
}  
}  
output {  
elasticsearch {  
hosts =\> "[http://localhost:9200](http://localhost:9200)"  
index =\> "CR"  
}  
stdout {codec =\> rubydebug}  
}

---

<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:** [July 23, 2018, 12:44pm UTC](https://discuss.elastic.co/t/unable-to-filter-csv-file/141169/2 "2018-07-23T12:44:08Z")

</div>

Change column to columns and seperator to separator.

---

<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:** [August 20, 2018, 12:44pm UTC](https://discuss.elastic.co/t/unable-to-filter-csv-file/141169/3 "2018-08-20T12:44:15Z")

</div>

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