appazur.com > Help > Infinite Campus

Infinite Campus

× For documentation customized for you, please click the Help button in your Appazur Dashboard. This page may refer to the Sunnycrest High demo.

You can sync Appazur™ to Infinite Campus™:

Sync Student Contacts via SFTP
Manual Import
Sync Staff Accounts/Contacts
Sync Classes and Class Roster

Sync Student Contacts via SFTP

Infinite Campus can push student contact data to Appazur automatically on a schedule using the Data Extract Utility.

PATH: System Administration → Data Utilities → Data Extract Utility → Data Extract Utility Set Up

This setup should be performed by a technical administrator. You will need to add an Ad Hoc filter or SQL query to produce the correct data for your Appazur app. Please also contact Appazur Support — we will provide your SFTP credentials.

Steps

Navigate to System Administration → Data Utilities → Data Extract Utility.
Click the New icon. A Detail Information section will appear.
Fill in the fields as follows:

Field	Value
Extract Instance Name	Appazur Student Contacts
Delivery Mode	SFTP
File Name	students.txt
File Extension	txt
Column Delimiter	TAB
Character Set	UTF-8
Append Date to Filename	yyyymmddhhmmssSS
Include Header Row?	Yes (checked)
Include Double Quotes?	No (unchecked)
Username	[Appazur Support will supply this]
Password	[Appazur Support will supply this]
Server	[Appazur Support will supply this]
Port	2022
Path	sunnycrest/users

For the data source, select Ad Hoc (or SQL if your technical administrator prefers).
In the Data Extract Schedule section, configure a nightly run:
- Frequency: Daily
- Start Time: Choose a time in the middle of the night (e.g., 2:00 AM)
- Day of Week: Not required as daily is preferred.
Click Save.
Click Test Connection to verify the connection to Appazur’s SFTP server. A pop-up will appear indicating success or describing any connection error.
Click Run Extract to perform an initial transfer, then notify Support so we can verify the data on our end.

Data fields required

The extract must include the following student and contact information.

Data	Notes
Student Number	Unique student ID
First Name	Student's first name
Last Name	Student's last name
Grade Level	Student's grade designation
School ID / School Number	Used to associate the student with a school
Contact 1 First Name
Contact 1 Last Name
Contact 1 Primary Phone	For voice calls
Contact 1 Cell Phone	For SMS text messages
Contact 1 Email Address
Contact 2 First Name
Contact 2 Last Name
Contact 2 Primary Phone	For voice calls
Contact 2 Cell Phone	For SMS text messages
Contact 2 Email Address

Additional contacts (Contact 3, Contact 4, etc.) can be included if needed.

Manual Import

A manual import is useful to test an initial export before setting up automated SFTP, or if your data changes infrequently.

Use Infinite Campus’s Ad Hoc Reporting tool to run a saved student contacts filter and export the results as a CSV or tab-delimited file. Once you have the file:

In the Appazur Dashboard sidebar, go to App Users.
Click the Import button (upper right corner).
Click Add Import Data, choose your file, then click Save to start a dry-run.
When the dry-run completes, review any WARNINGs in the report. 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 Infinite Campus export, ensuring all required columns are present.

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

A student with no contact information.
A teacher assigned to a class but not yet synced to Appazur.
A typo in an email address.

You can repeat this procedure at any time. If there are no changes, there will be no effect on Appazur.

Sync Staff Accounts/Contacts

Appazur staff accounts and contacts can be synced from Infinite Campus using a procedure similar to the above. Please contact Support for assistance or refer to Staff Accounts Import CSV.

Classes and Class Roster

Contact Appazur Support before proceeding as these instructions are subject to change. Infinite Campus supports OneRoster via either SFTP/CSV or the OneRoster REST API.

Classes Option A — OneRoster REST API (Recommended)

Appazur can pull class data directly from Infinite Campus using the OneRoster 1.1 REST API. This requires no file exports or SFTP configuration — Appazur fetches the data automatically on a nightly schedule using a secure API key.

Classes Option B — OneRoster 1.1 CSV via SFTP

Infinite Campus can push data to Appazur using a .zip file via SFTP.

OneRoster Classes API Sync for Infinite Campus

Appazur can pull class data automatically from Infinite Campus using the OneRoster 1.1 REST API and OAuth 2.0, with no file exports or SFTP setup required.

▼ Procedure (click to collapse)

Prerequisites

Before beginning, have the following ready:

