Unable to import CSV to elasticsearch via logstash

Elastic Stack Logstash
1

Hi the Created the Config as below.
usecase.config:
input {
file {
path => "C:\ElasticStack\UseCase_Karthi.csv"
start_position => "beginning"

}
}
filter {
csv {
separator => ","

  columns => ["Use case number","Project-ID","Delivery BU","Practice Unit","Account","Project Name","Run or Change","Use case source","Use cases","Use case description","Use case category","Tools/Solutions Suggested","Target FTE","Use case added to Engagement tracker","Use case implementation month-(MMM-YY)","Status","Additional remarks","Internal Automation SPOC"]

}
}
output {
elasticsearch {
hosts => "http://172.29.203.49:9200"
index => "wallet-address-index1"
}
stdout {}
}

i didnt get any error while ruinning the logstash,
logstash -f usecase.config.
but when i check the index in Kibana i am not able to find the index.

2

Did you see any output in the terminal? If the file input is reading lines from your CSV file then you should see some terminal output.

If you don't see output, you need to take care of the since_db file. Read these docs: https://www.elastic.co/guide/en/logstash/current/plugins-inputs-file.html#_tracking_of_current_position_in_watched_files

3

Thanks @guyboertje. since_db was the problem. sincedb_path => "nul"
now it working fine. Thanks Again.

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.