Problem when importing a CSV file

Good morning, sir,
When importing, the columns described in the Filter section were not taken into account.
They are all in column 1!?!

Blockquote

    filter {

        csv { 

            separator => ","

            columns => ["GROUPE,CODE,TITRE,SOCIETE,PRENOM,COMPLEMENT,NP,ADRESSE,VILLE,LONGITUDE,LATITUDE,REPRESENTANT,CODE_DEPOT,PICOD,PINO,FACTURE,ANNEE,TRIMESTRE,MOIS,DATE_FACT,REFERENCE,DESIGNATION,OP,SERIE,QUANTITE,QUANTITE,TOTAL_HT,TRANSPORT"]

            }

    }![Capture1|690x175](upload://ro0Z9ImS7SMc61sDzdrAxcM4udh.jpeg) ![Capture2|291x500](upload://ghvtf2H2NhZtKTDzD22DVBf5gnQ.jpeg) 

Blockquote

see capture1
.
Other remarks, did the numerical data remain in text format?
see capture2

Thank you in advance for your help
G. Muller

is the source field "message" for csv? if not, try to define the correct one.

filter {
        csv {
            source => "source_field" 
            separator => ","
            columns => ["GROUPE,CODE,TITRE,SOCIETE,PRENOM,COMPLEMENT,NP,ADRESSE,VILLE,LONGITUDE,LATITUDE,REPRESENTANT,CODE_DEPOT,PICOD,PINO,FACTURE,ANNEE,TRIMESTRE,MOIS,DATE_FACT,REFERENCE,DESIGNATION,OP,SERIE,QUANTITE,QUANTITE,TOTAL_HT,TRANSPORT"]
            }
    }

For numeric fields add convert:
https://www.elastic.co/guide/en/logstash/current/plugins-filters-csv.html#plugins-filters-csv-convert

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