Error Handling and Validation
There are two levels of validation:
• Worksheet Validation - The Wizard forms validate the data using lists of values, date formats, field lengths and some other field level validation.
• Upload Validation - The upload process will perform the worksheet validation above as well as the validation within the API.
Data keyed directly into the worksheet (not via the Wizard forms) will be validated when it is validated/uploaded. If you wish to check anything before it is uploaded, simply open the Wizard form and check any fields which are displayed in red, or alternatively select the ‘Validate’ option on the Agreement and Funding Wizard.
Invalid/Custom Column Colouring – The column header colour will change on form initialization; upload or download (excluding Custom Query) when the column name does not match any of the default Wizard columns or the custom template column names.
In this scenario the invalid column would look like this:
This functionality aids both the users and support in any instance where unexpected behavior is occurring in the Wizard.
This may also occur if a new version is received and a column has been renamed by More4apps, these can be corrected by synchronizing the template. See Synchronize Template
If an agreement is uploaded with one or more funding lines that contain errors, only the valid agreement and funding lines will be uploaded. The example below shows an agreement with three funding lines. The agreement and two funding lines uploaded successfully, and one funding line rejected due to errors.
The rejected funding line is over funding ‘API Error: The funding allocation is invalid. (FUNDING=)[PA_AGREEMENT_PUB.ADD_FUNDING]’.
In order to rectify the line and upload the funding line correctly against the agreement:
- Clear the existing Accepted status from the Agreement and Funding Status columns by clicking the ‘Clear Status Columns’ icon on the Wizard ribbon (not the ‘Clear Status and ID Columns’).
- Remove the upload action of ‘Create’ from the Agreement and Funding lines that were successfully uploaded.
- Correct the rejected funding line and make sure that the upload action of ‘Create’ is against the line to be uploaded.
- Leave the existing agreement and funding lines with their IDs.
- Upload.
Refer to section: