OneRoster CSV

 

Lab-Aids offers a host of options for schools and districts to roster their students, teachers, and other staff so that they can access their online curriculum from the Lab-Aids Portal. The Lab-Aids Portal (provided by MagicBox) is OneRoster v1.1 certified.

You have the ability to roster and update account info via OneRoster CSV uploads from your district’s SIS (or other platform), which should be OneRoster v1.1 certified. Below is a list of details that outlines how you'll upload rosters from your SIS to the Lab-Aids Portal.

OneRoster CSV Description

Method: Your district admin will export a set of files from your SIS (OneRoster v1.1 compliant) and upload into the portal. Updates are made by uploading the entire set of files at a frequency of your choice.  Admin will assign licenses to teachers. 

Pros: No manual rostering required. SSO available in some cases. Good alternative to manual rostering for larger districts who can’t integrate with another method.

Cons: Maintaining updated rosters requires a manual SIS export and manual two-step upload by the admin. This upload could be daily, weekly, monthly, etc.

Requirements:

  • SIS (or other source of accounts) that is OneRoster v1.1 compliant (we do not support OneRoster v1.0)

  • Admins established at each school that needs licenses

    • If school admins are not established in the CSV export, district admin must create them manually within the Lab-Aids portal.

  • Users are only associated with one school (org)

  • Users only have one role/user type

  • Classes differentiated by title/name only (no class metadata synced at this time)

  • Obtain parental/guardian permission to share account data for students under the age of 13

  • If passwords are not defined in the files, alternate login/SSO option must be agreed upon with Lab-Aids

District Admin Instructions:

 

1. Export and zip files from SIS:

1. Export the set of files from your SIS. At minimum, you must export these files: users.csv, orgs.csv, manifest.csv, enrollments.csv, courses.csv, classes.csv, academicsessions.csv

2. Zip the files into a folder titled "OneRosterv1p1BaseCSV".zip . 

  • For a successful upload, you must zip the files themselves; do not zip the folder containing the files. 

  • Do not delete the column headings.

  • The zipped file must be named "OneRosterv1p1BaseCSV" each time you upload. Any other name will trigger an error. 

  • At minimum, you must export these files: users.csv, orgs.csv, manifest.csv, enrollments.csv, courses.csv, classes.csv, academicsessions.csv

Click here to download a sample file export.