certification

• 22.x branch is for Sakai 22.
• 21.x branch is for Sakai 21.
• 20.x branch is for Sakai 20.
• 19.x branch is for Sakai 19.
• 12.x branch is for Sakai 12.
• 11.x branch is for Sakai 11.

Student Numbers

Student numbers are supported in the Report interface, and are provisioned through LDAP using the CandidateDetailProvider in Kernel.

useInstitutionalNumericID

This is a boolean value, which defaults to false and controls whether student numbers are enabled system wide.

certification.extraUserProperties.enable

This is a boolean value, whose default is false, which controls whether or not student numbers are enabled.

certification.extraUserProperties.enable = true

Conversion (Course end date)

When upgrading an existing installation to a version that supports the fixed course end date certificate variable, apply conversion/add-course-end-date.sql before starting Sakai if automatic database updates are disabled.

Conversion (Users of versions older than 12.0)

Due to the tool refactor, some tables were renamed and some classes were refactored, a conversion script is required to make it work in the 12.x version and newer.

The table cert_field_mapping was renamed to certificate_field_mapping for consistency reasons:

ALTER TABLE cert_field_mapping RENAME TO certificate_field_mapping;

Some classes were refactored, update the classes of the certificate_criterion table:

UPDATE certificate_criterion SET type = 'org.sakaiproject.certification.api.criteria.gradebook.GreaterThanScoreCriterion' where type = 'com.rsmart.certification.impl.hibernate.criteria.gradebook.GreaterThanScoreCriterionHibernateImpl';

UPDATE certificate_criterion SET type = 'org.sakaiproject.certification.api.criteria.gradebook.WillExpireCriterion' where type = 'com.rsmart.certification.impl.hibernate.criteria.gradebook.WillExpireCriterionHibernateImpl';

UPDATE certificate_criterion SET type = 'org.sakaiproject.certification.api.criteria.gradebook.FinalGradeScoreCriterion' where type = 'com.rsmart.certification.impl.hibernate.criteria.gradebook.FinalGradeScoreCriterionHibernateImpl';

UPDATE certificate_criterion SET type = 'org.sakaiproject.certification.api.criteria.gradebook.DueDatePassedCriterion' where type = 'com.rsmart.certification.impl.hibernate.criteria.gradebook.DueDatePassedCriterionHibernateImpl';

The tool id has been changed for consistency:

UPDATE sakai_site_tool SET registration = 'sakai.certification' WHERE registration = 'com.rsmart.certification';