I'm currently trying to import a large number of devices into Prime rather than running a discovery and I'm running into a few issues.
I've downloaded the sample csv file and tried to edit the file to include just one device as a trial.
I've tried using both notepad+ and Excel and neither files work.
Now here's the catch when I try to import the normal file I'm told
Yes, you need the headers in there but you don't need the example user-defined-field. You can remove that column if you don't have any UDFs.
That was really the only sticking point I ever had, Paul.
You may try to select the add device manually. Try to add 1 device first and then once you have successfully added with no errors. You may try to export it in a form of .csv file which you can use as a valid template. Cisco Prime User Guide also has the informations which headers/columns are needed for you to successfully add a device.
Just thought I would follow this up by saying i had to make sure that the relevant fields were correctly filled out
ip, snmp version, community string, write community string, protocol, cli username, cli password
ip, snmp version, snmp retries, snmp timeout, protocol, cli username, cli password
0. I reccomend you to fill some devices manually and then make an export existing devices to csv file.
1. You need to create a excel file.
2. Import your csv file as a text with comma separating to your excel file. This would be more comfortable to add and edit new devices.
3. When your device list is ready, save it as .txt file
4. Open your .txt file, and with ctrl+H change all tabs to commas. Save file as .csv and upload to your PRIME.
5. Be happy
I have had the same problem. Then I have tried to export a defined device, but couldn't open the tar-file.
Now, I have successfully Bulk-imported a device list.
The point was, that in the example CSV, there is missing the column "network_mask". If missed, the error was "Incorrect Input ... [ip_address]".
So I have the following 2 first lines in the CSV, instead of all Passwords, etc, I have a credential profile with the name "Switch" :