by OPEN CX GmbH

Better Data Quality

Free Trial

By clicking you consent to share your profile with the developer

Admin Guide

ICC Data Quality – Configuration Guide

1. License Key Validation

1.1

Navigate to SugarCRM > Admin > "ICC Settings for Data Quality" > License Configuration

1.2

Enter the License Key and click Validate to activate the license.

2. Configuration of Quality Levels

2.1

Navigate to SugarCRM > Admin > "ICC Settings for Data Quality" > Data Quality
OR via URL: *sugarurl*/#ICC_DataQuality

3. Creating Quality Levels

3.1

Open the Record View by clicking the Create button or via the Action Menu in the navigation bar: "Create Data Quality".

3.2

The Quality Level is defined here. The Name field is auto-populated but can be edited manually.

3.3

Select the Module: Choose between Account or Contact.

3.4

Select Quality Levels – One record must be created for each level. Please follow this order (from lowest to highest):

  1. Mandatory fields incomplete (Lowest)
  2. Low
  3. Normal
  4. High (Highest)

Note: The system detects missing levels during validation. These are logged in sugarcrm.log, and the corresponding records will be cleared.

3.5

Field Selection – Select the relevant fields for each level.

Note: Logically, fields from a lower level should be included in the next higher level.

3.6

Team Permissions – Valid teams can be assigned via the "Valid for Team" selection.

Recommendation: To minimize errors, it is best practice to create a complete set of quality levels for each specific team (if required).

4. Optional: Degradation of Quality Levels

Used for lowering quality scores over time based on inactivity or age.

4.1

Navigate to SugarCRM > Admin > "ICC Settings for Data Quality" > Lower Data Quality Settings
OR via URL: *sugarurl*/#ICC_DQ_Settings

4.2

Click Create or use the Action Menu: "Create Data Quality Setting".

4.3

The Name field is auto-populated.

4.4

Select the quality levels in the same order as above (Mandatory fields incomplete up to High).

4.5

Define the timeframe in the field: "Lower Level after (days)".

5. Execution & Final Checks

5.1

Starting the Initial Check

  1. Go to SugarCRM > Admin > "ICC Settings for Data Quality".
  2. Click "Start Data Quality Check for all Records" (the status will change to "Data Quality Check Running").
  3. Confirm the data change to start the process.

Note: Cronjobs must be active, as the background job handles the population and updates of the Data Quality values.

5.2

Verifying Layouts

5.2.1 – Listview: A new column "Data Quality" should be available (may need to be enabled via column settings).

5.2.2 – Recordview: The "Data Quality" field should be located at the bottom of the first panel.

5.2.3 – Functional Test: Verify the logic for both existing and new records.

Note: In case of conflicts, please refer to the previous notes and logs.

Saving Comment Saving Comment...