Advertisement
Guest User

Untitled

a guest
Jul 12th, 2021
69
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None
  1. input {
  2. file {
  3. path => "File/you/want/to/import.csv"
  4. start_position => "beginning"
  5. sincedb_path => "NUL"
  6. }
  7. }
  8. filter {
  9. csv {
  10. separator => ","
  11. skip_header => "true"
  12. columns => [victimCorporationID,victimCorp,victimAlliance,finalCorporationID,finalCorp,finalAlliance,destroyedShipTypeID,destroyedShipType,destroyedShipGroup,killTime,solarSystemID,solarSystemName,regionID,regionName,iskLost,iskDestroyed,bountyClaimed]
  13. }
  14. date {
  15. match => ["killTime", "yyyy-MM-dd HH:mm:ss"]
  16. timezone => "Etc/UTC"
  17. target => "killTime"
  18. }
  19. mutate {
  20. convert => {
  21. "bountyClaimed" => "float"
  22. "iskLost" => "float"
  23. "regionID" => "integer"
  24. "solarSystemID" => "integer"
  25. "victimCorporationID" => "integer"
  26. "destroyedShipTypeID" => "integer"
  27. "finalCorporationID" => "integer"
  28. "iskDestroyed" => "float"
  29. }
  30. remove_field => [ "path", "message", "host"]
  31. }
  32. }
  33. output {
  34. elasticsearch {
  35. hosts => "http://localhost:9200"
  36. index => "ccp-data"
  37. }
  38.  
  39. stdout {}
  40.  
  41. }
Advertisement
RAW Paste Data Copied
Advertisement