This article will explain how to create and import lists of known Devio CR-1 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 CR-1 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 CR-1 units.