TCMS V3/Ingress Software - How To Import Different User Leave Type And Remark From Excel

Monday, August 27, 2018 TimeTec 2 Comments

Introduction
In TCMS V3/Ingress, the system has the option “Batch Update Planner”, whereby users can assign the same Leave Type and Remark for all users or selected users at any one time without the need to repeat the same process for each user.

However occasionally, there are various users that are on leave with different leave types and remarks. Therefore, the easiest way to import all the data is to place the data in the Excel file and upload the file into TCMS V3/Ingress Software. Hence, this can help reduce both time and workload as the system can import all kinds of different leave types and remarks without requiring the user to repeat the process. To do so, please refer to the steps below:

Process:
1. Users will need to fill in all leaves or remarks in the Excel File following the format given in
 the software.

You can download a sample Excel file from the link given: (https://s3.amazonaws.com/files.fingertec.com/Yusri+Tools/Sample+Excel/sample+import+leave+and+remark.xlsx)


2.  To begin the process, click Attendance sheet > Edit > Import > Browse the Excel file > Import.
 


EXAMPLE:
Excel Data -


Attendance Sheet Before Importing File.


List Of Leave And Remark That Will Be Imported.


Attendance Sheet After Import.


That’s it, you're all done and you can now make use this handy tip to better improve your experience with our Smart Solution.

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.