How to Fix the Customized User Duty Roster Import Errors for TimeTec TA
Introduction
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
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).
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.
0 comments:
Have any questions or inquiries about FingerTec? Drop your input here.