Import Attendance from Pinnacle

On this page:

Use the Pinnacle Import Utility Page to import attendance from the Pinnacle Gradebook. The import creates attendance records with source set to O (office) or T (teacher) based on the data from Pinnacle. It adds records to the Attendance Audit table and will update the Attendance Bottomline table in the following situations:

The student has no bottomline record for the date and attendance period.
The student has a bottomline record for the date and attendance period with the same source.
If the source of the Pinnacle data is T (teacher) and the student has a bottomline record for the date and attendance period with O (office) as the source and the building is configured to use the Teacher source as the official absence.
If the source of the Pinnacle data is O (office) and the student has a bottomline record for the date and attendance period with T (teacher) as the source and the building is configured to use the Office source as the official absence.

For an overview of the Pinnacle integration, refer to Pinnacle and eSchoolPlus Integration.

Prerequisites

Importing data into eSchoolPlus is a two-stage process. Before you can import data, the data must first be loaded to the staging tables in the eSchoolPlus database. Refer to the documentation for Pinnacle for information about this process.

Import attendance from Pinnacle Gradebook

Select Administration > Utilities > Integration > Pinnacle Import Utility.
On the Pinnacle Import Utility page, set the Import Type field to Attendance.
In the Building field, select the building to process.
In the From Run Date field, select the first date in the range of dates for which you want to import attendance by entering a date or a number of prior days. If you schedule the import to run periodically, use the By Prior Days option and specify the number of prior days to import.
In the To Run Date field, select the last date in the range of dates for which you want to import attendance by selecting Today or entering the date. If you schedule the import to run periodically, use the Today option.
In the Run panel, select to run the import now or schedule it to run.
Click Run.
After the import is complete, check the pinnacle_att_2_MMMDD.log for rejected records.

Import Error Messages

The following error messages may display in log to explain why a record was rejected.

Error	Description
Invalid student ID...	The student ID does not exist in the eSchoolPlus application.
Invalid Absence code...	The absence code has not been configured for the building or which the import was run.
Arrive time is required for this code...	The code given is configured to require an arrival time in eSchoolPlus and no arrival time was provided in the staging table.
Dismiss time required for code...	The code given is configured to require an dismissal time in eSchoolPlus and no dismissal time was provided in the staging table.
Arrive time not allowed for code...	The code given is configured to prohibit an arrival time in eSchoolPlus but an arrival time was provided in the staging table.
Dismiss time disallowed for code	The code given is configured to prohibit an dismissal time in eSchoolPlus but an dismissal time was provided in the staging table.
Course-section-session,...,, does not exist in the master schedule.	The course and section information entered in the staging table does not exist in the master schedule for the current building and school year.
No matching attendance period for course-section-session,...,period,...	No attendance period has been configured to match the start period of the section in the master schedule. This error applies to buildings that take class attendance (a.k.a period attendance).
Source must be (O)ffice or (T)eacher, but was...	The source field in the class attendance staging table must be set to O or T, but it was set to some other value.
Must be AM or PM!	The building in question takes daily attendance (a.k.a. Homeroom attendance), and has two attendance periods configured. These attendance periods are considered AM and PM attendance periods by the import. The daily attendance staging table must have a value of A or P in its am_or_pm field or this error will be issued.
Must be full day!	The building in question takes daily attendance (a.k.a. Homeroom attendance), and there is only a single attendance period configured. The building is considered to take full day attendance. The daily attendance staging table must have a value of F in its am_or_pm field or this error will be issued.