How can I import DID’s into the 3CX Phone System?
3CX administrators need to plan ahead on how to setup their 3CX Phone System. Businesses now utilize multiple trunks and VoIP providers with multiple DID numbers and it can be very time consuming to create DID rules manually for each DID number. With 3CX Phone System 12 you can create your DID Inbound Rules in minutes in a .csv file and import it into 3CX Phone System 14.
Create DID Import File Using the Sample
Download the above sample file and create your PBX configuration to your specifications. Each column is hard-coded in the 3CX Import DID function and the position of the column must remain as is. The comma delimited file provides the structure of the columns and how they should be named in Row 1, 2, 3, 4 and 5 contain examples which will create DIDs in your 3CX Phone System 14. Open the sample file in Excel and then modify it according to your specifications and needs. You may then import the DID file back into 3CX Phone System by:
- Logging into the 3CX Management Console.
- Click on the Inbound Rules node.
- Click on Import and then browse for the DID import file.
- Click Open and the DID rules will be imported into your 3CX Phone system 14.
Creating the import file Without Using the Sample
To create the DID import file from scratch use Excel and the values shown at the at the template table below, without any errors. If errors are made, the the import will fail. Any PORTS that the administrator declares must be pre-created before DID import. Any extensions and queues declared must also be present on the 3CX Phone System before the DID import. Also if declarations are wrong such as specifying as queue the number 100 while 100 is an extension and not a queue, this will cause errors. Declaring a time which is not correct, will also cause the import to skip the whole rule, so the administrator needs to be extremely careful when creating the DID import file from scratch.
The table below explains the field requirements and options for 3CX Phone System Version 12 DID import.
|PRIORITY||Priority of rule in numeric format||1,2,3,4||Rule priority (numeric)|
|NAME||Inbound Rule Name||Sales,German Support (Alphanumeric)||Name of the inbound rule|
|TYPE||Inbound Rule Type||1, 2||1=DID MASK
|PORTS||INSERT THE PORTS that you want to create DID’s for in [ ]||]||[PORT NUMBER aka VIRTUAL EXTENSION NUMBER|
|INOFFICE_DEST_TYPE||Destination where in office calls will be forwarded to||1, 2, 3, 4, 5, 6, 7||0=END CALL
1=CONNECT TO VOICEMAIL
2=CONNECT TO EXTENSION
3=CONNECT TO QUEUE
4=CONNECT TO RING GROUP
5=CONNECT TO IVR
6=CONNECT TO EXTERNAL NUMBERr
7=CONNECT TO FA
|INOFFICE_DEST_NUMBER||Destination routing – depends on in office type||EXTENSION NUMBER FOR EXAMPLE: 100 or 1000
RING GROUP NUMBER
FAX EXTENSION NUMBER
|SAME_DEST_AS_INOFFICE||Apply same routing logic outside of office hours||0=UNCHECKED
|IF SAME_DEST_AS_INOFFICE = 1, SKIP IMPORTING OF “OUTOFOFFICE_DEST_TYPE” + “OUTOFOFFICE_DEST_NUMBER” + “SPECIFIC_HOURS” + “SPECIFIC_HOURS_TIME” + “INCLUDE_HOLIDAYS”|
|SPECIFIC_HOURS||Specific office hours||0=UNCHECKED
|IF SAME AS OUT OF OFFICE IS UNCHECKED WE CAN CONFIGURE SPECIFIC OFFICE HOURS
If SPECIFIC_HOURS = 1, YOU CAN ALLOW IMPORTING OF “INCLUDE_HOLIDAYS” ELSE (IF SPECIFIC_HOURS = 0, SKIP”INCLUDE_HOLIDAYS”
|SPECIFIC_HOURS_TIME||DATE:TIME in 24 hour format with each time entry in [ ]||[MON:08:00-10:00][MON:13:00-13:30][MON:16:00-17:30][WED:08:00-17.30]||[DDD:HH:MM-HH:MM]|
|INCLUDE_HOLIDAYS||Include holidays option||0=UNCHECKED
|IF INCLUDE_HOLIDAYS = 1, SKIP IMPORTING OF “PLAY_HOLIDAY_PROMPT”|
|OUTOFOFFICE_DEST_TYPE||Destination where out of office calls will be forwarded to||Depends on “Same as out of office”||IF “SAME_DEST_AS_INOFFICE” = 1 (checked) then you skip importing “OUTOFOFFICE_DEST_TYPE” + “OUTOFOFFICE_DEST_NUMBER”|
|OUTOFOFFICE_DEST_NUMBER||Same as IN OFFICE DESTINATION NUMBER||QUEUE NUMBER
RING GROUP NUMBER
FAX EXTENSION NUMBER
|PLAY_HOLIDAY_PROMPT||Play Holiday prompt on public holiday||0=UNCHECKED
Important: the import file needs to be a .CSV file. Any other file format (.doc, .txt etc) will not be accepted for import.