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, you can also open the form and check any fields which are displayed in red.

Invalid/Custom Column Colouring – The column header colour will change on any log in, 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 behaviour 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

Refer to section:

Status and Message Columns

Correcting Errors and Reloading