Uploading school data to Apple School Manager

Claris Connect provides an Apple School Manager connector that lets you securely upload school data in CSV file format to Apple School Manager. There are two main steps in the process:

  1. You upload a ZIP file containing a set of CSV files using an SFTP client. This step triggers the Claris Connect flow.

  2. After the flow is triggered, Claris Connect transfers the ZIP file to Apple School Manager. This step is the action in the flow. (As part of this step, the data is converted to ASM format if needed.)

This documentation covers the following:

About uploading school data using SFTP

You might need to use SFTP to upload to Apple School Manager if:

  • Your SIS isn’t currently supported by Apple School Manager.

  • You don’t have a SIS, but you want to import school data from your current system.

SFTP upload requires that you install a third-party SFTP client. Claris Connect and Apple School Manager each generate unique URLs and credentials to use in configuring SFTP upload via that client.

Supported data file formats

Your school data files must be in one of these formats:

  • Apple School Manager CSV

  • OneRoster 1.1 CSV

Apple School Manager provides these templates for your school data:

Template Contents
Students Student account information
Staff Staff account information, such as account information for instructors
Courses Course definitions
Classes Course and instructor information
Rosters Class, student, and location information
Locations Location information

For detailed information about SFTP setup in Apple School Manager and downloading and using templates, see this Apple Support article.

OneRoster is an open standard specification for the exchange of school data. Use OneRoster if your school district has implemented that standard. For information about the OneRoster CSV file format, see the CSV Format section. For uploading OneRoster files to Apple School Manager, the required files are:

  • manifest.csv

  • org.csv

  • courses.csv

  • users.csv

  • enrollments.csv

  • classes.csv

About file accounts in Claris Connect

In Claris Connect, you create a file account for uploading files using an SFTP client. A file account is only available with the Apple School Manager connector. The connector provides a trigger that runs when you upload a ZIP file to your file account.

When you create the account, a host URL and credentials are generated. You use this information when you set up the SFTP client to connect to the host server for the file upload.

After you create a file account, you can use the File Accounts tab in Claris Connect to view the account information, regenerate the password, or delete the file account using the link at the bottom of the page.

You can’t delete a file account if it is in use in a flow. If you regenerate the file account credentials, you must update the connection in your SFTP client.

Creating your flow from the template

Prerequisites

  • You must have an SFTP client installed.

  • You must have prepared your ZIP file of CSVs in either OneRoster or Apple School Manager format.

When you are ready, use a template to create your flow in Claris Connect. The template wizard walks you through a set of preconfigured steps.

  1. Go to https://connect.claris.com/.

  2. Sign in using your Managed Apple ID and password.

  3. On the Templates page, click the Apple School Manager CSV icon or the OneRoster CSV icon.

  4. Review the information needed to complete the template setup, then click Next.

  5. On the Connect page, click Activate Account next to Claris Connect File Account.

    The Claris Connect File Account dialog box appears, displaying the host URL and account credentials.

  6. Copy and paste the password and save it in a safe place.

  7. On the Connect page, next to Apple School Manager, click Connect New Account.

    The Apple School Manager dialog box appears, with the SFTP domain pre-filled.

    The Apple School Manager dialog

    1. Click View how to get the username and password for information on the username and one-time password in Apple School Manager.

    2. Open a new browser window and sign in to Apple School Manager.

    3. Copy and paste the username and the password from Apple School Manager into the dialog box, then click Sign In.

  8. On the Configure page, which displays the trigger step File uploaded to Claris Connect file account, click Save.

  9. Click Next to go to the Finish page, then click Go to Project.

    A dialog box prompts you to enable flow history for the project.

  10. (Optional) Click Enable to turn on the flow history, which provides a record of the flow runs on the History tab. See Viewing flow history.

To trigger the flow:

  1. Upload the school data ZIP file to your Claris Connect file account in an SFTP client. This step initiates the flow run.

  2. After you start the flow run, check the History tab to view the run status.

Click in the flow run to see the status of each flow step, and click each step to view the HTTP response and request. Claris Connect detects and displays errors if the file you uploaded is not in a valid file format.