When you upload a file and the import process fails, we provide you with clear guidance to help you understand the issue and resolve it. Here's what you can expect when an upload fails.
If your file upload fails, you'll see a warning message stating that we were unable to upload your file "We're sorry but we were unable to upload your file" You'll need to correct the errors before you can submit the file.
Please take a look at our article Customer file upload errors for advice.
📌Note: Where there are many errors, it may be quicker to look at the file in a text editor. A text editor shows formatting errors that might not show in Excel. It's easy to see, for instance, an invalid schedule name. Assuming you are exporting data from Excel, there's no harm in opening and editing the file in a text editor after you have exported it and before you load it onto Access PaySuite DDCMS.
In-line Correction
📌Note: In-line edit is only available for 50 errors or less.
To correct errored rows individually:
Locate the file in Uploaded files tab.
Click on the red Fix Errors icon.
Check the errors on the column First Problem Detected.
Click the Edit (pencil icon) next to any rows showing on the page, this brings up the individual row to amend.
Correct the field within the form that needs updating and press SAVE. If the amendment is correct, this removes the row from the list of errors.
If it needs deleting, click the Delete (bin icon).
Follow the steps again for any further errors.
Once all errored rows are updated, click Submit this file.
Download and delete all errored rows
The other option is to download all errored rows for correction and later resubmission, and submit only the validated rows:
Click Download list with errors.
This downloads a file of your data in the format in which you uploaded it, with an additional column at the end specifying the validation error.
You may work through the downloaded file, correct the errors, delete the final column and upload or click DELETE ERRORED.
A pop up appears asking Are you sure you want to delete all of the errored lines? click Confirm.
Once all errors are deleted, click Submit this file.