Importing and Exporting Settings

Last Updated : Mar 08, 2023 |

Manager can import configuration settings created elsewhere. This can be useful when setting up a new system or sharing common settings such as a directory between systems.

Settings are imported and exported in the following formats:

File Type

Description

Binary Files (.exp)

These are non-editable files. During export, it is possible to select what types of records are included in the file. During import, the whole file is imported. The types of records supported are:

  • ARS, Control Unit, Extension, Firewall Profile, Group, Incoming Call Route, Line, RAS, System Short Codes, Users, User Rights, Account Codes, Authorization Codes, Auto-Attendants, Conferences, Directory, IP Route, License, Location, Logical LAN, RAS Location Request, Service, Time Profile, Tunnel, WAN Port.

Comma Separated Variable Text Files (.csv)

These are editable plain text files. The types of records supported are:

  • Groups, Users, Directory, System Short Codes, Licenses (ADI only), Full Configuration.

  • Only key values for the records selected are included. See the table below for details.

CSV File Format

The format is CSV using commas as field separator, no text delimiters and no header row. The simplest way to check the required format for a CSV file before import, is to export a file from an existing system configuration.

  • UTF-8 Character Encoding

    Manager imports and exports CSV files using UTF-8 character encoding which uses a multiple bytes to support characters with diacritic marks such as ä. Other applications, such as Excel, may, depending on the user PC settings, use different encoding which will cause such characters to be removed or corrupted. Care should be taken to ensure that any tool used to create or edit the CSV supports all the characters expected and uses UTF-8 format.

File Name

Fields in Order

Configuration

The format of this CSV is too complex to be described. This file format should only be used for export and import between systems and not for any offline editing.

License

This option is only available for export and only for ADI licenses present on the system.

Short Code

Code, Telephone Number, Feature.

User

Name, Extension, User Rights, Email Address, Full Name, Password, VoiceMail Code, Login Code, User Template, Extension Template.

Directory

Name, Number, Speed Dial.

Group

Name, Extension, Group, Hunt, Rotary, Longest Waiting, Queuing On, Voicemail On, Broadcast, Voicemail Email.

  • Apart from the Name, Extension and Voicemail Email fields, all other fields use a 1 or 0 value for on or off.

Excel Notes

When opening a .csv file in Excel, it will alter the way some data is displayed, for example automatically changing the display format of dates and long numbers such as phone numbers. Therefore it is important to use the following steps when using Excel.

  • Importing into Manager from Excel From Excel, save the file as a .csv. This file will use ANSI character encoding. Open the file in Notepad and use the Save As option to rename the file and select UTF-8 encoding. Import the UTF-8 version of the file into Manager.

  • Exporting from Manager into Excel Do not double-click on the file exported from Manager. Start Excel and use File | Open to select the file. Excel will recognize that the file uses UTF-8 encoding and will start its text file importation wizard. Follow the wizard instructions and select comma as the field delimiter.

Using the CSV Configurator spreadsheet

You can use the CSV Configurator spreadsheet to create or modify multiple configuration entries. The CSV Configurator spreadsheet IP Office User CSV Configurator.xlsm is available in the IP Office Manager application folder.

Exporting Settings

Procedure

  1. Select File | Import/Export... from the menu bar.
  2. Select Export.
  3. Select the type of file. The list of exportable record types will change to match the file type.
  4. Select the types of items that should be exported.
  5. Use the Save In path to select the location for the exported files.

    • The default location used is a sub-folder in the Manager application directory based on system name of the currently loaded system. For example, ...\Avaya\IP Office\Manager\System_1.

  6. Click OK.

Importing Settings

Importing settings will overwrite any existing records that match a record being imported

Procedure

  1. Select File | Import/Export... from the menu bar.
  2. Select Import.
  3. Select the type of file. The list of items will change to match the type of file selected and whether a matching file or files is found in the current file path.
  4. Use Look In to adjust the file path.

    • The default location used is a sub-folder in the Manager application directory based on system name of the currently loaded system. For example, ...\Avaya\IP Office\Manager\System_1.

  5. Select the types of items that should be imported.
  6. Click OK.