topic Error on import Users ACS Version : 5.8.1.4 in Network Access Control

Error on import Users ACS Version : 5.8.1.4

Malick MBAYE — Sat, 23 Feb 2019 12:26:48 GMT

Hello,

My trooble is that i want to import some users on ACS.

For exemple i downloaded the template show on file operations.

the first line is:

name:String(64):Required,description:String(1024),Email_Address:String(1024),"dateExceedsEnabled:Boolean(true,false):Required",dateExceeds:Date(yyyy-Mmm-dd),"maxFailedLoginAttemptsEnabled:Boolean(true,false):Required","enablePasswordHash:Boolean(true,false):Required",maxFailedLoginAttempts:Integer(1:99),"passwordNeverExpires:Boolean(true,false):Required","enabled:Boolean(true,false):Required","changePassword:Boolean(true,false):Required",password:String(32):Required,enablePassword:String(32),passwordType:String(256):Required,UserIdentityGroup:String(256)

And i completed the second line with:

bbtrading,,,false,,false,false,3,false,true,true,Pass123,,Internal Users,All Groups

Then i saved and tried to imported this file but i got the folowing error:

2019-02-23 12:19:31: File Format Validation Failed
Header is incorrect. Download Import Template for required header record.

Aborting......

I looked on others discussions and tried the solutions but nothing .

Help please. i need to import 100 users.

I attached the import file.

Re: Error on import Users ACS Version : 5.8.1.4

Malick MBAYE — Sun, 24 Feb 2019 09:27:36 GMT

Can any Pro help a Noob Please?

Re: Error on import Users ACS Version : 5.8.1.4

Damien Miller — Sun, 24 Feb 2019 18:42:39 GMT

The issue with your file is that the header is all in Column A. You do not have headers for Coumns B on that you should. I have fixed the file for you and attached it to my post.

Re: Error on import Users ACS Version : 5.8.1.4

Malick MBAYE — Sun, 24 Feb 2019 20:14:09 GMT

Hello Damien,

Thanks for replying me.

I dont really understand. You mean that there will be something on ColumnB ?

I imported your file and it works but when i just try to change the name "bbtrading" to "bbtradings" (with s) or change the Group, and try to import, i have got the same result: It Fails.

I put on attach the file changed to bbtrading (i just did Ctrl+H to find and replace)

Can you Help me?

Re: Error on import Users ACS Version : 5.8.1.4

Damien Miller — Sun, 24 Feb 2019 20:22:18 GMT

It's a CSV file. Each value/column is separated by a comma. Look at the image I attached, data is parsed in to individual columns.

Your failing file has the header in a single column.

Mine below has everything set correct.

Re: Error on import Users ACS Version : 5.8.1.4

Malick MBAYE — Sun, 24 Feb 2019 22:27:12 GMT

Oddly, opening your file that works, I do not have the same view as you (See Joint) but it works anyway.
It's just when I change the name that it does not work anymore.

I do not understand why this is Can the problem come from Excel itself?