Developer Documentation Library > Interviewer - Server Admin > User administration > Importing users and roles > Setting up the spreadsheet > Projects
 
Projects
The Projects worksheet assigns roles to projects.
The worksheet must contain two columns called ProjectID and Roles listing the project names and the roles to be assigned to each project. Role names in a list must be separated by semicolons.
The ProjectID field must contain the project’s uppercase ID, not its name. By default, UNICOM Intelligence Interviewer - Server Admin creates projects with the same name and ID, except that the ID is in uppercase.
Example
ProjectID
Roles
SOFTDRINKS
ProjMan;Scriptwriter;CATIsupervisor;CATIinterviewer; Analysis
TRAVEL
ProjMan;Scriptwriter;Analysis
Role assignments for existing projects are added to the current settings. To delete roles from projects, remove the roles manually by using User Administration.
See also
Setting up the spreadsheet