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 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 external trunk calls "22222900", the AlphaCom number 110 will be dialed.

out ;120;22341567;

When AlphaCom station calls out on SIP trunk the source number will be "22341567"

bi;2563;40002563;

When incoming call dials "40002563" the AlphaCom number will be "2563", if "2563" calls out on SIP trunk the source will be "40002563".

in ;-;*;

If incoming call to other than 22341567, 40002564 and 22222900 the call will be rejected with 404_not_found

out ;*;40002500;

For all other station 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, 40002564 and 22222900 will be sent to AlphaCom number "100"