Migration Path

Please follow this step-by-step guide to migrate Smart Courses data to Confluence Cloud. Reach out to our support team for more details: help@creativas.io .

Pre-requisites

Update Smart Courses for Confluence - LMS to the latest versions, 7.6.0 is the minimum required version.
Update the Confluence Cloud Migration Assistant to the latest version.
if you moved contents between spaces, please follow these steps to prevent you from experiencing an incident related https://jira.atlassian.com/browse/CONFSERVER-77826
Navigate to the Dark Feature page for your product at <Confluence_URL>/admin/darkfeatures.action
Add migration-assistant.app-migration.feature in the text box.
Click add or submit
Add migration-assistant.app-migration.dev-mode in the text box.
Click add or submit
Make sure that the courses you are migrating belong to the targeted spaces for migration. If it is not the case, simply move the courses to the appropriate spaces. If you migrate all spaces, make to move all the global courses (not belonging to a space) to one or more spaces.
Make sure that the authors of the restricted courses have the add restriction right in the chosen spaces.

Remove possible duplicate entries, PLEASE BACKUP YOUR DATABASE BEFORE EXECUTING THE BELOW SQL CODE

DELETE from bodycontent dc 
where dc.contentid IN 
(select c.CONTENTID
from CONTENT c
INNER JOIN content d
ON (((c.PREVVER is not null AND d.PREVVER is not null) OR ((c.PREVVER is null AND d.PREVVER is null AND c.creationdate < d.creationdate)))   AND c.pageid = d.pageid)
WHERE (c.VERSION = 1  and d.version = 1)
AND (c.CONTENTTYPE = 'CUSTOM' AND c.TITLE = 'courseAuthors' AND c.pluginkey ='com.atlassian.confluence.plugins.confluence-content-property-storage:content-property') 
AND (d.CONTENTTYPE = 'CUSTOM' AND d.TITLE = 'courseAuthors' AND d.pluginkey ='com.atlassian.confluence.plugins.confluence-content-property-storage:content-property')
);

DELETE from  contentproperties cp 
where cp.contentid IN 
(select c.CONTENTID
from CONTENT c
INNER JOIN content d
ON (((c.PREVVER is not null AND d.PREVVER is not null) OR ((c.PREVVER is null AND d.PREVVER is null AND c.creationdate < d.creationdate)))   AND c.pageid = d.pageid)
WHERE (c.VERSION = 1  and d.version = 1)
AND (c.CONTENTTYPE = 'CUSTOM' AND c.TITLE = 'courseAuthors' AND c.pluginkey ='com.atlassian.confluence.plugins.confluence-content-property-storage:content-property') 
AND (d.CONTENTTYPE = 'CUSTOM' AND d.TITLE = 'courseAuthors' AND d.pluginkey ='com.atlassian.confluence.plugins.confluence-content-property-storage:content-property')
);


DELETE from content rc 
where rc.contentid IN 
(select c.CONTENTID
from CONTENT c
INNER JOIN content d
ON (((c.PREVVER is not null AND d.PREVVER is not null) OR ((c.PREVVER is null AND d.PREVVER is null AND c.creationdate < d.creationdate)))   AND c.pageid = d.pageid)
WHERE (c.VERSION = 1  and d.version = 1)
AND (c.CONTENTTYPE = 'CUSTOM' AND c.TITLE = 'courseAuthors' AND c.pluginkey ='com.atlassian.confluence.plugins.confluence-content-property-storage:content-property') 
AND (d.CONTENTTYPE = 'CUSTOM' AND d.TITLE = 'courseAuthors' AND d.pluginkey ='com.atlassian.confluence.plugins.confluence-content-property-storage:content-property')
);

commit;

SQL

Important information

The insights will be migrated along with the courses.
The course administrators will be migrated, it is always possible to add new collaborators if needed.
Scorm courses sessions will be migrated. You need to reupload the SCORM course content to Cloud.