Click on a topic for more information.
OneRoster™ Overview
The OneRoster™ standard has been developed by IMS Global Learning Consortium® to facilitate the exchange of roster information and grades between an educational organization and a software vendor. OneRoster™ is a trademark of IMS Global Learning Consortium, Inc. (www.imsglobal.org). FitnessGram® supports importing roster data, including classes, users, and enrollments, using OneRoster™ v1.1 compliant CSV files transferred within a zip file. FitnessGram® does not currently support importing or reading rostering data via a OneRoster™-compliant REST API.
The OneRoster™ specification allows for two types of processing: bulk (full) and delta (incremental). Both of these are supported by FitnessGram®.
Bulk imports will essentially override the roster data for your entire district to match the file; i.e. adding new records, updating existing records, and inactivating missing records. FitnessGram® requires 7 OneRoster™ CSV files for bulk processing: manifest.csv, orgs.csv, users.csv, classes.csv, enrollments.csv, academicSessions.csv, and demographics.csv. FitnessGram® does not use and therefore does not require any additional CSV files to perform a bulk import. The OneRoster™ specification lists courses.csv as an additional requirement; however, since FitnessGram® does not use or store any course data, this file may be safely omitted.
Delta imports only specify records that should be updated. This functions much like the standard FitnessGram® import process, where records not included in the file are left alone. There are no required files other than manifest.csv, but the files that are included must meet all validation requirements (detailed under the File Templates section). If records are marked as “To Be Deleted”, then validation requirements are ignored, other than columns with the requirement indicated as Always or Only for Delta.
Bulk or delta processing for files is specified for each individual file in the manifest.csv.
Import with SFTP
OneRoster™ zip files can be imported via the SFTP protocol. Data is encrypted in transit and at rest throughout the import process.
This option is recommended for districts that will be doing frequent data imports or have a SIS vendor or other service (such as ClassLink) that enables automatic SFTP transfers. This option allows you to schedule files for automatic processing (outside of the FitnessGram® system).
District-specific FTPS credentials are available by selecting the “View FTP credentials for automated imports” link on the Import page.
For SFTP troubleshooting tips, please refer to the tips from the standard FitnessGram® import process.
ClassLink Integration
For districts leveraging ClassLink, FitnessGram® is available in the ClassLink App Library. Here’s how to add and assign apps within ClassLink.
You must select OneRoster v1p1 as the Export Template; FitnessGram® does not support version 1.0 of the OneRoster™ specification.
If you need a Custom Export to meet state requirements on state licenses, you can follow these steps or contact ClassLink Support for assistance on setting one up.
SFTP Setup Note: SFTP setup can be done via the File Export section of ClassLink. You can find your district’s unique SFTP credentials in our platform by going to Data Management > Import > Look for “View FTP Credentials for automated imports.” at the bottom of the page. These credentials are unique to your district. Please copy and paste your FitnessGram SFTP username after the “/” in the path field.
ClassLink Frequently Asked Questions
What will happen to our existing accounts? Will existing data merge into new accounts?
If the IDs match, the accounts will merge. An ID mismatch will cause errors within your import if all other data matches. However, if all the other student information provided is different, ex. email, username, and ID, the accounts will be considered different and duplicated, which will separate past data from the users. To avoid this, before sending any files, you should check the school and student IDs in the FitnessGram software.
How long will it take for accounts to be created?
As soon as data is sent to FitnessGram it usually takes between 5-60 minutes to appear in FitnessGram. View the import history tab to monitor progress.
How do Admin accounts get created and how will admins login?
Admins are managed within the FitnessGram software by a current administrator.
Users are trying to SSO but keep receiving an error. Why?
User IDs will need to match between both platforms. The userID within FitnessGram should match the sourceID within ClassLink. If students are required to have stateIDs and the sourceID within ClassLink is not a stateID, unfortunately, students will be unable to SSO. Teachers are not required to have stateIDs; import files can include the teacher sourceID from ClassLink to override the teacher userID within ClassLink. If an issue still persists, please reach out to our help desk.
File Templates
Download OneRoster™ v1.1 Templates
The following tables detail the CSV file specifications for bulk and delta imports. As mentioned previously, fields listed with a requirement of “Yes” may be left blank ONLY for records marked to be deleted within a delta import. For all other cases, these values must be specified.
All fields are case-sensitive and order-specific in adherence with the OneRoster™ standard. In addition, all fields other than those prefixed with “metadata.” must be specified in the appropriate file, even if all the values will be blank or the description indicates the column is not used by FitnessGram®.
FitnessGram® requires additional data, not necessarily required in the OneRoster™ standard. Please review the CSV specifications and examples below and note additions. A summary of items you should check is listed under the Before You Import & Troubleshooting Tips section.
Jump to a specific table:
Before You Import & Troubleshooting Tips
In order to avoid errors an unexpected results, please review the following before importing a OneRoster™ file.
Do I want to override existing users’ usernames and passwords? If no, then ensure that the Update Usernames and Passwords setting is set to “No” on the Import page under the Settings tab. If you do want to override these values, then check the box for the duration of that specific import.
Does my file meet all OneRoster™ v1.1 requirements? FitnessGram® does not support v1.0 of the OneRoster™ standard.
Are all the schools I’m importing actively licensed within FitnessGram®? Every school included in the import must already exist within FitnessGram®, have a Local Identifier that matches the school ID, and be assigned to an active license.
Do the user and class IDs match the existing user/class Local Identifiers within FitnessGram®? Any user or class IDs that are not found in FitnessGram® during the import will be created. In order to avoid creating duplicate records, it’s important to ensure that these identifiers are set correctly prior to the import. If your district requires a “mass update” of Local Identifiers (for instance, if you recently changed SIS vendors), please send an Excel file with the old (existing) and the new Local Identifiers to the FitnessGram® Help Desk, with both columns clearly labelled.
Do all students have demographics specified with Birth Date and Sex? FitnessGram® requires these values for all students since they are necessary to calculate scores based on their test event results.
Is my district’s School Year Start Date set correctly? The import validation will require every academic session with dependent classes to a Start Date no earlier than the School Year Start Date specified for your district, and an End Date no later than one year after the School Year Start Date.