How do you move a single user from one Crowd directory to another?

I have an install of Crowd 2.2.2 with two user directories. For this exercise let's call the directories OSI and GCI. I have a single user who is a member of the GCI directory. I need to move him to the OSI directory. Migrating all users from GCI into OSI is fairly simple but I can't find a way to move a single user from one to the other. So far my best idea is to export all GCI users to a CSV file, eliminate all but the single user I need and import the file. That seems a bit roundabout and likely to have unintended (bad) consequences. Is there a better way?

1 answer

1 accepted

3 votes
Colin Goudie Community Champion Feb 13, 2012

You could do this in the database

Basically the 3 tables you'll need to look at are cwd_user, cwd_group and cwd_membership

The easiest part is changing the user, you would simply change the directory_id field for that particular user in cwd_user

However, you also need to update that user's membership details which will involved making sure corresponding groups exist in the cwd_group table and updating the membership table to point to the new cwd_group id's and directory_id

Take a look at the schema, it's pretty easy to navigate

Score! That was it. Thanks, Colin.

This change needs to be restart JIRA is there a way to avoid that?

Suggest an answer

Log in or Join to answer
Community showcase
Alexey Matveev
Published Saturday in Jira

How to run Jira in a docker container

Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...

152 views 3 7
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot