Once an HR data file has been imported, an email will be sent summarizing:
‘Rows Inserted’ refer to new people records being added
‘Rows Updated’ refer to existing people records being added
‘Rows Failed’ refer to person records failing to be inserted or updated
‘Errors’ refers to errors causing the entire person to fail on import
‘Warning’ refers to specific fields on a person record that have failed
COMMON ERRORS
For a further description on common errors, please see below:
Data does not exist for ‘Reporting Structure Name’ type element in cell: H2
Translation: Please check This Reporting Structure name, as it Does not exist in the Solv System in this cell: H2
Data is Invalid for Person Type in cell: S2: Volunteer
Translation: ‘This Person type does not exist in the drop-down. Please check this drop-down item and re-upload in cell S2: Volunteer
Person already exists in database with this employee id in row: 3 – 60077819
Translation: Person with Name: ‘Full Name’ already exists in the system with this email address (john.doe@hotmail.com) in row: 3. Please check the data.
Person already exists in database with this Client Unique ID in row: 3 – DOE, JOHN
Translation: Person with Name: ‘Full Name’ already exists in the system with this Client Unique ID (12345678) in row 3. Please check the data.
Data does not exist for ‘Reporting Structure Unique ID’ type element in cell: D10
Translation: This Reporting Structure Unique ID Does not exist in the Solv System in this cell: D10
Model validation failed for object in row 4276: The field Home Suburb can only contain letters, numbers, spaces, and the following characters - ' ( ) _ / & , . [ ] @ # - John Doe
Translation: Please check the data for Person: ‘John Doe’ In Row 4276: The Field Home Suburb can only contain letters, numbers, spaces, and the following Characters - ‘ ( ) _ / & , . [ ] @ #.
Duplicate people exist with this client unique id in the current dataset in row: 347 – 7068
Translation: 2 or more people in the spreadsheet (HR DATA Upload) have the same Client Unique ID in row: 347 – 7068.
Duplicate people exist with this email address in the current dataset in row: 921 – john.doe@hotmail.com
Translation: 2 or more people in the spreadsheet (HR DATA Upload) have the same email address in row: 921 – john.doe@hotmail.com
Model validation failed for object in row 1017: Reporting Structure Name is required
Translation: The Reporting Structure name cell is blank in row 1017. This is a required field, Please check the data.
Model validation failed for object in row 35: The field MobilePhone must be a string or array type with a maximum length of '20'. - Latisha McMillian
Translation: The data failed to update in row 35: The field Mobile Phone must contain digits only, have less than 20 characters and contain the following characters ( ). Please check the data.
Person email address john.doe@hotmail.com cannot be updated because it is linked to a User in the system. Please contact support.
Translation: You are attempting to update the email address for john.doe@hotmail.com - however this email is linked to a user in the system. Please contact support if you wish to make changes to this record. You cannot assign a person as their own manager - 104158 - AJ1117
You cannot assign a person as their own manager - 104158 - AJ1117
Translation: You cannot assign a person as their own manager– in row: 1117 – (Full Name Goes Here).
Data does not exist for 'Home Country' type element in cell: Y2 - USA - Y2
Translation: The home country: USA is an invalid value for Person: ‘Full Name’ Row 2 - Cell Y2
Data is invalid for 'Title' in cell: P573 – Mx
Translation: We cannot accept the value ‘Mx’ in the Title field in Row 573. Please check the data.