When you upload a Bulk Rate Update file into FastTrack360 to update rates, a series of checks is performed to ensure that the uploaded file can be read by the system and that it contains all of the relevant data required to successfully update rates in the system. If any of these checks fails, a validation error or an exception will be raised. Each of these conditions are described below.
Validation Errors
A validation error occurs when the Bulk Rate Update file that you have uploaded cannot be recognized. That might occur if:
...
If this occurs, open the file, look for any duplicate columns, delete them from the file and save the file. Take extreme caution not to delete any other columns from the file. Once you have removed any duplicate columns and saved the file, attempt to upload the file again.
Exceptions
If there are no validation errors when you upload a Bulk Rate Update file, FastTrack360 creates a Bulk Rate Import batch and performs further checks on the data that is contained within each of the mandatory columns in the file is not blank and is valid based on the type of data that is expected in each respective column. For example, a check is done to ensure that each row in the NewValdityDate column contains a date and that the date value is in the format dd/mm/yyyy.
...
on completion of processing, the status of the batch will be set to Completed with Exceptions if at least one rate could be updated successfully or Rates Import Failed Due to An Exception if no rates could be updated successfully
an exception file will be generated and the offending row from the Bulk Rate Update file, and all other rows in the file that are linked to the same agreement rate rule or standard rates rate set are written to the exception file, along with an exception message that explains why the corresponding rates could not be updated (for more information, see Batch Processing Exceptions)
the exception file is attached to the notification email message, which is sent to the user who submitted the Bulk Rate Update batch when the batch completes processing.
...
You can refer to the exception messages in the exception file to determine why the corresponding rows could not be updated. You can then fix the offending row in the exception file, save the file and upload the updated file to process a new Bulk Rate Update batch so that the rates that failed to update the first time around can be updated. For more information about the exception messages that can be written to the
exception file and how to fix each exception condition, see Batch Processing Exceptions.
| Info |
|---|
Before you attempt to upload an exception file that has been corrected, you must delete the Exceptions column, which contains the description of the exception, from the file. The Bulk Rate Update will fail if there is an Exceptions column in the file that you upload. |
...