Server User Guides > Interviewer - Server Admin > User administration > Importing users and roles > Setting up the spreadsheet > Users
 
Users
Identifies the users to be added to UNICOM Intelligence Interviewer - Server Admin.
The worksheet can include the following columns but only the UserName column is mandatory:
UserName - lists the users you want to add
Description - can be up to 250 characters long
Roles - lists the roles of which each user is a member. If the user is a member of more than one role, the names must be separated by semicolons.
MustChangePasswordAtNextLogin - controls whether imported users must change their passwords at the next login (True or False)
Action - has three options: Disable/D (disable an existing user), Remove/R (remove an existing user), Add/A (add a new user)
Position - indicates the interviewer's position in the telephone room (seat number, for instance)
For example:
UserName
Position
Description
Password
Roles
MustChangePasswordAtNextLogin
Action
benjamin
1
Benjamin Brown
Rabb1ts4
ProjMan; Scriptwriter; Analysis
False
Add (or A)
jose
2
Jose Mendoza
J6KT57SY
Scriptwriter
True
Disable (or D)
davinder
3
Davinder Patel
Pandora99
Analysis
True
Remove (or R)
Notes
See also Password policy.
Set MustChangePasswordAtNextLogin column to True for newly imported users or when the password is reset by the administrator.
Password definitions apply only to new accounts that are created by the import process. Passwords are never changed or removed for existing users even if the password column contains a value. However, when the MustChangePasswordAtNextLogin is set to True for existing users in the Excel spreadsheet, those users must change their passwords the next time they login. Typically users cannot change their password unless they have administrator authority; when MustChangePasswordAtNextLogin is set to True, users can change their password regardless of administrator status. By default, all imported users are required to change their passwords at next login.
If the Action column is not defined in the spreadsheet, the user records are processed as normal. This means that when the user exists in user database, the user description and role assignment are updated. Otherwise the user is added to the user database.
The Position column is required when using the UNICOM Intelligence Interviewer Load Tool Logins interface.
When MustChangePasswordAtNextLogin is not defined in the Excel spreadsheet, the default value is False.
If you import an existing user, the description in the spreadsheet overwrites the existing one in the UNICOM Intelligence Interviewer - Server Admin database. If roles are specified, the user is added to these roles if they are not already a member; for example, specifying the Manager2 role for a user who is already a member of the Manager1 role makes that user a member of both roles. Leaving the role column blank does not remove the user from the roles to which he/she currently belongs: you must do this manually.
See also
Setting up the spreadsheet