input {
  file {
    path => "File/you/want/to/import.csv"
    start_position => "beginning"
    sincedb_path => "NUL"
  }
}
filter {
  csv {
      separator => ","
      skip_header => "true"
      columns => [victimCorporationID,victimCorp,victimAlliance,finalCorporationID,finalCorp,finalAlliance,destroyedShipTypeID,destroyedShipType,destroyedShipGroup,killTime,solarSystemID,solarSystemName,regionID,regionName,iskLost,iskDestroyed,bountyClaimed]
  }
  date {
    match => ["killTime", "yyyy-MM-dd HH:mm:ss"]
	timezone => "Etc/UTC"
	target => "killTime"
  }
  mutate {
    convert => {
	  "bountyClaimed" => "float"
	  "iskLost" => "float"
	  "regionID" => "integer"
	  "solarSystemID" => "integer"
	  "victimCorporationID" => "integer"
	  "destroyedShipTypeID" => "integer"
	  "finalCorporationID" => "integer"
	  "iskDestroyed" => "float"
	}
	remove_field => [ "path", "message", "host"]
  }
}
output {
   elasticsearch {
     hosts => "http://localhost:9200"
     index => "ccp-data"
  }

stdout {}

}