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 incorrect formatting of user files sent via SFTP.
- Missing Columns: employeeid, firstname, lastname
- Bad Data Found
- Index was outside the bounds of the array
Missing Columns: employeeid, firstname, lastname
If you see this error check to see if the file is a .xlsx or other non-csv format, or look in the file to see if it is actually missing one of these required columns.
Fix: Save the file as a csv or add the missing columns and try uploading again.
Bad Data Found
This means the data in the file is not text so the Awardco API is unable to parse the file correctly. Generally this means the file is an xls or xlsx format.
Fix: Save the file as a csv and try again.
Index was outside the bounds of the array
This error occurs when the platform attempts to upload a non text file as a user file. Generally this is a video or image file.
Fix: Upload non-user files to the correct location, outside of the /User file, to avoid the webhook/API trying to upload it.
If you have any questions, please contact Awardco Admin Support.