is it possible to move reviews from one user that needs to be deleted to another user that will remain as an active user?

is it possible to move reviews from one user that needs to be deleted to another user that will remain as an active user?

Im trying to clean up users inorder to create a new one and I have 2 users id like to delete but they have reviews I need to keep. Is there a way to move those reviews to another user?

1 answer

1 accepted

This widget could not be displayed.

Hi Seth,

It's possible but you will have to modify the database directly:

  • generate a backup of the Crucible instance (in Admin/Backup)
  • stop Crucible
  • find the primary key of the user you want to delete:
select cru_user_id from cru_user where cru_user_name = 'user_to_delete'

  • find the primary key of the user you want to keep:
select cru_user_id from cru_user where cru_user_name = 'user_to_keep'

  • update all the reviews, review comments and review participants to switch them from the old user to the other one:
update cru_comment set cru_user_id = 'id_user_to_keep' where cru_user_id = 'id_user_to_delete';
update cru_comment_read_status set cru_user = 'id_user_to_keep' where cru_user = 'id_user_to_delete';
update cru_review_participant set cru_user = 'id_user_to_keep' where cru_user = 'id_user_to_delete';
update cru_review set cru_creator = 'id_user_to_keep' where cru_creator = 'id_user_to_delete';
  • start Crucible
  • in the Admin, if the user to delete is a moderator, default reviewer and default review participant in any project, remove him or her from the project's setting (using the button 'Edit' in the 'Crucible settings' column for each project)

You may also want to update the review history:

see the cru_logitem table, the cru_user_id column

 

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

169 views 18 7
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