Need Help with bulk extension import/update on existing extensions.

allankon

New Member
Jun 25, 2020
3
0
1
31
Hi,

we're currently using fusionpbx 4.5.13 and would like to know how do a bulk update on the existing extensions

i know that there is extension import function in fusionpbx either by pasting in the Data or upload a csv file.
By pasting the extension values into Data will create new extensions instead of overwriting the existing extensions. i.e. i ended up having 2 identical extensions with the same value by doing that.

I tried uploading CSV within "file to upload" function but it leads to an empty page instead.

i'm new to fusionpbx and would really appreciate if anyone can help with this. o_Oo_O





1593491316849.png

1593491616234.png
 

ad5ou

Active Member
Jun 12, 2018
423
91
28
Install from terminal
cd /usr/src
git clone https://github.com/fusionpbx/fusionpbx-apps
Move the directory 'bulk_account_settings' into your main FusionPBX directory
mv fusionpbx-apps/bulk_account_settings /var/www/fusionpbx/app
chown -R www-data:www-data /var/www/fusionpbx/app/bulk_account_settings.

Log into the FusionPBX webpage
Advanced -> Upgrade
Menu Defaults and Permission Defaults.
Log out and back in.


Once it is installed, it will be found under Advanced>Bulk Account Settings
Then You will get a screen to choose type of bulk changes. Devices, Extensions, Users, Voicemails.
1593696281629.png
When you make a selection it will create a list of available settings to change and which device/extension/etc to update.
1593696429705.png
Choose the setting. For example Emergency Caller ID Number. The screen will then give you an input box for the new information.
1593696630176.png
Select which items get the updated setting and press "submit"
Depending on what was changed, it might be necessary to flush cache.


(edited to add install directions since it isn't in repo)
 
Last edited:

Adrian Fretwell

Active Member
Aug 13, 2017
486
85
28
@ad5ou Great tutorial, you have explained this very well.

Just for completeness may I ask why we are not using the Extension Import that is built in to the standard FusionPBX extensions page as per the screenshot posted by @allankon are there problems with that software?
 

ad5ou

Active Member
Jun 12, 2018
423
91
28
As mentioned, the import tool will create new but struggles with updating existing information. The bulk account setting app is great for making changes to multiple extensions etc.

I use it quite often to update all sorts of options. Bulk reset voicemail passwords, change device sip ports/transport, Outbound or emergency CID etc etc

There is also a “bulk import extensions” app in the extra app repository but isn’t needed in master (4.5j since imports are built in.
 
  • Like
Reactions: Adrian Fretwell