Wireless Access

Hello everyone, I just want to ask if there is a way that I can bulk import users from my csv file to Clearpass Local user database. since we are now migrating all users to clearpass. to achieved a seamless  process we will migrate first all the user credentials to our clearpass local user database so everyone can still connect to the ssid using there existing credentials once we will broadcast the ssid with clearpass as radius server. as I check, the only way is to use an xml file and it is a tedius process since we have a almost 400 users to migrate.

What I want to achieve is that I can migrate all users at the same time so it can save time also with our process.

Hi

You can import local users, but you must use an XML file. For example:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><TipsContents xmlns="http://www.avendasys.com/tipsapiDefs/1.0">  <TipsHeader exportTime="Wed Feb 21 13:39:12 CET 2024" version="6.10"/>  <LocalUsers>    <LocalUser changePwdNextLogin="false" enabled="true" roleName="[Employee]" passwordNtlmHash="" passwordHash="" password="" userName="test user" userId="test.user"/>  </LocalUsers>  <Roles>    <Role description="Default role for an employee" name="[Employee]"/>  </Roles></TipsContents>

You can create a simple script or use e.g. mail merge in MS Word and thus generate the appropriate file.

Regards

------------------------------
Piotr Filip

ACEX#41/ACCX/ACDX/ACMX/CWNA/CWSP

Original Message:
Sent: Feb 21, 2024 06:59 AM
From: ajorigenes17
Subject: Import Users to ClearPass Local user database

Hello everyone, I just want to ask if there is a way that I can bulk import users from my csv file to Clearpass Local user database. since we are now migrating all users to clearpass. to achieved a seamless  process we will migrate first all the user credentials to our clearpass local user database so everyone can still connect to the ssid using there existing credentials once we will broadcast the ssid with clearpass as radius server. as I check, the only way is to use an xml file and it is a tedius process since we have a almost 400 users to migrate.

What I want to achieve is that I can migrate all users at the same time so it can save time also with our process.

Hi

You can import local users, but you must use an XML file. For example:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<TipsContents xmlns="http://www.avendasys.com/tipsapiDefs/1.0">
  <TipsHeader exportTime="Wed Feb 21 13:39:12 CET 2024" version="6.10"/>
  <LocalUsers>
    <LocalUser changePwdNextLogin="false" enabled="true" roleName="[Employee]" passwordNtlmHash="" passwordHash="" password="" userName="test user" userId="test.user"/>
  </LocalUsers>
  <Roles>
    <Role description="Default role for an employee" name="[Employee]"/>
  </Roles>
</TipsContents>

You can create a simple script or use e.g. mail merge in MS Word and thus generate the appropriate file.

Regards

------------------------------
Piotr Filip

ACEX#41/ACCX/ACDX/ACMX/CWNA/CWSP
------------------------------

Original Message:
Sent: Feb 21, 2024 06:59 AM
From: ajorigenes17
Subject: Import Users to ClearPass Local user database

Hello everyone, I just want to ask if there is a way that I can bulk import users from my csv file to Clearpass Local user database. since we are now migrating all users to clearpass. to achieved a seamless  process we will migrate first all the user credentials to our clearpass local user database so everyone can still connect to the ssid using there existing credentials once we will broadcast the ssid with clearpass as radius server. as I check, the only way is to use an xml file and it is a tedius process since we have a almost 400 users to migrate.

What I want to achieve is that I can migrate all users at the same time so it can save time also with our process.

Hello everyone, I just want to ask if there is a way that I can bulk import users from my csv file to Clearpass Local user database. since we are now migrating all users to clearpass. to achieved a seamless  process we will migrate first all the user credentials to our clearpass local user database so everyone can still connect to the ssid using there existing credentials once we will broadcast the ssid with clearpass as radius server. as I check, the only way is to use an xml file and it is a tedius process since we have a almost 400 users to migrate.

What I want to achieve is that I can migrate all users at the same time so it can save time also with our process.

Maybe this Aruba Solution Exchange solution works for you. It generates XML based on CSV input.

Hello everyone, I just want to ask if there is a way that I can bulk import users from my csv file to Clearpass Local user database. since we are now migrating all users to clearpass. to achieved a seamless  process we will migrate first all the user credentials to our clearpass local user database so everyone can still connect to the ssid using there existing credentials once we will broadcast the ssid with clearpass as radius server. as I check, the only way is to use an xml file and it is a tedius process since we have a almost 400 users to migrate.

