How to Export and Import Roster from TimeTec TA Easily with Excel files

Wednesday, July 31, 2019 TimeTec 0 Comments

Introduction 
TimeTec TA is a cloud-based attendance system designed for companies of different sizes. To ease the updates of a large number of employees into rosters, import from Excel file is recommended. Hence, users can modify the data and information of the user roster by exporting it using an Excel file without having to access multiple modules in TimeTec TA.

Process 
1.   Login to TimeTec TA with your admin account, then go to SCHEDULE > Customise User Duty Roster. Click edit to make changes to the selected settings.

2.    From Customise User Duty Roster module, you may see all the listed schedules by clicking on ( < ) icon on the right page for references.

3.  Click Export  > select Year and Month you wish to export > Select user > (confirm) to start exporting User Duty Roster

4.   Exporting of user file roster information can be done per organisation chart to make the process easier and more organized. The users can be viewed in an organization structure, following the steps below:

5.    Inside the Excel file you can see the user information in TimeTec User ID, year, month and days.


6.    The import file starts with "user ID" "year" "month" followed by “day type (W – workday, R – restday, O – offday and H – holiday) > schedule number”.

* (Note: Leave Type must be same as specified in TimeTec TA)

7.    Next, to import the edited User Roster file into TimeTec TA, go to SCHEDULE > Customise User Duty Roster > Import.

8.    Browse the edited Excel file and click Confirm to complete the process.


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 info@timeteccloud.com, we will update it as soon as possible.