Is there a way to bulk change user roles, for example with user import?

Siim Neljandik shared this question 4 months ago
Answered

Hello,


Is there a way to change the role of a selection of users at once?

For example does using the user import with slightly changed values overwrite the data for existing users? Or is this something only a user with database query access can do?


All the best

Siim N

Comments (1)

photo
1

Hi Siim,

The bulk import does not allow you to do this. It will simply let you know that the user exists.

You're best option (if you have access to the DB) is to modify the column 'RoleCode' in the 'StaffMemberRole' table.

This code matches an existing role in your system.

Then after the change, you restart YF and you're done!

You would obviously need to know the ipemployee id and who it belongs to, which you can get from the ipcontact or person table.

ie.

44284858817a7769922e8471d5858674

NOTE: If you are going to make any updates to this table. Make sure you have backed up your DB first and that it is fully recoverable.

Please let me know if this is what you are looking for and if you need anything else.

Regards,

Paul

photo
1

Hello,


Thank you for your answer, this got me towards the answer. Because we have multiple child organisations and this needed to be done in a single one, the iprltshp table was also used.


All the best

Siim N

photo
1

Hi Siim,

Yes this would be quite correct and I should have clarified that with you first. So from your comments can I assume then that you now have a query which works? If not, please let me know what else you need.

Thank you,

Paul

photo
1

Yes, I have a query that worked, and you can consider this question answered.

photo
1

Hi Siim,

Thats great and thanks for getting back to me.

Cheers,

Paul

photo