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

  1. Update Smart Courses for Confluence - LMS to the latest versions, 7.4.0 is the minimum required version.
  2. Update the Confluence Cloud Migration Assistant to the latest version.
  3. Enable migration-assistant.app-migration.feature at <Confluence_URL>/admin/darkfeatures.action.
  4. 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.
  5. Make sure that the authors of the restricted courses have the add restriction right in the chosen spaces.
     
  6. Remove possible duplicate entries,  PLEASE BACKUP YOUR DATABASE BEFORE EXECUTING THE BELOW SQL CODE 

     Click here to expand...
    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 metrics 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 are not supported currently on cloud but all their sessions will be migrated.

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 Terms 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 the screen similar to the one.