SIP number translation table (AlphaCom)

From ICX-Web or AlphaWeb, 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.

Use case: Direct Dial-In (DDI) (aka Direct Inward Dialing DID), where a series of public phone numbers are routed directly to predefined intercom stations. When an outgoing call is made from an intercom station, one can manipulate the source of the caller (Caller ID) to be the public phone number instead of the intercom station number.

SIP settings configuration page

SIP number translation file

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

The file name must be sip_config.csv

The format of the sip_config.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 "Type"

• "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"

• AlphaCom intercom number

Third column "Public"

• Public phone 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"
• The “From” field of the SIP Header is changed from 120 to 22341567, causing the Caller ID at the receiving side to 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"