Logstash - CSV sample

csv_sample.conf

input {
    file {
        path => "C:\Users\afreeland\Documents\GitHub\ElasticImport\conf\appointment1.txt"
        start_position => beginning
    }
}

filter {
    csv {
        columns => [
            "evt",
            "aId",
            "dateTime",
            "message",
            "userId",
            "visitId",
            "accountNumber",
            "location"
        ]
        separator => "|"
    }
    date {
        match => ["dateTime", "ISO8601"]
    }
}

output {
    elasticsearch {
        hosts => ["http://localhost:9200"]
        action => "index"
        index => "walkthrough-%{+YYYY.MM}"
    }
    stdout {}
}