Skip to main content

Correct validation errors

Identify and correct validation errors when a file upload fails.

O
Written by Ollie Denning

If a file upload fails, Access PaySuite DDCMS displays the validation errors found in the file and provides tools to help you correct them.

If you see the message 'We're sorry but we were unable to upload your file', use the customer file upload fixes to understand why the upload failed, identify the required changes and successfully resubmit the file.

šŸ“ŒNote: If your file shows as Partially Successful, some rows were uploaded successfully while others contain errors. Click Fix Errors next to the file to correct the remaining rows and resubmit.

šŸ“ŒNote: If your file shows as Queued for validation, the system is still checking the file. This is normal for larger files. Refresh the page after a moment. Once validation is complete, the status will update and any errors will be displayed.

šŸ“ŒNote: If your file contains many errors, it may be quicker to review it in a text editor. Text editors can reveal formatting issues that may not be visible in Excel, such as an invalid schedule name.

Correct errors individually

You can correct errors directly in Access PaySuite DDCMS when there are 50 errors or fewer.

  1. Locate the file in the Uploaded Files tab and click the Fix Errors icon.

  2. Review the First Problem Detected column to identify the error on each row.

  3. Click the Edit pencil icon for the row you want to update.

  4. Correct the field that contains the error.

  5. Click Save and if the update is valid, the row is removed from the list of errors.

  6. Repeat these steps for any remaining errors.

  7. Click Submit this file when all errors have been corrected.

To remove a row instead of correcting it, click the Delete bin icon.


Download and correct errors

If you prefer to correct errors outside Access PaySuite DDCMS, you can download the rows that contain errors and resubmit them later.

  1. Click Download list with errors and open the downloaded file.

  2. Review the validation error column added to the end of the file.

  3. Correct the errors and delete the validation error column.

  4. Save the file and upload it again.

Submit validated rows only

If you don't want to correct the errored rows, you can remove them and submit only the validated rows.

  1. Click DELETE ERRORED.

  2. Review the confirmation message and select Confirm.

  3. Click Submit this file once all errored rows have been deleted.


File already processed

Once a file has been processed successfully, it cannot be edited or submitted again.

If the file contains incorrect customer details, such as a name, bank account information, or reference, you can update the customer record instead.

  1. Within the CUSTOMERS tab, find the customer by searching any of the fields.

  2. Click View Customer the eye icon, this opens the customer's PROFILE.

  3. Update the required fields and click Save.

šŸ“ŒNote: If the customer was added through a New Payer file and does not yet appear in the search results, wait a few minutes for the record to be created and then search again.

Did this answer your question?