How do I import my delegated LDAP users from Confluence into Crowd
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
To import delegated LDAP users from Confluence into Crowd. You can create 2 CSV (Comma Separated Values) files from your database of users and memberships that are in the Delegated Directory and import them into Crowd. The following examples are for MySQL only. (for other databases, please refer to your database manual on how to generate a CSV file from a query).
Solution
First, run this query to identify the ID of the Delegated Directory (in the Confluence Database):
1
SELECT * FROM cwd_directory;Record the ID of the Delegated Directory, then use it in the following queries:
To generate the Group Memberships CSV file:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23SELECT 'Username', 'GroupName' UNION ( SELECT u.user_name, g.group_name FROM cwd_user u JOIN cwd_directory d ON u.directory_id = d.id JOIN cwd_membership m ON u.id = m.child_user_id JOIN cwd_group g ON g.id = m.parent_id WHERE u.directory_id = <id> ORDER BY 2 ASC, 1 ASC INTO OUTFILE '/path/to/memberships.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n');Replace
/path/to/memberships.csvwith the full path to the memberships csv file that you wish to generate, and<id>with the ID of the Delegated Directory from the earlier SELECT queryTo generate the User CSV File:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18SELECT 'FirstName', 'LastName', 'Username', 'EmailAddress', 'Password' UNION ( SELECT u.first_name, u.last_name, u.user_name, u.email_address, u.credential AS password FROM cwd_user u WHERE u.directory_id = <id> ORDER BY 2 ASC, 1 ASC INTO OUTFILE '/path/to/users.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' );Replace
/path/to/users.csvwith the full path to the users csv file that you wish to generate, and<id>with the ID of the Delegated Directory from the earlier SELECT query
After this is done, login to Crowd, then click on Users, followed by Import Users. Select the CSV Importer:
Specify the destination directory as a Delegated Directory in Crowd (that you might have created much earlier). Then specify the path to both the users.csv and memberships.csv that are generated with the SQL queries earlier, something like this:
Then specify the mapping accordingly, something like this:
Click Continue and Voila! You're done!
Was this helpful?