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

Friday, October 02, 2015 TimeTec 9 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's Ingress & TCMSv3 software comes with a feature for 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.

Note:
The images below are from Ingress software, however the steps also apply to TCMSv3 which has a slightly different interface.

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


9 comments:

  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
  2. How can Get terminal User list as a TEXT File.

    ReplyDelete
    Replies
    1. Hello Sir,

      Regarding to your query, you can generate the Terminal User Listing report under Report tab (refer picture http://prntscr.com/ndi7dq). Then you can save or convert the report as txt file or other format (refer picture http://prntscr.com/ndi7vq).

      Regards

      Delete
  3. Is there another way of exporting clocking data to a third party software like payroll, say, from the Attendance Sheet, where you can create a template? Is this the same?

    ReplyDelete
    Replies
    1. Dear Sir,

      Good day to you.

      In regards to your inquiry, you can export the attendance data by using the export attendance sheet option in the software. Go to Attendance > Export Attendance Sheet (refer https://prnt.sc/uns7jn) > Select Details or Summary and Template Configuration (refer https://prnt.sc/uns7yt) > Set the template (refer https://prnt.sc/uns8wt) > Select User > Set Date Range > Click Export (refer https://prnt.sc/uns9c7).

      Delete
  4. This comment has been removed by the author.

    ReplyDelete
  5. We know how hard it is to keep track of what is currently in your data center. Our data center audits allow you to get control over investments already made, determine the items you can dispose of and end monthly maintenance contracts on redundant or obsolete items, and make better decisions going forward. data center audit


    Company name 4sight Technologies (Pvt) Ltd
    Phone: 923008221603
    Location: Suite # 2B, 45-C, 27th Street Tauheed Commercial Area DHA, Phase V, Ext. Karachi, Pakistan
    4sighttechnologies2@gmail.com
    Postal Code: 75500

    ReplyDelete
  6. While it has been politically un-savy to raise minor paces of tax assessment, our government officials have had the option to support absolute expense assortments by both expanding requirement through extra audits and by recruiting extra income officials to gather neglected charges. find out more

    ReplyDelete
  7. Hi to everybody, here everyone is sharing such knowledge, so it’s fastidious to see this site, and I used to visit this blog daily fud crypter

    ReplyDelete

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