Importing and Exporting Settings

Last Updated : Mar 08, 2023 |
Prolog information
Resource Id: ImportSettings:32023
Resource Id: ExportSettings:32025
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 theapplication folder.

Exporting Settings

  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.
    ADDITIONAL INFORMATION:
    • 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
  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.
    ADDITIONAL INFORMATION:
    • 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.