Merge Duplicate Records

Merging duplicate company or name records is performed in the Reports module. You will generate a report of possible duplicate records based on criteria you select. Once the report is generated, you can select the Master record, and which records should be merged to the Master record.

  1. Click Reports on the main menu.
  2. Click Auditing Reports.
  3. Select the icon for Duplicate Companies Report or Duplicate Names Report.
  4. Select criteria to locate possible duplicate records. Please note that in selected criteria with more than one item all of the selected criteria must match
    1. To generate a list of possible duplicate companies, you can search records based on:
      1. Company name, phone number
      2. Company name, city
      3. Company name, city, phone number
      4. Company name
      5. Phone number
    2. To generate a list of possible duplicate names, you can search records based on:
      1. First name, last name, home phone
      2. First name, last name, work phone
      3. First name, last name, city
      4. First name, last name, company name
      5. First name, last name
      6. Last name and email address
  5. Click the Print action icon at the top right to display possible duplicates. The report is displayed in a new tab. The count reflects the number of records with the same data as selected.
  6. Click Merge to view the records that are possible duplicates – Here you can select the record if you wish to view the details prior to merging.
  7. If the records should be merged, click the Master check box for the record that you want to be the final record. The record you select as master should contain the most accurate data or most recent data in the fields.
  8. Click the Merge checkbox for each record that should be merged to the master record.
  9. Click Merge. A message will display to alert you that the other records will be deleted, resumes cannot be combined, and to verify that you have selected the proper merge criteria.
  10. Click OK to continue the merge process. A message will alert you when the merge process is finished.

 

PCR also provides the ability to merge duplicate records from the search results screen. For example, if you perform a quick search for a person and two or more Name records are returned who are the same person:

  1. Click the checkbox to the left of each record you want to merge.
  2. Click the Merge action icon at the top right.
  3. If the records should be merged, click the Master check box for the record that will become the final record. The record you select as master should contain the most accurate data or most recent data in the fields.
  4. Click the Merge checkbox for each record that should be merged to the master record.
  5. Click Merge. A message will display to alert you that the other records will be deleted, resumes cannot be combined, and to verify that you have selected the proper merge criteria.
  6. Click OK to continue the merge process. A message will alert you when the merge process is finished.