Implement Import CSV to Elasticsearch
Elasticsearch
- Download elasticsearch-7.9.3.zip and Extract All
- Go to bin folder and Run
cmd : elasticsearch.bat
3.Go to Chrome URL: http://localhost:9200/
Kibana
- Download kibana-7.9.3.zip and Extract All
- Go to bin folder and Run
cmd: kibana.bat
3. Go to Chrome URL: http://localhost:5601
Logstash
- Download logstash-7.9.3.zip and Extract All
- 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: