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 i
n 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.
Assessing the app for Cloud migration
1. Navigate to Confluence Administration > Migration Assistant.
2. Click ASSESS AND INSTALL APPS.
3. Select Needed in cloud for the Smart Courses app. Choose the status for the rest of the apps.
4. Continue.
5. Click Choose cloud site.
6. Enter the site to migrate from and select the cloud site which data will be migrated to.
7. Check Allow Atlassian to access migrations data.
8. Confirm.
9. Return to the Migration Assistant section.
10. Select Manage Your Migration.
11. Click Create new migration.
12. Click Connect to cloud.
13. Name the migration.
14. Click Choose cloud site.
15. Enter the site to migrate from and select the cloud site which data will be migrated to.
16. Check
17. Confirm.
18. Click Choose what to migrate.
Make sure to select the option All users and groups. Select Click Next.
19. Select spaces you want to migrate.
20. Click Add to migration.
21. Check errors and warnings.
22. Click Review Migration.
23. Click Run now.
24. The migration starts. Click View details to monitor the progress.
25. Upon completion, you will see a screen similar to the following one.