Add csv data to elastic search

Elastic Stack Elasticsearch
1

Hi All,

I have set of data's which is in .csv format, I'm trying to push all the data into elastic search and based on the data i'll we be creating dashboard Kibana.

Is there any way to do that?

Thanks,
Mani.

2

Hey,

I had the same issue. We installed Logstash and executed it with a file like this:

input
{
  file {
  path => "/PathToFile/xy.csv"
  type => "core2"
  start_position => "beginning"
  }
}
filter {
  csv {
  columns => ["column1", "..."]
  separator => ";"
  }
}
output {
  elasticsearch
{
  action => "index"
  host => "localhost"
  index => "logstash-%{+YYYY.MM.dd}"
  workers => 1
  }
#optional, writes the input in the terminal
  stdout {
  codec => rubydebug
  }
}

The file must end on .conf and placed in the logstash-directory.
You can execute your file from the terminal (logstash-directory) with

/bin/logstash -f xy.conf

I hope this will help you.

Regards