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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Thursday in Off-topic

Friday Fun: Magic Eyes

...staring into the background. Once the image pops out in 3D, you can look around the picture and enjoy. If you will see if you are a true illusion master! :) You did it? :) Wow! Awesome! As a bonus...

458 views 83 11
Join discussion

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