VSys One: Volunteer Management Software

Previous Topic

Next Topic

Book Contents

Book Index

Check for Duplicated IDs

Within VSys, all internal ID codes should be unique. However, occasionally, more than one record will contain the same ID code. The Check for duplicated IDs tool validates tables and checks for records that may have the same internal ID codes and corrects them so no two IDs are alike.

VSys requires that all VSys and GMS users other than the one running this tool have exited the application while it is fixing the duplicate codes, otherwise a user may lose data or their copy of VSys One may crash. VSys will prevent more than one person being in this tool at a time, but not in your VSys database.

Follow the steps in this task when you receive word from VSys One technical support that you need to find and fix duplicate IDs in the database.

Steps in this task

  1. Be sure all other users are out of VSys and/or GMS.
  2. Click on Check for duplicated IDs from the Administrator tools panel.
    Linked Graphic
    VSys will check all entry and certification tables, unless you de-select those checkboxes under Tables to check.
    When Run in read-only mode... is checked, VSys will look for possible issues, but will not repair them. This is useful as a diagnostic tool.
  3. Click on the Run button.
  4. When complete, VSys gives you an on-screen report of the number and types of records that were updated.

See Also

Tools

Apply Certification Automatic Creation Rules

Attachments Analyzer

Automatically Create Eligibility/Intake Checklists

Data Backup

Bulk Value Updater

Check for Zip/Postal Code Updates

Concurrent Users Monitor

Create and Manage Data Encryption Keys

Database Merge Tool

Enter VSys One Registration Codes

Find Duplicate Assignments

Find Duplicate E-mail Addresses

Find Overlapping Volunteer Hours

Fix Recurring Assignment Detail Gaps

Index Update Tool

Letters Purge Tool

License Information

Make a Local Backup of VSys One in Another Folder

Photo Resize Tool

Purge Old Trace Records

Recalculate the Bonus Hours for Volunteer Hours

Recalculate the Value of Volunteer Hours

Restore From a Backup

Special Table Tools

SQL Commands to Database

Table Permissions Diagnostics

Trace Analyzer