Importing Extensions in Bulk - CSV File Structure

Importing Extensions in Bulk - CSV File Structure

You can import extensions in bulk by creating a CSV (Comma Separated Values) file specifying all the options to be imported:

  1. Download the 3CX Phone System CSV sample file.
  2. The position of the column must remain as is. The comma delimited file provides the structure of the columns and their names in the first row. The subsequent rows contain  example entries that you need to modify to create extensions with provisioning.
  3. When you have created the CSV, log in to the 3CX Management Console and go to Users > Import > Import CSV.
  4. Browse and select your extension CSV file and click on Open to import your extension(s) into 3CX.

This table describes the available fields and requirements: 

FIELD NAME

DESCRIPTION

VALUE

Number

Extension Number

Required - numeric values only

FirstName

First Name

Alphanumeric

LastName

Last Name

Alphanumeric

EmailAddress

Email Address

Aphanumeric

MobileNumber

Mobile Number

Numeric values only

AuthID

SIP Authentication ID

Required - aphanumeric

AuthPassword

SIP Authentication Password

Required - aphanumeric

WebMeetingFriendlyName

Webmeeting Friendly Name

Extension MUST have an email address and Name. This will be the alphanumeric ID for the webmeeting URL for this extension.

WebMeetingPrivateRoom

Create new room for each participant

0 – Generate new room for each new anonymous participant

1 – Shared room for all anonymous participants

ClickToCall

Set ClickToCall option for this extension

0 - Disable ClickToCall

1 - Enable ClickToCall

ClickToCallFriendlyName

ClickToCall Friendly Name

Unique alphanumeric string, without spaces.

Example:

CallMe

WebMeetingAcceptReject

Moderate participants

0 – Disable Moderate participants

1 – Enable Moderate participants

EnableVoicemail

Enable Voice Mail Box for this extension

0 – Voicemail is disabled

1 – Voicemail is enabled

VMNoPin

Disable Voicemail PIN authentication

0 – Pin Authentication for voicemail is disabled

1 – Pin Authentication for voicemail is enabled

VMPlayCallerID

Play Caller ID

0 – Do not play Caller ID

1 – Play Caller ID

PIN

PIN number used to access voicemail box

Numeric

VMPlayMsgDateTime

Read out date/time of message

0 – Do not read Date/Time of message

1 – Read in AM/PM Format

2 – Read in 24hr format

VMEmailOptions

Email options

0 – No email notification is generated when the extension receives voicemail

1 – Email notification is sent

2 – Email Notification with voicemail attached will be sent.

3 – Email notification with vmail attached will be sent and vmail file will be deleted from the server.

QueueStatus

Queue status

0 – Logged out of Queues

1 – Logged in Queues

OutboundCallerID

Outbound Caller ID

Alphanumeric – Configures the Outbound Caller ID for the extension

SIPID

SIP ID

Alphanumeric – Configures the SIP ID for the extension

DeliverAudio

PBX delivers Audio

0 – PBX does not deliver audio

1 – PBX delivers audio

SupportReinvite

Supports Re-invite

0 – Reinvites not supported

1 – Reinvites supported

SupportReplaces

Support Replaces header

0 – Does not support Replaces Header

1 – Supports Replaces Header

EnableSRTP

Switch on Secure RTP (SRTP)

0 – Disabled

1 – Secure SRTP on

ManagementAccess

Allow 3CX Management Console Access

0 – 3CX Management Console access not allowed

1 – 3CX Management Console access enabled + user can manage his own Extension

2 – 3CX Management Console access enabled + User is set as Group / Department manager (can manage the extensions of the groups he is a member of)

3 – 3CX Management Console access enabled + user is set as a Global Extension Manager (can manage all user extensions on the System)

ReporterAccess

Allow 3CX Web Reports Access

0 – 3CX Reports access not allowed

1 – 3CX Reports access enabled

WallboardAccess

Allow 3CX Wallboard Access

0 – 3CX Wallboard access not allowed

1- 3CX Wallboard access enabled

TurnOffMyPhone

Disallow use of 3CXPhone

0 – 3CX app use is enabled

1 – 3CX app use is disabled

HideFWrules

Hide Forwarding Rules

0 – Forwarding Rules tab enabled in the 3CX app

1 – Forwarding Rules tab disabled in the 3CX app

CanSeeRecordings

Show Call Recordings

0 – Call recordings not shown to the user

1 – Call recordings shown to the user

CanDeleteRecordings

Allow deletion of recordings

0 – Does not allow the deletion of recordings by the user

1 – Allows deletion of recordings by the user

RecordCalls

Record all calls

0 – Do not record all calls

1 – Record all calls for this extension

CallScreening

Call screening ON

0 – No Call Screening

1 – Enable Call Screening

EmailMissedCalls

Send email notification on missed call

0 – Do not send email notification on missed call

1 – Send email notification on missed call

Disabled

Disable Extension

0 – Extension is enabled

1 – Extension is disabled

DisableExternalCalls

Disable External Calls

0 – External calls enabled

1 – External calls disabled

AllowLanOnly

Disallow the use of extension outside the LAN

0 – Use of extension outside LAN is enabled

1 – Use of extension outside LAN is disabled

BlockRemoteTunnel

Block Remote Tunnel Connections

0 – Remote tunnel connections enabled

1 – Remote tunnel connections disabled

PinProtect

Pin Protect

Numeric value in seconds – user has to type a pin to allow external calls in the time allocated

MAC_0

