Setting up import validation
- Mattias Löfstrand
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 |
|---|---|
Ignore | If value defined in |
Replace | If value defined in |
Exception | If value defined in |
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>