Versions Compared

Old Version 7

changes.mady.by.user Luc Richard

Saved on

compared with

New Version Current

changes.mady.by.user Luc Richard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When a course's expiration settings are changed in the course completion settings, it will only affect new learning records created going forward. Existing records will still show the settings expiration date as of the date the record was addedcreated. If you want all previous records to reflect the latest settings expiration rules, then you will need to export, void and re-import your somehow update the existing learning records. 

Step-by-step Guide

To void or update existing learning records using a CSV approach:

  1. Export the records you want to change following this article: Exporting Learning Records

  2. Void the learning records, see Voiding Learning Records in this article: Importing Learning Records

  3. Prepare to import new Learning Records with an updated expires timestamp using the file exported in step 1

    1. In the expires column, update the date the record should expire. ex: Use Jan 1 when the course must be completed by Dec 31

    2. If the course expires by lapse time, you will need to calculate the new expires dates based on the timestamp column and set the cell format to YYYY-MM-DD. There are some formulas for convenience below.

  4. Import the new Learning Records: Importing Learning Records

Info

Here are some formulas to calculate expiration by lapse time of 365 days. Cell K2 is assumed to be the timestamp cell.

Excel or LibreOffice

=DATE(LEFT(K2,4), MID(K2,6,2), MID(K2,9,2)) + 365

For more information, please see:

...

hiddentrue

...

Important Notes

  • If you want to simply void all existing learning records for a single course, you should follow the procedure explained in Voiding All Learning Records in a Course.

  • If you want to change everyone's expiration date for a single course to the same date, you should follow the procedure explained in Expiring Learning Records.

  • If your scenario is more complex (e.g. multiple courses, selecting specific learning records, specifying different expiry dates for different people), you will need to follow the step-by-step instructions in this article.