** How To Solve Parse Failed Error when Importing User Data from Excel file in Ingress/TCMS V3 **
----
{{:home:knowledge_base:webstation:fingertec:ingress_software:parse_failed_error.jpeg?direct 750|Parse Failed Error}}
**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: \\ \\
**[[{{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?30|font-size:15px; width:20em; color:green; border-color: black}}home:knowledge_base:webstation:fingertec:ingress_software:badge.xlsx|Download Here]]**
\\
Refer to the screenshot below for more clarification- \\
{{:home:knowledge_base:webstation:fingertec:ingress_software:example_userlist.png?direct 750|Example UserList}}
\\
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. \\
{{:home:knowledge_base:webstation:fingertec:ingress_software:example_userlist_2.png?direct 750|Example UserList}} \\
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. \\
{{:home:knowledge_base:webstation:fingertec:ingress_software:example_userlist_3.png?direct 750|Example UserList}}
{{:home:knowledge_base:webstation:fingertec:ingress_software:parse_failed.png?direct 750|Parse Failed}}
__**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 from the button provided below. \\ \\
**[[{:home:knowledge_base:webstation:software:autocount_accounting:download-icon.png?30|font-size:15px; width:20em; color:green; border-color: black}https://ipohserver.com/download/AccessDatabaseEngine.exe|Download Here]]** \\ \\
If you have other inquiries or still unsuccessful in importing the Excel data into TCMS V3/Ingress Software, kindly forward your Excel file to **software@webstation.my** 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 **sales@webstation.my**, we will update it as soon as possible.
\\
Credits:**[[https://www.fingertectips.com/2019/01/how-to-solve-parse-failed-error-when.html|FingerTec]]**