Update user group name

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Update user group name

Postby davide.filippi » Mon May 21, 2018 9:57 am

Hi All,
I need to update the name of an user group. If I simply change the name from USER GROUP / [name of group], users in that group doesn't update their user group automatically. Is there some trick or I need to search in database all columns named "user_group" and update table by table?

Vicidial VERSION: 2.14-662a - BUILD: 180306-1718

Thanks for the reply
ViciBox.x86_64-4.0.1.iso from dvd | Vicidial VERSION: 2.8-403aBUILD: 130510-1350 | SVN Version: 1983 | Cluster: 4 web+dialer (2 Dell Poweredge 1950 - 1 Dell Poweredge 2950; 1 Dell Poweredge R610); 1 db on Dell Poweredge R710 | no extra hw/sw
davide.filippi
 
Posts: 85
Joined: Thu Nov 10, 2016 8:45 am

Re: Update user group name

Postby MJCoate » Mon May 21, 2018 12:45 pm

Correct, you'd have to update them in the DB manually.
Mike Coate | VICIdial Technical Support Staff
MJCoate
 
Posts: 82
Joined: Wed Mar 25, 2015 1:57 pm

Re: Update user group name

Postby davide.filippi » Wed May 30, 2018 9:58 am

Hi all,
I did it.

First of all check which table you have to update. Go in "information_schema" database, "COLUMN" table and execute
SELECT * from COLUMNS where table_schema = "yourasteriskdb" and column_name = "user_group". This show you all tables contains user_group field.

After this you can execute for all tables you found in the first step
update [one of the table found in the previous step] set user_group = "NewUserGroup" where user_group = "OldUserGroup"

Hope this can help.

Regards
ViciBox.x86_64-4.0.1.iso from dvd | Vicidial VERSION: 2.8-403aBUILD: 130510-1350 | SVN Version: 1983 | Cluster: 4 web+dialer (2 Dell Poweredge 1950 - 1 Dell Poweredge 2950; 1 Dell Poweredge R610); 1 db on Dell Poweredge R710 | no extra hw/sw
davide.filippi
 
Posts: 85
Joined: Thu Nov 10, 2016 8:45 am


Return to Support

Who is online

Users browsing this forum: Bing [Bot] and 55 guests