Imports

The Imports screen in the admin dashboard allows admins to bulk import users, content view data, and legacy SCORM course data to Fuse, as well as change manager-reporter relationships in bulk by importing a CSV file.

Fuse does not support CSV files with UTF-8 encoding. You must save it as a standard CSV file.

The Imports screen consists of the following tabs:

Bulk import of users

The Bulk import of users tab allows admins to:

Add new users to Fuse by importing a CSV file.
Make changes to the details of multiple existing users by importing a CSV file.

You cannot add profile pictures to users during import. This can only be done after users have been imported to Fuse.

Important information

Take note of the following points when formatting the CSV file:

You do not need to add headers at the top of each column in the CSV file. You will be prompted to map existing Fuse profile fields to each column during the import.
When importing new users into Fuse, the CSV file must include each user's username or email address in order to import successfully.
When making changes to existing users, the CSV file must contain a user's username, email address or Fuse ID (User ID).

An existing user's ID is visible in the URL of their Personal settings page:
Non-mandatory user information in the CSV differs for each organisation and is based on the custom profile fields that have been set up in an organisation's Fuse instance. For example, some organisations may include information such as a user's first and last names, location, and employee number in the CSV file because there are fields in each user's profile that display this information.

An example of what a CSV file might look like when importing new users to Fuse, can be downloaded here.
An example of what a CSV file might look like when making changes to the details of existing Fuse users, can be downloaded here.

To import users using a CSV file:

In the Bulk import of users tab, click Import from CSV
A window appears allowing you to search for and upload the CSV file.
Select the CSV file and click Open.
The Tweaking the import screen appears.
[Optional] Under Ability options, select one or more of the following configurations:
- Add new users: Assigns new user IDs to all imported users.
- Update existing users: Profile details for existing users are updated based on the information in the CSV file.
  
  Existing users are Fuse users with a username or email address that matches the information in the CSV file.
Under Manager options, select one of the following configurations:
- Add managers to existing managers list: Users marked as 'managers' in the CSV file are added to the managers list on the company instance.
- Replace existing managers with new managers: Users marked as 'managers' in the CSV file replace existing managers on the company instance.
[Optional] Under Welcome email, select Send new users welcome email if you want a welcome email to be automatically sent to all newly-imported users.

If you select the Send new users welcome email option, the password for all newly-imported users is reset.
In the section below Welcome email, select labels from each dropdown, to correspond to the categories of information provided for each user in the CSV file, such as username and email address.

The available labels correspond to the custom profile fields created during the company on-boarding process.
Click Import users.
The users are added to Fuse and the CSV file is listed on the table in the Bulk import of users tab.
If you have imported new users, they will appear on the Manage users screen.

If the file fails to import successfully, you can download a report containing a list of errors by clicking the number in the Errors column. In the example below, 1 error was found in the CSV file.

The table in the Bulk import of users tab displays a list of completed user imports, as well as those that are currently in progress. The following information is displayed for each CSV file:

Item	Description
File	Displays the name of the CSV file used to import users to Fuse. The following options are available in the File column: Click the filename to view details of the users imported from the CSV file. Select the checkbox to the left of the filename and click Delete selected files button to delete the CSV file. Select the checkbox to the left of the File heading, and click the Delete selected files button, to select and then delete all CSV files in the list. Notes: The deleted CSV file remains on the table, but you can no longer open it and view the data. Deleting a CSV file does not delete the imported users from Fuse.
Progress	Displays the current user import progress. For example, if the import has completed, the progress bar will show 100%. If labels have not been assigned to each of the user details in the CSV, click Adjust labels to start to assign labels before importing can complete.
Errors	Displays the number of errors that occurred during the import process. Click the number to download an error report CSV file.
Created	Displays the date and time the CSV file began importing. For example, 01 July, 2019, 16:41.
Author	Displays the name of the user who imported the CSV file. For example, James Evanston. Click the user's name to view their profile.
CSV	Click Download to download the CSV file.

Views dataloader

