SIP number translation table (AlphaCom)

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.

SIP settings configuration page

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 to other than 22341567, 40002563 and 22222900 will be sent to AlphaCom number "100"