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 on user files sent via SFTP.
- Phone number must be in format x
- Hire date must be in format x
- Birth date must be in format x
- Role must be - {list of valid roles}
- First Name is Required (Row)
- Last Name is Required (Row)
- Employee ID is Required (Row)
- Country is not valid
- Missing Column
- Duplicate Employee Id in the file
- Cannot parse approver mapping: {mapping}
- Cannot parse Recognition Program Approval Rule ID: {mappingSplit[1]}
- Cannot name a generated column the same as an import column
- A Cycle Was Detected in the set of changes
- An item with the same key has already been added
- Object reference not set to an instance of an object
Phone number must be in format x
Phone numbers must be in a valid format:
+11234567890
Hire date must be in format x
The Hire Date column must be in a valid format:
M/D/YYYY YYYY-MM-DD
Birth date must be in format x
The Birth Date column must be in a valid format
M/D/YYYY
YYYY-MM-DD
Role must be - {list of valid roles}
Valid roles are:
Admin
Executive Manager
Group Manager
Employee
First Name is Required (Row)
All employees must have a first name
Last Name is Required (Row)
All employees must have a last name
Employee ID is Required (Row)
All employees must have a unique Employee ID
Country is not valid
Country codes must be in 2 character ISO format:
https://www.iban.com/country-codes
Missing Column
An expected column is not appearing in the file. This generally has to do with upload parameters
Duplicate Employee Id in the file
Multiple instances of the unique Employee Id appear in the user file. Employee IDs must be unique.
Cannot parse approver mapping: {mapping}
The custom approver mappings cannot be applied. This usually means the column in the file references a user that no longer exists.
Cannot parse Recognition Program Approval Rule ID: {mappingSplit[1]}
The custom approver mappings cannot be applied. This usually means the rule referenced in the Approver Mapping has changed and needs to be updated.
Cannot name a generated column the same as an import column
The user file includes a column with the same header as a field created in the Metadata Generator
A Cycle Was Detected in the set of changes
A group of approvers is circular. Most commonly this is associated with the Chief Executive. If you need help, please contact your CSM.
An item with the same key has already been added
The user file has two columns with the same name. Remove or rename one of the columns.
Object reference not set to an instance of an object
The file or import mechanics are referencing an object that doesn't exist. The most common issue is an Employee ID listed in the "Supervisor ID" column, but that is not in the file nor in the platform.
If you have any questions, please contact Awardco Admin Support.