The Views dataloader tab allows admins to bulk import view data for existing items of Fuse content. When importing view data for an item of content, you must provide the ID of the content, the ID of the Fuse user who has viewed the content, and the date they viewed the content.

Example:

When an organisation migrates from their previous learning management system to Fuse, they will often migrate all of their content and users. However, when content is migrated across, historical data for that content such as view data (records of when a user has viewed an item of content) might not be included. The Views dataloader tab allows admins to bulk import view data for content that has been migrated to Fuse.

An example CSV file, showing how the data should be formatted when importing content views to Fuse, can be downloaded here.

CSV files imported in the Views dataloader tab must contain the following header labels:

Header	Description
user_id	The ID of the user who viewed the content. A user's ID is visible in the URL of their Personal settings page:
content_id	The ID of the content that was viewed. The ID for an item of content is visible in the URL when viewing the content's homepage.
datetime	The date the content was viewed. The date must be in the following format: YYYY-MM-DD. For example, 2019-01-01.

The CSV file can contain up to a maximum of 500 rows when importing view data into Fuse.

To import content views to Fuse:

In the Views dataloader tab, click Import from CSV.
A window appears allowing you to search for and upload the CSV file.
Select the CSV file and click Open.
The CSV file is imported and Fuse will begin processing it.
To check if the view data has been added to a particular item of content, click the Views tab on the content's homepage.

If the CSV file fails to import successfully, an error message is displayed providing further information.
For example, a CSV file cannot be imported if any of the mandatory CSV headers (listed in the table above) are missing or spelled incorrectly.

Managers and reporters

The Managers and reporters tab allows admins to assign managers to another user or assign reporters (users who are subordinate to another Fuse user) to a manager via a CSV import.

CSV files imported in the Managers and reporters tab must contain the following header labels:

An example of what a CSV file might look like when changing manager-reporter relationships can be downloaded here.

Label	Description
user_id	Enter the user ID of the manager or reporter being imported to Fuse. A user's ID is visible in the URL of their Personal settings page:
type	Specify whether the user being imported is a manager or reporter. Enter one of the following: manager: The user being imported is the manager of another user in Fuse. reporter: The user being imported reports to another user in Fuse.
manager_or_reporter_id	If the user being imported to Fuse is a reporter, enter the user ID of the manager being assigned. If the user being imported to Fuse is a manager, enter the user ID of the reporter being assigned. A user's ID is visible in the URL of their Personal settings page:

To import a CSV file containing changes to manager/reporter relationships:

Under Manager options, select one of the following configurations:
- Add managers to existing managers list: Users marked as managers in the CSV file will be added to the managers list on the company instance.
- Replace existing managers with new managers: Users marked as managers in the CSV file will replace existing managers for the user they are assigned to.
Click the Import from CSV button.

The CSV file is imported and it will begin processing.
To check if a user's manager or reporter relationship has been updated, you can view the Manager/Report details section in the user's Personal settings screen.

If the CSV file fails to import successfully, an error message is displayed providing further information.
For example, a CSV file cannot be imported if any of the mandatory CSV headers (listed in the table above) are missing or spelled incorrectly.

Events

The Events tab allows admins to bulk-import event records to Fuse using a CSV file. Details that can be imported include start and end dates, participating users, and host information.

An example CSV template can be downloaded by clicking the Download template button.

If the information imported from the CSV file does not precisely match the event details, including capitalisations, a new occurrence is created.

The CSV file must contain all the following header labels, even where the data is optional:

