Mitel Version 5.7 SP1 Importing a range of devices using a .csv file

130 Chapter 6 Configuration
Importing a range of devices using a .csv file
NOTE: Before you attempt to import a device using a .csv file, ensure
• The .csv file contains data for all of the fields required to save a device in YourSite Explorer as detailed
in “Mandatory device fields for .csv imports” on page129.
• If a device requires a dependency to be specified, for example specifying a media server is required in
order to save an agent, the dependency must already exist in YourSite Explorer. The Import Wizard
cannot create new dependencies and will fail if the dependency does not already exist in the
database.
To import a range of devices using a .csv file
1. In YourSite Explorer, under Devices, click the name of the device you will add using a .csv file.
2. Click Import.
3. After Select file type, specify whether the .csv file uses Comma separated values (.csv) or Tab
separated values (.txt).
4. After Select file, click Browse and specify the location of the .csv file.
5. Under Options, specify how the Import Wizard will handle duplicate items.
If duplicates are found:
• Overwrite entries if duplicates are found will use the .csv file as the master and overwrite
duplicate entries in the YourSite database with data in the .csv file.
Employee divisions Name, reporting number N/A
Agents First name, last name, agent login
ID, media server
Failover media server, employee,
real time and reporting, is active
Agent groups Name, reporting number, media
server
Failover media server, real time
and reporting, is active
Queue groups Name, reporting number N/A
Extensions Name, reporting number, media
server
Extension type, failover media
server, real-time license, is active,
cost this extension, notes, is
general business hotdesking
Extension groups Name, reporting number N/A
Extension divisions Name, reporting number N/A
Trunks Name, reporting number, media
server
N/A
Trunk groups Name, reporting number Media server, do not cost calls,
carrier plan, intra switch
DNIS Name, reporting number, media
server
Short abandon, service level,
carrier plan, call type, call rate
DNIS groups Name, reporting number N/A
Account Codes Name, reporting number Use as classification code
Make Busy Reason Codes Name, reporting number N/A
Do Not Disturb Reason Codes Name, reporting number N/A
Teams Name, reporting number N/A
Device Mandatory fields Optional fields