Exporting Data from Attendance Sheet into CSV Format in TCMS V2

TCMS V2 is a comprehensive and powerful management software designed exclusively for FingerTec's facial, fingerprint and card system terminals. Part of what makes the software so flexible is its ability to export data for integration with third party applications. Read below for a step-by-step guide on how to export data from the  TCMS V2's Attendance Sheet into comma-separated value (CSV) format.

Step 1

Open the TCMS V2 software > Attendance Sheet > Click Export.

Step 2

Select the Employee ID and range of Date to be exported > Choose between Export Detail or Export Summary.

Step 3

Tick on Delimited with double quotation mark and separated with comma > Click ASCII > Voila! The exported file will have the CSV formatting. 

Example Resulting Text File (Data with CSV format)

Example Resulting Text File (Data w/out CSV format)

• Related Articles

• TCMS V3 / Ingress - Displaying Header for Text and CSV file when Exporting Attendance Data

  Introduction FingerTec has recently introduced a new feature for Ingress and TCMS V3 software, where users can show the header in a text or CSV file when exporting the Attendance data. This enhancement gives the flexibility for the user to import the ...

• Ingress & TCMSv3 Software - Exporting Data from Audit List to TXT and CSV format

  Introduction CSV file, also known as Comma Separated Values file, allows data to be saved in a table structured format. You can use this CSV file format to exchange data from a database or a spreadsheet between applications. Each line in a CSV file ...

• Export Data from the Attendance Sheet to Microsoft Access Database

  Good news to users who are using Access database software. By using the TCMS V2 software, you can now export data from the Attendance Sheet into Microsoft Access Database format. There are various types of third party software out there using Access ...

• Exporting Attendance Data in Ingress & TCMSv3 for Better Data Management

  Introduction FingerTec Ingress and TCMSv3 can export attendance data into several formats including .xls, .xlsx, .txt and .csv. There are 2 types of Export in Ingress: Export Details provides you with clocking details such as the In, Out, Break, ...

• Export Scheduler for Attendance and Transaction data in Attendance Module

  Introduction We have recently introduced a new feature within Ingress and TCMS V3 software, where you can export the Attendance and Transaction data automatically by date or time into the dedicated folder path under Attendance Module. Advantages By ...