Export Scheduler for Attendance and Transaction data in Attendance Module

Thursday, November 23, 2017 TimeTec 3 Comments




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 using this feature, you can export the transaction logs automatically for payroll calculations. At the same time, you can configure this feature with other options like Auto Download Transaction and Auto Generate Attendance Record to achieve better work efficiency

Process
To use this feature, go to Attendance module in Ingress software or Scheduling & Attendance module in TCMS V3 software, then select Export Scheduler > Add Scheduler.

There are 3 types of report that you can export:

1. Data Audit List
2. Summary Attendance Sheet
3. Details Attendance Sheet



From here on, you can select Auto Export period (either by Date, Weekly, Daily, Hourly or by Minute). Note that you can also configure the export Running Time and Date.

Export Data Audit List
In Export Data Audit List, you can choose to export the file in 2 template formats. Select the export format template you preferred. Template options are:

1.  Export Type 1 
With Export Type 1, you can select or remove the data fields as you need, example User ID, Name, Clocking Time and Check Type. Note that “No.” refers to the sequence of the data and “Size” refers to the maximum characters for the data field.



2.  Export Type 2
With Export Type 2, you need to type the desired export format and click Verify for system to check and save the data format. The System will show the status: Parse Successful (data format valid) or Parse Failed (data format invalid).



- Next, select the Export Path or location where you want to save the file.
- Select Append Data if you want the System to update the new data that you have exported inside the same file.
- Press OK to Save the Export Scheduler settings.



- To test whether all of the configurations are working based on the settings, please click at Run. ‘Print Job Completed’ message shows that the configurations are working and you can now expect the System to export all of the data based on the scheduler time.
- Check the exported file and the item inside the selected folder for confirmation.

Remark (Updated in Jan 2019):
Please note that there is also an auto export to email feature which is applicable for Details Attendance and Summary Attendance Sheet only:
http://www.fingertectips.com/2019/01/how-to-auto-export-attendance-data-in.html

Related Posts
How To Auto Export Attendance Data in Specified Folder and Email in TCMS V3/Ingress
Auto Generate Report to a Specific Path using Report Scheduler in Ingress and TCMS V3

3 comments:

  1. hello


    When I export Attendance sheet I'll have a crash error you can see screenshot (https://prnt.sc/ns8zf7)

    ReplyDelete
    Replies
    1. Dear Sir / Ma'am,

      Good day to you,

      Referring to your issue, kindly try to install Microsoft .Net Framework 4.7.2 from the link below, run the Ingress again and see whether the problem persists or not.

      http://go.microsoft.com/fwlink/?linkid=863265

      If the problem persists, kindly follow the steps below to solve the issue

      1) Backup your database in System Settings > Database Configuration > Browse Database Server Backup Path > Backup
      2) Uninstall Ingress from Control Panel
      3) lnstall the latest Ingress version from the link below

      https://s3.amazonaws.com/files.fingertec.com/Software+Releases/Ingress/2019/Official+Release+/3.2.0.14+(+11042019+)+-+WDMS+fixed+false+log+photo++++/Ingress+Server+(MySQL).zip

      4) Restart your PC

      Note: Make sure to turn off antivirus and firewall before reinstall

      Thanks & Best Regards,
      Nursyafawani Kasram binti Mohd Hisham

      Delete
  2. hello

    try to configure auto scheduler for data audit DD/MM/YYYY UUUUUU hh:mm:ss, refer to https://prnt.sc/q3q51r but the result did not as i expected (refer https://prnt.sc/q3q5jn).

    seems it stops at employee id, if i put UUUUUU infront of the export format, result is blank

    ReplyDelete

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