To preserve the quality of the information that is stored within iBase, you can ensure
that items are only extracted that match the rules set in iBase Designer. For example, item
extraction is prevented if mandatory information is missing, data exceeds field type limits,
or maps to fields that require specific values that aren't specified.
Procedure
-
On the Chart Item Extractor Validation Results page, click
Options and with Extract chart item label turned on,
click Advanced.
-
To add these items that do not match your database validation rules to your
database, select Include in extraction. There are four
options that you can use to clean the data and prevent issues:
- Allow duplicates (entities only)
Allows the
import of duplicate entity records.
- Validate 'Selected from Code List'
values
Verifies that the values in the source data are
valid for the code lists in the current database. Invalid values are
reported as errors during an extraction.
- Auto-populate blank mandatory fields
Allows
records to be created without all the mandatory fields being mapped. To
allow this, a default character is inserted into each mandatory field
that is blank. This will continue to use the default value if one has
been specified within the field definition or will populate the field with:
- '-' for text fields
- '0' for number fields
- the current date for date fields
- the current time for time fields
- Truncating text field overflows
Truncates
fields that exceed the maximum field length. If this option is not
selected, records with fields that exceed the maximum field length will
be marked with validation errors.
- To exclude items from your extraction, select the Exclude from
extraction.
Note: These rules can be set up to be run on a selection of items by highlighting the items within
the Validation Results and selecting the Apply to selected items only. To
extend the rule to all items, select Apply to all items.
