topic Re: Administrators bulk add via mgmt_cli in API / CLI Discussion

Administrators bulk add via mgmt_cli

Juan_ — Mon, 05 Jul 2021 14:11:36 GMT

Hi Buddies,

We are trying to add multiple administrators in one go via mgmt_cli but something is going wrong.

Not sure if its a bug or there is a different reason for the failure.

We Run:
- mgmt_cli add administrator name "username" password "password" email "username@xyz.com" authentication-method "check point password" permissions-profile "Read Write All" --domain 'System Data'
  - This works fine
If we run:
- mgmt_cli add administrator --batch administrators.csv --domain 'System data'
  - Fails with:
    - Line 2: code: "generic_err_invalid_parameter_name" message: "Unrecognized parameter [name]"

Our CSV looks like this:

name,password,email,authentication-method,permissions-profile

username,password,username@xyz.com,'check point password','Super User'

Have tried on R80.40 and 20.

Any suggestion?

Cheers

Re: Administrators bulk add via mgmt_cli

PhoneBoy — Mon, 05 Jul 2021 15:05:42 GMT

It should be failing on line 1 if the header row is wrong.
Which suggests you have an extra line feed in your CSV file.

Re: Administrators bulk add via mgmt_cli

Juan_ — Mon, 05 Jul 2021 15:26:21 GMT

Thanks! That helped my memory.

dos2unix fixed it.

Re: Administrators bulk add via mgmt_cli

Tal_Paz-Fridman — Mon, 05 Jul 2021 15:29:19 GMT

I created your file with quotations marks instead of apostrophes in the following way and it worked:

name,password,email,authentication-method,permissions-profile

username,password,username@xyz.com,"check point password","Super User"

Also worked without the quotation marks:

name,password,email,authentication-method,permissions-profile

username,password,username@xyz.com,check point password,Super User

Re: Administrators bulk add via mgmt_cli

Juan_ — Mon, 05 Jul 2021 15:33:40 GMT

Thanks mate! as explained above the issue was with the format. dos2unix did the trick

I think we transferred the file out of excel directly. (ugh!)