Is there a way to bulk change user roles, for example with user import?
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
The same question
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.
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
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.
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
Replies have been locked on this page!