How to import user certificate data

Keywords:

Inquisiq allows you to import historic certificate data for users who have earned certifications 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 all of the 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 Certificate Data:

- If there is data the system cannot read in one or more of the fields (for example, “Certificate Award Date” field is not in the correct Date/Time format specified in the table on the page), the upload will fail.
- If there is a space, tab, or enter in the tab-delimited file after the very last “END,” the upload will fail.

Note: There is a link in each individual user profile for Import Certificate 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.