‘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