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.9.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
Move all the global courses (not belonging to a space) to one or more spaces.
Remove all view restrictions from restricted courses

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.