Import attendance record and remark to Timesheet

28-Jun-2022 · Felix Fung

Why import attendance records and remarks to Timesheet?

You may find there are missing attendance records or you may want to add some notes to the Timesheet to record the reason why the staff is late, early out, or missed punch. You do not want to input the time and remark one by one but want to import the attendance records and remarks to the system in batch.

What you need

How to import attendance records and remarks to Timesheet?

Import Attendance Records to Timesheet

  • Find the excel sheet "Attendance" and delete data in the sheet "Remark"
  • Follow the cell format to input Placement Number, RecordDate, and RecordTime 
    • ReaderNumber, ActionCode, and IP are optional fields
    • Remember to delete the template data before importing the file
  • Go to Attendance --> Timesheet --> Import -->Upload the file
    • Select the Month of the attendance data
    • Define the status of the timesheet when importing the file
    • "Template to use" = "General-use Backstage standard version"

Import Remarks to Timesheet

  • Find the excel sheet "Remark" and delete data in the sheet "Attendance"
  • Follow the cell format to input placement number, RecordDate, and Remark 
    • Remember to delete the template data before importing the file
  • Go to Attendance --> Timesheet --> Import --> Upload the file
    • Select the Month of the attendance data
    • Define the status of the timesheet when importing the file
    • "Template to use" = "General-use Backstage standard version"

What's Next

  • Check the staff Timesheet
    • Check the time range of the Shift if you find some attendance records are missing