Bulk Migrate

The Bulk Migrate feature is our solution to not having a way to bulk update user information through the web portal. To make larger changes to the RapidIdentity MFA environment, we generate a SQL report that can be copied to a CSV file where we can make the necessary changes to then upload back to the server.

These changes do not affect the users' other MFA account information and the changes are instant.

Part 1 - Getting User Report From SQL

1. In your SQL database manager, run the following query:

-- Queries the following data with their respective titles:
-- UserName, Domain, Email, Language, AuthSet, Role, UserState

USE [ONE]
SELECT 
Users.name AS 'UserName', 
Users.domain AS 'Domain', 
Users.email AS 'Email', 
Languages.name AS 'Language', 
Auth_Sets.name AS 'AuthSet', 
Roles.name AS 'Role', 
States.name AS 'UserState'

FROM (Users
INNER JOIN User_Roles ON Users.user_id = User_Roles.user_id
INNER JOIN Roles ON User_Roles.role_id = Roles.role_id
INNER JOIN Auth_Sets ON Users.auth_set_id = Auth_Sets.auth_set_id
INNER JOIN States ON Users.state_id = States.state_id
INNER JOIN Languages ON Users.language_id = Languages.language_id )

-- Excludes the 'ONE_sys_admin' and  and 'Password Only' accounts 
-- to avoid accidental modifications to those accounts/account types
WHERE Auth_Sets.name != 'RapidIdentity Password Only'
ORDER By Users.name ASC

*You can add additional WHERE clauses to refine your results, if necessary.

2. In the results page from the query, copy the results. The column headers are optional.
   

   

3. Paste the results to your CSV editor of choice (this example utilizes Google Sheets).
   

4. Modify your users' information as necessary. Be sure to leave the headers alone.

5. Once your changes are complete, save your file as a .CSV.

Part 2 - Uploading The .CSV

1. In your MFA ONE Portal, go the the Users tab.
2. On the left-hand side, click New Users.
3. In the new dropped down menu, select Bulk Migrate.
4. In the main Bulk Migrate screen, click Choose File to open your file explorer and select your new .CSV file.
5. If you kept the headers like this example, be sure to check (✓) the "Ignore First Line" option.
6. Finally, click Bulk Migrate to upload your .CSV.