Hello everyone,
I am trying to load data from a csv file to elasticsearch, but I can't get the accents "é",
I get \xE0 for "à", there is some solution to solve this ?
Here is my config, and the accents exist in the column ["Libellé évènement"
###############################################################################################################
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"
}
}
############################################################################################################################
filter
{
csv
{
separator => ","
columns => ["Date et heure","Utilisateur","Code","Libelle evenement","Code retour","Application","Code site","Objet Start","Usage cache","Valeur avant modif","Valeur apres modif"]
}
mutate{
convert => {
"Date et heure" => "string"
"Utilisateur" => "string"
"Code" => "integer"
"Libellé évènement" => "string"
"Code retour" => "integer"
"Application" => "string"
"Code site" => "integer"
"Objet Start" => "string"
"Usage cache" => "string"
"Valeur avant modif" => "string"
"Valeur après modif" => "string"
}
#Gestion des accents
rename => { "Libelle evenement" => "Libellé évènement"
"Valeur apres modif" => "Valeur après modif" }
}
date { match => [ "Date et heure", "dd/MM/YY HH:mm" ] }
}
##############################################################################################################################
output
{
elasticsearch
{
hosts => "cas0000658713:9200"
index => "monbeaunode_1"
}
stdout { codec => rubydebug }
}
##############################################"