KaviŽ Members Help

Chapter 175. Check Data Integrity

Overview

Use this tool to check for discrepancies between fields required by Web site configuration and the actual content of these fields in the database. Even though rules established through site configuration are enforced through User, Company and Admin tools, discrepancies sometimes arise. This is usually due to changes in site configuration, but it can happen during batch uploads or other processes that allow some circumvention of rules normally enforced through tool pages, etc.

Back to top

How to Check Data Integrity

Select the checks you want to perform and set the tool to automatically fix issues that lend themselves to being repaired automatically. These fixes can be previewed before committing any changes to the database, but every option you've checked on this step will be fixed in one batch commit unless you opt not to make the changes on the Preview step. Set the email address where you'd like the Integrity Check Results Email to be sent.

Select

Select the options to create the type of integrity check you want to perform and press Next.

Check

Company types assigned through membership

Check that Company Types that are only assigned through membership have been assigned appropriately, and report on any member companies that lack the Company Types that should have been granted according to the membership they hold, and any companies that have types they shouldn't have.

The fix: Company Types assigned only through membership will be removed from companies that don't have the correct membership, and companies that lack any Company Types that should be assigned through their membership will have these added.

User types assigned through membership

Check whether individual members have all the User Types that they should have according to the type of membership they hold.

The fix: User Types assigned only through membership will be removed from users who don't have the correct membership, and individual members who lack any User Types that should be assigned through their membership will have these added.

Member companies without memberships

Identify any companies with the purpose of 'Member Company' that lack memberships.

No automatic fix is available.

Individual members without memberships

Identify any users with the purpose of 'Individual Member' who lack memberships.

No automatic fix is available.

Inactive companies with a current membership

Companies with current memberships should be active. Identify any companies that hold a membership but are inactive.

The fix: Inactive companies with current memberships will be activated. No email is sent to these companies or their representatives.

Inactive individual members with a current membership

Individuals with current memberships should be active. Identify any individuals who hold a membership but are inactive.

The fix: Inactive users with current memberships will be activated. No email is sent to these users.

Orphaned memberships

Identify any memberships that don't belong to a member (i.e., the company's or user's purpose has changed to a purpose that is incompatible with membership, but the membership record still exists).

The fix: Orphaned memberships will be deleted and types assigned through membership will be revoked.

Member companies without a primary contact

Every member company should have a primary contact designated. Identify any companies that lack a primary contact.

No automatic fix is available.

Check email addresses against company accepted domains

If accepted domains are enforced for the Web site, identify any company representatives whose primary email address isn't on their company's list of accepted domains.

No automatic fix is available.

Check for empty required fields

Identify any company or user record where any required field is empty.

No automatic fix is available.

Fix Data

Fix data problems

Select this option if you want to have data fixed automatically if the tool finds any data integrity issues that can be repaired automatically. You will have the option of previewing any automatable repairs and committing or cancelling these repairs on the next step.

Report only: Do NOT change any data

Select this option if you don't want any changes to be made automatically. If you change your mind later, you can always perform another data integrity check an set this option to 'Fix data problems'.

Email Results To

Set the address where you want the results email sent, such as the address you are currently monitoring.

Preview

A list of the changes that will be made to the database is provided. Press Run Check if you want to perform the check and commit any changes you have selected to the database. If you want to reset any options, press Back to return to the previous step.

Done

You've just checked the database for the most common types of errors and a report has been emailed to the specified address. If you elected to fix data problems automatically, these changes will have been committed to the database.

Back to top

Related Topics

Back to top