Load Data from MOOC
Last updated
Was this helpful?
Last updated
Was this helpful?
login to
username:
click reporting
-> Subjects
-> View all reports
Find Complete by Courses (Created by yeesiang for Campus ID usage. DO NOT DELETE.)
and click view report
button
Click run report
button
Download the generated CSV file when it is completed.
Goto Central backend > Services
> MagicOps
> Load Completed DBA
Follow instruction submit download CSV
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.