Data Automation Troubleshooting
A guide to automated email responses and what to do when you receive them
I've received an automated response that says invalid file name.
If you have received an regarding an ‘Invalid File Name’, you must first follow the steps outlined in the automated email. If a file has been uploaded with a name matching a current file name, your most recent file must be updated and uploaded again. When uploading a file, the time and date must be updated with each upload.
What should I do if I received an email response that states there is an error with my file?
If you have received an automated email stating a ‘File Error’, you must first investigate the error as it could be 1 of 2 things:
- The filename may have already been submitted.
- The account rules are not configured.
To resolve this issue, please check the data in the file is correct and rename the document with the current date and time of the upload.
I've received an automated email that states my file contains invalid columns, what does this mean and how can I rectify?
If you have received an email below regarding ‘invalid columns’ you must first investigate the error as it could be any of the following:
- Incorrect column headers
- Missing columns
- Columns appearing in the wrong sequence.
To resolve this issue (as stated in the email below) you must ensure all columns are in the correct format, as shown in the data template you were provided. You must also check there are no unnecessary spaces in the template.
What should I do if I receive an email that states my file contains invalid data?
If you have received an email regarding ‘invalid data’ you must first investigate the error as it could be any of the following:
- Missing emails
- Incorrect number of dependent
- Names that are too long
Doctor Care Anywhere will upload a document to the SFTP which will pinpoint the error made. To access the file, please log on to the SFTP, click on the folder labelled ‘From DCA’ and then ‘ContentRejectedFiles’. To check the file in an excel format, you must open and convert the document. Please follow the steps in the ‘How to find out & resolve invalid content?’ section.
I've received an automated email that states my file contains an unexpected number of records.
If you have received an email regarding ‘unexpected number of records’, this means you have made changes to 10% of the total population within the file, as there are lots of changes, Doctor Care Anywhere will need to confirm with you if the changes are correct. This process acts as a safety net to ensure the correct number of changes are actioned. If you receive this error and have confirmed the data is correct, please contact your Customer Success Manager and let them know you are happy for Doctor Care Anywhere to process the file.
If you believe an error has been made (i.e. data has been duplicated), please inform your Customer Success Manager and Doctor Care Anywhere will disregard the file for further processing.
You must then upload a file containing correct data (ensuring the new file name contains the correct date and time).
My uploaded file has been rejected, what can I do?
If you have received an email regarding a ‘rejected file’, the file has been rejected by Doctor Care Anywhere and will not be processed. You must check the file name does not match any previous files uploaded and all data within the file is correct. Once resolved, re-upload the file.
I've received an email stating my upload was successful, is there anything further I need to do?
If you have received an email regarding ‘Successful Upload’, your file has successfully passed all validation checks and is now awaiting uploading within our system.
No further action from you is needed at this time.