Importing Users
In addition to manually adding individual users, you can import multiple users in bulk if you have exported them to a comma-separated values (.csv) file or Microsoft Excel (.xls) file. It is possible to import the username and password directly from the CSV/Excel to the product. Other user attributes can be imported only if the claim URls are defined for such attributes in the product.
For example, consider that you have claim URls defined for your product as shown below. These will allow you to import the user's email address, full name, last name, given name and role in addition to the username and password.
The username, password and other attributes (claim URls) that you import should be given in a CSV file as shown below. Note that the first line of the file will not be imported considering that it is not a username.
This is only supported if you have configured your user store as JDBCUserStoreManager. See here for information on how to do this.
It is recommended to upload a maximum of 500,000 users at a time. If you need to upload more users, you can upload them in separate batches of 500,000 each. You can also specify the size of the file that you can upload in the <PRODUCT_HOME>/repository/conf/carbon.xml
file using theTotalFileSizeLimit
element. This value is in MB.
<TotalFileSizeLimit>100</TotalFileSizeLimit>
Follow the steps given below to import users:
- Sign in to the WSO2 EMM management console.
- Click Add under Users and Roles.
- Click Bulk Import Users.
- Browse and select the file that contains the user data.
- Specify a default password to assign to all the users you are importing and click Finish. This password is valid for only 24 hours, so you should inform your users that they must log in and change their password within 24 hours.