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.