Resource Center Home

ACA Resources

Employee File, Common Import Errors and How to Fix

You are here:
Estimated reading time: 2 min

KB13-047

To review hours and reports within the ACA Compliance Solution, data must be imported into the software in a txt (Text Tab Delimited) on the Upload and Import page, for specific instructions please Click Here.

The import process is fairly smooth and easy. However, different scenarios can create import errors and for the import to not go through. Below are some examples and what steps are needed to fix the file.

Employee Import Error Example 1:

Employee
This error will occur if a character limit of one of the columns is over the allotted limit. On the excel templates Click Here to view, the columns have specific character limits. To resolves this error, review the columns and make sure that the characters limits are within the acceptable number of characters. Re-save the file and then re-import. The employee file will not upload if an error occurs.

Employee Import Error Example 2:

Employee 2

This error will occur if the Column Headers in the first row of the file are not imported with the file. To resolve this error, input the column headers in the exact format and order of the Employee Excel Template Click Here to view. Re-save the file and then re-import the file. The employee file will not upload if an error occurs.

Employee Import Error Example 3:

Employee 3This error will occur if the file contains a comma in any one of the cells. As the example shows, there is a comma after the last name of the employee. To resolves this error, remove the comma. Re-save and re-import the file. The employee file will not upload if an error occurs, you will not need to delete the first errored file.

This error will appear with quotation marks (“”) in the text file.  The best way to clean the entire txt file is to open the text file.  Go to Edit at the top menu.  Go down to Replace.  Put a ” in the top line and tab down to the second line leaving it blank.  Click Replace All.  If the txt file turns blue momentarily, you had ” that were removed.  Save and re-upload.

Employee Import Error Example 4:

Employee 4