Examples of bulk import and export of user by using the Excel file

Last Updated : Dec 04, 2014 |
Prolog information
Metadata
Keywords:
The following are the credentials of John Miller, a user with two communication profile sets:
  • Login name: johnmiller@avaya.com
  • Name of the default communication profile set: Primary
  • Name of the nondefault communication profile set: secondaryProfile

Example of navigation across Excel worksheets

In the exported file, you can use the hyperlink to navigate across worksheets to access various records for a profile data of a user.
In the CM Endpoint Profile worksheet, the Station Site Data and Buttons columns contain hyperlinks to navigate to the respective worksheets. If the child worksheet, for example, Buttons contains only one record in the worksheet for that user profile, the link points to the corresponding record of the user profile. If the child worksheet contains multiple records for that user profile, the link points to the first record in the list.
Login Name*
...........
Station Site Data
Abbr List
Buttons
johnmiller@avaya.com#Primary
...........
Go to Station Site Data worksheet
Go to Buttons worksheet
In the following Station Site Data worksheet, the link points to the corresponding user profile record of the child worksheet because this child worksheet contains only one record for that user profile.
Login Name*
Room
Jack
Cable
Floor
Building
Headset
Speaker
Mounting
Cord Length
Set Color
johnmiller@avaya.com#Primary
false
false
d
0
The following Buttons worksheet contains multiple records for johnmiller@avaya.com#Primary, the user profile, but the link points to the first record in the list.
Login Name*
Number*
Type*
Data1
Data2
Data3
Data4
Data5
Data6
johnmiller@avaya.com#Primary
1
call-appr
johnmiller@avaya.com#Primary
2
call-appr
johnmiller@avaya.com#Primary
3
call-appr

Example of handling multiple communication profile sets for a user

In the exported Excel file, the system appends the login name with #profileSetName in all worksheets except the Basic and Profile Set worksheets. Appending the profile set name to the login name associates the communication profile set with the user record, for example, jmiller@avaya.com#profileSetName. When you export users in the Excel file, the association is automatic. When you provide data in a blank Excel template that you downloaded for import, you must make the association manually.
Note:
The Profile Set worksheet must contain all communication profile sets of a user, but only one communication profile set can be the default. The Is Default column is set to true only for the default profile.
In the Profile Set worksheet, the two communication profile sets for the user John Miller must contain the following information:
Login Name*
Name*
Is Default*
johnmiller@avaya.com
secondaryProfile
false
johnmiller@avaya.com
Primary
true
If a SIP e164 handle is associated with secondaryProfile of John Miller, the Handle worksheet must contain the following information:
Login Name*
Handle*
Type*
Sub Type
Domain
johnmiller@avaya.com#secondaryProfile
+1123
sip
e164
smgrdev.avaya.com
If a Session Manager communication profile is associated with secondaryProfile of John Miller, the Session Manager Profile worksheet must contain the following information:
Login Name*
Type*
Session Manager
Session Manager
Termination Application Sequence
Origination Application Sequence
Conference Factory Set
Survivability Server
Home Location*
Max. Simultaneous Devices
Block New Registration When Max Active
Enable Disable Call Log
johnmiller@avaya.com#secondaryProfile
Session Manager
sm6
Pune
6
false
true
If a Avaya Breeze® platform communication profile is associated with Primary for John Miller, the CE Profile worksheet must contain the following:
Login Name*
Type*
Service Profile*
johnmiller@avaya.com#Primary
AUS
TempProfile