SIS Data Requirements for CatapultCONNECT
CatapultCONNECT uses data from your Student Information System (SIS) to automatically build and maintain communication groups for students, staff, and families. To support this, your district will provide data exports that are securely transferred to CONNECT and updated regularly (typically nightly). This article outlines the required file formats, structure, and data expectations for a successful integration.
Table of Contents:
- StudentExport.csv
- StaffToStudentExport.csv
- AttendanceExport.csv (If Attendance Alerts are enabled)
- SchoolExport.csv (One-Time File)
Key Requirements
- File Format: CSV (comma-separated values)
- File Transfer: Secure upload via SFTP
- Headers: Must be included and cannot be modified or reordered
- File Names: Must remain unchanged
- Data Updates:
- Core files (Staff, Student, Staff-to-Student) should be uploaded nightly (before 11:30 PM PST)
- Attendance files (if used) should be uploaded ~30 minutes before alerts are sent
- School Data: Provided as a one-time export
Required Files
1. StaffExport.csv
Used to define staff users and their associated sites.
Required Fields:
- ID – Unique staff ID from SIS (can be numeric or alphanumeric)
- School – School code (one per row; multiple schools require multiple rows)
- Name.First – Staff first name
- Name.Last – Staff last name
- Email – Staff district email
- Title – Staff role/title
Optional Fields:
- Mobile_number – Staff mobile phone
2. StudentExport.csv
Used to define students and their associated contacts.
Required Fields:
- ID – Unique student ID
- School – School code
- Name.First – Student first name
- Name.Last – Student last name
Common Fields:
- MobileNumber / Email (only include if students receive alerts)
- ContactNamePrimary
- ContactPhonePrimary
- ContactEmailPrimary
- ContactNameSecondary
- ContactPhoneSecondary
- ContactEmailSecondary
Additional Optional Fields:
- ZipCode
- Grade
- BusRoute
- LunchBalance
- PrimaryLanguage
- PreferredContactMethod
3. StaffToStudentExport.csv
Defines relationships between staff and students (used for messaging groups).
Required Fields:
- School – School code
- Teacher – Must match Staff ID from StaffExport
- Student – Must match Student ID from StudentExport
- Period – Class period, homeroom, or “0”
- Name – Course name
Optional Fields:
- Course_number
- Section_number
4. AttendanceExport.csv (If Attendance Alerts are enabled)
Used to trigger automated attendance notifications.
Required Fields:
- School – School code
- Student – Must match Student ID
- Period – Must align with StaffToStudentExport
- Absence.code – Defined by district
Optional Fields:
- Teacher.name
- Date (format: MM/DD/YY)
5. SchoolExport.csv (One-Time File)
Used to create site structure within CONNECT.
Fields:
- School Site Name
- Address
- Phone Number
- Optional: Merge with Site ID (for combining locations)
Additional Notes
- If a staff member is associated with multiple schools, they must appear in multiple rows (one per school).
- Student and staff IDs must remain consistent across all files.
- File structure and naming must remain unchanged to ensure successful processing.
Need Help?
If you're unsure about formatting or setup, our team will work directly with your IT staff to guide the process and validate your data.