Ad Widget

Collapse

Export and import data to excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • badaboom
    Junior Member
    • Jun 2012
    • 3

    #1

    Export and import data to excel

    Is it possible for me to export some data from Zabbix to Excel, create a trendline graph in Excel, since I can't do that in Zabbix, and then take that data from the treadline graph in Excel back to Zabbix and create the graph there? If this isn't possible, do you have any suggestions on getting trend predictions to work?

    Thanks
  • pantera
    Member
    • Dec 2014
    • 39

    #2
    i also have to import over 7000 nodes to zabbix and assign to predefined template and host group

    how to to do?


    help please

    Comment

    • kloczek
      Senior Member
      • Jun 2006
      • 1771

      #3
      Originally posted by badaboom
      Is it possible for me to export some data from Zabbix to Excel, create a trendline graph in Excel, since I can't do that in Zabbix
      This is not entirely true
      Look on https://support.zabbix.com/browse/ZBXNEXT-922
      http://uk.linkedin.com/pub/tomasz-k%...zko/6/940/430/
      https://kloczek.wordpress.com/
      zapish - Zabbix API SHell binding https://github.com/kloczek/zapish
      My zabbix templates https://github.com/kloczek/zabbix-templates

      Comment

      • gleepwurp
        Senior Member
        • Mar 2014
        • 119

        #4
        Pantera,

        you can use the Zabbix API to do this: Zabbix API

        An other, more cumbersome method would be to "export" a single host, and generate an XML file based on it to "Import" all your hosts... Test it on a dev system first though...

        G.

        Comment

        Working...