Logstash doesn't Import CSV columns correctly

Elastic Stack Logstash
1

Hi
I am importing some IP data stored in CSV into ELK using Logstash. When I view the data in Kibana however the columns are all over the place and they are formatted fine in the CSV?

Kibana Screenshot

image

Does ELK struggle with Blank cells or special charters???

Logstash Config:

else if [path] == "C:/ProgramData/FDA/output/processed/OSINT.csv"{
	csv {
        separator => ","
        columns => ["city", "region_code", "os", "ip", "isp", "area_code","dma_code", "last_update", "country_code3", "country_name", "hostnames", "postal_code", "longitude", "country_code", "ip_str", "latitude", "org"]
    }
}

CSV data

image
image.png1367×1164 135 KB

Any Ideas?

2

You left out "tags" in your columns option for the csv filter.

1 Like
3

Thanks again @Badger Can't believe i miss this.....

4

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