User's Manual
Avaya Branch Gateway Manager 10.0 Page 52
15-601011 Issue 29r (Friday, November 02, 2012)B5800 Branch Gateway
2.12.10 Importing and Exporting Settings
Branch Gateway 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.
· The system supports LDAP (System | Directory Services | LDAP ) for automatic importation of directory
records (LDAP Version 2).
· The system also supports HTTP (System | Directory Services HTTP ) for automatic importation of directory
records.
Settings are imported and exported in the following formats:
· Binary Files (.exp)
These are non-editable files. During import and export it is possible to select what types of records should be
included in the file. During import the whole file is imported.
· Comma Separated Variable Text Files (.csv)
These are plain text files. In addition to being exported from a system these files can be created and edited using
programs such as WordPad or Excel.
· When opening a .csv file in Excel it will alter the way some data is displayed, automatically changing the
display format of dates and long numbers such as phone numbers.
· UTF-8 Character Encoding
Branch Gateway 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.
· Importing into Branch Gateway 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 Branch Gateway Manager.
· Exporting from Branch Gateway Manager into Excel
Do not double-click on the file exported from Branch Gateway 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.
CSV File Formats
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 prior to import, is to export and a file from an existing system configuration.
File Name
Fields in Order
Directory
Name, Number.
Hunt Group
Name, Extension, Group, Hunt, Rotary, Longest Waiting, Queuing On, Voicemail On, Broadcast,
Voicemail Email.
Short Code
Code, Telephone Number, Feature.
User
Name, Extension, User Restriction/Rights, Voicemail Email address, Full Name.
Configuration
Proprietary format. Note that this does not contain all configuration fields.
Notes:
· Hunt Group: Apart from Name, Extension and Voicemail Email, the fields use a 1 or 0 value for on or off.
· The format of the system CSV is too complex to be described. It is a full export of all the system's configuration
settings. This file format should only be used for export and import between systems and not for any offline editing.
171 171
174 174