Hi with ES 5.4 and LG 5.4
I try this
output {
csv {
fields => ["nom","nom_maire","CODGEO", "street", "cp","nomcommune","departement","DEPET","region","email","siteweb","tel","fax","population","location[lat]","location[lon]"]
path => "/home/jsondata/57cae745456ab85d4ff76a83ef3f1f0e/dp_577b539512dfa520df2c0a18ffb8482f.csv"
}
}
The raw data from ES
{
"_index" : "sirene",
"_type" : "logs",
"_id" : "mairie-49317-01",
"_score" : 1.8746464,
"_source" : {
"DEPET" : "49",
"siteweb" : "http://www.saint-remy-la-varenne.fr",
"identifiant" : "mairie-49317-01",
"dept" : "49",
"nom" : "Mairie de Saint-Rémy-la-Varenne",
"cp" : "49250",
"CODGEO" : "49317",
"nomcommune" : "Saint-Rémy-la-Varenne",
"provider" : "sp_mairie",
"street" : "4 rue de la Mairie",
"@version" : "1",
"host" : "host4-vm101",
"miseajour" : "all_20170508",
"tel" : "0241570394",
"location" : {
"lon" : -0.317674010992,
"lat" : 47.3968009949
},
"num_region" : "52",
"population" : 975.0
}
As you see "population" and "lat" and "lon" are number
the output give me this:
Mairie de Saint-Rémy-la-Varenne,01247,Rue Dame-Pernette,01410,Mijoux,Ain,01,Auvergne Rhône-Alpes,accueil.mairie@mijoux.fr,http://www.mijoux.fr,0450413204,0450413288,0.975E3,0.463662528992E2,0.599627113342E1
the output of the numbers seem to be in scientific format how can I output decimal number??