What I want to achieve is that I can migrate all users at the same time so it can save time also with our process.

Hi Herman can you shared me a sample csv file to make sure that im in the right path for the configuration.

Thank you

Original Message:
Sent: Feb 21, 2024 08:02 AM
From: Herman Robers
Subject: Import Users to ClearPass Local user database

Maybe this Aruba Solution Exchange solution works for you. It generates XML based on CSV input.

------------------------------
Herman Robers
------------------------
If you have urgent issues, always contact your Aruba partner, distributor, or Aruba TAC Support. Check https://www.arubanetworks.com/support-services/contact-support/ for how to contact Aruba TAC. Any opinions expressed here are solely my own and not necessarily that of Hewlett Packard Enterprise or Aruba Networks.

In case your problem is solved, please invest the time to post a follow-up with the information on how you solved it. Others can benefit from that.

Original Message:
Sent: Feb 21, 2024 06:59 AM
From: ajorigenes17
Subject: Import Users to ClearPass Local user database

Hello everyone, I just want to ask if there is a way that I can bulk import users from my csv file to Clearpass Local user database. since we are now migrating all users to clearpass. to achieved a seamless  process we will migrate first all the user credentials to our clearpass local user database so everyone can still connect to the ssid using there existing credentials once we will broadcast the ssid with clearpass as radius server. as I check, the only way is to use an xml file and it is a tedius process since we have a almost 400 users to migrate.

What I want to achieve is that I can migrate all users at the same time so it can save time also with our process.

You have a CSV example when you go to the link sent by Herman

userId,userName,enabled,password,roleName,Phone,Email,Sponsor,Title,Department,Designationtestuser1,Test User 1,true,aruba123,[TACACS Super Admin],8882221212,test@test.com,admin1,Test Title 1,IT,Contractortestuser2,Test User 2,true,aruba124,[TACACS Super Admin],8882221213,test@test.com,admin2,Test Title 2,IT,Contractor

Of course, you don't have to use that many columns. The minimum will probably be: userId, userName, enabled, password, roleName

Regards

------------------------------
Piotr Filip

ACEX#41/ACCX/ACDX/ACMX/CWNA/CWSP

Original Message:
Sent: Feb 21, 2024 08:17 AM
From: ajorigenes17
Subject: Import Users to ClearPass Local user database

Hi Herman can you shared me a sample csv file to make sure that im in the right path for the configuration.

Thank you

Original Message:
Sent: Feb 21, 2024 08:02 AM
From: Herman Robers
Subject: Import Users to ClearPass Local user database

Maybe this Aruba Solution Exchange solution works for you. It generates XML based on CSV input.

------------------------------
Herman Robers
------------------------
If you have urgent issues, always contact your Aruba partner, distributor, or Aruba TAC Support. Check https://www.arubanetworks.com/support-services/contact-support/ for how to contact Aruba TAC. Any opinions expressed here are solely my own and not necessarily that of Hewlett Packard Enterprise or Aruba Networks.

In case your problem is solved, please invest the time to post a follow-up with the information on how you solved it. Others can benefit from that.

Original Message:
Sent: Feb 21, 2024 06:59 AM
From: ajorigenes17
Subject: Import Users to ClearPass Local user database

Hello everyone, I just want to ask if there is a way that I can bulk import users from my csv file to Clearpass Local user database. since we are now migrating all users to clearpass. to achieved a seamless  process we will migrate first all the user credentials to our clearpass local user database so everyone can still connect to the ssid using there existing credentials once we will broadcast the ssid with clearpass as radius server. as I check, the only way is to use an xml file and it is a tedius process since we have a almost 400 users to migrate.

What I want to achieve is that I can migrate all users at the same time so it can save time also with our process.

Hello everyone, I just want to ask if there is a way that I can bulk import users from my csv file to Clearpass Local user database. since we are now migrating all users to clearpass. to achieved a seamless  process we will migrate first all the user credentials to our clearpass local user database so everyone can still connect to the ssid using there existing credentials once we will broadcast the ssid with clearpass as radius server. as I check, the only way is to use an xml file and it is a tedius process since we have a almost 400 users to migrate.

What I want to achieve is that I can migrate all users at the same time so it can save time also with our process.