Validating the extraction
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.