Difference between revisions of "SIP number translation table (AlphaCom)"
From Zenitel Wiki
(→SIP number translation file) |
|||
| Line 6: | Line 6: | ||
The CSV file can be uploaded, edited and saved from Excel. | The CSV file can be uploaded, edited and saved from Excel. | ||
| − | .CSV file | + | '''.CSV file''' |
Number translation;;; | Number translation;;; | ||
| Line 22: | Line 22: | ||
| − | First column | + | '''First column''' |
*"in" Translation used for incoming calls, the destination number will be matched with "Public" and replaced with "AlphaCom" number. | *"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". | *"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. | *"bi" Translation used for both incoming and outgoing with the above rules. | ||
| − | Second column | + | '''Second column''' |
*AlphaCom number | *AlphaCom number | ||
| − | Third column | + | '''Third column''' |
*Public number | *Public number | ||
| − | Special characters | + | '''Special characters''' |
'*' If no match found use this entry (Can only be used for "in" or "out" not for "bi") | '*' 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). | '-' 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). | ||
| Line 40: | Line 40: | ||
| − | Explanation of the example file | + | '''Explanation of the example file''' |
in ;110;22222900; | in ;110;22222900; | ||
When external trunk calls "22222900", the AlphaCom number 110 will be dialed. | When external trunk calls "22222900", the AlphaCom number 110 will be dialed. | ||
Revision as of 11:19, 31 May 2018
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"