MAC Address of the first provisioned phone.

Alphanumeric hexadecimal string without spaces or dashes.

InterfaceIP_0

Select Interface

3CX Phone System IP address

UseTunnel

Use 3CX Tunnel for Remote Connections (3CX app only)

0 – Do not use tunnel for Remote Connections

1 – Use tunnel for Remote Connections

DND

DND

0 – Do Not Disturb off

1 – Do Not Disturb on

UseCTI

Configure default phone to use in 3CX Phone for windows

empty – default phone to use in 3CX app for windows not specified

0 – Use Inbuilt Softphone

1 – use IP Phone via CTI

StartupScreen

Default Startup Screen

0 – Dialpad as Start up screen

1 – Presence screen as Start up screen

HotelModuleAccess

Allow 3CX Hotel Module Access

0 – Extension cannot access 3CX Hotel module

1 – Extension can access 3CX Hotel module

DontShowExtInPHBK

Do not show Extension in 3CX Company phonebook

0 – Extension is shown in 3CX Company Phonebook

1 – Extension is not shown in 3CX Company Phonebook

DeskphoneWebPass

Phone Web Page Password

Required - alphanumeric password used to access the IP Phone’s web configuration pages.

SrvcAccessPwd

Access password for 3CX Web Services

Alphanumeric – this is the password used to access the 3CX Web services (3CX Management Console)

VoipAdmin

Voip Trunk Administrator

0 – User is not allowed to manage VoIP Gateways, VoIP Providers and 3CX Phone System Bridges

1 – User is allowed to manage VoIP Gateways, VoIP Providers and 3CX Phone System Bridges

SysAdmin

System Administrator

0 – User is allowed to modify System Extensions (Queues, Ring groups, Digital Receptionists), change System Settings and perform 3CX Phone System Updates

1 – User is not allowed to modify System Extensions (Queues, Ring groups, Digital Receptionists), change System Settings and perform 3CX Phone System Updates

SecureSIP

Enable Secure SIP (TLS)

0 – Secure SIP is not enabled for this user

1 – Secure SIP is enabled for this user

PhoneModel14

Phone Model name

Model of the first provisioned phone

PhoneTemplate14

Template used by the  IP phone for provisioning

Template file name

CustomTemplate

Custom template used for Hardpphone provisioning

Custom template file name

PhoneSettings

Custom Settings of Phone from extension

Custom settings of the first provisioned phone will be shown in the following format:

<PhoneDevice ProvType="0" PhoneLanguage="English" XferType="BXfer" RingTone="Ring 1" DateFormat="WWW MMM DD (Mon Jan 15)" TimeFormat="24-hour clock"

AllowAllRecordings

Ability to download All Recordings

0 – Not allowed to download all recordings

1 – Allowed to download all recordings

PushExtension

Enable Push for Smartphones

0 – Push notifications disabled

1 – Push notifications enabled

Integration

Enable Integration for the Extension with 3CX Plugins (Legacy)

Empty – Disable Integration. To enable Integration you need to set specific plugin . For example

salesforce.zip
. To find out the correct name for your plugin, download the plugin that you need and then go to Settings > CRM Integration in Management Console to see the file name of the plugin.

AllowOwnRecordings

Enables the user to start and stop call recording

0 – Disallow user to control call recording

1 – Allow user to control call recording

RecordExternalCallsOnly

Enables recording only for external calls

0 – Disable external calls only  recording mode

1 – Enable external calls only recording mode

DID

List of DIDs assigned to the extension, separated by colon (:)

Example:

36912:*123963321:*961235469

⚠ Important: If using Microsoft Office to open CSV files, take care that the

MAC_0

MAC address column is NOT presented as a number. To fix, right-click on the MAC address column, select “Format Cells…” and choose text.

Alternatively, you can create at least one extension, then export your extensions to a CSV file containing the columns required. You can then populate this .csv file with your users, and use the method described above to import it into 3CX.

📄 Notes:

  • Rows describing existing 3CX extensions are skipped.
  • Provisioning information is generated if the filename is identical to the model names included in the template.
  • Provisioning information is not generated if the IP address interface field does not match a valid IP from which the phone requests the provisioning file. This entry must match one of the entries in the Users > Select a user > Phone Provisioning tab > Select Interface list.
    • Related Articles

    • Set Office Hours

      Configure Office hours You probably don't want calls to ring your mobile in the middle of the night. Thank God for the office hours function then. Here you can configure when your business is open and when you are on break and then route your calls ...
    • How to Install Multi-Line TAPI

      To install the 3CX Multi-Line TAPI for use with your 3CX Desktop App follow the instructions below. Download the installer from here or login to your 3CX Desktop App and go to Settings >> Integration. Run the installer. Specify the extension numbers ...
    • How to Upgrade to V20

      On this topic: Prerequisites Make sure you have 2 gig Ram and 2 vCPU. Check you have Split DNS configured. Read how to configure Split DNS Step 1 - Assign a System Owner This System Owner account will be used to login to the Admin Console! Ensure the ...
    • Configure Your Office Hours

      Introduction The office hours function allows you to handle calls differently based on the time of day. Office hours are configured at department level and any extensions or system extensions such as an IVR that are part of that department will ...
    • Record Voicemail Greetings

      Voicemail Greetings In the “Web Client or Dekstop App > Settings” section, you can Record or Upload your Voicemail Greetings as well as Download or listen to your VM greetings. Record your Voicemail Greetings Go to your WebClient/Dekstop App Settings ...