Uniform Configuration Update: SIP & RTP Port Update

[RayC]

My Fellow 3CXrs, I have a problem...

Long story short, our 3CX configuration for a client with just sub 1000 extensions have had their setup messed up a bit. Multiple users have the same RTP and SIP ports specified for their extensions and this turned out to create some issues with voice quality.

I would like to rectify this and some other formatting issues, and the easiest way I thought might be possible, would be to correct all the mistakes in excel and import CSV. I have since found a few issues..

1. Existing extensions cannot be overwritten.
2. RPT and SIP Port information cannot be imported (or I might not be doing this correctly).
3. MAC address info cannot be imported (or.. you know.. I might be the one not doing this correctly.

One positive thing I noticed, was that if I delete an extension, and import it using my CSV template, the provisioning URL stays the same, so with some manual input I can get a phone up and running again in only a few minutes. Problem is, I need to fix a few hundred extensions, and manually assigning MAC addresses and Port details to each extension would take weeks to complete (I have a crazy schedule).

Question:

Is it possible to import MAC, RTP and SIP info using a CSV file? (Please provide me with a link to a template if it is possible - I tried finding the template myself but failed).

Keeping my fingers crossed for some positive feedback! Thanks in advance!

Sample of the Header and Ext text used in my CSV file:

Number,FirstName,LastName,EmailAddress,MobileNumber,AuthID,AuthPassword,WebMeetingFriendlyName,WebMeetingPrivateRoom,ClickToCall,ClickToCallFriendlyName,WebMeetingAcceptReject,EnableVoicemail,VMNoPin,VMPlayCallerID,PIN,VMPlayMsgDateTime,VMEmailOptions,QueueStatus,OutboundCallerID,SIPID,DeliverAudio,SupportReinvite,SupportReplaces,EnableSRTP,ManagementAccess,ReporterAccess,WallboardAccess,TurnOffMyPhone,HideFWrules,CanSeeRecordings,CanDeleteRecordings,RecordCalls,CallScreening,EmailMissedCalls,Disabled,DisableExternalCalls,AllowLanOnly,BlockRemoteTunnel,PinProtect,MAC_0,InterfaceIP_0,UseTunnel,DND,UseCTI,StartupScreen,HotelModuleAccess,DontShowExtInPHBK,DeskphoneWebPass,SrvcAccessPwd,VoipAdmin,SysAdmin,SecureSIP,PhoneModel14,PhoneTemplate14,CustomTemplate,PhoneSettings,AllowAllRecordings,PushExtension,Integration,AllowOwnRecordings,RecordExternalCallsOnly,DID,SMS,PhoneSysAdmin

1234,Username,Surname,[email protected],27712345678,P@55w0rd!@#$%1,P@55w0rd!@#$%2,,0,0,,0,1,0,0,2468,0,0,1,,,1,1,1,0,0,0,,0,0,0,0,0,0,0,0,0,0,0,0,,domain.3cx.co.za,1,0,0,0,,0,P@55w0rd!@#$%3,P@55w0rd!@#$%4,0,0,0,,,0,<PhoneDevice ProvType=""1"" LocalSipPort=""9876"" LocalRTPPortStart=""65100"" LocalRTPPortEnd=""65120"" PhoneLanguage=""English"" XferType=""BXfer"" RingTone=""Ring 1"" DateFormat=""WWW MMM DD (Mon Jan 15)"" TimeFormat=""24-hour clock"" PowerLed=""Both (Voicemail and Missed calls)"" Backlight=""30 seconds"" ScreenSaver=""30 seconds""><CustomQueueRingTones /><mcgroups enabled=""false"" /><DynamicOptions><option name=""vlanwanport"" value=""False"" /><option name=""vlanwanid"" value=""1"" /><option name=""vlanwanpriority"" value=""0"" /><option name=""vlanpcport"" value=""False"" /><option name=""vlanpcid"" value=""1"" /><option name=""vlanpcpriority"" value=""0"" /></DynamicOptions><LldpOptions><option name=""lldpvalue"" value=""True"" /></LldpOptions><CodecsPriority><Codec Priority=""1"" PriorityVarName=""codec1"" DisplayText=""PCMU"" PayloadTypeName=""payload1"" payload=""PCMU"">0</Codec><Codec Priority=""2"" PriorityVarName=""codec2"" DisplayText=""PCMA"" PayloadTypeName=""payload2"" payload=""PCMA"">8</Codec><Codec Priority=""3"" PriorityVarName=""codec3"" DisplayText=""G722"" PayloadTypeName=""payload3"" payload=""G722"">9</Codec><Codec Priority=""4"" PriorityVarName=""codec4"" DisplayText=""G729"" PayloadTypeName=""payload4"" payload=""G729"">18</Codec></CodecsPriority><BLFS OwnBlfs=""0"" /></PhoneDevice>",0,1,,1,0,,,0

 

[Saqqara]

Are extensions - physical handsets on the same network as the 3cx server or setup as SBC or the nightmare stun ?

To get the latest template to import, export one of your extensions.

Issues I can see - if you delete the extension all voicemail settings are deleted, same applied to chat - not sure what happens if you have voice recording enabled.

 

[RayC]

Are extensions - physical handsets on the same network as the 3cx server or setup as SBC or the nightmare stun ?

To get the latest template to import, export one of your extensions.

Issues I can see - if you delete the extension all voicemail settings are deleted, same applied to chat - not sure what happens if you have voice recording enabled.

Hi there Saqqara,

To answer your first question, "Nightmare STUN" would be the answer...

I have looked at the latest template (https://downloads-global.3cx.com/downloads/misc/ImportExtensionTemplateV16.csv) and this does not include any Port entries.. which is the biggest issue I'm facing at the moment.

I have updated the "PhoneSettings" entries manually and tried importing this, but it's simply not working. The extension might be created, but it will have Port info generated automatically, which kind of solves the issue, but we have a range of Port numbers specified, so although a free port is assigned to each extension, it's not in line with what we need for this specific client.

We have voicemail disabled for most extensions and we're not really bothered about the chat feature at the moment, so that doesn't really matter. The few extensions that I do need voicemail to be enabled for can easily be configured manually.

Edit: I have reviewed some advanced options that may have been ignored by the person who set the system up initially. So, I might in fact be able to use the template to fix these issues after-all.

 

[Saqqara]

If the phones are setup as stun, each phone requires different sip and rtp ports along with firewall configuration


To make your life easy, if the phones support it install one or more sbc servers at the phone location - https://www.3cx.com/docs/3cx-tunnel-session-border-controller/ . None of the sip / rtp ports , firewall config - just allow https , 3cx tunnel port and ntp ports out

 

[RayC]

If the phones are setup as stun, each phone requires different sip and rtp ports along with firewall configuration

To make your life easy, if the phones support it install one or more sbc servers at the phone location - https://www.3cx.com/docs/3cx-tunnel-session-border-controller/ . None of the sip / rtp ports , firewall config - just allow https , 3cx tunnel port and ntp ports out

Brilliant! I'll give this a go. Thank you so much!