This article is for districts that utilize our 2 file rostering via sftp. Provided are a series of questions to help ensure your files meet requirements and avoid common errors. If you need further assistance with your files or errors, please contact ST Math support at support@mindresearch.org.
Download the 2 File Template: 2file_rostering.zip
When building your files:
- Are your files named correctly?
- students.csv
- admins.csv
- Do your header names match the template exactly?
- Did you include all active data, not just changes? Any data removed from the files will be removed from ST Math.
When building your required students.csv:
- Do your header names match the template exactly?
- Do you have data in the required fields on students.csv?
- iid
- district_teacher_id
- teacher_email
- teacher_last_name
- teacher_first_name
- grade
- student_id
- student_last_name
- student_first_name
- student_username
- student_password
- permanent_login
- Be careful if you have any leading zeros to always include the leading zeros on all files.
- Is your iid 8 characters or less?
- Are your district_teacher_id(s) unique and constant across the district?
- Are your teacher_email(s) the teacher’s district assigned email addresses?
- Are your teacher_email(s) unique across the district?
- Do your teacher_email(s) have no special characters other than a hyphen or underscore?
- Are your grades mapped per our instructions?
Rostering Value Pre-Kindergarten Transitional Kindergarten Kindergarten Grade 1 Grade 2 Grade 3 Grade 4 Grade 5 Grade 6 Grade 7 Grade 8 Grade 9 Grade 10 Grade 11 Grade 12 Field Value (not case sensitive) -2, pk, prek, or Prekindergarten -1, Transitional Kindergarten, or tk 0, Kinder, k, kg, or Kindergarten 1 2 3 4 5 6 7 8 9 10 11 12 - Are your student_id(s) unique and constant across the district?
- If IDs must be changed, please contact support@mindresearch.org as changing IDs will result in errors for the account and may result in lost progress or access.
- Are your student_username(s) unique and constant across the district?
- Did you provide a password?
- Is permanent_login one of the following:
- text
- visual
- blank (no type provided will default to text)
- Is action empty?
When building your optional admins.csv:
- Do you have the required fields on admins.csv?
- iid
- district_teacher_id
- last_name
- first_name
- postion
- access_level
- Be careful if you have any leading zeros to always include the leading zeros on all files.
- Did you include only school administrators and staff without sections that need access to ST Math?
- Teachers assigned to a class are created via students.csv
- Is your iid 8 characters or less?
- Are your district_teacher_id(s) unique and constant across the district?
- Are your email(s) the administrator's district assigned email addresses?
- Are your email(s) unique across the district?
- Do your email(s) have no special characters other than a hyphen or underscore?
- Is position one of the following:
- lab_tech
- principal
- assistant_principal
- math_coach
- program_coordinator
- Is access_level for all administrators school_level?
When submitting your files:
- Did you follow the instructions for uploading roster files to a sftp?
- Are your files in the /home folder within your sftp?
- Did you upload your files with all active data?
- Remember: Any data removed from the CSV files will be removed from ST Math.
- Are your files named correctly?
- students.csv
- admins.csv
- Did you upload students.csv?
- The required students.csv file must be present for upload to be processed. The admins.csv file is optional and does not have to be present for the upload to process.
- Did you upload your files by 9 pm your district's local time?
- If these are your first set of files or you are actively working with your Regional Implementation Manager, did you email your Regional Implementation Manager when you uploaded your files?
Ongoing/Year to Year Rostering:
- Contact ST Math support at support@mindresearch.org in the following situations:
- When you begin submitting roster files with data for a new school year.
- iid(s) change.
- student_id(s) change.
- district_teacher_id(s) change.
- email(s) change.
If you need further assistance with your files or errors, please contact ST Math support at support@mindresearch.org.