View source for SIP number translation table (AlphaCom)

{{A}} From the web interface of AlphaCom, in the '''System Configuration''' > '''SIP settings''' menu, one can upload a CSV file, which is used for number translation on incoming and/or outgoing SIP Trunk calls.
<br>
'''Use case''': [https://en.wikipedia.org/wiki/Direct_inward_dial Direct Dial-In (DDI)] (aka Direct Inward Dialing DID), where a series of public phone numbers can be directly routed to predefined intercom stations. When an outgoing call is made from an intercom station, one can manipulate the source of the caller to be the public phone number instead of the intercom station number.

[[File:AMC SIP Settings.PNG|thumb|500px|left|'''SIP settings''' configuration page]]
<br style="clear:both;" />

<br>
== SIP number translation file ==

The CSV file can be uploaded, edited and saved from Excel.

'''.CSV file'''

 Number translation;;;
 Type;AlphaCom;Public;
 in ;110;22222900;
 out ;120;22341567;
 bi;2563;40002563;
 in ;-;*;
 out ;*;40002500;



The first two lines of the file is ignored and is used for description of columns in Excel.
(The order of the rest of the lines is not important.)


'''First column'''
*"in"      Translation used for incoming calls, the destination number will be matched with "Public" and replaced with "AlphaCom" number.
*"out"     Translation used for outgoing calls, the source number will be matched with "AlphaCom" and replaced with "Public".
*"bi"      Translation used for both incoming and outgoing with the above rules.

'''Second column'''
*AlphaCom number

'''Third column'''
*Public number

'''Special characters'''
 '*'  If no match found use this entry (Can only be used for "in" or "out" not for "bi")
 '-'  When used for "in"-AlphaCom number, the reply on SIP will be "404 not found". (Use it with public number "*", to reject all undefined numbers).

If no match and no "*" the number will be sent as is to AlphaCom.


'''Explanation of the example file'''
 in ;110;22222900;
* When receiving an incoming SIP trunk call from phone number "22222900", the AlphaCom number 110 will be dialed.
* The “To” field in the SIP Header is changed from 22222900 to 110, and the call is routed to 110. 

 out ;120;22341567;
* When making an outgoing call to the SIP trunk from AlphaCom station 120, the source number will be "22341567"
* It is the “From” field of the SIP Header that is changed from  120 to 22341567,in this waty the Caller ID at the receiving side will be 22341567.

 bi;2563;40002563;
* Incoming calls from phone number "40002563" will be routed to intercom station number "2563". On outgoing calls from intercom station "2563" the source (Caller ID) will be "40002563".

 in ;-;*;
* Incoming calls from other phone numbers than 22341567, 40002563 and 22222900 will be rejected with the SIP response "404 Not found"

 out ;*;40002500;
* For all other stations than 120 and 2563, the source number will be 40002500 for outbound calls.

Other example
 replace  "in ;-;*;" with
 in ;100;*;
For all incoming calls from other than 22341567, 40002563 and 22222900, the call will be routed to AlphaCom number "100"

[[Category:AlphaCom - SIP Integration]]