Resources

CSV Import Tool

Video
 

Transcription:

In this video, we're going to cover how to add devices using the CSV import tool. Now, navigate to the devices manager at the top, and select device manager. That will bring you to the page you now see. Once you're here, select menu icon at the top left, and select CSV importer. There are 2 options, depending on the version of SNMP you are using. To ensure that you enter the information in the correct format required for the import tool, the best way is to copy this entire line here and use it as the header of a CSV file. For example, I could copy that information and then create a text file and give it a name such as importtemplate.csv. I have already done that, so I will forego that step. Once you actually have the template made, navigate to the CSV editor of your choice, in this case I'm using Excel. You can use as many as you would like here. I have entered 2 just for demonstration purposes.

You can see that the only piece of information that is strictly necessary is the IP address, because we will automatically resolve the name, if possible, in the system. However, the name flied cannot be left blank. Be sure to at least add the IP address of the device or devices you're looking to add. Everything else here is optional. We will save this, and then we're going to want to open it in a plain text editor. I'm going to right-click. Now I'm going to select everything below line one. Copy that, and then bring it back to our import tool, and hit paste.

Now, this should throw up errors, because these devices are already in the system. You'll see I have 2 errors. If I were to change this IP address to something new, and hit import, you can see that only the local host is now throwing up the errors. The CSV import tool will continue on and try every single device you have listed, and throw up errors when there's conflict, but it won't stop the process. It's resilient in that respect. You should actually see, going back to the device manager, those devices entered into the system.