Implement Import CSV to Elasticsearch

Elasticsearch

1. Download elasticsearch-7.9.3.zip and Extract All
2. Go to bin folder and Run

cmd : elasticsearch.bat

3.Go to Chrome URL: http://localhost:9200/

Kibana

1. Download kibana-7.9.3.zip and Extract All
2. Go to bin folder and Run

cmd: kibana.bat

3. Go to Chrome URL: http://localhost:5601

Logstash

1. Download logstash-7.9.3.zip and Extract All
2. Create logstash-test-info1.conf in bin folder

Line 2 input session

Line 4 path for import csv file : D:/TestLog/test_information.csv

Line 6 sincedb_path: D:/TestLog/dev/null

Line 9 filter: used csv filter

Line 11 separator: “,”

Line 12 columns in csv file: No,Name,LastName,Email

Line 16 output in elasticsearch

Line 18 hosts of elasticsearch: localhost:9002

Line 19 index of elasticsearch: test_information1

Line 20 document_type: testdata1

3. Prepare input .csv file

4. Go to bin folder and Run

cmd: logstash.bat -f logstash-test-info1.conf

5. Output: Logstash

6. Output: Kibana

6.1 Go to Kibana and Click Dev Tools on the left-hand side menu

6.2 The page appears

o Input on the Life hand side: GET /test_information1/_search and Run button

o Output on the Right hand side: