Image

Monitor data quality

Even if data is entered very carefully, there may be false entries.
To prevent this, there are options for data validation. Once configured, the data is checked wether entered manually and for all ways of Excel import.
Screenshot: Example for data validation on row level

Image

Data row validation

You can interdependently validate the values of a data row:

  • Flexible comparison of values
  • Calculations with Variables
  • Custom errror messages

Validation after entry

Sometimes it is important to save all data and to validate later.

  • Post execution of database functions and external scripts
  • Check the data after entering and possibly correct it
  • Or mark it for further processing

Single value validation

Provides the checking of individual values by:

  • Validity intervals for date and number types
  • Regular expressions for text types
  • Custom java validator classes for all types

Import file name validation

The accepted file name can be defined, even with variables:

  • Example: controlling_<%CURRENT_YEAR%>_<%CURRENT_MONTH%>.xlsx
  • Accepted: controlling_2019_12.xlsx
  • Denied: controlling.xlsx