Dashboard > Help > Skyward

Skyward

You can sync Appazur™ to Skyward™:

• SFTP
• Manual Import
• Sync Student Contacts
• Sync Classes
• Sync Class Roster
• Student Absence Notifications
• Sync Staff Accounts/Contacts

You can configure data to be transferred automatically (typically nightly), or manually upload CSV files to your Appazur Dashboard.

For each export type, choose the Export Template you used last year, or click Add if this is the first time.

SFTP

You will need to configure SFTP in Skyward:

• Name: Appazur SFTP
• Protocol: SFTP
• Host: [Appazur Support will supply this information]
• Port: 2022
• Username: [Appazur Support will supply this information]
• Password: [Appazur Support will supply this information]
• Remote Path: [Appazur Support will supply this information]

To see the results of your SFTP data transfers, follow the instructions for Manual Import (below) but do not click Add. You'll see the list of all the recent imports.

Manual Import

A manual import is useful to test an initial CSV export, before setting up SFTP, or if your data doesn't change very often and you don't want to set up SFTP.

1. From the Appazur Dashboard Home page, go to the page for the data you want to import, such as Classes/Groups or App Users.
2. Click the Import button (in the upper right corner).
3. Next click Add Import Data, choose your CSV file, then click Save to start a dry-run of your import.
4. When the dry-run import completes, review any WARNINGs in the report, and if there are no ERRORs or obvious concerns, click Import.

If you get an ERROR, you cannot proceed. Review the error message, and double check your Skyward export, especially your choices on the "Export Records" screen.

Typically there will be some minor WARNINGs, which do not prevent you from proceeding, such as:

• A student with no contact information in Skyward (as of the last nightly automatic contacts sync).
• A teacher assigned to a class but not in the last nightly automatic staff sync.
• A typo in an email address.

You can do this procedure any time, as often as you like, to keep the system up to date so that the correct families receive notifications. (If there are no changes then there will be no effect on Appazur.)

Sync Student Contacts

Your student contact data is required for the optional Mass Notification capability.

Your CSV file must contain the following fields:

• Student ID
• Stu First Name (Student's first name)
• Stu Last Name (Student's last name)
• Cur School Code (school ID)
• Student Grade (Student's grade designation)

In addition, include your parent/guardian name, email, and phone fields, e.g.:

• F1/G1 Frst Name
• F1/G1 Last Name
• F1/G1 EMail
• F1/G1 Cell Ph
• F1/G1 Pri Phone
• F1/G2 Frst Name
• ...

Please export a CSV file including a header row (i.e. Appazur expects the first row to have the field/column names).

Classes

You can import the list of all classes for the current year from your Student Information System (SIS). Appazur Support can customize how classes are listed, to ensure that a student or parent can find the correct section of a course to subscribe to. For example, we can configure your app to append the period, section, and/or teacher's name to the course name provided by your SIS.

Your CSV file should contain the following fields:

• Course_Code - Unique class code, required.
• Course - Course or class name, required.
• Email - teacher email, required (for permissions and contact link).
• Semester - YR/S1/S2 (optional)

Please export a CSV file including a header row (i.e. Appazur expects the first row to have the field/column names).

See also: Dashboard Guide: Classes.

Class Roster

If you wish to upload your class roster to Appazur so that families are subscribed to all of their classes automatically then follow this procedure. (This will add all the classes to Appazur, and also subscribe the families to the classes.)

The roster can also include Bus Routes, Sports Teams, and any other group you'd like to subscribe students and parents to. You just need to make sure that you enter the class code in the Dashboard to match the code in this CSV file.

Your CSV file should contain the following fields:

• Student Id
• Code

where Code is a unique class code for every class (section) or a code for your bus route, team, or other group.

Please export a CSV file including a header row (i.e. Appazur expects the first row to have the field/column names).

Student Absence Notifications

Please contact Support for assistance.

Learn more: Student Absence Notifications

Sync Staff Accounts/Contacts

Appazur staff accounts/contacts could be synced to your website OR to Skyward. Please contact Support for assistance.

If syncing from Skyward to Appazur, use Export File Builder (screenshot below) to export a CSV file with the following column headings. Please note that these are case-sensitive.

Skyward Field	CSV Heading
First Name	First_Name
Last Name	Last_Name
Work Email Address	Email
Entity Name	Category
Title	Title
Employee ID	Staff_Code
Phone	Cell_Phone¹
Phone	Home_Phone¹

The file may be synced automatically over SFTP, or imported manually.

¹Cell_Phone or Home_Phone need only be exported if you wish to use SMS Text or Voice Mass Notification to communicate with staff who are not using the app.

Learn more: Staff

---

Skyward is a trademark of Skyward, Inc.

Top of page