Import a csv into ElasticSearch using logstash - Windows

Elastic Stack Logstash
1

I am trying to import a csv into ElasticSearch using logstash - Windows but receive the following error

Error: No config files found

Command I run is

logstash -f agent logstash-simple.conf

The config is as follows:

input {
stdin {
type => "stdin-type"
}
file {
path => ["C:/Program Files/ElasticSearch/sample.csv"]
start_position => "beginning"
}
}

filter {
csv {
columns => ["Name","Year"]
separator => ","
}
}

output {

elasticsearch { action => "index",
host => "localhost",
index => "customer",
workers => 1 }

}

1 Like
2 
logstash -f agent logstash-simple.conf

You're asking Logstash to load a config file named "agent". Do this instead:

logstash -f logstash-simple.conf
3

Tried this and still receive the same error message.

Can you make sure this path is a logstash config file?
You may be interested in the '--configtest; flag which you can use to validate logstash's configuration before you choose to restart a running system.

4

Below code is working for me. Remove commas in output.
input {
stdin {
type => "stdin-type"
}
file {
path => ["C:/Program Files/ElasticSearch/sample.csv"]
start_position => "beginning"
}
}

filter {
csv {
columns => ["Name","Year"]
separator => ","
}
}

output {

elasticsearch_http {
host => "localhost:9200"
index => "customer"
}

}

5

I had the same problem. Try changing host to hosts in your output.