Skip to main content

Import/Export Attendance

Dylan B.
  • Updated

Imports give the district or BOCES the ability to import attendance from another system. Please follow the instructions below to learn how to import attendance.

 

  1. Login to SchoolFront as Admin, Attendance Admin, Attendance Coordinator, Attendance Supervisor, Benefits Coordinator, Business Office, HR Team, or HR Admin.
  2. Go to "Time & Attendance" -> "Import/Export" -> "Attendance Import/Export"
  3. Download the Excel file labelled "Empty Data Sheet" to get the proper file format and the list of existing items or download the Excel File labelled "Current Data Sheet" to export.
  4. Save the file to a location on your computer as you will need to access later.
  5. Open the file from the saved location, make the additions and edits, and then save and close the file.
    • Required Columns on the Excel File in this order. Do not include other columns.
      • Employee Name - Must match SchoolFront.
      • Employee ID - Must match SchoolFront.
      • Position - Must match a valid position in SchoolFront.
      • Attendance Group Name - Must match a valid group in SchoolFront.
      • Code - Must match a valid code in SchoolFront.
      • Date - Date absence occurred
      • Time Entry - Amount of time
      • Time Units - (Days, Hours, Minutes)
      • Import Type - (Accrual or Attendance)
      • Accrual Type - Type of accrual
      • Scheduled Time - Original start time
      • Comment - Comments
  6. Click the "Choose File" button, and find the saved file containing the updates.
  7. Click the "Preview Import" button.
  8. You will then be presented with the items in the file. You can review the information to validate your changes. If any required columns are missing, they will be listed as errors and the "Import Data" button will not be available. Extra columns will be listed as warnings and ignored.
  9. Click the "Import Data" button to continue or the "Cancel Import" button to prevent the data from being updated.
  10. You will then be presented with the Import Summary, listing the number of rows processed and whether they were Skipped, Inserted, or Updated. You may also be presented with row-specific errors, should any exist. It will list the row number, column name and the problem with the data. An example of this would be an email address that is not in the proper format.

Related articles