--- title: Prepare for SFTP file uploads with OneRoster description: Ensure successful SFTP file uploads for OneRoster v1.1 API by gathering credentials, format, and process details. Follow this guide for smooth integration. --- [Skip to content](https://help.schoolday.com/knowledge/prepare-sftp-file-uploads-with-oneroster#main-content) English Show submenu for translations [More support](https://help.schoolday.com/knowledge/kb-tickets/new?hsLang=en) [Customer portal](https://help.schoolday.com/support?hsLang=en) ![gg4l logo](https://help.schoolday.com/hs-fs/hubfs/Automated%20emails/gg4l%20logo.png?width=100&height=33&name=gg4l%20logo.png) - [Go to Knowledge Base](https://help.schoolday.com/knowledge) Open main navigation Close main navigation - [Go to Knowledge Base](https://help.schoolday.com/knowledge) - English Show submenu for translations - [More support](https://help.schoolday.com/knowledge/kb-tickets/new) - [Customer portal](https://help.schoolday.com/support) What are you looking for? - There are no suggestions because the search field is empty. 1. [SchoolDay Help Center](https://help.schoolday.com/knowledge?hsLang=en) 2. [Roster Integrations](https://help.schoolday.com/knowledge/roster-integrations?hsLang=en) 3. [SFTP Integration](https://help.schoolday.com/knowledge/roster-integrations?hsLang=en#sftp-integration) August 9, 2026 # Prepare for SFTP file uploads with OneRoster ## Gather the credentials, file format, and account access you need before uploading OneRoster CSV files to SchoolDay over SFTP This article walks you through what you need before you send OneRoster files to SchoolDay over SFTP. You'll activate your admin account, gather your SFTP credentials, and confirm your CSV files match the [OneRoster file format](https://help.schoolday.com/knowledge/supported-data-standards-oneroster?hsLang=en). Complete these steps first : skipping them is the most common cause of failed uploads. ### Requirements #### *Account and permissions* - **Activate your SchoolDay admin account.** Use the activation link sent to your email. The link expires after 24 hours. Contact [support@schoolday.com](mailto:support@schoolday.com) if the link expires. - **Obtain district data-sharing approval.** Ensure you have authorization before you upload roster data to vendor applications. #### *SFTP credentials* Gather the following credentials: - **SFTP server address.** Provide the hostname or IP address of the SFTP server. - **Port.** Use port 22 (default). - **Username and password.** #### *OneRoster CSV files and format* Format all files in the **OneRoster v1.1 CSV format.** For more information, see [OneRoster File Format](https://help.schoolday.com/knowledge/supported-data-standards-oneroster?hsLang=en). Follow these file format requirements: - **Include active data only.** Include only currently enrolled students and active staff. Do not upload historical or archived records. - **Use UTF-8 encoding.** Verify the file encoding before you upload to prevent corrupted special characters. - **Match headers exactly.** Ensure column header names match the OneRoster specification exactly. To see the complete field list for each file, check the [OneRoster File Format](https://help.schoolday.com/knowledge/supported-data-standards-oneroster?hsLang=en). - **Create unique identifiers.** Ensure each sourcedId is unique within its entity type. Match IDs across files to create relationships. For example, a matching userSourcedId in users.csv and enrollments.csv enrolls that user in a class. - **Use CSV format.** Separate values with commas. Use double quotes only when field values contain commas. - **Choose an upload format.** Upload files individually or compress them into a single .zip archive. #### *Tools* - **FTP client** installed on your machine. WinSCP or FileZilla recommended. ### How to upload For step-by-step upload instructions, see [Create SFTP File Transfer via WinSCP/FileZilla](https://help.schoolday.com/knowledge/sftp-import-filezilla-winscp?hsLang=en). To set up the SFTP Import app in SchoolDay before your first upload, see [Configure an SFTP Integration](https://help.schoolday.com/knowledge/configure-a-sftp-integration?hsLang=en). ### Next steps - [OneRoster File Format](https://help.schoolday.com/knowledge/supported-data-standards-oneroster?hsLang=en): full CSV field specification - [Configure an SFTP Integration](https://help.schoolday.com/knowledge/configure-a-sftp-integration?hsLang=en): set up the SFTP Import/Export app itself - [Automate SFTP File Transfer via Task Scheduler](https://help.schoolday.com/knowledge/file-transfers-to-the-sftp-server?hsLang=en): schedule recurring uploads - [Getting Started](https://help.schoolday.com/knowledge/getting-started?hsLang=en#main-content) - [Introduction](https://help.schoolday.com/knowledge/getting-started?hsLang=en#introduction) - [Getting Started by Role](https://help.schoolday.com/knowledge/getting-started?hsLang=en#getting-started-by-role) - [Get Support](https://help.schoolday.com/knowledge/getting-started?hsLang=en#get-support) - [Legal](https://help.schoolday.com/knowledge/getting-started?hsLang=en#legal) - [Data Management (Connect)](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#main-content) - [Introduction](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#introduction) - [Applications](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#applications) - [Data Mapping](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#data-mapping) - [Data Synchronization](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#data-synchronization) - [Data-Sharing Requests](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#data-sharing-requests) - [Data Quality](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#data-quality) - [Data Privacy (Privacy Shield)](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#data-privacy-privacy-shield) - [Grade Sync Service](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#grade-sync-service) - [Miscellaneous](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#miscellaneous) - [Governance](https://help.schoolday.com/knowledge/data-management-connect?hsLang=en#governance) - [Roster Integrations](https://help.schoolday.com/knowledge/roster-integrations?hsLang=en#main-content) - [Introduction](https://help.schoolday.com/knowledge/roster-integrations?hsLang=en#introduction) - [SFTP Integration](https://help.schoolday.com/knowledge/roster-integrations?hsLang=en#sftp-integration) - [API Integration](https://help.schoolday.com/knowledge/roster-integrations?hsLang=en#api-integration) - [Import Integrations](https://help.schoolday.com/knowledge/roster-integrations?hsLang=en#import-integrations) - [PowerSchool Integration](https://help.schoolday.com/knowledge/roster-integrations?hsLang=en#powerschool-integration) - [Export Integrations](https://help.schoolday.com/knowledge/roster-integrations?hsLang=en#export-integrations) - [Administration & Account Settings](https://help.schoolday.com/knowledge/administration-account-settings?hsLang=en#main-content) - [Account Settings](https://help.schoolday.com/knowledge/administration-account-settings?hsLang=en#account-settings) - [Organization Management](https://help.schoolday.com/knowledge/administration-account-settings?hsLang=en#organization-management) - [SSO](https://help.schoolday.com/knowledge/sso?hsLang=en#main-content) - [Introduction](https://help.schoolday.com/knowledge/sso?hsLang=en#introduction) - [Identity provider (IdP) Setup](https://help.schoolday.com/knowledge/sso?hsLang=en#identity-provider-idp-setup) - [SSO Applications](https://help.schoolday.com/knowledge/sso?hsLang=en#sso-applications) - [SSO Resources](https://help.schoolday.com/knowledge/sso?hsLang=en#sso-resources) - [MFA for Administrators](https://help.schoolday.com/knowledge/sso?hsLang=en#mfa-for-administrators) - [MFA for Users (SchoolDay Login)](https://help.schoolday.com/knowledge/sso?hsLang=en#mfa-for-users-schoolday-login) - [ID Card Login](https://help.schoolday.com/knowledge/sso?hsLang=en#id-card-login) - [SSO Troubleshooting](https://help.schoolday.com/knowledge/sso?hsLang=en#sso-troubleshooting) - [LMS Integrations](https://help.schoolday.com/knowledge/lms-integrations?hsLang=en#main-content) - [Coursera Integration Video Guides](https://help.schoolday.com/knowledge/lms-integrations?hsLang=en#coursera-integration-video-guides) - [Coursera Platform Integration](https://help.schoolday.com/knowledge/lms-integrations?hsLang=en#coursera-platform-integration) - [Qwiklabs Platform Integration](https://help.schoolday.com/knowledge/lms-integrations?hsLang=en#qwiklabs-platform-integration) - [LMS Integrations instructions](https://help.schoolday.com/knowledge/lms-integrations?hsLang=en#lms-integrations-instructions) - [Resource Management (App Store)](https://help.schoolday.com/knowledge/resource-management-app-store?hsLang=en#main-content) - [Users & Classes](https://help.schoolday.com/knowledge/resource-management-app-store?hsLang=en#users-classes) - [Resources](https://help.schoolday.com/knowledge/resource-management-app-store?hsLang=en#resources) - [Access & Security](https://help.schoolday.com/knowledge/resource-management-app-store?hsLang=en#access-security) - [Privacy Governance Console (PGC)](https://help.schoolday.com/knowledge/privacy-governance-console-pgc?hsLang=en#main-content) - [Get Started](https://help.schoolday.com/knowledge/privacy-governance-console-pgc?hsLang=en#get-started) - [Monitor and Report](https://help.schoolday.com/knowledge/privacy-governance-console-pgc?hsLang=en#monitor-and-report) - [Govern Apps](https://help.schoolday.com/knowledge/privacy-governance-console-pgc?hsLang=en#govern-apps) - [For Parents/Students](https://help.schoolday.com/knowledge/for-parents-students?hsLang=en) - [For Vendors](https://help.schoolday.com/knowledge/for-vendors?hsLang=en) - [Updates](https://help.schoolday.com/knowledge/updates?hsLang=en#main-content) - [2026](https://help.schoolday.com/knowledge/updates?hsLang=en#2026) - [2025](https://help.schoolday.com/knowledge/updates?hsLang=en#2025) - [2024](https://help.schoolday.com/knowledge/updates?hsLang=en#2024) - [2023](https://help.schoolday.com/knowledge/updates?hsLang=en#2023) - [2022](https://help.schoolday.com/knowledge/updates?hsLang=en#2022) - [Reference](https://help.schoolday.com/knowledge/reference?hsLang=en#main-content) - [APIs](https://help.schoolday.com/knowledge/reference?hsLang=en#apis) - [CSV File Formats](https://help.schoolday.com/knowledge/reference?hsLang=en#csv-file-formats) [![SchoolDay logo](https://help.schoolday.com/hs-fs/hubfs/schoolday-logo%20(300%20x%20100%20px)%20(1).png?width=300&height=100&name=schoolday-logo%20(300%20x%20100%20px)%20(1).png "SchoolDay logo")](http://schoolday.com) [mailto:support@schoolday.com](mailto:support@schoolday.com) Copyright © 2025, SchoolDay, Inc.