Update a SevOne device’s meta-data from an excel spreadsheet

 View Only
Thu September 14, 2023 04:57 AM

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.

Statistics
0 Favorited
29 Views
2 Files
0 Shares
12 Downloads
Attachment(s)
zip file
Add SevOne Device Metadata from Excel_2023-03-08_21 27 26.zip   2 KB   1 version
Uploaded - Thu September 14, 2023
xlsx file
SevOne Device Metadata.xlsx   10 KB   1 version
Uploaded - Thu September 14, 2023

Comments

Wed April 17, 2024 03:56 PM

@Pieter De Villiers, please export the flow using absolute paths so that the Excel action blocks are linked appropriately within the flow.  

Currently you get a red block:

Missing flow URL: system/Excel/ListSheetNames