‘User Import’- Fields and required formats

The table below shows all available fields and the required format for ‘User Import’

* = Mandatory field

** = Mandatory field if you are using single sign-on

Fields Description Format Example
GUID* This is the unique identifier for each user String b1d084c4
Username* We recommend using the email address here if you do not have a current set of usernames String laura.marling@invotra.com
email* The email address of the user. Email laura.marling@invotra.com
ForeName The person’s first name String Laura
Surname The person’s last name String Marling
role ID The unique identifier of the person’s job role. This must reference an existing job role in the system String job role-1234
Grades      
Birthday      
Phone Work phone number of the person String 01234567891
Mobile Mobile phone number of the person String 01987654321
Linkedin Link to the person’s LinkedIn profile URL https://www.linkedin.com/in/lauramarling/
Facebook Link to the person’s Facebook profile URL https://www.facebook.com/laura.marling
Twitter Link to the person’s Twitter profile URL https://twitter.com/LauraMarling
LocationID The unique identifier of the person’s location. This must reference an existing location in the system String location-1234
Organisational ID A field to store an organisational identifier such as a staff number String abc1234
Org unit ID The unique identifier of the person’s team. This must reference an existing team in the system String team-1234
Role       
ImageUrl      
Manager The unique identifier (GUID) of the person’s manager. This must reference an existing user in the system. This will be used to build the Org Chart on the site String b1d086bg
Authname** The unique string used for SSO (in most cases this will be the same as the value used for GUID) String Could be anything
Status      
Hide email      
Hide phone      

Here’s an example of a User Import CSV file with SSO disabled

Here’s an example of a User Import CSV file with SSO enabled