User Guide‎ > ‎

Sample Roster Excel File for Import

There are two import formats for Roster Table

1. By Period

Please note that the first column is [PERIOD] and the columns [1],[2],[3] refer to 1st day, 2nd day, 3rd of the Attendance Period. ([1] must be at column C) So If the Attendance Period is starting from 1st of current month, [1],[2],[3] referring to 1st, 2nd, 3rd of the month.  
However, if the Attendance Period is starting from 20th of last month, [1] referring to 2015/06/20, [2] referring to [2015/06/21] etc.

Download Sample Excel File 

2. By Month

When the first column is [MONTH], the [1], [2], [3] refer to 1st, 2nd and 3rd of the month, in the above example, i.e. 1st November, 2nd November and 3rd November. This format will not consider Attendance Period Settings.

Download Sample Excel File. Or you can generate a similar format by clicking the Export button in Roster Enquiry.

  1. Please note that if the [ROSTER_CODE] is not exists in the Roster Table, the import will create a new Roster Table for that Roster Code.
  2. [DESCRIPTION] in column C is optional. If the column [DESCRIPTION] exists in Column C, it will update the Description of the Roster Code during the import process.

See also