Description: Allows a user to fill in the appropriate columns and rows in a Excel spreadsheet with metadata about a device.  Different tabs in the worksheet create different SevOne namespaces so the user can add more types of metadata for any device in SevOne.

Rapid Network Automation Version: 2022.8 or later

Integrations required: SevOne minimum version 1.0.20

Authentication(s) needed: SevOne, SSH (needed for the SFTP server)

Infrastructure requirements: SFTP server where the spreadsheet can be stored

SevOne User Role: The user must be part of the administrator's group

Setup:

• Download the Excel spreadsheet provided to a server running SFTP - Rapid Network Automation needs to be able to download the sheet before executing the automation.  If you need more information on how to set up a SFTP server please refer to the documentation for the operating system you are running on the intended server
• You must modify the variable SevOne_Authkey in the start block to your current SevOne authentication name
• You must modify the variable SFTP_authKey in the start block to your current SFTP SSH authentication name
• You must modify the variable XLSX_file_path in the start block to your current file path of the excel (xlsx) file.