Import CSV file to Logstash on windows


(Uma Ananthu) #1

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


(Anh) #2

The separator does not match your sample input. Is it space delimited?

You mean you can't add index pattern in Kibana? If yes, did you see events successfully parsed in Logstash? If there is no index in Elasticsearch, you can't add index pattern in Kibana.


(system) #3

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