Edge Import - Video Transcript Load and Feed

The Video Transcript load and feed enable organizations to load transcript data specific to video learning objects.

Starter Guide

Select this link to download the Edge Import Starter Guide.

Select this link to download the Edge Import - Learning Guide.

Unique Identifiers

When loading video transcript data, the following can be used as the unique identifier for each video:

  • Video ID - Select this option when you have Video IDs available and want to import new transcripts or update existing transcripts.
    • The final unique key fields will be User ID, Video ID, and Transcript Key.
    • In Custom Reports, the Video ID is displayed as Training ID.
    • Videos created via the user interface will not have a Video ID. To update transcript records for videos created via the user interface, you must use the system-generated Learning Object ID.
  • Learning Object ID - Select this option if you have the unique system generated Learning Object IDs available and want to import new transcripts or update existing transcripts.
    • The final unique key fields will be User ID, Learning Object ID, and Transcript Key.
    • You can create a custom report to locate the Learning Object ID of each video.

When updating existing transcript data, the following can be used as the unique identifier for each transcript record:

  • Registration Date/Time - Select this option to create new or update existing transcript records with previously loaded registration date. Recurrence must be enabled for the learning object in the Course Catalog before adding multiple registrations. The final unique key fields will be User ID, Learning Object ID, and Registration Date/Time.
  • Registration Number - Select this option to update existing transcript registrations. A new transcript registration cannot be added using this option. The final unique key fields will be User ID, Learning Object ID, and Registration Number.

Supported Transcript Statuses

The following transcript statuses are supported with this load type:

  • Completed
  • Exempt
  • Registered

Note: Edge Import can be used to update a transcript status to "Completed" even if the current transcript status is not supported in Edge Import. For example, Edge Import can update a transcript status from "Registered/Past Due" to "Completed." Some restrictions apply and are included in the updated template guide.

Due Date Action Type

The optional Due Date Action type field allows administrators to remove due dates or update due dates for learning objects within a curriculum when the due date for the child is updated using Edge Import.

This field accepts the following values:

  • Update ONLY for this transcript - This option will update the due date only for the selected learning object type, and it will not update the due date for learning objects within a curriculum.
  • Update for ALL LO associated transcript - This option will update the due date for the selected learning object type, including if the learning object is within a curriculum.
  • Delete ONLY for this transcript - This option will delete the due date only for the selected learning object type, and it will not delete the due date for learning objects within a curriculum.
  • Delete for ALL LO associated transcript - This option will delete the due date for the selected learning object type, including if the learning object is within a curriculum.

Use Case: The Edge Import transcript load is used to update the due date of a training to July 1. This training exists in a curriculum and has a due date in the curriculum of August 6. If the value in the Due Date Action Type field is "Update for ALL LO associated transcript," then the data load updates the training due date to July 1, including the due date within the curriculum.

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

Frequently Asked Questions (FAQs)