Import attendance record and remark to Timesheet

To import attendance records and remarks to Timesheet, you need an import template.

Please download the attachment at the bottom.

Import Attendance Records to Timesheet

1. Find excel sheet "Attendance" and delete data in the sheet "Remark"
2. Follow the cell format to input placement number, RecordDate, and RecordTime 
   • ReaderNumber, ActionCode, and IP are optional fields
   • Remember delete the template data before importing the file
3. Go to "Attendance" --> ''Timesheet''
4. "Import" --> Select the excel template you have edited
   • you can define the status of the timesheet when importing the file
   • Please choose "General-use Backstage standard version" as the "Template to use"

Import Remarks to Timesheet

1. Find excel sheet "Remark" and delete data in the sheet "Attendance"
2. Follow the cell format to input placement number, RecordDate, and Remark 
   
   • Remember delete the template data before importing the file
3. Go to "Attendance" --> ''Timesheet''
4. "Import" --> Select the excel template you have edited
   • you can define the status of the timesheet when importing the file
   • Please choose "General-use Backstage standard version" as the "Template to use"