this is what I get :
{
"monbeaunode_1" : {
"mappings" : {
"properties" : {
"@timestamp" : {
"type" : "date"
},
"Application" : {
"type" : "keyword"
},
"Code" : {
"type" : "keyword"
},
"Code retour" : {
"type" : "keyword"
},
"Code site" : {
"type" : "keyword"
},
"Date et heure" : {
"type" : "date",
"format" : "DD/MM/YYYY HH:mm"
},
"Libellé évènement" : {
"type" : "keyword"
},
"Objet Start" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"Objet start" : {
"type" : "keyword"
},
"SDT" : {
"type" : "keyword",
"null_value" : "-"
},
"Type de table" : {
"type" : "keyword"
},
"Usage cache" : {
"type" : "keyword"
},
"Utilisateur" : {
"type" : "keyword"
},
"Valeur après modif" : {
"type" : "keyword"
},
"Valeur avant modif" : {
"type" : "keyword",
"null_value" : "NULL"
}
}
}
}
}
And here is my entire config :
###############################################################################################################
input
{
file
{
path => "C:/Users/BEKRISO/KIBANA7.0.1/INPUT/9r_piste_audit.csv"
start_position => "beginning"
sincedb_path => "C:/Users/BEKRISO/KIBANA7.0.1/sincedb"
codec => plain{charset =>"UTF-8"}
}
}
############################################################################################################################
filter
{
csv
{
separator => ","
columns => ["Date et heure","Utilisateur","Code","Libelle evenement","Code retour","Application","Code site","Type de table","Objet Start","Usage cache","Valeur avant modif","Valeur apres modif","SDT"]
}
mutate{
convert => {
"Utilisateur" => "string"
"Code" => "integer"
"Libellé évènement" => "string"
"Code retour" => "string"
"Application" => "string"
"Code site" => "string"
"Type de table" => "string"
"Objet Start" => "string"
"Usage cache" => "string"
"Valeur avant modif" => "string"
"Valeur après modif" => "string"
"SDT" => "string"
}
#Gestion des accents
rename => { "Libelle evenement" => "Libellé évènement"
"Valeur apres modif" => "Valeur après modif" }
#suppression des champs inutiles
remove_field => [ "message", "host", "path","@version", "@timestamp"]
#Suppression des carriage returns(\r) du dernier champs
gsub => [ "message", "[\r]", "" ]
}
date { match => [ "Date et heure", "DD/MM/YYYY HH:mm" ] }
#Remplacement des champs vide("NULL") par V1 car dans ESHMA V1 la version n'etait pas precisée
#gsub => [ "Valeur avant modif", "NULL", "V1" ]
#if [Valeur avant modif] == "NULL" { mutate { replace => [ "[Valeur avant modif]" , "V1" ] } }
}
##############################################################################################################################
output
{
stdout { codec => rubydebug }
elasticsearch
{
hosts => "cas0000658713:9200"
index => "monbeaunode_1"
}
}
Kibana display "19/07/1970 01:11" for "19/07/2019 01:11", so it seems like it doesn't receive the year value,