OneRoster API base URL — the root URL for Infinite Campus’s OneRoster service, e.g. https://district.infinitecampus.org/campus/oneroster/v1p1
OAuth 2.0 client credentials — a client ID and client secret generated in Infinite Campus (see Third-Party Access below)
Appazur Support — contact Support to provide the credentials and enable the integration

Step 1 — Generate API credentials in Infinite Campus

PATH: System Administration → Resources → Third-Party Access

Click New to create a new third-party access record.
Set the Application Name to Appazur.
Under Scope, enable OneRoster v1.1 read access.
Click Save. Infinite Campus will generate a Client ID and Client Secret.
Note the Client ID, Client Secret, and the base URL for your district’s OneRoster endpoint.
Send these credentials to Support via a secure channel (do not send by plain email).

Step 2 — Appazur Support configures the integration

Support will:

Store the credentials in your brand’s server configuration.
Verify the API connection with a dry-run import.
Enable the nightly scheduled pull (runs at approximately 3:40 AM local time).

Step 3 — Verify the first automated import

After the first nightly run, Support will confirm the classes were imported correctly and appear in your Appazur Dashboard under Classes/Groups.

What data is imported

Each nightly pull fetches:

Organizations (Schools) mapping.
Semesters.
Classes.
Teachers associated with classes.
Student enrollment in classes.

Classes with status other than active are skipped.

Troubleshooting

Symptom	Likely cause
No classes appear	Credentials may be expired or the scope may not include OneRoster
Classes missing instructor	Teacher account not found in Appazur — ensure staff are imported first
All classes show semester 0 (Year-long)	Problem with semesters data — contact Support
Import stopped running	Check SIS section of your Appazur dashboard for last import date

Option B — OneRoster 1.1 CSV via SFTP

Infinite Campus exports class and enrollment data in the OneRoster 1.1 CSV format via the Data Extract Utility. The export produces a ZIP file containing 7 CSV files; Appazur uses classes.csv, courses.csv, enrollments.csv, and orgs.csv to import classes and subscribe students and parents to them automatically.

▶ Procedure (click to expand)

PATH: System Administration → Data Utilities → Data Extract Utility

These queries are expensive — schedule them to run during off-peak hours (e.g., 2:00 AM).

Step 1 — Create an individual extract for each CSV file

You must create one Data Extract Utility entry for each of the 11 OneRoster CSV files. For each file, create a new extract with the settings below, varying only the Extract Instance Name, File Name, and SQL/Prism value from the table in Step 2.

Field	Value (same for all files)
Delivery Mode	SFTP
File Extension	csv
Column Delimiter	CSV
Character Set	UTF-8
Include Header Row?	Yes (checked)
Include Double Quotes?	Yes (checked)
Data source	SQL

Use the SFTP credentials provided by Support for the Username, Password, Server, and Port fields.

Step 2 — SQL/Prism values and file names

File Name	SQL/Prism
manifest	`EXEC extract_V1P1OneRosterManifest @type = 'bulk'`
academicSessions	`EXEC extract_V1P1OneRosterAcademicSessions @type = 'bulk'`
classes	`EXEC extract_V1P1OneRosterClasses @type = 'bulk'`
courses	`EXEC extract_V1P1OneRosterCourses @type = 'bulk'`
enrollments	`EXEC extract_V1P1OneRosterEnrollments @type = 'bulk'`
orgs	`EXEC extract_V1P1OneRosterOrgs @type = 'bulk'`
users	`EXEC extract_V1P1OneRosterUsers @type = 'bulk'`

All CSV header names and file names are case-sensitive.

Step 3 — Bundle into a ZIP file with the Data Extract Zip Tool

After the individual extracts are created, use the Data Extract Zip Tool to bundle them into a single ZIP file for delivery to Appazur.

PATH: System Administration → Data Utilities → Data Extract Utilities → Zip Tool

Click New.
Enter an Extract Instance Name (e.g., Appazur OneRoster Bulk).
Set Delivery Mode to SFTP and fill in your Appazur SFTP credentials.
Set File Name to OR_bulk and File Extension to zip.
Set Append Date to Filename to yyyymmdd so files are not overwritten.
Set Port to 2022 and Path to sunnycrest/classes/.
In the Select instances to include section, check all 7 bulk extracts (e.g., OR_bulk_classes, OR_bulk_enrollments, etc.).
Click Save, then Test Connection, then Run Extract.
In the Data Extract Schedule section, set Frequency to Daily and choose an off-peak time (e.g., 2:00 AM).
Notify Support when the first extract has run so we can verify the data.

Manual import

You can also import the ZIP file manually through the Classes/Groups page in your Appazur Dashboard instead of using SFTP.