Automate the Update feature (advanced)
On this page:
About update automation
For system administrators who maintain thousands of students across large schools or districts, updating student information in mySciLEARN can be an almost daily task. To facilitate this process, mySciLEARN lets you automate the Update feature to run on a regular basis, keeping your mySciLEARN students up-to-date and in sync with your student information system (SIS).
For example, you can create a script that gets the latest student information from your SIS, formats it as a CSV file, and runs a command to securely upload that information to mySciLEARN, where it's processed as a regular student update. When the update completes, you'll receive an email with the results, including any errors.
Using the commands
mySciLEARN provides three endpoints that let you remotely manage student updates from the command line: start, status, and cancel. Access these endpoints using cURL. All three endpoints require authentication and use HTTP over SSL encryption. Follow these tips:
- Run the updates at night or on the weekends, when your students are not using the product.
- Capture the command line output in a log file for later reference.
- A district manager staff account for mySciLEARN, which includes a login email and password. If you don't have one, contact a mySciLEARN district manager and have them add an account for you. Use an email address suitable for receiving ongoing status emails.
- Your mySciLEARN district server name. To find it, log in to mySciLEARN and click the Manage tab. The URL will start with your server name. For example, the server name in https://ondemand4.scilearn.com/slc is ondemand4.
- A CSV file with your student information that conforms to our format requirements. See Step 2 – Edit and format the CSV file.
Start
This command uses an HTTP POST request to submit your student information to the mySciLEARN district server, which sends an email with the job results. Enter the CSV filename (and path as needed), your district manager credentials (login email and password), and the district servername; for example, ondemand4.
You can run either of these commands to start the update (if one does not work in your environment, try the other):
curl -F file=@filename.csv -F login=login email -F password=password https://servername.scilearn.com/slc/studentupdate/start
Example: curl -F [email protected] -F [email protected] -F password=1234Abcd https://ondemand4.scilearn.com/slc/studentupdate/start
curl --form file=@filename.csv --form login=login email --form password=password https://servername.scilearn.com/slc/studentupdate/start
Example: curl --form [email protected] --form [email protected] --form password=1234Abcd https://ondemand4.scilearn.com/slc/studentupdate/start
Status
This command checks the status of your last update job: completed, still running, or canceled. Note that completed updates may include students who were not updated due to errors.
You can run either of these commands to check the status (if one does not work in your environment, try the other):
curl -F login=login email -F password=password https://servername.scilearn.com/slc/studentupdate/status
Example: curl -F [email protected] -F password=1234Abcd https://ondemand4.scilearn.com/slc/studentupdate/status
curl --form login=login email --form password=password https://servername.scilearn.com/slc/studentupdate/status
Example: curl --form [email protected] --form password=1234Abcd https://ondemand4.scilearn.com/slc/studentupdate/cancel
Cancel
This command cancels your current update job, if one is actively running. The server sends an email with the canceled job results. Note that the command only cancels the update for students that are still in the queue waiting to be processed; students that have already been updated when you run this command will remain updated.
You can run either of these commands to check the status (if one does not work in your environment, try the other):
curl -F login=login email -F password=password https://servername.scilearn.com/slc/studentupdate/cancel
Example: curl -F [email protected] -F password=1234Abcd https://ondemand4.scilearn.com/slc/studentupdate/cancel
curl --form login=login email --form password=password https://servername.scilearn.com/slc/studentupdate/cancel
Example: curl --form [email protected] --form password=1234Abcd https://ondemand4.scilearn.com/slc/studentupdate/cancel