Set Data Validator default options - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

The following options can be set at the site level and will be inherited by all objects created in Data Validator. The options can be changed, as needed, when configuring and mapping the objects required for Data Validator Administration.

  1. Click System Options Com_Gear_20 on the main Data Validator window.

  2. On the Import page, set the defaults for the following:

    • character encoding,

    • illegal characters,

    • validation of column header text and order,

    • separator for multiple values, and text values that represent blank values,

    • validation of CSV file format before uploading in the Web Client for processing jobs.

    • copying behavior for export mappings.

    Each import mapping object created in Data Validator Administration inherits these defaults, which you can keep or change, as necessary.

    For more information on illegal characters, see Set illegal characters for import mapping.

    For more information on the copying behavior for export mappings, see Copying behavior for export mappings.

    You can set default text values that represent property values in your CSV file, which will be treated as blank values so the properties will not be imported into the staging system during mapping. For example, you may have properties in your CSV file that contain values like NA, N/A, NR, and None. These values will be skipped during import.

  3. On the Export page, select default error severity settings in the following boxes:

    • Block object on export minimum severity - Set the minimum error severity level at which object export will be prevented. Select Error to block the export of objects that return validation errors, or Warning to block the export of objects that return validation warnings or errors.

    • Block property on export minimum severity - Set the default minimum severity level at which the property export will be prevented. Select Error to block the export of properties that return validation errors, or Warning to block the export of properties that return validation warnings or errors.

    This default value can be overridden on the stage property to target property map.

    • Suppress notifications for all jobs - This check box is selected by default to suppress notifications on all jobs. These notifications are from the notification subscriptions configured on any class definition (like create, and update events).

    The Suppress Notifications check box in the Create Job Definition dialog box is enabled only if this check box is not selected. For more information, see Create a job definition.

  4. On the Job Management page:

    • Select the column set that will be used when displaying job information in the Desktop Client. For more information about columns sets, refer to Create a column set.

    • Set the wait time to the number of days before a crashed job can be deleted from Data Validator Job Management. The minimum wait time value is 1 and the maximum value is 30. For example, if you have created a job today, and set the wait time to 1 day, then you can delete the job anytime next day.

    • Select Yes or No to allow the automatic cleanup of failed jobs or those awaiting approval after a specific time interval. By default, this option is set to Yes. However, if you are upgrading from an earlier update of SmartPlant Foundation, the default is set to No.

      • Set the wait time to the number of days before a job that is awaiting approval can be automatically cleaned up from Data Validator Job Management. The minimum wait time value is 1 day and the maximum value is 365 days. For example, if you have created a job today, and set the wait time to 1 day, then the job is cleaned up automatically any time after one day. The default wait time is 21 days.

      • Set the wait time to the number of days before a failed job can be deleted from Data Validator Job Management. The minimum wait time value is 1 day and the maximum value is 365 days. For example, if you have created a job today, and set the wait time to 1 day, then the job is cleaned up automatically any time after one day. The default wait time is 14 days.

    • The job can still be viewed and the reason for failure will be accessible in the Job Management module or the SmartPlant Foundation Web Client.

    • The cleaned up job cannot be re-run or submitted for approval.

    What happens during the automatic clean up of jobs that are failed or awaiting approval?

    The failed jobs and those awaiting approval can be automatically cleaned up at periodic intervals by configuring the wait time for such clean up. During this process, the staging and landing tables for the failed/awaiting approval jobs are deleted from the database. The ISPFConfiguration interface is removed from the job and it is not considered as a configuration object anymore. This ensures better performance during login and a healthy database over time.

    Jobs that are on hold or crashed jobs will not be part of the automatic cleanup process.

  5. On the Reports page, specify the:

    • Maximum number of rows to be included in a validation report.

    • Default validation report definition, which determines the type of validation report generated: Excel, text, or a custom format.

    A default Excel format is delivered with Data Validator.

  6. On the set of Validation pages, select the default rules for the auto-generation of rules:

    • In the Auto Generated Object Rules page, select the default object rules to be automatically generated for each object action.

    • In the Auto Generated Property Rules page, select the default property rules to be automatically generated for each property action.

    • In the Auto Generate Relationship Rules page, select the default relationship rules to be automatically generated for each relationship action.

    • In the Auto Generate Relationship Property Rules page, select the default relationship property rules to be automatically generated for each relationship property action.

    Before the relationship property rule is auto-generated, at least one relationship property mapping must be configured. One rule will be generated for all the properties of a relationship.

    For more information, see Actions.

    There is a naming convention for the validation rules that are automatically generated. For more information, see Naming convention for rule auto-generation.

  7. On the Inconsistency Severity page, select the default error severity for inconsistent property values, invalid action combinations, and conflicts between multiple actions. By default, inconsistency checks run for all jobs, but they can be disabled on the job definition.

  8. On the Severity Level page:

    • Choose the colors used for each severity level in the validation report. The defaults are red for errors and yellow for warnings.

    • Create additional severity levels or remove any unused levels.

  9. On the Validation Defaults page, select default severity triggers for the following boxes:

    • Property error propagation minimum severity - The minimum severity level at which the property error will be propagated to the object. Any error of higher severity, such as warnings, will also propagate up to the object.

    This default can be overridden on the stage property to target property mapping.

    • Missing mandatory and unique identifier generation columns error severity – The default severity level for an object or property that comes from a mandatory column but has no a value.

    • Missing UID columns error severity – The default severity level when one of the properties for the UID creation has no value.

    • Auto-generate rule error severity- The default severity level for an auto-generated rule that fails validation. For more information about auto-generated rules, see Define import mapping.