Aeries SIS has developed a CSV extract process based on the OneRoster® 1.1 specification. OneRoster is a standard for securely exchanging data between student information systems (SIS) and other applications such as Learning Management Systems (LMS). More information is available on the IMS Global website: http://www.imsglobal.org/activity/onerosterlis
By using the OneRoster standard, Aeries can ensure interoperability with other vendors that have implemented or will implement the same standard.
To configure the extract, first go to the OneRoster Extract Config page under School Info | Imports and Exports in the navigation tree.
The OneRoster CSV extract can be sent to multiple third-party vendors. Each vendor must have a file server that supports file transfer using the SSH File Transfer Protocol (also known as Secure File Transfer Protocol or SFTP). Click the Add Vendor button to configure a vendor to receive the extract.
Enter the following information, then click Save:
||The name of the vendor
||SFTP Server name or IP address
||If you want the files to upload to a folder other than the root, then put in the folder name that is already on the SFTP site.
||Port number (default for SFTP is port 22)
||Username to connect to the SFTP server
||Password to connect to the SFTP server
Select the schools that should be included in the extract
Configure the following values for the scheduled process:
|Days to run SFTP
||Days of the week to run the scheduled extract
||Time of day to run the scheduled extract on the selected day(s)
||Address to receive a confirmation email when the process completes. Multiple email addresses can be entered, separated by commas.
|Scheduled Process Button
||Disable or Enable the scheduled extract process
Click Save to save all the options on the page.
When you are ready to schedule the extract to run on a regular basis, click Enable Scheduled Process. Now the process will run on the schedule you have specified and automatically upload the CSV files to the vendor(s).
This section is intended both for Aeries Administrators and for vendors receiving the OneRoster CSV extract from Aeries.
Aeries currently supports most, but not all, of the files in the OneRoster 1.1 specification. Detailed information about the file specifications is available on the IMS Global website: https://www.imsglobal.org/oneroster-v11-final-csv-tables
All files are created using the bulk processing method. The extract from Aeries does not currently support any delta processing.
The SFTP transfer will include a single zip archive named OneRoster.zip that contains all of the csv files.
||Gradebook Assignment Types (GBT)|
||Master Schedule (MST) - secondary schools and Elem w/MST schools
Teachers (TCH) - elementary schools
||Student Class Schedules (SEC)
Course Attendance Record (CAR)
||Gradebook Assignments (GBA)|
||Gradebook Scores (GBS)|
Student Data (STU)
Portal Accounts (PWA)
Portal Accounts (PWA)
User Names (UGN)