For schools that need to have attendance and tardy data logged in their Student Information System (SIS), manually pulling reports can add a significant administrative load. Make your life easier by setting up automatic reports to be delivered directly through SFTP or an emailed CSV.
Permission Level Required: Owner | District Manager
In this article:
What We Export: Learn which columns are included in scheduled exported reports.
Important Technical Requirements: Ensure that the reports meet your system's reporting needs.
Example Tardy File Template: Use this file as a template for uploading information into your SIS.
Schedule a Report: A step-by-step walkthrough on creating a scheduled report for tardy data.
Setting Up SFTP Delivery: What information is needed to set up delivery via SFTP.
What We Export
Minga’s reporting engine allows you to customize the data points included in your exports. The most common reports used to reconcile data in an SIS are the Behavior History Report (for tardies) and the Check-in History Report (for attendance).
💡 Pro Tip: You can uncheck any column that is not relevant to your specific SIS import requirements to keep your file clean.
Behavior History Report Columns
Behavior History Report Columns
Header | Definition |
First Name | Users first name |
Last Name | Users last name |
ID Number | User's ID number |
Grade | Users grade level |
Role | Role in Minga |
Note | If there was a note included when the behavior was assigned, it will be included in this field. |
Class | The name, start time, and end time of the class during which the behavior was assigned. |
Section ID | The Section ID code from your SIS |
Period ID | The Period number from your SIS |
Term ID | The Term ID code from your SIS |
Section Number | The number that identifies a specific occurrence of a course |
School ID | This is a local identifier assigned directly by your specific school in your SIS |
SIS ID | This is the unique identifier that your SIS uses to identify a specific record |
Behavior | The name of the behavior in Minga. |
Category | The category of behavior (Guidance or Praise). |
Assigned by | The name of the User who assigned the behavior. |
Staff ID | The ID number of the Staff member who assigned the behavior. |
Date | The date the behavior was assigned. |
Time | The time the behavior was assigned. |
Last Modified | If the record of the behavior was modified or edited, a record will show in this field. |
Check In History Report Columns
Check In History Report Columns
Header | Definition |
Reason | The name of the Check In reason in Minga. |
First Name | Users first name |
Last Name | Users last name |
ID Number | User's ID number |
Grade | Users grade level |
Role | Role in Minga |
Note | If there was a note included when the behavior was assigned, it will be included in this field. |
Class | The name, start time, and end time of the class during which the Check In was assigned. |
Section ID | The Section ID code from your SIS |
Period ID | The Period number from your SIS |
Term ID | The Term ID code from your SIS |
Section Number | The number that identifies a specific occurrence of a course |
School ID | This is a local identifier assigned directly by your specific school in your SIS |
Issued by | The name of the User who assigned the Check In. |
Date | The date the behavior was assigned. |
Time | The time the behavior was assigned. |
Last Modified | If the record of the behavior was modified or edited, a record will show in this field. |
Important Technical Requirements
Before setting up your schedule, consult with your IT team or System Administrator to determine:
Required Fields: Which columns are mandatory for your SIS import?
File Format: Does your SIS require a specific header row or date format?
Connection: If using SFTP, you will need the Host URL, Port, Username, and Password for your secure server.
Note: If you do not see an essential field required by your SIS, please reach out to our Technical Support Team.
Example Tardy File Template
Below, we have provided a mock-up of the headers/columns needed to import into your SIS:
For a downloadable file template, see the attached file at the bottom of this article.
Note: The columns highlighted in green (Section ID, Period ID, Term ID, Section Number, School ID) require an active Bell Schedule to be set up in your Minga Instance.
The column highlighted in yellow (Behavior Code) is customized in the scheduled report.
Schedule a Report
Follow the steps below to create a scheduled report to be automatically delivered to your email inbox or to an SFTP server.
Step-by-step Guide to Scheduling a Report
Step-by-step Guide to Scheduling a Report
Open Settings from your main Minga dashboard.
Select the Scheduled Reports tab.
Click the Schedule a Report button.
Report Name: Enter a unique name (e.g., "Daily Tardy Export - Aeries").
Report Type: Select your desired report (e.g., Behavior History Report).
User List (Optional): Filter the report to only include specific students (e.g., a specific Grade level).
SIS Formatting: * Aeries: Select this to auto-format the file for Aeries tardy reconciliation.
Other: Select this for all other systems to receive a standard CSV.
Behavior Code (Optional): Enter the specific attendance code used by your SIS (e.g., "T" for Tardy or "L" for Late).
Frequency: Choose Daily or Weekly.
Time: Select the time you want the report generated (we recommend a time shortly after the school day ends).
Delivery Method:
Email: Enter the email address of a registered Minga user.
SFTP: Enter your server credentials (Host, Port, Path, Username, Password). This is the most secure method for automated SIS syncing.
Click Create.
Setting Up SFTP Delivery
SFTP is the most secure method for automated data syncing. Minga does not host an internal SFTP server. You must provide a destination server managed by your school or district.
To set up SFTP delivery, you will need the following credentials from your IT department:
Host URL: The address of your secure server.
Port: Usually 22 for SFTP connections.
Path: The specific folder where the file should be dropped.
Username & Password: The credentials created specifically for the Minga connection.
💎 Tip: Always run a "Test Connection" if available to ensure your firewall is not blocking Minga's IP address.
FAQs
FAQs
Can I send the automated report to someone who doesn't use Minga?
You can only send automated reports via email to users who are registered with a Minga account. If you need to deliver data to an external party, we recommend using the SFTP delivery method to a shared server.
What is the difference between the Aeries format and the standard CSV?
The Aeries formatting option automatically renames headers and organizes columns to match the specific requirements for Aeries tardy reconciliation. The standard CSV option uses Minga's default headers and is compatible with most other Student Information Systems.
Resources
Tardy Management Setup Guide: A complete guide on Tardy Management in Minga