Ad Widget

Collapse

Data Source "csv" File / Import CSV Files

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tarsinion
    Junior Member
    • Aug 2009
    • 28

    #1

    Data Source "csv" File / Import CSV Files

    Hi all,

    we do have some maschines which i would like to monitor with zabbix as well. They can write logfiles in csv format on a file server.
    The csv file looks like:

    Name;Date Time;Value;Time_MS
    VISUAL_MESS020;30.11.2011 12:56;10,51794;1;40877538900

    ... can someone give me a hint how to import or set this csv file as data source?
    Are you doing something similar?

    Cheers,

    Richard
  • HullZabbix
    Senior Member
    • Feb 2011
    • 104

    #2
    I'm now looking at importing machine data via csv files.

    Anyone done this before?

    Comment

    • Tarsinion
      Junior Member
      • Aug 2009
      • 28

      #3
      unfortunaly i'm still not any further, but the maschine is giving out csv very unreliable - so that has to be solved first

      Comment

      • nibedita@jena
        Junior Member
        • Mar 2022
        • 6

        #4
        write code for import csv file in zabbix.(please solve this issue)help me ,it's urgent

        Comment

        • dimir
          Zabbix developer
          • Apr 2011
          • 1080

          #5
          If I understood you correctly, you can write a script that will do that.

          First, make sure you have appropriate hosts and items of type Zabbix trapper configured in Zabbix​. Then create a script that would:
          • parse the CSV file
          • create input file for zabbix_sender (run
            Code:
            man zabbix_sender.man | col -b | grep -A4 -- -i,​
            for details)
          • use zabbix_sender -i <file> to populate values to zabbix via trapper port
          • delete processed CSV file
          and put the script to cron.

          Comment

          Working...