Logstash unable to upload csv

I am trying to add index to ElasticSearch from a csv using logstash.
my config file :

 input {
	file{
		 path => "C:\Users\Administrator\Downloads\8THJAN210.csv"
		 start_position => "beginning"
		 sincedb_path =>"C:\Users\Administrator\Downloads\null"
	}
}
filter {
	csv{
		separator => ","
		autodetect_column_names => true

	}
	mutate {
    		convert => {
			"APPL" => "integer"
			"ANNL" => "integer"
			"SCOR" => "integer"
    }
  }

}
output {
	elasticsearch {

		hosts=>"http://localhost:9200"
		index =>"logger"

	}
	stdout {}
}

Is this file okey??

Hello @examin are you getting any index in kibana?

please change the path and dbpath , as shown below

from

to

path => "C:/Users/Administrator/Downloads/8THJAN210.csv"

Also change

sincedb_path =>"C:\Users\Administrator\Downloads\null"

to

sincedb_path => "NUL"

Please find the sample here[Load csv file in logstash - #3 by balumurari1]

1 Like


This was my issue in actual And yes i had to change both path signatures...

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