topic Re: Importing CSV file into ISE 3.0 in Network Access Control

Importing CSV file into ISE 3.0

fitzie — Thu, 16 Dec 2021 19:37:53 GMT

I'm setting up a new ISE 3.0p4 cluster. It consists of a pair of 3655 servers.

I'm unable to import a CSV file of Network Access Users.

Typical Error:

User Import Failed: Invalid Number of Field Names Found in csv File.

Sample File:

User Name,First Name,Last Name,Email
jblow-ms,Joe,Blow,jblow@domain.com

This file is based from the template file available from the application. I see four headers and four fields, separated by commas.

Re: Importing CSV file into ISE 3.0

Arne Bier — Thu, 16 Dec 2021 21:42:49 GMT

Hi @fitzie

I can't get to an ISE 3.0 system at the moment, but I think the CSV is missing a few fields.

User Name,First Name,Last Name,Email,User Details,Password,Is Password Encrypted(True/False),Enable User(Yes/No),Change Password on Next Login(Yes/No),User Identity Groups,Enable Password,Is Enable Password Encrypted(True/False),Password ID Store,Expiry Date(MM/dd/yyyy)

How about you try

User Name,First Name,Last Name,Email,User Details,Password,Is Password Encrypted(True/False),Enable User(Yes/No),Change Password on Next Login(Yes/No),User Identity Groups,Enable Password,Is Enable Password Encrypted(True/False),Password ID Store,Expiry Date(MM/dd/yyyy)
jblow-ms,Joes,Blow,jblow@domain.com,,,,,,,,,,

Re: Importing CSV file into ISE 3.0

hslai — Mon, 20 Dec 2021 03:36:19 GMT

Arne is essentially correct. But, the password is also required. Attached is a test CSV that worked on my ISE 3.0.