This document provides guidance for resolving issues encountered during the data import process. This page offers troubleshooting tips and common error explanations, ensuring smooth and successful data import.
Please ensure that the import file has correct headers and sheet names as specified in this guide. Headers and Sheet Names are case-sensitive.
Please ensure that file is being imported under the right category
Error importing file: Sequence contains no matching element
Please ensure that the import file has correct references.
The File Headers should not have additional space or characters.
Data Import for “File” has some errors
Navigate to the “Import Errors” section under “Data Import” for further information.
Reference is already in use
The reference specified in the import file is already used in the system. Kindly check the values.
Kindly enable the Backing Data under Billing Scheme for which you are trying to import the data for
Kindly add the relevant Backing DAT ain the import file or check the Billing Scheme for “required” check for the backing data
The Backing Data inputted in the file cannot be found in the system, kindly check the values entered
You Do not have access to the Business Unit or Business Unit not found
You are trying to import the data for a Business Unit that you don’t have access to or is not available in the system. Kindly, check the import file for correct Business Unit
More Files cannot be added for Previous Period
Please import files in the current period {Data Import -> Import File -> Select Files}
Effective Date can’t be in previous periods
Please ensure that worker rates are being imported for the current period. Currently the application does not support importing worker rates for previous periods.
P45Frequency must be Week or Month if StarterForm is P45.
P45 Frequency must be provided in the import file if the worker to be imported is Week 1
Accepted values in this field are “Week” or “Month”
P45Period must be greater than zero if StarterForm is P45.
P45 Period must be provided in the import file if the worker to be imported is Week 1
Accepted values in this field are “Numbers” – 1-52 for weeks or 1-12 for months
Please Enter a valid email address
The entered email address contains invalid characters. Kindly check and fix any errors in the provided email address. Please refer to Notes (Point 3) for all valid characters
Error Importing file: A column names 'reference' already belongs to this Data Table
Please ensure there is only 1 column with heading "reference" each in "Timesheets" and "TimesheetRates" worksheets, any other column with this heading would result in data import failure.
Cannot exclude non Director workers from auto-enrollment
Worker Import file contains a PAYE worker with ExcludeAutoEnrolment set as 1 and DirectorNi set as 0; Only workers with DirectorNi set as 1 can be imported with ExcludeAutoEnrolment = 1. This flag affects the auto enrolment status of pensions.
Cannot give a holiday scheme for Placement as it is not enabled in Configuration
Please ensure, customer holiday scheme is enabled for placements in the configuration. for further information please refer to 🪟Customer Holiday Scheme guide. Cannot give a holiday scheme for Timesheet as it is not enabled in Configuration
Please ensure, customer holiday scheme is enabled for timesheets in the configuration. for further information please refer to 🪟Customer Holiday Scheme guide. Unable to process Opt Out - Worker Worker_Reference Worker_Name
Pease Ensure worker reference provided is correct
The contents of this document, along with any associated documents, are the property of PurePro Solutions Ltd. and are shared in strict confidence with the intended recipient. These materials may not be reproduced, shared, or used in any manner without prior written consent from PurePro Solutions Ltd. Unauthorized use or distribution is prohibited.