Demo Portal Administration
Deploying Course to Demo Portal
Vault request
Vault request
Follow the instructions
Importing
List Courses
http://demo.icomproductions.ca/admin/course_list.php
Upload Course Package
Upload Progress
Confirm screen
Edit Imported Course
They prefer the follow naming convention:
(Company name) - (Course name)
eg: ENMAX - Online Benefits
Add this course to the *NEW* topic so the sales team can see what's new by clicking on that tab on their home page.
Enroll Self
Structure selection
Select Class
Org/Group Catalog
Confirm
Home
Demo Portal group
A new group with an auto-enrollment for the newly imported course will allow the Sales Team to share the course.
They prefer the follow naming convention:
(Company name) - (Course name)
eg: ENMAX - Online Benefits
Enroll "All Courses (990+)" group
This is how Admins know which courses are available to them.
http://demo.icomproductions.ca/includes/modules/FM_EnrollmentWizardWithoutEvent/index.php
Rename "demo" courses "[DEMO]"
UPDATE courses
set name = REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(name, ')', ''), '(', '') , 'demo', 'DEMO'), 'Demo', 'DEMO'), 'DEMO', '[DEMO]')
WHERE name LIKE '%DEMO%'
AND name NOT LIKE '%[DEMO]%'
AND is_active = 1;
UPDATE courses
set name= REPLACE(name, '-[DEMO]',' [DEMO]')
WHERE name LIKE '%[DEMO]%'
AND is_active = 1 ;
NEW topic cleanup
/* Remove old new ones */
DELETE FROM course_topic_assn
WHERE topic_id = 49;
/* Add newest ones */
INSERT IGNORE INTO course_topic_assn
SELECT c.id AS course_id, 49 AS topic_id
FROM enrollments AS e
LEFT JOIN curriculums AS cu
ON cu.id = e.curriculum_id
LEFT JOIN structures AS s
ON s.id = cu.structure_id
LEFT JOIN courses AS c
ON c.id = s.course_id
GROUP BY e.curriculum_id
HAVING MIN(enrolled_at) > '2018-07-19'; /* Make this your target date */
DEMO courses not with Singles groups
SELECT *
FROM curriculums
WHERE id NOT IN
(
SELECT curriculum_id
FROM fm_autoenroll_assn AS aa
LEFT JOIN groups AS g
ON g.id = aa.group_id
WHERE g.parent_id = 52 /* Singles parent */
)
AND is_visible = 1
AND name LIKE '%[DEMO]%';
Add DEMO courses to All Courses (990+)
INSERT INTO fm_autoenroll_assn
SELECT 18 AS group_id, id AS curriculum_id
FROM curriculums
WHERE id NOT IN
(
SELECT curriculum_id
FROM fm_autoenroll_assn AS aa
WHERE group_id = 18
)
AND is_visible = 1
AND name LIKE '%[DEMO]%';