How to make mass changes to extensions?

[edisoninfo]

I want to change the allow field for all of the extensions from ulaw,alaw to g722,ulaw. It appears I have to click on each extension one by one and make this change? Ugh. Any way to do this across the board? I have Aastra 57i and 31i phones and have put settings in the .cfg files but it appears that the settings in FreePBX override them.

 

[euser4life]

Bulk Extensions module is your friend

You need to add the third party FreePBX module called Bulk Extensions. It will make life much easier.... Also before making any changes make a FreePBX backup first.... Just to CYA!!!

 

[Bitnetix]

Or, you can do what we do and update the database directly, then repopulate the config files. This is *NOT* recommended for the feint of heart, but your command would be this (you can do it for all or for individual extensions):

$ mysql -u root -p
<enter password>

mysql> use asterisk;
mysql> update sip set data='g722,ulaw' where keyword='allow';
<or>
mysql> update sip set data='g722,ulaw' where keyword='allow' and id='<ext>';

mysql> exit

Go into FreePBX interface and you should see the yellow bar to commit changes. Punch it and you should be all set.

BE VERY FREAKIN CAREFUL doing this type of operation, as it's easy to mess it up. But it's quick and dirty to do this kind of work this way as well.