LatitudeLearning logoLatitudeLearning logo
  • Administrators
    • Organize People
    • Organize Content
    • User Experience
    • Manage People
    • Manage Learning
    • Track Progress
  • Instructors
  • Managers
  • Students
  • Release Notes
  • Sign In
LatitudeLearning logoLatitudeLearning logo
  • Administrators
    • Organize People
    • Organize Content
    • User Experience
    • Manage People
    • Manage Learning
    • Track Progress
  • Instructors
  • Managers
  • Students
  • Release Notes
  • Sign In

Use Transcript Import to Update History

The Transcript Import feature lets portal administrators upload up to 10,000 new training history records to their LMS at once.

Feature Overview and Requirements

Prepare the Transcript Import File

Download a blank import template here: Transcript Import CSV template. A link to the most current template is also available from the Transcript Import page via the online Help (?) icon in the LMS header.

The CSV file must be submitted in the standard template format and contain user, course, and transcript information.

  • All columns must remain in the uploaded file without column order or heading changes.
  • The filename of the CSV file must not contain any spaces. Dashes (-) and underscores (_) are acceptable.
  • New transcripts will be created for each entry in the file, this tool WILL NOT edit any existing transcripts.

Step by Step Procedure and Field Description

Required Fields

Username: Must be a valid user with primary profile in portal.
Course Code: Must be a valid course code for an existing course within the portal. The course does not need to be active.
Enroll Date: Must be on or before Score Date, in format mm/dd/yyyy
Score Date: Must be on or after Enroll Date, in format mm/dd/yyyy
Score: Number between 1-100. Only use a whole number and do not include special characters, such as %, as they will cause the import to fail.
Status: Supported statuses are listed below. The process requires exact text match for a successful import.

  • Pass
  • Attend No Bill (Pass)
  • Cancel
  • Fail
  • Incomplete

Optional Fields

Expiration Date: Enter a date in the format mm/dd/yyyy if this transcript should be loaded as expired or expiring in the future. Must be on or after the Enroll Date and on or after the Score Date.
Pre-Test Score: Number between 1-100. On some LMS pages this will display in the field Written Score.
Post-Test Score: Number between 1-100. This will be displayed in the Practical Score field on some LMS pages.
Location Code: The code representing the location to be associated with the user’s transcript.

Upload the Transcript Import File to the LMS

The CSV file name cannot include spaces or the import process will fail, even with valid transcript data.

Once the file has been prepared for upload, from the Administration menu, select Imports > Transcript Import.

Use the Choose File button to select your import file, then click Process Transcript Import.

Administrators will typically receive a confirmation email within a few minutes of initiating to let them know that their file was accepted and processing is in progress. Once the import process is completed, administrators will receive a second email titled “LatitudeLearning Data Import Exception Log” with an attached Excel file. The file contains information about successfully imported transcripts, and lists any import errors as failures, but at this time, does not include the specific data or other reason that is causing the failure.  (SuccessFailureLog).

Shortcuts

  • Feature Overview and Requirements
  • Step-by-Step and Field Descriptions

Useful Links

  • Transcript Import Template

LatitudeLearning LLC
100 East Michigan Avenue
Suite 200
Saline, Michigan 48176
888.577.2797

  • Administrators
  • Instructors
  • Managers
  • Students
  • Release Notes
  • FAQs
  • Schedule a Demo
  • Free Trial
  • About Us
Translate this page:
© Copyright 2009 – 2025 LatitudeLearning LLC  |  Terms of Use  |  Privacy Policy
  • Facebook
  • Twitter
  • YouTube
  • LinkedIn