On SchoolStatus Connect, you can assign a Student Attribute label to a student profile. This feature can be used to store details about a student's demographic, and educational requirements, as well as logistical information like bus routes and extracurricular activities.
This article will include instructions on how to sync the Student Attribute update with SFTP.
1. Prepare an SFTP folder.
In order to set up an automated SFTP sync, you need to have an SFTP folder to drop the CSV file. You can use a folder on your SFTP site. If you don’t have one, Connect support will happily create a folder for you on our server. Please reach out to our Support.
2. Send the student_attributes.csv file to the SFTP folder.
The student_attributes.csv file must use specific formatting to upload successfully. You'll find the complete guide on how to create this file here.
Please review the CSV file and other settings and make sure everything is set up as you want it to be.
Automated Student Attribute sync works as part of a daily sync.
Student Attributes SFTP sync works as part of a daily sync, meaning that if the daily sync runs at a District level, the Student Attributes sync should be set up at a district level too.
File name and format
The file name can be anything but you will have to let our team know first so we can record it and once it is set, you will have to keep using the same file name. E.g. student_attributes.csv
The format is “.csv”
The encoding is UTF-8 or ASCII. If your file uses another encoding (e.g. ISO-8859-1) and cannot be converted to UTF-8, please let us know about it at email@example.com.
If you’re not sure about the file encoding, you may feel free to proceed with the setup. We’ll be able to help you at a later stage if encoding-related issues arise.
Test the files by uploading the attributes manually before enabling the sync. You can follow the instructions here. When successful, proceed to step 4.
4. Enable the sync.
Connect will create an initial sync configuration for you. You can then adjust the settings to ensure the sync meets your needs.
a. Click the School or District Settings.
b. Click SIS Rostering.
c. Click SFTP Sync for Student Attributes and Guardians.
d. Toggle the Student Attributes Sync Enabled button on and click Save.
SFTP Login - your SFTP log-in email.
SFTP Password - your actual SFTP password.
SFTP Host - The SFTP domain where your files are accessed and shared.
SFTP Path - where the files live in your SFTP server.
5. Launch the sync.
The sync is now enabled and will automatically run as part of the Daily sync in the evening.
To run the full sync now, please click the Start SIS Sync button at the top of the SIS Rostering page.
6. Check sync results.
After the sync is complete, please check the sync reports or verify family rosters visually on District and School Directory and Classroom pages.
Please note that SchoolStatus Connect Districts and Schools that do not have SIS Rostering Integration can still use the Student Attributes feature except for the uploader and the syncing feature.