Error | Resolution |
'Uploaded file should be in excel format (i.e. .xls extension)'. | The file cannot be saved as another file type, only a .xls type will be accepted. |
'Uploaded file name should be in "Sub Domain_[Something]Data.xls format (case-sensitive)'. | The file must be named as described in this error. |
'Uploaded excel file should have only one worksheet'. | The file cannot have multiple tabs or filters against the data. Even once these have been deleted it will pick up in the background. To solve this, copy and paste the data into a blank template. |
'Name of single worksheet available in uploaded excel workbook should be [specified name]'. | [specified name] will show as what the worksheet name should be called. The name of the open work sheet should be named EmployeeData (case-sensitive with no spaces). |
'[worksheet name] should have [number] columns'. | This will specify the worksheet, and the name and number of columns that should be there. Columns should not be added or deleted. |
'All expected columns should be available in [worksheet name] at required position'. | Columns should not be moved or renamed. |
'[worksheet name] should contain data in at-least one row'. | As well as having to have at least one row, there cannot be any empty rows in between rows with data. |
'Uploaded excel file should not have more than [number] rows'. | This tool can load up to the specified amount of data lines at a time. If employee data sheet, leaver records do not count in this value. |
If you actioned on the error but it didn't help, reach out to us and make sure you have:
Granted us impersonation rights after confirming with the engineer the email address you need to grant access to.
Attached the file you want to upload to the case.