Auto Deployment Plan Using Template

[TheZTP]

Hi,

I'm having issues when using Import Auto Deployment Devices to upload a CSV file with pre-populated fields.

After clicking start import button I get the following:

Import Result

Import File NameTemplate.csv
Start to import files...
Necessary file parameters are missing.
The import is complete. Please view information about imported devices on the auto deployment plan page.

I've tried it by leaving the column headings in, and also by only completing the few required fields and removing other fields. I can complete the process manually using the same file name for the config that gets sent to the device and it works fine, but not bulk using the CSV template. There are no imported devices on the auto deployment plan page using the template method.

I'm currently using iMC PLAT 7.3 (E0705) and not sure where the logs are to find out more information as to why it is failing.

[jguse · Accepted solution]

Hello,

It's been a while since I did some setups with CSV Import for ZTP, but one thing I recall is that all the headers in the CSV file were needed, even if some of the optional columns are not filled in. That's excluding the initial 'description' row in the template when you download it, which is only there to inform you of how each field should be filled in, and should be removed before import.

The "necessary file parameters are missing" error generally means you are missing certain columns or values, so that's why I'd recommend testing it with all of them.

So the first row/line should look similar to this:

TargetIp,ConfigFile,ConfigPara,MACAddress,changDeviceInfo,DeviceName,DeviceGroup,DeploySoft,CLIScript,CLIPara,changSnmpPara,SnmpParaVersion,SnmpParaRead,SnmpParaWrite,SnmpParaSecurityUser,SnmpParaContextName,SnmpParaSecuMode,SnmpParaAuthScheme,SnmpParaAuthPassword,SnmpParaPrivScheme,SnmpParaPrivPassword,PingDevType,changTelnet,TelnetStyle,TelnetUseName,TelnetPassword,TelnetSuperWord,changeSsh,SshParaAuthType,SshParaUserName,SshParaPassword,LoginType,mainToBackupFlag

...followed by the next rows/lines that include all the values filled in for the device(s), leaving optional ones blank.

By the way, the in-context Help menu in iMC has a neat table showing all the parameters and how to fill them in as well.

If you are still struggling to get it working, let me know and I'll ask you to send me the import csv file directly, so I can test it in my lab and see what is causing the issue.

[TheZTP]

Thanks Justin, I got it working by removing the row with descriptions. It also works when removing columns.

I had further issues but they were due to mismatch in variables in the template on iMC and the CSV emplate uploaded.