Red Rover Import

Modified on Thu, Oct 3 at 10:50 AM

About

This task will use SFTP to retrieve a Year to Date Daily Attendance File from Red Rover and then import it into SchoolFi.

The file should be a TAB delimited file with the following columns:

Column	Sample	Description
Staff ID	1234	(Local) Staff Id of the employee as on the demographics tab.
Employee Full Name	Zinn, Chris	Last Name, First Name of the employee as on the demographics tab. Used only to log when the employee cannot be found in SchoolFi by their Staff Id.
Date	9/15/2030	Date of the attendance transaction in Month/Day/Year format.
External Absence Entitlement Code	V	This must math an Attendance Code on the Setup - *Calendars - Attendance Codes* screen.
Units	1.00	Only values of 1 or .5 are accepted. Any other value will log an error.
Day Part	Full Day	Allowed Values: Full Day Half Day Afternoon Half Day Morning
Unit Types	D	This value is ignored by the import process

The file is first loaded into memory for processing.

For each unique employee in the file...

For each unique attendance date for that employee in the file....

Skip to the next unique attendance date If the records in memory match what is in SchoolFi

Check to see if the employee has a primary calendar. If not, show an error and continue to the next date

Delete all existing Employee Attendance records in SchoolFi for this unique date (IF the date is TODAY or Before).

Future records are never deleted from SchoolFi.

Post the records from memory to SchoolFi for this unique date

[This logic runs to determine if a record was deleted in Red Rover and if it must be deleted in SchoolFi also)

Load into memory all Attendance daily records in SchoolFi the school year for this employee

For each existing attendance daily record in SchoolFi for this employee

If there are no attendance records in memory from Red Rover for this date, they are deleted.

If the staff attendance calendar in SchoolFi has 1.25 for a day (instead of 1) then...

The logic will compare the 1 in the filt to 1.25 in the daily, and a .5 in the file a .625 value in the daily.

The attendance will be posted as 1.25 or .625