Activity Import

Summary
If you have learning completion data you would like to migrate to Learn Amp, you can use the Activity Import to upload this in bulk.

Main Features

Establish a secure connection to migrate data to Learn Amp
Import Activity Data by uploading a CSV file to Learn Amp
Map activity data to any Item, Learnlist or Channel you have created in Learn Amp.
Import archived records for any learning you have not created in Learn Amp.

Information that can be synced

Activity Import is performed by uploading a CSV file through the Activity Import page in Company Settings. The Activity Import accepts the following columns of data:

Activity field	Details

Activity field	Details
Email	This is the default identifier used to look up users while processing the import.
Source ID	If your content was imported from another system, you may have supplied a unique identifier for each piece of content. If available, this should be used rather than title as it is less ambiguous.
Source Type	Short text identifier for where this item is being imported from. If you uploaded your content in an import, you may have provided a source type e.g the name of your old learning management system.
Title	Not required if using Source ID and Source Type. Title of the learning object, to look up the content for each activity.
Type	Optional: Defaults to 'Item'. Must be one of 'Item', 'Channel', 'Learnlist', 'Quiz'. Designates the type of content the activity should match to.
Started at	Optional: If the activity has a start date/time, use this column to create a started activity. Times should be in UTC time zone (+0). Please use the following date format: YYYY-MM-DD hh:mm:ss
Completed at	Date/time when the content was completed by the user. Times should be in UTC time zone (+0). Please use the following date format: YYYY-MM-DD hh:mm:ss
Score	Optional: User's score (out of 100) when completing the content
Result	Optional: Generally either 'pass' or 'fail'
Total time	Optional: Time that the user took to complete the content (in seconds as a whole integer).

Syncing Additional Information

If you require additional information to be imported such as Tasks or CPD please speak with your Implementation or Customer Success Coach.

Please Note: Requests for custom development will be handled by your Implementation or Customer Success Coach.

Known Limitations/ Considerations

Replace/overwrite existing data: The activity import will only add new data. It cannot replace/overwrite existing data, e.g. to change a user’s activity record. Once the Activity Import has completed, it is not possible to amend activity data in Learn Amp. In this case please submit a data change request to our Technical Support Team.

Content mapping: You must first create any items, quizzes, Learnlists or channels that you would like to map activity to. When completing the import, you can choose to add archived records for any content items not found in Learn Amp.

Level of import: Activity imports must happen at Item level, otherwise channel % completion won't calculate. E.g. you can't upload activity at Learnlist-level only, and expect channel % completion on Content/People logs to display accurately.

Processing Time for Imported Activities: When you import activity data through the Activity importer, there may be a delay before the activities are reflected in the platform logs. This delay is due to the processing time required to ensure accurate data integration. The processing time can vary depending on the volume of data being imported. Also, it will take additional time for totals on the Content log to refresh and show accurate results.

Required Stakeholders

Owners or Admins; individuals who are recognized owners of any user learning data.

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

The exact answer to this question will depend on your use case, and what system(s) you are coming from. Typically, most Learn Amp customers want to import completion data.

This will populate Learn Amp’s Activity Log, with a complete history of who completed what, when. For most customers, this completion activity is all that is required when coming from another learning system.

A CSV template is available to download from the Activity Import page in Learn Amp. Often the required data can be exported from your existing LMS or reporting platform.

Learn Amp uses the email field as a user’s unique identifier in the Activity Import. You can only import activity data for users who exist in Learn Amp.

The ‘Title’ field is used to look up the content title for each activity record.

If your content was imported from another system, you may have supplied a unique identifier for each item using the Source ID field. If available in Learn Amp, this should be used rather than title as it is less ambiguous.

No, the activity import will not award certificates retrospectively.

Related articles

User Import with sFTP (Secure File Transfer Protocol)

Items Import with sFTP (Secure File Transfer Protocol)