Create Routing Called Number Manipulation Rules

The RoutingCalledNumberManipulation.txt file created by the exportForIntraStateCalls.sql script is configured for the ‘default’ account as a global set of rules that will apply for all accounts that do not have routing called number manipulation rules. If the rules should apply to a specific account, edit the text file to replace the default account with the desired account name.

The following example illustrates how the vi text editor in Linux is used to globally replace the ‘default’ account name with the ‘Customer-A’ account name.

[ossadmin@linux-lab MY_SQL]$ vi RoutingCalledNumberManipulation.txt
default 1251    334     MON-00:00       ##1251r Intra-AL
default 1251    938     MON-00:00       ##1251r Intra-AL
default 1256    205     MON-00:00       ##1256r Intra-AL
default 1256    251     MON-00:00       ##1256r Intra-AL
default 1256    256     MON-00:00       ##1256r Intra-AL
:%s/default/Customer-A/g

Use the following command to verify the change was successful.

[ossadmin@linux-lab MY_SQL]$ head RoutingCalledNumberManipulation.txt
Customer-A 1907    907     MON-00:00       ##1907r Intra-AK
Customer-A 1205    205     MON-00:00       ##1205r Intra-AL
Customer-A 1205    251     MON-00:00       ##1205r Intra-AL
Customer-A 1205    256     MON-00:00       ##1205r Intra-AL
Customer-A 1205    334     MON-00:00       ##1205r Intra-AL
Customer-A 1205    938     MON-00:00       ##1205r Intra-AL
Customer-A 1251    205     MON-00:00       ##1251r Intra-AL
Customer-A 1251    251     MON-00:00       ##1251r Intra-AL
Customer-A 1251    256     MON-00:00       ##1251r Intra-AL
Customer-A 1251    334     MON-00:00       ##1251r Intra-AL
[ossadmin@linux-lab MY_SQL]$