Setting up import validation

Owned by Mattias Löfstrand
Last updated: 30 Jul 2021
2 min read

At import it is possible to block or ignore defined values in specifications on presentation. This can be useful if e.g. a source system sends e.g. a value “000” or “---”, where this means no value. Ignoring such a value will prevent existing values to be overwritten or stop bad values from being imported.

The validation operates on imports in import storage and on XLS imports.

This function is available in version 5.0 and later.

Overview

Validation at import is configured in import.config. Validation is set up as rules, each rule having a few settings. Validation operates on specifications on presentations.

  • Validation option - what to do if a value is encountered

  • Target value - the value in a specification which will trigger an action

  • Replace value - if Replace option is used, this is the new value

  • Persistent identity of specification - validation will be done on this specification type

Validation option

Usage

Validation option

Usage

Ignore

If value defined in target-value is encountered at import, this value will be ignored (considered NULL). No values will be imported, and any existing value will not be overwritten.

Replace

If value defined in target-value is encountered at import it will be replaced by the value in replace-value.

Exception

If value defined in target-value is encountered at import, import will stop with an exception.

Configuration

In import.config add the configuration needed. Sample configuration:

<Specifications> <!-- Ignore EAN codes with values "xxx" --> <SpecificationValidationConfig enabled="true" validation-option="Ignore"> <target-value culture="en-GB" value="xxx" /> <replace-value culture="en-GB" value="" /> <specification-type-persistentidentity>EAN</specification-type-persistentidentity> </SpecificationValidationConfig> <!-- Replace country codes with values "pt-BR" with "pt" --> <SpecificationValidationConfig enabled="true" validation-option="Replace"> <target-value culture="en-GB" value="pt-BR" /> <replace-value culture="en-GB" value="pt" /> <specification-type-persistentidentity>Country</specification-type-persistentidentity> </SpecificationValidationConfig> <!-- Stop import if code "X" comes --> <SpecificationValidationConfig enabled="true" validation-option="Replace"> <target-value culture="en-GB" value="X" /> <replace-value culture="en-GB" value="" /> <specification-type-persistentidentity>NLACode</specification-type-persistentidentity> </SpecificationValidationConfig> </Specifications>