Curriculum Enrolment Unfold Refold

Curriculum Enrolment Unfold Refold is a process where the enrolments of users in FiLMS are reorganized to maintain their training history.

Symptoms

Users who have previously seen a Completed enrolment for a curriculum on their Home page now see a Not Attempted enrolment for the same, or similar, curriculum. Administrators may see a large number of inactive completions and a large number of new enrolments.

Cause

Completed enrolments of users in a curriculum may become inactive and have a Not Attempted enrolment created in it's place by the misuse of the FiLMS Auto-Enrolment module.

Solution (incomplete)

1. Analyze curriculums and determine which single curriculum is "known good"
2. Clean up the names and is_active flags of courses, structures, curriculums, classes for all curriculums involved. Mark inactive elements with the tag " (DEACTIVATED)"
3. Merge all the enrolments of duplicate curriculums into one known good curriculum
   1. Admin Console (eg: AHS)
   2. Select a "duplicate" curriculum, that you want to phase out, as "source"
   3. Select the known good curriculum as "target"
   4. Analyze
   5. Execute
   6. All enrolments from source should have been moved to target. The enrolment deemed to have a greater level of completion will be set active and all others inactive
4. Collect the Curriculum ID of the known good curriculum
5. Create a new curriculum as a place holder and collect it's ID number
6. Execute SQL, using your Curriculum IDs, to separate the inactive enrolments from the active enrolments and activate them. Note: A user should never have more than one active enrolment for any one curriculum