Hi,
I am trying to import CSV file to Logstash and pass to elastic search. I am using the below config
input {
file {
path => ["D:/AnalyticsTool/Exe/logstash-5.2.0/logstash-5.2.0/bin/GWT_new.CSV"]
type => "core2"
start_position => "beginning"
sincedb_path => "/dev/null"
}
}
filter {
csv {
separator => ","
columns => ["Issue id", "Custom field (Requesting Market)","Summary","Priority", "Issue Type", "Status", "Created", "Custom field (Requested Completion Date)
", "Time Spent"]
}
}
output {
elasticsearch { hosts => ["localhost:9200"]
index => "NewIndex"
user => elastic
password => changeme
}
stdout { codec => rubydebug }
}
CSV Sample Input:
Issue id Custom field (Requesting Market) Summary Priority Issue Type Status Created Custom field (Requested Completion Date) Time Spent
19000 Global Campaign Hub - Image size validation and display tiles without blank 5 Bug Closed 1/4/2016 7:06 2/28/2017 0:00 126900
19005 Global Request Ongoing (MONTHLY) GWT K5 Transaction Extract 5 Task Open 1/4/2016 13:42 1/29/2016 0:00
In kibana , I am not able to create Index. Please let me know if i am missing any.
Thanks in Advance