spyglass-plugin-xls/doc/source/excel_specification.rst
Ryan Schroder f9df9d1886 Docs update for Spyglass Excel Plugin
Removed all tugboat refernces, added getting started guide to
explain installation and steps to run, and reformated so that
all the informantion was not in the index file.

Change-Id: I20234c1c7565794d81d25565fddb2879df460d9b
2019-12-20 11:39:10 -06:00

4.7 KiB

Excel Specification

Excel Spec is like an index to the Excel sheet to look for the data to be collected by the tool. The excel_spec.yaml file provides a sample structure for an excel specification based off the SiteDesignSpec_v0.1.xlsx sheet. (Both can be found in the examples folder)

Below is the definition for each key in the Excel spec

  • ipmi
    • type - How the data is stored (series/container/point)
    • sheet_name - Name of the sheet from where IPMI information is to be read (File name, excluding the file extension, when using a CSV file)
    • iter
      • index-type - How data is indexed (row/col)
      • start - Row/Col number where ipmi data begins
      • end - Row/Col number where ipmi data ends
    • data
      • hostname - location of the hostname (row/col/[r, c])
      • ipmi_address - location of the ipmi address (row/col/[r, c])
      • ipmi_gateway - location of the ipmi gateway (row/col/[r, c])
      • host_profile - location of the host profile (row/col/[r, c])
  • private_vlan
    • type - How the data is stored (series/container/point)
    • sheet_name - Name of the sheet from where private vlan information is to be read (File name, excluding the file extension, when using a CSV file)
    • no_sanitize - Names of values that should not be sanitized
    • iter
      • index-type - How data is indexed (row/col)
      • start - Row/Col number where private vlan data begins
      • end - Row/Col number where private vlan data ends
    • data
      • net_type - location of the net type (row/col/[r, c])
      • vlan - location of the vlan (row/col/[r, c])
  • private_net
    • type - How the data is stored (series/container/point)
    • sheet_name - Name of the sheet from where private net information is to be read (File name, excluding the file extension, when using a CSV file)
    • iter
      • index-type - How data is indexed (row/col)
      • start - Row/Col where private vlan data begins
      • end - Row/Col where private vlan data ends
    • data
      • vlan - location of the vlan (row/col/[r, c])
      • ip - location of the ip (row/col/[r, c])
  • public
    • type - How the data is stored (series/container/point)
    • sheet_name - Name of the sheet from where public information is to be read (File name, excluding the file extension, when using a CSV file)
    • data
      • oam
        • type - How the data is stored (series/container/point)
        • data
          • vlan - location of the vlan (row/col/[r, c])
          • ip - location of the ip (row/col/[r, c])
      • ingress
        • type - How the data is stored (series/container/point)
        • data
          • ip - location of the ip (row/col/[r, c])
      • oob
        • type - How the data is stored (series/container/point)
        • iter
          • index-type - How data is indexed (row/col)
          • start - Row/Col where private vlan data begins
          • end - Row/Col where private vlan data ends
        • data
          • ip - location of the ip (row/col/[r, c])
  • site_info
    • type - How the data is stored (series/container/point)
    • sheet_name - Name of the sheet from where site information is to be read (File name, excluding the file extension, when using a CSV file)
    • sanitize - If data should be sanitised (boolean)
    • data
      • domain - location of the domain (row/col/[r, c])
      • subdomain - location of the subdomain (row/col/[r, c])
      • global_group - location of the global group (row/col/[r, c])
      • ldap - location of the ldap (row/col/[r, c])
      • ntp - location of the ntp (row/col/[r, c])
      • dns - location of the dns (row/col/[r, c])
  • location
    • type - How the data is stored (series/container/point)
    • sheet_name - Name of the sheet from where location information is to be read (File name, excluding the file extension, when using a CSV file)
    • sanitize - If data should be sanitised (boolean)
    • data
      • sitename - location of the sitename (row/col/[r, c])
      • corridor - location of the corridor (row/col/[r, c])
      • state - location of the state (row/col/[r, c])
      • country - location of the country (row/col/[r, c])
      • clli - location of the clli (row/col/[r, c])