When you transfer your files with SFTP, it provides the best opportunity to ensure smooth delivery and reception of the correct data in the correct format. This article will explain different errors you might encounter when it comes to missing data on user files sent via SFTP.
- Employee ID is Required
- First Name is Required
- Last Name is Required
- Special Note
- No Header Record Found
- Missing Columns: employee id, firstname, lastname
Employee ID is Required
This error indicates that the specified users do not have an employee id in the user file
Fix: Add an Employee ID for the user on the user file and reupload.
First Name is Required
This error indicates that the specified users do not have a First Name column in the user file
Fix: Add a First Name for the user on the user file and reupload.
Last Name is Required
This error indicates that the specified users do not have a Last Name column in the user file
Fix: Add a Last Name for the user on the user file and reupload.
Special Note
If you see all three of the above on consecutive lines:
This indicates that there are blank lines at the end of the file populated with just a row of commas.
Fix: Either open the file in a text editor and delete the comma rows, or:
1. Open the file in Excel
2. Navigate to the last populated row
3. Select the entire row below it
4. Highlight everything below that on the file using ctrl + shift + down-arrow
5. Right-click the highlighted area and choose "Delete". Using the "delete" key will not remove blank line, you must right-click and delete.
After removing the blank lines reupload the file.
No Header Record Found
This is a general error. Usually it indicates a problem in the SFTP server structure, a file that was deleted before it could be pulled, or the webhook triggering on a folder creation or other non-file upload action. This can generally be ignored, but please contact your CSM if you believe an uploaded file may not have gone through.
Missing Columns: employee id, firstname, lastname
This error can occur if the columns are missing or if there is a problem pulling the file to the Awardco platform.
Fix: Review the file to make sure the columns are headed correctly. Try reuploading the file and contact your CSM if you receive the error again.
If you have any questions, please contact Awardco Admin Support.