my CSV has the following:
gymid,gymdate,sets,exercise,worktime,rest,reps,weight,muclegroup
3013,20-03-2020,1,Barbell Deadlift,01.42,03.02,11,47,back
my config has:
input
{
file{
path=>"D:/gym1.csv"
start_position=>"beginning"
sincedb_path=> "NUL"
}
}
filter
{
csv {
separator=>","
columns=> ["gymid","gymdate", "sets", "exercise", "worktime", "rest", "reps", "weight", "musclegroup"]
}
date {
match => ["gymdate", "dd-mm-yyyy"]
target => "@timestamp"
}
mutate {convert => ["sets", "integer"]}
mutate {convert => ["reps", "integer"]}
mutate {convert => ["worktime", "float"]}
mutate {convert => ["rest", "float"]}
mutate {convert => ["reps", "float"]}
mutate {convert => ["weight", "integer"]}
}
output
{
elasticsearch{
hosts=> "localhost:9200"
index=>"gym"
document_type => "workout"
}
stdout{}
}
i get dateparseerror