This article will explain how to create and import lists of known Devio devices into the Devio System Administration Utility (SAU). There are two supported methods for importing known devices into the SAU: pasting in a properly formatted plaintext list, or importing a .csv file. Either of these methods will result in the SAU's device list being populated with a separate entry for each of the IP addresses provided.
What is a CSV file?
A Comma-Separated Values (CSV) file stores information intended for a table as plain text, with commas indicating when a new cell or field is needed. This can be used to import/export tables between otherwise incompatible software applications.
In Devio, CSV files can be used to quickly import a table of known Devio devices within the SAU.
Creating a CSV file
CSV files can be created using most spreadsheet and plain text editing software applications, such as Microsoft Excel and Notepad, respectively. To create a CSV file that can be imported successfully into Devio's SAU, follow the steps below.
- Create a list of IP addresses that is horizontal, with no line breaks between them
- If using a spreadsheet editor, place each IP address into a separate cell, on a single row.
- If using a plain text editor, separate each IP address with a comma.
- Most spreadsheet editing applications should natively support the .csv file extension. If this is true for the application you are using, follow these steps:
- Go to File and select Save As
- From the file type drop down, select a .csv extension
- Press OK to create the .csv file under the name and location you've specified
- If the application does not natively support the .csv file extension (most plain text editors will not), proceed with the following steps:
Importing device list
Below you will find instructions for the two supported methods of importing a list of known devices into the SAU.
Importing a .csv file
Once a .csv file has been created, it can be imported directly into the SAU using the following steps.
Adding devices via the clipboard
This first method does not actually require generating a .csv file. However, the same rules will apply in terms of how the data is laid out -- it must be in horizontal rows, separated either by commas or cells, with Word Wrap engaged and no line breaks.
Below is a small notepad document containing five known IP addresses of Devio units.