Import CVS to Kibana using filebeat

Elastic Stack Elasticsearch
1

Hello!
I'm a beginner in this theme. Maybe someone can help me. I need to import csv file to kibana, to build some graph using filebeat.

I did filebeat conf like that:
filebeat.prospectors:

  • type: log
    enabled: true
    paths:
    • C:\filea.csv
      filebeat.config.modules:
      path: ${path.config}/modules.d/.yml
      reload.enabled: false
      setup.template.settings:
      index.number_of_shards: 1
      setup.template:
      name: 'filea'
      pattern: 'filea-      '
      enabled: true
      output.elasticsearch:
      hosts: ["localhost:9200"]
      index: "filea"

Data imported to Kibana, but all my strings from csv file looks like this

IMG_0779
IMG_0779.jpeg2851×2138 3.12 MB

Can someone write me a code please to separate this message to 5 columns? Or maybe I can do this while import with some filter or something like this. Can someone give me a reason please?

2

I wrote something like this here: http://david.pilato.fr/blog/2017/01/09/4-years-at-elastic/

Note that I was using a Grok processor which can be a bit slow.
I'd encourage using:

Note that in Elasticsearch 6.6 there is now a CSV importer in Kibana.

3

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