Step 1: Create the file.
The file that will be uploaded to your Secure File folder has the same format as the one-time manual roster file. For instructions on how to create that file: see Roster File Contents.
Step 2: Upload the file to your Secure File folder in Forefront.
Navigate to your Secure File folder in Forefront, located in your All Resources folder (learn more here). The folder that you will upload this file to will be named "2026-2027". You should not have to create this folder, it will be created for you automatically. The file name does not matter.
Step 3: Setting up the import in Forefront.
Tell the Forefront system to import the file you uploaded to your Secure Files folder and tell us when you would like to run the import. Navigate to the "Jobs" page using the side navigation tab.
1. Click on the "Add New Scheduled Job" button in the "Scheduled Jobs" section of the page.
2. Select "SFTP Roster Import."
3. Finish creating the scheduled job.
"Schedule Expression" is what determines how often your import will run and when. The value of the Schedule field is a "Cron Expression". For more information on how to write cron expressions see this Wikipedia article. By default, the job will run at midnight GMT.
Confirm the file that's imported for the job.
The import will automatically run the next time the scheduled time is reached. To test the file, click the "play" triangle icon by the scheduled job. It will run when clicked.
Troubleshooting:
Issue: Error that says "unknown column headers" when using a PowerSchool export.
PowerSchool defaults to a Carriage Return to delineate each line of data. This needs to be changed to a Line Feed.
Need more support?
Submit a support request or email our team at [email protected].