Load Data from MOOC

1. login to https://mymagic.bloomplatform-ap.com/

2. username: [email protected]

3. click reporting -> Subjects -> View all reports

4. Find Complete by Courses (Created by yeesiang for Campus ID usage. DO NOT DELETE.)and click view report button

5. Click run report button

6. Download the generated CSV file when it is completed.

7. Goto Central backend > Services > MagicOps > Load Completed DBA

8. Follow instruction submit download CSV

9. Copy all the generated queries and paste into database (you need to do this manually).

Dont worry, as you can see the SQL queries perform an INSERT... ON DUPLICATE... so existing records in database will be check and replace accordingly, instead of creating duplicate recornds.