How to Import User Activity Data

Keywords:

Inquisiq allows you to import historic course completion data for users who have taken courses outside of the LMS. This information can be imported and displayed on user transcripts and in reports.

Use the table on this page as a reference to create a spreadsheet with information about the users you wish to import. You will then export the spreadsheet as a tab-delimited text file (from Excel on a PC), a Windows Formatted Text file (from Excel on a Mac), or a Tab-separated values (.tsv) file, which upon downloading, you will then change the extension to .txt (from Google Sheets on a PC or Mac).

A few things to keep in mind when Importing Activity Data:

- If there is data the system cannot read in one or more of the fields (for example, “Module Success” field has “Pass” or “Fail” rather than the required “Passed” or “Failed”), the upload will fail.
- If there is a space, tab, or enter in the tab-delimited file after the last “END,” the upload will fail.
- If the username does not already exist in the system, the upload will fail. The user needs to be in the system before activity data can be imported.
- If there is a course in the system that matches a course code in the activity import document, the user’s transcript will reflect that course’s information. If the course code in an activity import document matches to one in the system, and the course title is different in the activity import document from that which is already in the system, the system will not import the course title from the document and will instead attribute the user’s activity to the course in the system.

Note: There is a link in each individual user profile to Import Activity Data. Both the page here and the link in each user profile serve the same purpose. There is no difference between either and it does not matter on which page you perform the upload. The data will be imported the same way.