Summary If you have learning content you would like to migrate to Learn Amp, you can use the Items Import to upload these in bulk. sFTP is a secure way to manage large or regular data imports to Learn Amp.
Items Import is performed by first uploading content files (e.g. SCORM, MP4) into Learn Amp's sFTP server, then importing a CSV file of metadata through the Items Import page in Company Settings.
Main Features
Establish a secure connection to migrate data to Learn Amp
Create Items, e.g. videos and SCORM packages
Add items to learnlists and channels in Learn Amp
Update Items on bulk
Information that can be synced
Items are any single learning activity or resource such as a SCORM package, video or PDF.
Content files
Learn Amp can import the following content files uploaded to your sFTP server:
Zip files, containing SCORM/xAPI or AICC packages.
MP4 or similar video files, for video content.
PDF / Word / PowerPoint files, for downloadable documents.
PNG / JPG images
Items CSV
To complete the import, you will also upload to Learn Amp an accompanying CSV file containing item meta-data (e.g. title, description, file name). You can also use this file to import items without attached files, such as websites or actions.
The import accepts the following columns of data:
Item field
Information
Item field
Information
Title
Required: This is the name/title of the learning object.
Description
Optional: This is the body description that appears on the item page. You may include basic HTML tags in this description.
Source Type
Optional, but recommended: This is a short text identifier for where this item is being imported from. For example, it could be the name of your old learning management system, or the content provider of these learning objects.
Source ID
Optional, but strongly recommended: If you are importing content from another system, please supply the ID or unique identifier for the course or learning object as it was in the old system. This is very useful for importing historic completion data into Learn Amp from your old system.
Type
Required:
article
document
book
q_and_a
info_card
video
elearning
infographic
audio
slides
image
project
classroom
coaching
course
event
presentation
meeting
webinar
action
test
qa
announcement
newsletter
reminder
website
other
Tags
Optional: A comma seperated list of tags.
Attachment File Name
Optional: If the learning object is a Video, Audio, Document, PowerPoint presentation or some other file, then this column should contain the exact filename of the corresponding asset.
Before importing your CSV, you will need to transfer this file to us via sFTP. When transfering files, do not use directories or sub-directories. Please place each file in the root of your sFTP folder.
SCORM File Name
Optional: If this is a Scorm, xAPI, CMI-5 or AICC package, this column should contain the exact filename of the .zip archive for this content. The .zip archive must contain a correctly formatted single elearning package, otherwise upload will fail.
Before importing your CSV, you will need to transfer this file to us via sFTP. When transfering files, do not use directories or sub-directories. Please place each file in the root of your sFTP folder.
Image File Name
Optional: (not required if using Image URL column). JPG or PNG image file name for the Tile or Hero image for the item. This column should contain the exact filename of the corresponding image file.
Before importing your CSV, you will need to transfer this file to us via sFTP. When transfering files, do not use directories or sub-directories. Please place each file in the root of your sFTP folder.
Image URL
Optional: (not required if using Image File Name). Full URL (including HTTPS etc) of an image to use for the Tile or Hero image on the item. This URL must be publically accessible. Our system will fetch the image from the remote page automatically during import.
URL
Optional: required if content is a Web link item: Full URL of an external web page (includes links to YouTube, Vimeo, Vidyard, Wistia and MS Streams).
Learnlists
Optional: Comma seperated list of Learnlist names. Use this column if you want to add the item into existing learnlist(s) with matching names.
Channels
Optional: Comma seperated list of Channel names. Use this column if you want to add the item into existing channels(s) with matching names.
Skills
Optional: if Skills is enabled on your account. A comma separated list of skill names.
CPD Type
Optional: if CPD is enabled for your account. Must be one of:
formal
informal
CPD Hours
Optional: if CPD is enabled for your account. Number of CPD Hours awarded for completing the content.
Known Limitations/ Considerations
Importing Learnlists and Channels: Learnlists and Channels are imported using the Imports feature in Learn Amp. These cannot be uploaded to your sFTP server but an sFTP connection must be set-up to import these in Learn Amp.
Creating the import files: How CSV files are generated will depend entirely on your internal systems and processes. Sometimes a file can be generated from your content management platform by someone in your organisation. Sometimes the file will need to be manually created.
sFTP server access: You will need to consider who will need access to your sFTP server to upload content files if you are unable to schedule this from your content management platform, e.g. Sharepoint.
Adding items to learnlists and channels: You can use the Items CSV to add items to Learnlists and Channels. These Learnlists and Channels need to already be available in Learn Amp, e.g. by performing the Learnlists and Channels import first.
How the Platforms Connect
Secure File Transfer Protocol (SFTP) is a secure file protocol for transferring large files over the web.
An SFTP server requires both communicating parties to authenticate themselves by providing and validating an SSH key. One-half of the SSH key is stored on the computer of the two clients, while the other half is loaded on the server and associated with their account public. Only when the SSH key pair matches then authentication can occur.
Required Stakeholders
IT Manager / Team; for setting up your sFTP server.
Owners or Admins; individuals who are recognized owners of any user data or content you will import using sFTP.
HR Managers / Team; for input around people processes in relation to new starters, changers or leavers.
Set up Instructions
Instructions on how to enable sFTP can be found in Company Settings on your Learn Amp account.
You will need to be the account owner to configure sFTP.
Other Frequently Asked Questions
Content imports (items) cannot be scheduled. These are run manually by importing the accompanying CSV file to Learn Amp.
The status of completed imports is displayed on the Items Import page.
STATUS
UPLOADED AT
PROCESSED AT
UPLOADED BY
STATUS
UPLOADED AT
PROCESSED AT
UPLOADED BY
No, it is only possible to associate items being added to Learn Amp via sFTP to channels and Learnlists that already exist in the platform. To add new Channels or Learnlists, use the Channels or Learnlists import tools, and then complete the items import.
