Canadian Natural Contractor Portal
CNRL Contractor E-Learning Portal is a FiLMS instance with a custom login & home page.
Admin Team:
Training.Systems@cnrl.com
kristen.goudie@cnrl.com
Kelsey.Samms@cnrl.com
Support
Video Tutorials
https://docs.google.com/drawings/d/1JuUS-YMlhT2gOsKjdTA-rJkydy3VuPziYVjR7vaLG9s/edit?usp=sharing
Missing courses?
Examity provides Tier 1 support on behalf of ICOM. Their help documentation:
HR Support:
If company name does not exist during registration, contact: Training.Systems@cnrl.com
Mining courses:
The Mining group manually enrolls users on a case-by-case basis
Users looking for enrollments in mining courses should email: Mine.Training@cnrl.com
Organization admins:
Administrators at an individual organization, eg: Ledcor Site Services, may need to print the Earned Certificates of other employees at their company
These Administrators can be given the role of: Reporter only Organization
This role allows these admins to report on their organization
End-User Support
The User Home page has a Support button
The Support page includes this HTML end-user doc that lives here:
The source file can be edited here on Google Drive:
An updated version can be downloaded as HTML (zipped)
Unzip & rename the HTML file: documentation.html
HTML file & images folder can be uploaded using SFTP on AWS here:
/www/vhosts/cnrlcontractor/webroot/htdocs/orgresources/1/FM_CNRL_ContractorHomepage/documentation.html
Deployment
Instructor-Led
ICOM provides Instructor-Led versions select Brain-Flash courses. They differ from the normal course in this way:
Auto-next lesson
Lesson unlocked
Scrubber unlocked
No certificate
Client developed
CNRL will send support tickets to have courses they have developed to deploy to FiLMS.
Download zip from FTP location (/horizon/HR/Icom Productions/To ICOM/)
FTP connection details available here
New?
When deploying courses to cnrlcontractor.icomproductions.ca, make sure to do two very important steps
1) Make the course available to all organizations. This is done on the course screen at the bottom.
2) Make the class associated to no organizations, it should say "Select One"
Update?
CNRL asks for frequent updates to Horizon Contractor Orientation - Part 1 & 2. This can be performed by Update Files Only
Admin
New Company
CNRL adds new companies themselves. They do this to limit duplicates.
Deactivate Course
* Actions:
** Course? Set inactive
** Auto-Enrollments? Delete all
* Result:
** Launchable? Not by anybody
** Reporting? Enrollment data maintained but not visible in Report Builder
Withdraw Enrollments for Contractor Organizations
* Actions:
** Enrollments? Delete "Not Attempted" and inactivate for non-CNRL users
** Auto-Enrollments? Delete all
** Classes? Change global access to CNRL only
* Result:
** Launchable? Only by CNRL
** Reporting? Enrollment data maintained but not visible in Report Builder
Delete all auto-enrollments
DELETE
FROM fm_autoenroll_assn
WHERE curriculum_id = [YOUR_CURRICULUM_ID]
Delete all no-visits
DELETE
FROM enrollments
WHERE curriculum_id = [YOUR_CURRICULUM_ID]
AND visits = 0
AND is_complete = 0
AND id NOT IN
(
SELECT enrollment_id
FROM results
)
Inactivate non-CNRL
UPDATE enrollments
SET is_active = 0
, notes = CONCAT(COALESCE(notes,''),' ~~~~~~~~~~~~
mjohnson 2018-09-20: Withdrawal')
WHERE curriculum_id = [YOUR_CURRICULUM_ID]
AND user_id NOT IN
(
SELECT id
FROM users
WHERE organization_id = 1
)
Set Global Deployments as non-Global
CNRL sometimes asks that Globally deployed courses (everyone is enrolled) be switched to non-Global courses they can still manually enroll specific users.
Delete all auto-enrollments
/* Delete all auto-enrollments */
DELETE
FROM fm_autoenroll_assn
WHERE curriculum_id = [YOUR_CURRICULUM_ID]
Delete all no-visits
/* Delete all no-visits. Filters for no visits, incomplete and no results */
DELETE
FROM enrollments
WHERE curriculum_id = [YOUR_CURRICULUM_ID]
AND visits = 0
AND is_complete = 0
AND id NOT IN
(
SELECT enrollment_id
FROM results
)