Validating the stage data
Bulk Data Loader validates that the data provided in the staging table meets the type and range criteria specified in the Optiva configuration.
Validation messages are numbered and displayed in the Reports tab.
On the Data Upload Summary section, you can:
- View the total records of every object
- Use the option to refresh the data in the Records field
- Use the option to download the data in excel format
On the Error(s) section, you can use these options:
- : To download the error data for unresolved objects
- : To refresh the data in stage table
- : To download all the errors in excel format
User can also see the validation messages based on the filter in the Update Stage Data tab. Users can modify and update the error values into stage table in this tab.
Validation Examples
- There are no duplicate rows.
- All coded fields such as UOMs, Parameter Code and Parent Code are configured in the database.
- All enumerated list fields have appropriate values in the supporting enumeration list.
- Range-driven data falls within the configured ranges.
- Data matches the specified data type. For example, parameters defined as Numeric do not have character values.
- Reference type data validation.
Bulk Data Loader ensures integrity of data by:
- Loading the Header data before detail data.
- Loading the Header data for referenced objects before references to those objects.
Note: When validation errors occur, it is best practice to update large or repetitive errors on the templates and re-upload then validate. This maintains the data source integrity for historical records.