Skip to content Skip to content

24/7 support from the USA, India and the Philippines +1 801 642 4655

CFD TOOL (call routing) Configuration

Updated 4 min read
On this page

Introduction

The 3CX Custom Call Router CFD is an indispensable tool within the 3CX system, tailored to optimize call handling. Users employ this solution to efficiently direct incoming calls, personalize call experiences based on numbers or area codes, and enhance customer service by swiftly connecting callers to the right agents. Its role in streamlining communication processes, reducing wait times, and ensuring calls reach their intended destinations promptly makes it a crucial asset for maximizing productivity and delivering exceptional service.

Overview of the Procedure:

Configure Default TablesCreate 3CX Custom Call Router CFD in SQL Server Management Studio, allowing table editing and automated ID generation.
Assign Custom CFD to an Inbound RuleConfigure 3CX Console Management for inbound calls by setting up rules directing calls to the Custom CallRouter during and after office hours for efficient call flow management.

Step 1: Configure Default Tables

  1. Log in to Microsoft SQL Server Management Studio with your credentials.
  2. In the Object Explorer Panel, expand the 3CX Custom Call Router CFD dropdown.
Figure 1: Object Explorer Pane – 3CX Custom Call Router CFD
  1. Expand the Tables folder to view the default tables.
Figure 2: Expanding Tables
  1. Right-click the dbo. Agent Routing option and select Edit Top 200 Rows option.
  2. Enter the details in the Contact Phone and Agent Extension fields. The script generates ID automatically.
    • Contact Phone is the
    • Agent Extension is the
Figure 3: Agent Routing Table
  1. Right-click the dbo. Area Code option and select Edit Top 200 Rows option.
  2. Enter the details in the Area Code and Route Extension fields. The script generates ID automatically.
    • Area Code is the
    • Route Extension is the
Figure 4: Area Code Table

NOTE:

If you have more than 200 records, then you need to update  or insert records using the SQL command. Click here to know the procedure.

Step 2: Assign Custom CFD to an Inbound Rule

  1. Open the 3CX Console Management. In the Left Side Panel select the Inbound Rule menu.
Figure 5: 3CX – Left Side Panel – Inbound Rules
  1. Select the desired inbound rule number to add the custom CFD.
Figure 6: Selecting an Inbound Rule
  1. In the Route Calls To section, do the following tasks,
    1. In the Destination For Calls During Office Hours dropdown, select the Send Calls To Call Flow Apps option and in the File Selection dropdown, select the Custom_Callrouter.Main option.
    2. In the Destination For Calls After Office Hours dropdown, select the Send Calls To Call Flow Apps option, and in the File Selection dropdown, select the Custom_Callrouter.Main option.
Figure 7: Route Calls To section Modified
  1. Scroll up and click the OK button to save your changes.
Figure 8: OK Button

You can view the custom CFD in the Inbound Rules screen.

Figure 9: Custom CFD Added to Inbound Rule Number

Database Update Procedure

If you have more than 200 records, follow the procedure,

  1. Copy and paste the following command to insert data into the table “AgentRouting” table with a phone number ‘1234567890’ and agent extension ‘1234’.
USE [3CX Custom Call Router CFD]
GO
 
INSERT INTO [dbo].[AgentRouting]
           ([ContactPhone]
           ,[AgentExtension])
     VALUES
           ('1234567890'
           ,'1234')
GO
  1. Copy and paste the following command to insert data into the ‘AreaCode‘ table. This command adds a record with the area code ‘911’ and its corresponding route extension ‘1000’.
USE [3CX Custom Call Router CFD]
GO
 
INSERT INTO [dbo].[AreaCode]
           ([AreaCode]
           ,[RouteExtension])
     VALUES
           ('911'
           ,'1000')
GO
  1. Copy and paste the following command to modify the ‘AgentRouting’ table. The command updates the contact phone to ‘12345021’ and the agent extension to ‘1111’ where the ID is 1.
USE [3CX Custom Call Router CFD]
GO
 
UPDATE [dbo].[AgentRouting]
   SET [ContactPhone] = '12345021'
      ,[AgentExtension] = '1111'
WHERE Id=1
GO
  1. Copy and paste the following command to adjust the ‘AreaCode’ table. This command modifies the area code to ‘112’ and its corresponding route extension to ‘2142’ where the ID is 3.
USE [3CX Custom Call Router CFD]
GO
 
UPDATE [dbo].[AreaCode]
   SET [AreaCode] = '112'
      ,[RouteExtension] = '2142'
WHERE Id=3
GO

Still stuck? Our team can help, 24/7.

Support from the USA, India and the Philippines, by email, phone or live chat.