Developer Documentation Library > Interviewer - Server Admin > User administration > Importing users and roles > Setting up the spreadsheet > UserProperties
 
UserProperties
The UserProperties worksheet contains the property settings for each user.
The worksheet must contain one column listing user names, and then as many columns as there are role and property combinations to set. Each property column for a role refers to one property in one property group and contains an appropriate value for that property (for example, true/false for a boolean property or a list of categorical values for a categorical property). The first column contains values for Role1:PropertyGroup1:Property1; the second column contains values for Role1:PropertyGroup1:Property2, and so on. If a property does not apply to a user, leave that cell of the worksheet blank.
If a user already has user properties set, the settings in the spreadsheet are added to the existing settings. If you want to change or delete settings you must do so manually.
Example
UserName
ProjMan:PGroup1: Prop1
ProjMan:PGroup1: Prop2
Scriptwriter:PGroup1: Prop1
Scriptwriter:PGroup1: Prop2
benjamin
english;french;german
true
 
 
jose
english;spanish
 
value1;value2
 
See also
Setting up the spreadsheet