How to import csv files into Elasticsearch


(Marc) #1

I have a csv file exported from a database and can not find correct information on how to do.

I want to upload the CSV file to Elasticsearch then display it in Kiwana.

I would appreciate help.

Regards,
Marc


(Mark Walkom) #2

Use Logstash with stdin/file input and the CSV filter :slight_smile:


(Marc) #3

Mark thanks for the quick reply.

I created a file .conf with data input, filter and output in /etc/logstash/conf.d and I do not how to apply this configuration.

I'm missing steps to continue.

Regards,
Marc


(Mark Walkom) #4

Start Logstash manually and then pass the config file to it with the -f flag, /path/to/bin/logstash -f /path/to/config/file/conf.


(Boyan Biandov) #5

I hear Kibana will have this feature in future releases? Anyone know how close we are to having it?

For the time being there are ton of python scripts and github tools, all of which broken or defective (maybe I can't figure it out lol) so a native Kibana GUI would be most helpful!


(Mark Walkom) #6

There's an open issue for it here - https://github.com/elastic/kibana/issues/9804

Not sure if there is a target for it at this stage, but please feel free to add a +1 to the OP :slight_smile:


(Boyan Biandov) #7

Thanks @warkolm -- definitely will do. Getting structured data in is of utmost importance for me. Thank you


(system) #8