Csv output problem with numbers?


(Henri) #1

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??


(Henri) #2

Sorry my question wasn't very clear....

I output a cvs file with the csv plugin and the field with float value output in a scientific format with E. How can I transform this in decimal value (best for latitude and longitude)

Thanks


(Henri) #3

The solution is here

I need to reconvert the number after get them but the plugin input elasticsearch


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.