How To Solve Parse Failed Error when Importing User Data from Excel file in Ingress/TCMS V3

Monday, December 31, 2018 TimeTec 8 Comments


Introduction:
Instead of individually enrolling user ID into the device, note that system administrators can upload all user data (such as UserID, Name, Username, Department) from the Excel files. This is done to reduce processing times as well as to prevent the repeating of steps when enrolling the users. However, they must first ensure that the appropriate excel file templates are used before importing the data into TCMS V3/Ingress Software; otherwise, the system will display the error “Parse Failed”.

Apart from that, the PC Setting can also cause the “Parse Failed” error to occur even though the Excel format is correct. Please refer to the steps below on how to solve this particular error.

Process:
There are 2 situations which can caused the “Parse Failed” error to occur:

A.   Excel File Format
B.   PC Setting

Excel File Format:
A1. Users must first create 1 new Excel file based on the template shown in the software.
Additionally, you can download an example of the Excel file here: https://s3.amazonaws.com/files.fingertec.com/Yusri+Tools/Badge.xlsx

Refer to the screenshot below for more clarification-


A2. In the Excel file, you must insert only the data (i.e. without color or box). Please refer to the example in the screenshot below.


Remark - If you include the data with color or table, it will then cause a “Parse Failed” error to be displayed during the import process.
 


PC Setting: 
B1. If the Excel files are already configured based on the given steps, but are still displaying the “Parse Failed” error; the cause might be due to the PC setting.

To solve the issue, please download Microsoft Access Database Engine in the link provided below.
https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255

If you have other inquiries or still unsuccessful in importing the Excel data into TCMS V3/Ingress Software, kindly forward your Excel file to support@fingertec.com for further review and we will also update this article if we discovered another issue that is causing the error.

Note: If some of the screenshots or steps viewed here are different from the ones in the current
system, this is due to our continuous effort to improve our system from time to time. Please notify us at info@timeteccloud.com, we will update it as soon as possible.

8 comments:

  1. Many Thanks for Your professional support

    ReplyDelete
  2. Where can I get the list of field names to be used in parsing? The field name "IC/Social Security No." does not work.

    ReplyDelete
    Replies
    1. Hello Sir,

      You may select the parse field according to the column that you set in the file. As per above excel files, I have added IC/Social Security No and try to import. I am able to select the column in the parse field accordingly. Refer : https://prnt.sc/1atsryl, https://prnt.sc/1attasn, https://prnt.sc/1atthrb, https://prnt.sc/1attp4h.

      Delete
    2. "ICSocialSecurityNo" worked, but it would've been nice to have a list of field names at the beginning.

      Delete
  3. iam added users from device and it is success but can not display on Users List

    ReplyDelete
    Replies
    1. Hello Sir,

      Kindly share with us the software version that you have use. If you still using the odl version, please update your software by downloading the latest installer file from this link : https://www.fingertec.com/software/index.html

      At the sametime, you can provide us the error and screenshot picture that appear on your system and send to our email at support@fingertec.com for further assistance.

      Best Regards.

      Delete
  4. The diet really need to read this and appreciate this side from the story. I cant think youre no more well-known simply because you undoubtedly provide the gift. excel consulting

    ReplyDelete

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