*To import extensions on Switchvox Version 6.4 or higher, go HERE

Import Extensions

The Import Extensions tool lets you create and update multiple SIP or Virtual extensions from data in an imported CSV file. To do this, you need to create an Extension File that is formatted correctly with specific extension information. Then, you can use the Import Extension tool to identify that file, evaluate the extensions that will be created or modified, and perform the import.

The Import Extensions File

• The first line of the file must be a header line that labels each column. Each subsequent line should be an extension line that contains the values of an extension.
• Depending on the type of extensions you are working with (SIP or Virtual) different information is required or accepted. You can use a file that has additional columns of information (Switchvox ignores this information) as long as the required extension information is included correctly, The order of the labels in the header is not important, but the values of each extension must match the order of the labels.
• If you are working with SIP extensions, the value of phone_password cannot be the same as extension.
• If you are updating an existing extension and you have some information that you do not want to change, use just the comma with no spaces or text. If you want to make it blank, put a space in that column.
• When your Extension File is ready, go to Setup > Extensions > Manage and click Import Extensions (see “Import Options”).

File Information

This table describes the data for each type of import:

NA=NOT USED

File Examples

SIP Extension File

ext,fname,lname,email,password,phone_password,mac_address
100,Joe,Smith,jsmith@home.com,100,s3CurEp@S$,0019159C0646
101,Jane,Doe,jdoe@home.com,101,c@nT6ueSS,0013174C5532
102,Dan,Jackson,djackson@home.com,102,g0ODP@$$,

Virtual Extension File with location and other information

fname,lname,email,dept,ext,password,location
Joe,Smith,jsmith@home.com,sales,100,100,3A
Jane,Doe,jdoe@home.com,sales,101,101,3B
Dan,Jackson,djackson@home.com,facilities,102,102,9A

SIP Extension Updates File without passwords with a location

ext,fname,lname,email,password,phone_password,location
100,Joe,Smith,jsmith@home.com,,,2A
101,Jane,Doe,jdoe@home.com,,,3B
102,Dan,Jackson,djackson@home.com,,,2C

Import Options

The Import Extensions options determine how to manage this import. When the settings are correct, click Evaluate Import to evaluate the Extension File and to see what will happen if you import the file.

Extension File. Browse your machine to find your Extension File. For details about creating this file, see The Import Extensions.

Extension Type. This is the extension type that is used for all of the extensions that are created.

Extension Template. This is the Extension Template that is used to create or update all of the extensions. All of the values in the template are used for each of the extensions in the Extension File.

On Duplicate Extension. This option specifies how to respond when an extension in the Extension File already exists on the system.

Skip: Do nothing with the extension data in the file, and skip to the next extension in the file.

Delete and Recreate: Delete the existing extension in the system, then create the extension with the values from the file and the chosen extension template. NOTE: only SIP, Analog and Virtual extensions are affected by this. For example, if you have a Call Queue extension of 333 and have a line in your file to create an extension of 333, this line in the file is skipped even if you have Delete and Recreate chosen.

Update Information: Update the existing extension with the values from the file and the chosen extension template. NOTE: the update is only applied if the extension types are the same. For example, if you have an existing Virtual extension of 100 and have a line in your file to create a SIP extension of 100, this line in the file is skipped even if you have Update Information chosen.

Import Extensions Evaluation

When you click Evaluate Import, Switchvox opens your Extension File and evaluates it against the extensions that already exist.

The results are shown with how many extensions will be created, how many are duplicates, what will be done with those duplicates, and how many are invalid and cannot be created.

If you have invalid extensions, check your Extension File for formatting problems or errors. Be sure your extension numbers are the same length as specified in Setup > Extensions > Settings.

If you want to proceed with the import, click Yes, Process Extensions.

rel60