How to Fix the Customized User Duty Roster Import Errors for TimeTec TA

Wednesday, September 01, 2021 TimeTec 0 Comments

Each user has their duty roster, which contains their duty on the specific dates. Choose weekly, bi-weekly, or yearly calendar views and click at the table column to edit the Schedule or add Leave or Holiday. Sometimes, when importing the user duty roster from Excel, some errors may occur when the Excel format changes. Below are the type of errors and how to fix those errors.

Import User Error

Check the leave type spelling.
The leave type spelling in the import Excel file must be the same as in the system. Therefore, the admin needs to refer to the correct spelling of the leave type name to import the file. 

The leave type can be referred to in the Company module. Go to the COMPANY > Leave Type.

Wrong Schedule Number
Schedule number is vital for the system to determine the schedule assigned to the user. The schedule listing is available on the right side of the page in Customise User Duty Roster Module.

Month Days available
Some months in a year have different days. Therefore, the user needs to check the code assigned to the unavailable day in Excel. E.g. September only has 30 days in a month. Therefore, the remaining days in Excel need to be filled with 0 (will be filed 0 by default if the file is exported from TimeTec TA).

Import files with “Name”
When exporting a file from the TimeTec TA, the user will have an option to export the file with the “Name” column. The rules also apply when a user wanted to import the file into the system. The admin needs to know whether the file is exported with or without the name column. 

Note: If some of the screenshots or steps viewed here are different from the ones in the current system, this is due to our continuous effort to improve our system from time to time. Please notify us at, we will update it as soon as possible.


Have any questions or inquiries about FingerTec? Drop your input here.