Exporting Custom SIP Profiles to another Instance

[Skeelkat]

Has anyone any idea on how to export a custom SIP Profile, so that it can be imported on another host?
I have searched high and low for an XML file that contains the data, but i feel this is stored in the DB somewhere..

 

[hfoster]

Yes, I think this is one thing that doesn't get cached as an XML file, mainly as it's only read at launch usually.

fusionpbx=# select * from v_sip_profile_settings;

You should be able to export this specific table using pgdump or COPY commands to a CSV import. Something like:

pg_dump --table=v_sip_profile_settings --data-only --column-inserts fusionpbx > profiles.sql



AS ALWAYS, BEFORE YOU DO ANY SQL WORK. CHECK YOU CAN RESTORE FROM A BACKUP.

 

[Mikeme]

From web gui ->SIP Profile, check box of the current profile and then press copy.
Then customize the copied profile.