Edge Import - External Training Load and Feed

The External Training load and feed enable organizations to load new or update existing external training transcript records.

Starter Guide

Select this link to download the Edge Import Starter Guide.

Unique Identifiers

When loading external training records, the following can be used as the unique identifier for each external training record:

  • New - Select this option when you want to import new external training records.
    • The final unique key fields will be User ID, Start Date/Time, Transcript Status, and Training Title
  • Existing - Select this option if you want to update an existing external training record.
    • The final unique key field will be Learning Object ID.
    • You can create a custom report to locate the Learning Object ID of each external training.

Supported Transcript Statuses

The following transcript statuses are supported with this load type:

  • Completed
  • Registered
  • Withdrawn

File FTP

If the document name is provided, the actual file needs to be present on the Cornerstone FTP site in a separate dedicated system folder: LMS/ExternalTrainingTranscript.

The external training files will not be removed from the FTP after the one-time load.

Due Date - Acceptable Format and Default Value

The Due Date field accepts the following format: DATE HH:MM:SS +/- UTC offset.

  1. If the Due Date time is not provided, the time defaults to 23:59:00.
  2. If the UTC offset is not provided, the offset defaults to UTC.

The following Due Date formats are accepted and available in the template guide:

  1. Valid Date Only
    1. Due date provided in the file: 01-01-2023
    2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 23:59:00 OFFSET: UTC
  2. Valid Date and Time
    1. Due date provided in the file: 01-01-2023 11:11
    2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 11:11:00 OFFSET: UTC
  3. Valid Date with Offset
    1. Case 1: Valid offset
      1. Due date provided in the file: 01-01-2023 +5
      2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 23:59:00 OFFSET: +5
    2. Case 2: Offset provided as 0; because 0 is not valid, UTC is used.
      1. Due date provided in the file: 01-01-2023 +0
      2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 23:59 OFFSET: UTC
  4. Valid Date and Time with Offset
    1. Case 1: Valid offset
      1. Due date provided in the file: 01-01-2023 11:11 +5
      2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 11:11 PM OFFSET: +5
    2. Case 2: Offset provided as 0; because 0 is not valid, UTC is used.
      1. Due date provided in the file: 01-01-2023 11:11 +0
      2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 11:11 OFFSET: UTC

Considerations

  • Start Date is only required when updating external training records. It is not required when creating new external training records.
  • Request Date/Time defaults to the Start Date or the import date and time in UTC.
  • Registration Date/Time defaults to the Start Date or the import date and time in UTC.
  • Completion Date/Time defaults to the End Date or the import date and time in UTC.