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

Friday, October 02, 2015 FingerTec 1 Comments

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 represents a record in the database, or a row in a spread sheet. Each field in a database record or cell in a spread sheet row is usually separated by a comma. However, you can use other characters to delimit a field, such as a tabulator character.

Benefit

FingerTec has released the latest version of Ingress software (v3.0.3) that includes the exporting of Data from Audit List in either TXT or CSV format. These transaction data are the raw data output obtained from the terminal. You can use the raw data in the third party software or payroll system that requires TXT or CSV file format.

Process:

Follow the steps below on how to Export Data from Audit List to either TXT or CSV format.

1) Log in to Ingress software > Attendance Tab > Select Data Audit List from the left panel > click
    on Export Data Audit.

 
 
2) In the Export Audit Data window, select Export Type 2.
 
3) Type in the desired export format and click Verify to lock and save the data format. System   
      will show the status of either Parse Successful or Parse Failed.
 
4)  Select at least a minimum of one User and choose the Output Target File where you want to
      save the exported file.
 
5)  Specify the effective date and time.  
 
Note: If you want to save the data for 1 day, i.e. 20.08.2015, you must key in the date range from 20.08.2015 to 21.08.2015 and enter 00.00 in both time columns.
 
 
6)  Press Ok once you are done with the all the settings. The system will generate the request
      and a successful message will be prompted once it is completed.
 

7)  You can open the file directly or you can get the file inside the target folder. Below are the
      examples of the output files in TXT and CSV format.

  
      TXT


     CSV


1 comment:

  1. How i can export all data to TXT file as the below format?
    • Each line must have exactly a fixed length of 50 characters.
    Company Emp No Date In Date Out Time In Time Out Shift
    12345 678910111213141516171819202122232425 2627282930313233 3435363738394041 42434445 46474849 50

    Exm:
    • Company Number: 10
    • Employee Number: 1000010
    • Date In: 22 - Feb - 2016
    • Date Out: 22 - Feb - 2016
    • Time In: 09:00 AM
    • Time Out: 13:00 PM
    • Time In: 14:00 PM
    • Time Out: 17:00 PM
    • Shift: Standard shift

    TXT File:
    000101000010 2016022220160222090017001

    ReplyDelete

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