It’s possible to import new users and update existing users at once by uploading a CSV file of changes that need to be made.

1. In the ClearXP admin interface, navigate to Users > Bulk Upload

2. Drag and drop a CSV file with your users and their attributes into the designated area of the page and click Start Upload.

3. Once the upload has completed, a screen will be displayed allowing you to map each column from your CSV file to a ClearXP resource, along with a preview of the first few rows of data from your CSV file.

For each column you wish to import, click the drop down and select the resource that column should be mapped to. A summary of possible values include:

4. Ensure you select a Display Name for your users. This name may be populated by a value from a single column or composed of values from multiple columns (such as First Name and Last Name) separated by a space.

5. Click Check Mapping to validate your configuration and see a summary of actions that will be taken. The summary screen will outline how many rows contain new users or existing users, as well as any errors or warnings that may occur when importing this file.

It is advised that you review this summary screen carefully. Sometimes it is safe to ignore warnings but in other cases, it may result in corrupt data so read each warning message and use your best judgement before importing. You can always return to the mapping screen and remove a column from import if you’re unsure of the consequences of importing it.

6. When you’re satisfied that the mapping is correct, click Confirm Import to queue the file for importing. After several minutes, this file will be imported and any new users will appear in the system.

The below is an example CSV file that includes 4 users with columns for 3 different user attributes (First name, Last name, and Email) as well as a column for adding to a group (Group) and adding to an enrolment (Enrolment).

First name,Last name,Email,Group,Enrolment
Danny,Demo,danny.demo@example.com,Test Group,
Dan,Demo,dan.demo@example.com,Test Group,Demo Enrolment
Sam,Sample,sam.sample@example.com,Missing Group,Demo Enrolment
Sammy,Sample,sammy.sample@example.com,,Missing Enrolment

As opposed to creating multiple activities and setting values manually through the user interface, it’s possible to bulk create or update activities by importing a CSV file.

1. In the ClearXP admin interface, navigate to Activities > Events and click Bulk Upload

2. Drag and drop a CSV file with your users and their attributes into the designated area of the page and click Start Upload.

3. Once the upload has completed, a screen will be displayed allowing you to map each column from your CSV file to a ClearXP resource, along with a preview of the first few rows of data from your CSV file.

For each column you wish to import, click the drop down and select the resource that column should be mapped to. A summary of possible values include:

4. Click Check Mapping to validate your configuration and see a summary of actions that will be taken. The summary screen will outline how many rows contain new users or existing users, as well as any errors or warnings that may occur when importing this file.

It is advised that you review this summary screen carefully. Sometimes it is safe to ignore warnings but in other cases, it may result in corrupt data so read each warning message and use your best judgement before importing. You can always return to the mapping screen and remove a column from import if you’re unsure of the consequences of importing it.

5. When you’re satisfied that the mapping is correct, click Confirm Import to queue the file for importing. After several minutes, this file will be imported and any new activities will appear in the system.

The below is an example CSV file that includes 1 event and 2 sessions with columns for Name, Event Cost, Session Start Date, Session End Date and Session Time Zone.

In this example we’re importing an event and a session at once, so where a column is not applicable, the value is left blank to ensure it is skipped.

Name,Cost,Start Date,End Date,Time Zone
Workshop,20,,,
Session 1,,12/11/18 9.00am,12/11/18 5.00pm,Asia/Tokyo
Session 2,,20/11/18 6.00am,21/11/18 3.30pm,Australia/Perth

The bulk importer for users and activities may sometimes require you to specify the format of a date you are importing. This might happen if importing a user attribute that is of the date format, or when importing a Session activity with a start or end date.

Because the import tool does not constrain what format dates must appear as in the CSV file, it is the responsibility of the admin to specify how the date is formatted so that it can be imported correctly.

See the below example CSV file for importing two sessions.

Session Name,Start Date,End Date
Session A,2019-01-15 09:00,2019-01-15 17:00
Session B,2019-01-20 08:30,2019-01-21 10:00

When this file is uploaded and mapped, the import tool will request a date format for both Start Date and End Date.

The Date Format field takes a series of tokens that map to the format of the date you are trying to import. The below is a reference table for all allowed tokens:

Given this reference table, we can determine that our sample file should use the Date Format of yyyy-mm-dd HH:mm to correctly import each session:

When bulk importing users or activities, it’s often desirable to link the imported entity to some other resource in the system. This may include assigning the imported user to a Group or Enrolment – the documentation above adequately covers how this can be done, however, it may not be clear that multiple resources can be assigned to a single user at once.

Take for instance, the following sample CSV for importing two users:

"Name","Group 1 Name","Group 2 Name"
"John Smith","Sales"
"Kelly Warner","Marketing","Managers"

The first row contains the user John Smith who will be added to the group Sales, if it exists. The second row, however, contains the user Kelly Warner who will be added to both the Marketing and Managers groups.