Data Upload UI and SFTP Server

A. Data Upload UI

UI for getting real time feedback on data loads prior to sending automated files
For use for one time or data uploads or for districts that choose not to do an automated integration with SchooLinks
You need a special capability on your SchooLinks account to access this tool. To gain access, please reach out to your implementation manager

We create SFTP accounts for each of our partner districts.

You can access the credentials for your SFTP account from our Data Upload UI if you have the proper access using the steps outlined below

url: sftp.schoolinks.com

username: district-specific sftp username

password: district-specific password

port: 22

remote home directory: if you're connecting with a SFTP client and need this, it is / (it will appear as the root)

In your home directory when you login to the SFTP server, you will see four folders. They have specific use cases as explained below:

/automated/ - this is where we'll be expecting files with very specific naming conventions and formats.
- When you drop a file here, it kicks off an automated ETL process to update data about your students in the SchooLinks database. Only put filenames that we're expecting here, because they won't process otherwise.
- We process files whenever you drop them here so timing doesn't matter, but if possible we do ask that you use overnight batch processing for files that are sent on a nightly basis.
/other/ - when you deposit a file here, we do not immediately try to process the file. You can treat this kind of like a drop box. There are specific files with formats that we will request deposited here, but there may be scenarios where there is ad hoc data you want to send. This is the place to put it. If you upload a file and would like for SchooLinks to process it, notify your Customer Success Manager or the Data Support team that the file has been uploaded.