Page Comparison

Import

You are able to Import new Users or Manage user information by using the Import functionality. You can use either the Import Template or the output from an Export (Excel Worksheets) to import New Users or change current User details.

Note

Before Importing Users, we recommend that you always 1st check either via an Export or Downloading of the latest Template, that the Excel Import format is the latest. Improvements are released periodically that may have an impact of the Import Template,. (i.e. Check all the possible columns (User Fields) are are present and in the correct sequence).
The Role Based Survey field if being used, requires to be populated by the Requirements Unique ID, NOT the Requirement Name.

Select the Import button. This will show the following pop-up dialogue

Image Removed

Image Added
If you do not yet have an Import Template or output from an Export you can download an empty template using the Download Bulk Template button
Image Modified
1. Save & rename this file as required etc
2. This file can now be edited and populated with new people you wish to add to the list of people
3. Warning: When editing/updating a persons Info, replacing the contents of a field with null or a space will clear the field of any previous value.
Once you are ready to Import select the Type of Import you wish to do
Image Modified
1. Insert & Update - will Insert People that have an email address that does NOT already exist in the system and Update people it finds with an existing email address
2. Insert Only - will only Insert People that have an email address that does NOT already exist in the system and ignorepeople it finds with an existing email address
3. Update Only - will Update people it finds with an existing email address and ignore People that have an email address that does not already exist in the system
Use the Select Files button to select the file you wish to import
Image Modified
And use the dialogue to select your file
You should see something similar to this after selecting your file

Image Removed
Image Added
To continue with the Import select the Perform Upload button
After the upload has completed you should get a brief message in the Top RHS e.g.
Image Removed
Image Added
Note: It will only show briefly then disappear
Note
Notes:
Invalid fields or null mandatory fields will cause the person to not be updated, and produce an error message.
Duplicate email addresses will not be imported