Exporting Attendance Data in Ingress for Better Data Management

Friday, June 19, 2015 FingerTec 5 Comments

Introduction
FingerTec Ingress can export attendance data into several formats including .xls, .xlsx, .txt and .csv.

There are 2 types of Export in Ingress: 
  1. Export Details provides you with clocking details such as the In, Out, Break, Resume, OT and Done times of each user per day.
  2. Export Summary simplifies clocking data such as Total Workday, Total Present,  Total Short time, etc for a specific date range.

Benefits
This function lets users export their attendance data to other software or payroll system for further analysis and augmentation with just a few clicks. You can also retrieve your data from the software anytime to prevent you being stuck in one system, providing you options to shift to a better system if need be.

Process
You can export the attendance data by going to the Attendance module in Ingress. To export the data, you need to follow these instructions:
Click the Export button > configure the template for the export > Click on the Template Configuration button.

Right click at Template Details, and click Add Template Details. Rename the template according to your preferences. Click the Edit button, and specify all the related fields.

The most important part here is for you to specify the Output Target file. You can choose the format of file to be saved, whether in .txt, .xls, .xlsx, or .csv format.
If you choose .txt format, the 3 parameters below the Output Target File will be enabled, while other formats do not support these features. Please select the data on the left-side table, and use the left or right arrow to select the fields you want to export. The up and down arrow on the right side is for you to sort the columns of your output file.
If you are using Flexi schedule with job-costing function, you need to check the “Job Cost” check-box at the bottom of the window, so that the output file will show the job-costing data correctly.
After you are done with the template configuration, click Save and Close. You will be reverted back to the Export page. Here, you need to first select the Template, and make sure the Output Target File name appears on screen. Once done, please select the users which you want to export the data to, and select the date range. Click on the Export button, and your file will be ready.

5 comments:

  1. I need to get day type and week day both in report.

    can you please help me

    ReplyDelete
    Replies
    1. Regarding your issue, kindly explain in details regarding your issue, which report that you're referring. For further details, you can send us a screenshot and explain your issue to support@fingertec.com

      Delete
  2. Hello there,
    when clicking on Export, the progress bar to the left stops at 2% or more and no files being created. I've tried over and over and changed the target folder and formats and it's still the same, please advise.

    ReplyDelete
    Replies
    1. Hi Sir,


      Good day.


      Firstly, you need to make sure that you are using the latest version of Ingress software. You can get it from here: https://s3.amazonaws.com/files.fingertec.com/Software+Releases/Ingress/2017/3+-+++v3.1.0.7+03-03-2017/Ingress+Server(MySQL).zip

      Then, make sure you configure the template correctly, because if no template, the system will not able to export the data.

      Try to update your Ingress software and try it again. Make sure you backup your database before you update your software.

      To update your software, uninstall the current Ingress software from control panel. After that, install using the latest one that you download from the link given.

      If there is any other information required, do let me know so I may assist you accordingly.

      Thanks & Best regards,
      Tengku Sulaiman

      Delete
  3. I'm using the latest version of TCMS V3!!

    ReplyDelete

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