Students
Log into eSchool and launch Cognos from Menu > My eSchoolPlus > Cognos.
Click on the "+ New" option and choose "Report".
In the next screen, where you have options for "Templates and themes," choose "Blank."
Once in the Report Studio, click "Select a Source" in the left pane and then choose Packages > Student Management System Packages > eSchoolPLUS Admin - Arkansas.
From there, double click the fields you need from the list on the left into the main report area. Generally, you should start with "Student ID" as the first field and then, once that has been added, drag/drop the filter for "active students" onto that Student ID column to limit the report to only active students.
Fields:
Student First Name
Student Last Name
Student Building
Student Grade
Guardian First Name
Guardian Last Name
Guardian Phone
Guardian Email
Once all fields have been added, click the "save" icon in the top-left and choose "Save As". Save the report in Team Content > Student Management System > District Shared > "School Name" folder and create a new folder named "Apptegy".
Attendance
Return to the main Cognos Screen.
Click on the "+ New" option and choose "Report".
In the next screen, where you have options for "Templates and themes," choose "Blank."
Once in the Report Studio, click "Select a Source" in the left pane and then choose Packages > Student Management System Packages > eSchoolPLUS Admin - Arkansas.
From there, double click the fields you need from the list on the left into the main report area. Generally, you should start with "Student ID" as the first field and then, once that has been added, drag/drop the filter for "active students" onto that Student ID column to limit the report to only active students.
Fields:
Attendance Date
Attendance Code
Attendance Period
Click on the header for "Attendance Date." Click the filter icon and choose "Create Custom Filter".
Set the filter as "After" and choose yesterday's date.
Click the "save" icon in the top-left and choose "Save As". Save the report in Team Content > Student Management System > District Shared > "School Name" folder and create a new folder named "Apptegy".
Sending the export
Once the report has been saved to the previously created folder, you will create a "Job" for each time the export is sent. You can have multiple reports per job.
To start, click the "+ New" and choose "Job."
In the next screen, click the + sign in the top right to add the student report as a job step. Then hover over the report and click the pencil icon to edit that report's settings.
In the report's settings, change the format to "CSV."
Then add "Send report by email" as the Delivery. Once that is selected, click "Edit Details" on the far-right.
In the next screen, remove the user's email and replace it with the sis+ email address that you've been given in a 1Pass link, if you have not received it reach out to Apptegy. If you'd like to receive the email, you can add yourself in the cc field.
Ensure the body of the email is completely empty and then, below the editing window, deselect "Include Link," select "Attach report output," and then click "Close."
Save the export by clicking the save icon in the top-left. Once saved, you should be able to click "Run Now" to manually run that job.
Then, click "Schedule" to schedule the time that job should run (for the student file, it should send overnight) and then save one last time by re-clicking the save icon in the top right.
Repeat the above steps to schedule the attendance export, setting the time for about 30 minutes before you would want to send an attendance alert.