Header	Data
community_id	The ID of the community in which the event exists. You can obtain a community's ID by viewing the URL of the community homepage.
owner_id	The user ID of the event owner. A user's ID is visible in the URL of their Personal settings page:
event_name	The name of the event. For example, All employee training day.
event_description	The description of the event.
starts_at	The date and time the event started. Date and time must be in following format: DD-MM-YYYY HH:MM For example, 01-01-2019 20:20.
ends_at	The date and time the event ended. Date and time must use the following format: DD-MM-YYYY HH:MM For example, 01-01-2019 20:20.
location	The location of the event. For example, The City Conference Centre.
advertisement_code	Unique code to identify the event (If one has been specified).
user_id	ID of the user who participated in the event. A user's ID is visible in the URL of their Personal settings page:
pass_status	Displays the pass or fail status for the user, if the Enable pass & fail for this course option is enabled. The Enable pass & fail for this course can be enabled in the Advanced options section of the New event screen.
internal_host_id	Internal host ID. This data is required if the event has an internal host.
external_host_name	The name of the user hosting the event, who is external to your organisation. For example, David Johns. This data is required if the event has an external host.
external_host_email	The email address of the user hosting the event, who is external to your organisation. For example, david.johns@email.com. This data is required if the event has an external host.
creator_approval_required	Whether or not creator approval is required when users apply to join the event. This can be TRUE or FALSE. This data is optional.
manager_approval_required	Whether or not a user must seek approval from their manager before being able to join the event. This can be TRUE or FALSE. This data is optional.
specified_approval_required	Whether or not a specified Fuse user (who is not the event owner or the user's manager) must give permission for a user to join the event. This can be TRUE or FALSE. This data is optional.

To view imported events, either:

Under Events import info, click the name of the CSV file.
Under CSV, click the Download button.

Survey scores

The Survey scores tab was used by admins to import survey assessment scores to Fuse using a CSV file.

Survey assessments were used by clients to obtain qualitative feedback from their users. This has now been superseded by the Surveys feature and will be deprecated in the near future.

SCORM courses

The SCORM courses tab allows admins to import SCORM course data to Fuse in bulk, using a CSV file. For example, an organisation might want to import legacy completion data for a SCORM course that has been imported to Fuse from a legacy learning management system.

Notes:

An example of what a CSV file might look like when importing SCORM course data to Fuse, can be downloaded here.
For information about SCORM courses in Fuse, including how to upload a SCORM course, see SCORM courses.
Fuse supports SCORM 1.2 (Single SCO 1.2).

The CSV file must contain the following header labels:

Notes:

Only the data shown in the table below can be imported into Fuse. All additional historical data and columns must be deleted prior to importing the CSV file.
The CSV file must contain all the following header labels, even where the data is optional.

Header	Data
user_id	The ID of the user who participated in the SCORM course. This data is mandatory and must be present in the CSV file. A user's ID is visible in the URL of their Personal settings page:
content_id	The content ID for the SCORM course. This data is mandatory and must be present in the CSV file. The ID for an item of content is visible in the URL when viewing the content homepage.
started_at	The time the user started the SCORM course. Date and time must be in following format: DD-MM-YYYY HH:MM For example: 01-01-2019 10:00. This data is optional.
completed_at	The time the user completed the SCORM course. Date and time must be in following format: DD-MM-YYYY HH:MM For example: 01-01-2019 10:55. This data is optional.
cmi.core.lesson_status	If the user has completed the SCORM course. The following statuses can be entered: complete: The user has completed the SCORM course. incomplete: The user has not completed the SCORM course. This data is optional.
cmi.core.score.raw	The raw score for the SCORM course. For example, 100. This data is optional.
cmi.core.score.max	The maximum number of points the user can receive for the SCORM course. For example, 100. This data is optional.
cmi.core.session_time	How long it took the user to complete the SCORM course. Session time must use the following format: HH:MM:SS. For example: 00:55:21. This data is optional.

To import a SCORM course:

In the SCORM courses tab, click Import from CSV.
A window appears allowing you to search for and upload the CSV file.
Click Open.
The CSV file is imported and Fuse will begin processing it.
To check if a user's completion data has been added for a particular SCORM course, you can:
- Create and run a SCORM courses report for the relevant SCORM courses.
- Check the Certificates tab on each user's profile screen. For example, if the user has completed the SCORM course, a certificate will be listed in their Certificates tab with the date of completion.
  
  If the CSV file fails to import successfully, an error message is displayed providing further information.
  For example, a CSV file cannot be imported if any of the mandatory CSV headers (listed in the table above) are missing or spelled incorrectly.