cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
684
Views
0
Helpful
2
Replies

ACS5.1 Updating Internal User Database

ComstorFR
Level 1
Level 1

Hi,

Using  a CSV file, I can not add user in the internal database of the ACS

I have a permanent "error File Format Validation Failed"

However the file I want to import is a really CSV file.

Do anyone had the same problem or does anyone know how to get out ?

Bests regards

1 Accepted Solution

Accepted Solutions

jrabinow
Level 7
Level 7

You need to make sure you perform the following steps

1) Go to Users and Identity Stores > Internal Identity Stores > Users

2) Press "File Operations" and then "Next"

3) Press "Sownload Add Template"

4) Open the downloaded file. This gives you a header file which describes the order of the fields to be defined in the CSV

Keep the header line as is - do not edit since will cause the error you see above. Undeneath the header add one line for each user you want to add. Eg here is a sample record for a user (in case where no internal identity attributes have been defined)

jonny,,true,false,1234,,                     // name: jonny; no description; enabled:true; change password: false; password: 1234; empty enable password and internal identity group [ defaults to "All Groups"

5) Once you have the file repeat the process of steps 1-4 above except instead of downloading file press "Next" and select the file you just created. Press finish and data should be imported

View solution in original post

2 Replies 2

jrabinow
Level 7
Level 7

You need to make sure you perform the following steps

1) Go to Users and Identity Stores > Internal Identity Stores > Users

2) Press "File Operations" and then "Next"

3) Press "Sownload Add Template"

4) Open the downloaded file. This gives you a header file which describes the order of the fields to be defined in the CSV

Keep the header line as is - do not edit since will cause the error you see above. Undeneath the header add one line for each user you want to add. Eg here is a sample record for a user (in case where no internal identity attributes have been defined)

jonny,,true,false,1234,,                     // name: jonny; no description; enabled:true; change password: false; password: 1234; empty enable password and internal identity group [ defaults to "All Groups"

5) Once you have the file repeat the process of steps 1-4 above except instead of downloading file press "Next" and select the file you just created. Press finish and data should be imported

ComstorFR
Level 1
Level 1

Hi jrabinow

Thank a lot for your reply.

Regards