•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 Asset Wizard ribbon.
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.
