All About Etcom

Friday, December 30, 2011 TimeTec 12 Comments

What is the etcom file? All data downloaded from the terminal into the TCMSv2 software is stored in the terminal data audit list and the etcom file.
When the data is downloaded from the terminal, the data will go into the etcom file. Once the data is downloaded into the etcom file, the TCMSv2 software will then calculate the amount of data inside the etcom file to match the amount of data inside the terminal. If it tallies, the terminal will clear all the data inside the terminal. If the data does not tally, the software will prompt an error for the customer to check the terminal.  

The downloaded data will then be stored in the Terminal Data List of the TCMSv2 software. Using the downloaded data, users can then configure the Attendance sheet and view or print the Reports.





The etcom file is located at c:\Program Files\FingerTec Worldwide\TCMSv2\etcom. After you have located the file, you will need to open the file with Notepad.





Let’s take a look inside the file. There are so many transactions in the file. How do we read the transactions? You may breakdown the code as below:


000010407120916580000000011022ß…





  • TTTTT - Terminal ID is 010
  • DDMMYY - Date is 04/07/12
  • hhmmss - Time is 09:16:58
  • UUUUUUUUU - user ID is 000000001
  • The 25th digit “1” is for In and “0” is for out.
  • AA - work code is 02
  • The 28th digit is verify type, “0” is for password, “1” is for fingerprint.  



The etcom file will also display the data downloaded date and time. Besides that, it will also display the total amount of log transaction downloaded.

Etcom Errors

If you encountered this error, it means your fptaudit.dbf file is corrupted. To solve this error it will involve deleting the fptaudit.dbf file and all the data in the terminal data audit list will be gone. To download the data to the TCMSv2 software, please follow the steps below:
  1. Go to C:\\ Program Files > FingerTec Worldwide > TCMSv2 > etcom and copy the _etcom file.
  2. Then paste the _etcom file into the remote folder inside the TCMSv2 folder.
  3. Start up the TCMSv2 software, go to Attendance and click Download.
  4. The system will download the raw clocking data from the _etcom file.
  5. After the process is completed, the system will delete the file that you paste in the remote folder.



If you accidentally restored the previous backup database and the database has been replaced with the old data:
  1. Go to C:\\ Program Files > FingerTec Worldwide > TCMSv2 > etcom and copy the _etcom file.
  2. Then paste the _etcom file into the remote folder inside the TCMSv2 folder.
  3. Start up the TCMSv2 software, go to Attendance and click Download.
  4. The system will download the raw clocking data from the _etcom file.
  5. After the process is completed, the system will delete the file that you paste in the remote folder.



If you accidentally downloaded the transaction data into another computer, you will need to merge the data into the TCMSv2 software.
  1. At the wrongly downloaded data computer, Go to C:\\ Program Files > FingerTec Worldwide > TCMSv2 > etcom and copy the _etcom file and store it to a USB pendrive.
  2. Transfer the _etcom file into the remote folder inside the TCMSv2 folder computer that you want to merge with.
  3. Start up the TCMSv2 software, go to Attendance and click Download.
  4. The system will download the raw clocking data from the _etcom file.
  5. After the process is completed, the system will delete the file that you paste in the remote folder. 

12 comments:

  1. We have just successfully recovered the data of 2 days for a company having 635 employees.

    This article saved a lot of manual work for their Time Office.

    ReplyDelete
  2. Yatin, good to know this write up helps you and your customer.

    ReplyDelete
  3. We have installed Fingertec AC100C attendance machine. We would like to update the attendance automatically into our ERP system. Is this possible ? Currently, we follow the procedure of "Setting duration" and "Exporting to Excel" and then "Upload the Excel file into our ERP software module". Please inform us of any possible automatic feature i.e. non-manual synchronising feature. Regards.

    ReplyDelete
    Replies
    1. The automatic export function only available with raw clocking data from the terminal data audit list.

      For attendance data, you will need to export it manually from the attendance sheet because you will need to select the user and date range that you want to export

      Delete
  4. this feature not workable for version 2.2 and above according to your support team.

    ReplyDelete
  5. Hello can you help me ?in my pc A can show all activity of my staff but my pc B can not do and I have asked the technical fingertec ready and they told me to merge the etom file so please tell me how I merge the clocking data at the PC B with the main PC by using the etcom file.

    ReplyDelete
    Replies
    1. Hi Anonymous,

      If you accidentally downloaded the transaction data into another computer, you will need to merge the data into the TCMSv2 software. Follow these steps to merge your data:

      -At the wrongly downloaded data computer, Go to C:\\ Program Files > FingerTec Worldwide > TCMSv2 > etcom and copy the _etcom.15 file and store it to a USB pendrive.
      -Transfer the _etcom file into the "remote" folder inside the TCMSv2 folder computer that you want to merge with.
      -Start up the TCMSv2 software, go to Attendance and click Download.
      -The system will download the raw clocking data from the _etcom file.
      -After the process is completed, the system will delete the file that you paste in the remote folder.

      Delete
  6. Hi, i copy the _etcom.16 into remote folder of TCMSv2 folder. then click download from TCMSv2, But i got error meg: No Active terminal or none is selected. why and how to solve it. pls advice. thank you

    ReplyDelete
    Replies
    1. Hi Alvin,

      Regarding your error message, kindly refer to the following link's scenario 1 as a guidance to resolve this issue: http://www.fingertec.com/newsletter/Oct2010/TIPS-02.html

      Delete
  7. hi
    my tcms v2 cant download the attendance function and cant print. it will return with error and the system will need ctrl+alt+del to close the software..can u help?million thanks in advance

    ReplyDelete
    Replies
    1. Dear Sir,

      Good day to you.

      With regards to your query, please advise what is the error that you have received when you want to download the attendance data. Kindly send the screenshot of the error to support@fingertec.com and explain in details regarding your problem.

      Thanks & Best Regards,

      Syed Mohd Firdaus bin Syed Mohd Fuzi

      Delete
    2. Dear Sir,

      With refer to those previous post, I manage to download those missing clock data with _etcom, my problem resolved. Thanks

      Delete

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