cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
4046
Views
5
Helpful
2
Replies

Importing CSV file into ISE 3.0

fitzie
Level 1
Level 1

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.

2 Accepted Solutions

Accepted Solutions

Arne Bier
VIP
VIP

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,,,,,,,,,,

View solution in original post

hslai
Cisco Employee
Cisco Employee

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

 

View solution in original post

2 Replies 2

Arne Bier
VIP
VIP

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,,,,,,,,,,

hslai
Cisco Employee
Cisco Employee

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