Student AOI Import

Use this function to import records into the Student AOI Attendance table. The file to be imported must include a student identifier. This identifier may be either the PowerSchool generated student id, the student number, or the state student number. The identifier to be used must be selected prior to the import.

When the records in the file match existing records, based on the student identifier, schoolid, LMS id, and the start or end time, the records may be updated or ignored. The preferred action must be selected prior to import, or it defaults to update the record. Records without a match will be inserted.

The update rules for LMS ID follow this logic:

If the existing record has a lmsId and the imported record has lmsId, and they match, then the record will update regardless of whether the start and end time overlaps.
If the existing record has a ImsId and the imported record has a lmsId, and they do not match, then the record will not update if a portion of one attendance overlaps the other. If there is no overlap, then it is an insert.

The update rules for records without an LMS ID follow this logic:

If start or end times for an imported record match the start or end times of an existing record (for a date/school/student combination), it is an update. (Start Time matches Start Time or End Time matches End Time)
If Start or End times do not match an existing record and the imported times overlap existing start or end times for the day/student/school combination, then it is an error.

The following fields are required and must be mapped to the database fields:

Student identifier
School Number
Attendance Date
Either minutes attended, or both start and end time.

How to Import Student AOI Attendance Records

On the Start Page, click on Special Functions. The Special Functions page appears.
Click on Importing & Exporting. The Importing & Exporting page appears.
Click on Student AOI Import. The Student AOI Import page appears.
Click on Browse to find the file to import.
Select the following options to complete the import function:

Field	Description
Delimiter	Select Tab or Comma to separate the data presented in the report output.
Student Identifier	Choose one of the following to use as the student identifier: Students.STUDENT_NUMBER Students.ID Students.STATE_STUDENTNUMBER
Should duplicate records be updated or ignored:	Choose one of the following: Update Existing Record – if a duplicate record exists, this option will update the records. Do Not Process Record – if a duplicate record exists, this option will not update the records. Note: a Duplicate is defined as a match of an existing record, based on the student identifier, schoolid, LMS id (if provided) and the start or end time.
Import File Column Map the columns in your file to an applicable PowerSchool Field listed below (unmapped columns will be ignored).
STUDENTS.STUDENT_NUMBER STUDENTS.ID STUDENTS.STATE_STUDENTNUMBER	The unique ID of the student. (One of the three will display based on the Student Identifier chosen above.)
S_AZ__STU_AOIATT_C.ATT_CODE	The attendance code associated with the record. Note: the value imported should match an existing Attendance Code at the AOI School. Not used in reporting, but can be used by Schools to differentiate between Online LMS Time and Face Time with a teacher.
S_AZ__STU_AOIATT_C.ATT_DATE	The date of instructional minutes. Format: mm/dd/yy or mm/dd/yyyy
S_AZ__STU_AOIATT_C.END_TIME	The end time of the instructional session. Format: hh:mm (military-time) Note: As with other Time records in PowerSchool, End_Time is converted to a ‘Seconds after midnight’ value.
S_AZ__STU_AOIATT_C.LMSID	The unique id of the attendance record from the Learning Management System (LMS) where the attendance was recorded. Note: The LMSID field is only used to identify records for update on import. If your LMS does not allow for export of a record ID it may be possible to generate one manually. For example, if your LMS only ever extracts a single record per day for a student, you could concatenate student_number+schoolid+att_date in excel to create a unique ID to be used as LMSID.
S_AZ__STU_AOIATT_C.MINUTES	The amount of instructional minutes in the reported session. Note: Whole minutes should be reported, without seconds or decimals.
S_AZ__STU_AOIATT_C.SCHOOLID	The school ID of the school associated with the attendance minutes.
S_AZ__STU_AOIATT_C.SECTIONID	The PowerSchool sectionid of the instructional minutes.
S_AZ__STU_AOIATT_C.START_TIME	The start time of the instructional session. Format: hh:mm (military-time) Note: As with other Time records in PowerSchool, Start_Time is converted to a ‘Seconds after midnight’ value.