Skip to main content

Workbooks
  • Knowledge Base
  • Customer Forum
  • Suggestions
  • Training
  • Support Portal
Login
  1. Home
  2. Support
  3. Knowledge Base
  4. Knowledge base
  5. People & Organisations
  6. De-duplication and Merge
Support

Knowledge Base

Browse our knowledge base articles to quickly solve your issue.

  1. Home
  2. Support
  3. Knowledge Base
  4. Knowledge base
  5. People & Organisations
  6. De-duplication and Merge
  • Welcome to the Knowledge Base
  • Introduction
    • Introduction to Workbooks
    • Using the Knowledge Base
    • Editions & Licensing
      • Renewing Licences
    • Workflow
      • Queues
    • Logging In
      • Configuring Security Policies
      • Google Authentication
      • Login Protection
      • Microsoft Azure Active Directory
        • Link Workbooks to Microsoft Azure
        • Setting up User Templates
        • Locking down your Workbooks
  • Training
    • Training Videos
    • Training Courses
  • Desktop Environment
    • Supported browsers
    • Introduction
    • Desktop
      • Setting up and configuring the Modern Theme
      • Tips & Tricks on the Desktop
    • Records
      • External Links to Workbooks records
      • Tabs
      • Watching Records
      • Notes
    • Landing Pages
      • Bulk Actions
        • Scheduled Bulk Actions
      • Customising Views
        • Customising Columns
        • Filtering
          • Custom Filters
        • Calendar Views
      • Deleted Items
      • Edit Grids
    • HTML Editor
    • Welcome Messages & Bulletins
    • Exporting Data
    • Multi Language
    • Notifications & Reminders
    • Workbooks Mobile Client
      • Modern UI on Mobile/Tablet
  • Preferences
    • Introduction to Preferences
    • Setting your Preferences
      • Email Accounts
  • Activities
    • Introduction to Activities
    • Using Activities
      • Meetings
        • Integrating Workbooks and Google Calendar
          • Installing and Managing Workbooks and Google Calendar Integration
          • Synchronising your Google Calendar with Workbooks
      • Follow-on Activities
  • Cases
    • Introduction to Cases
    • Displaying & Adding Cases
    • Managing Cases
    • Case Portal
      • Installation
        • Custom Fields
        • Case Portal Configuration
          • Company Details
          • General
            • Case Portal Reports
          • New Case
          • Help Text
          • Emails
          • Advanced Features
          • Field Mappings
          • Help Dialog
          • Product Area Questions
        • Case Portal Additional Features
          • Setting up Public/Private Activity creation
          • Setup Registration Emails from a Person
          • Automatic Emails on Case Status Change
      • Using the Case Portal
        • Case Updates - Public & Private Activities
        • Inviting a Person to the Case Portal
  • Email
    • Introduction to Email
    • Working With Emails
    • Email Signatures
    • Sending Bulk Email
    • Common Email Errors
    • Email Integrations
    • Mailing Lists
  • Forecasts & Quotas
    • Introduction to Forecasts & Quotas
    • Sales Forecasts
      • Adjusting Forecasts
      • Included Forecasts
    • Sales Quotas
  • Importing Data
    • Introduction to Importing
    • Preparing your Import Data
      • Import Templates
      • Compulsory fields for Import
    • Workbooks Import Wizard
      • Uploading your data
      • Defining Field Mappings
      • Extending your Import to other Record types
      • Checking for Duplicates
      • Running and Reviewing your Import
    • Managing your Imports
      • Undoing an Import
  • Leads
    • Introduction to Leads
    • Displaying & Adding Leads
    • Converting Leads
  • Marketing
    • Introduction to Marketing
    • Marketing Campaigns
      • Displaying & Adding Campaigns
      • Campaign Management
      • Campaign Membership
      • Tracking URLs on Campaigns
      • Integrating Workbooks and Constant Contact
      • Integrating Dotmailer and Workbooks
        • Configuring Workbooks and Dotmailer
      • Integrating MailChimp and Workbooks
        • Configuring Workbooks and MailChimp
    • Mailing Lists
      • Creating Mailing Lists
    • Products
      • Pricing Schemes
      • Supply Scheme
      • Product Bundles
    • Mailshots
      • Creating a Mailshot
    • Upload Library
      • Using the Upload Library
    • Templates
      • Creating Templates
      • Creating a Template to show multiple lines
      • Extra Template Placeholders
    • Workbooks Web Insights
      • Tracking Code
        • Restricting Page Tracking
      • Setting up the Plugin
      • Viewing Web Insights Data on your Form Layouts
      • Domain Names and Online Activities
      • Gator Popup
      • Reporting incorrect Leads created through Web Insights
      • Reporting on Web Insights data
      • Using UTM Values
      • Why aren’t Online Activities being created in the database?
      • Why is GatorLeads recording online activities in a foreign language?
    • Using HubSpot with Workbooks
    • Event Management
      • Introduction to Event Management
      • Enabling the Event Management Module
      • Using Event Records
        • Event Records
        • Event Sessions
        • Event Speakers
        • Event Sponsors
        • Event Products
        • Event Tickets
        • Event Attendees
      • The Event Management Portal
        • Introduction to the Event Management Portal
        • Prerequisites for installation
        • Accessing the Plugin
        • Installing the Event Management Portal
        • Amending Event Portal Parameters
        • Adding Custom CSS to the Event Portal
      • On The Day Registration App
      • Setup On the Day Registration App
    • Compliance Records
      • Introduction to Compliance Records
      • Enabling Compliance Records
      • Creating Compliance Records
      • Using Compliance Records
    • GatorMail Integration
      • Setting up the Integration
      • Sending Mailshots using GatorMail
        • Creating a GatorMail Mailshot without a Marketing Campaign
      • Gator Smart Forms
      • GatorMail - Dynamic Content
        • Dynamic Content Example - Dynamic Sender
      • GatorMail Domain Setup
      • GatorMail Field Mappings
        • GatorMail Hard Bounces
      • Managing your GatorMail Account
      • Setting up GatorMail Workflows
        • Spotler Data Sync
        • Triggered Mailshots
      • GatorCreator
      • GatorSurveys
  • Opportunities
    • Introduction to Opportunities
    • Displaying & Adding Opportunities
    • Opportunity Line Items
    • Opportunity Relationships
  • Integrations
    • Mapping
      • Introduction to the Mapping Module
      • Using the Mapping Module
      • Changing the size/colour of Map Pins
    • Electronic Signing Tools
      • Docusign Integration
        • DocuSign Functionality
          • Copy Document on Signature
          • Update Related Records
          • Sending Multiple Documents
          • People, Organisations & Cases with DocuSign
          • Invoice Payments with DocuSign
          • Managing DocuSign Documents
        • Setting up the DocuSign Integration
          • Authentication with DocuSign
          • Production vs Sandbox
          • Creating a Document with a DocuSign Template
          • Creating a Document with a Workbooks PDF
          • DocuSign Fields
          • DocuSign Settings
          • Form Layout Configuration
        • DocuSign - Worked Examples
          • Taking Payments
          • Updating Related Records
          • Multiple Document Sends
          • Creating a Template for Cases
          • Creating a Template for Organisations
          • Creating a Template for People
          • Unified PDF for Transaction Documents
        • DocuSign - Reporting
          • Multiple Send Report Grid
          • Document Review Report
          • Monitoring Integration Errors
      • Adobe Sign Integration
        • Introduction to Adobe Sign
        • Authentication with Adobe Sign
        • Installing the Integration
        • Integration Monitoring & Error Handling
        • Setup of Adobe Sign
        • Adobe Sign Fields & Form Layout Configuration
        • Optional Custom Fields for Adobe Sign
        • Adobe Sign Button Process
        • Using the Adobe Sign Integration
    • Creditsafe Integration
      • Installing the Creditsafe Plugin
      • Configuring Organisations to use the Creditsafe Integration
      • An example of how to use the Creditsafe Integration
    • Zapier
      • Introduction to Zapier
      • Available Triggers and Actions
      • Linking your Workbooks Account to Zapier
      • Setting up Zaps
        • Posted Invoices to Xero Invoices
        • Xero payments to Workbooks Tasks
        • New Case to Google Drive folder
        • New Case to Basecamp Project
        • New Workbooks Case to JIRA Ticket
        • Jira Issue to new Case
        • 123FormBuilder Form Entry to Case
        • Eventbrite Attendee to Sales Lead and Task
        • Facebook Ad Leads to Sales Leads
        • Wufoo Form Entry to Sales Lead
        • Posted Credit Note to Task
        • QuickBooks Online
          • Initial Setup
            • Authentication with QuickBooks Online
          • People & Organisations to QuickBooks Customers
          • POSTED Workbooks Invoice to QuickBooks Online
          • QuickBooks Online Payment to Workbooks Invoice & Task
          • QuickBooks Sales Tax Code Lookup
        • Survey Monkey responses to Tasks
      • Multistep Zaps
    • Email Integrations
      • Email Dropbox
        • Setting up your Dropbox
        • Using your Dropbox
      • Workbooks Exchange Server Sync
        • WESS System Requirements
        • Setting up the WESS
        • Synchronising Emails
        • Synchronising People & Contacts
        • Synchronising Tasks & Meetings
        • WESS Troubleshooting
        • The WESS Add-in
          • Introduction to the WESS Add-in
          • Enabling the WESS Add-in
          • Customising the WESS Add-In
          • Managing Emails with the WESS Add-in
            • Relating Emails to Specific Records
          • Managing Contacts with the WESS Add-in
          • Managing Records with the WESS Add-in
            • Creating Records with the WESS Add-in
      • Workbooks Outlook Connector
        • Introduction to the Outlook Connector
        • Before downloading the Outlook Connector
          • System Requirements
          • Enabling the Outlook Connector
        • Download/update the Outlook Connector
        • Installing the Outlook Connector
          • Uninstalling the Outlook Connector
        • Using the Outlook Connector
          • Configuring the Outlook Connector's Settings
          • Identifying Records in Workbooks created in Outlook
        • Outlook Connector Troubleshooting
    • Event & Webinar Integration Tools
      • GoToWebinar
        • Installation
          • GoToWebinar Fields & Processes
          • Setting up Process Buttons for GoToWebinar
        • Authentication
          • Multiple GoToWebinar Accounts
          • Removing GoToWebinar Accounts
        • Create/Update & Cancel Webinars from Events
        • Event Attendees as Webinar Registrants
        • Event Speakers as Webinar Panelists
        • Retrieve Webinar Data
      • ON24
        • Installation
          • ON24 Fields & Processes
          • Setting Up Process Buttons for ON24
        • Authentication with ON24
          • Removing ON24 Accounts
        • Create Webcasts from Events
        • Event Attendees as Webcast Registrants
        • Retrieve Webcast Data
          • Reporting: Survey Responses
          • Reporting: Poll Responses
        • Retrieve Survey Data
        • Engagement Hub Interactions
    • Microsoft Office
      • Azure Active Directory
      • Excel
      • Outlook
      • Power BI
      • SharePoint
        • Installation
          • Custom Fields & Processes
        • Setup
          • Sharepoint Configuration
            • Allow SharePoint to Display in iFrames
          • Authentication
          • SharePoint Integration Settings
        • Using the SharePoint Integration
      • Word
        • Introduction to the Word Add-in
        • Deploying the Word Add-in
        • Creating Word Add-in Templates
          • Example Word Add-in Templates
        • Using Word Add-in Templates
        • Word Add-in Tips and Tricks
    • Outreach
      • Installation
        • Outreach Fields & Processes
        • Create Outreach Custom Field Mappings
          • Configure Outreach Field Dynamic Picklist
        • Sync Outreach Mappings
      • Outreach Authentication
        • Remove Outreach Account
      • Sync People to Outreach Prospects
        • People Field Mappings
      • Sync Organisations to Outreach Accounts
        • Organisation Field Mappings
      • Sync Workbooks Opportunities to Outreach
        • Opportunity Field Mappings
      • Sync Outreach Tasks/Calls/Meetings to Workbooks
      • Sync Deleted Workbooks Records
      • Outreach Email Events to Online Activities
    • Scribe/Workbooks Connector
      • Connection Setup
      • Connector Control Blocks
      • Worked Example - Create, Read, Update & Delete
  • People & Organisations
    • Introduction to People & Organisations
    • Organisations
      • Displaying & Adding Organisations
      • Customers & Suppliers
    • People
      • Displaying & Adding People
      • Adding People to Outlook
    • Relationships
      • Change Employer Wizard
      • Direct Relationships
      • Third Party Relationships
    • De-duplication and Merge
      • Data Quality
    • Using Postcode Lookup
    • Data Enrichment
      • Introduction to Data Enrichment
      • Setting up Data Enrichment
  • Reporting
    • Introduction to Reporting
      • Creating Reports
        • Standard Workbooks Reports
        • Creating a Pre-populated Report
        • Creating a Report from a Template
          • Report Templates
        • Creating a Blank Report
        • Auto-refreshing Report Views
      • Sharing Reports
    • Using Reports
      • Reporting Explained
        • Adding Targets, Conditional Formatting and CSS Styling
          • Calculated Targets
        • Reporting with multiple currencies
        • Drilling into Summary Views
        • Improving Report Performance & Run Time
      • Displaying reports within Record Views
      • Displaying Reports
        • Reporting Views (Reports on Landing Pages)
      • Adding a Report view to a Dashboard
    • Charts
      • Creating & Using Charts
        • Bar Charts
          • Targets on Bar Charts
        • Line Charts
        • Pie Charts
        • Dial Charts
    • Exporting Reports
      • Emailing Scheduled Reports
    • Advanced Reporting
      • Using Calculated Columns
        • Introduction to the IF Statement
        • Introduction to the CASE Statement
        • Applying Search filters in Calculated Columns
        • Comments in Calculated Columns
        • Financial Year Reporting
        • Introduction to Date Functions in Reports
        • Using Calculated Criteria
      • Audit Reporting
  • Dashboards
    • Adding Elements to Dashboards
      • Configuring Dashboard Elements
    • Dashboard Views
    • Dashboard Fields
    • Creating a Sales Dashboard
    • Adding a Dashboard as a Record Tab
  • Transaction Documents
    • Introduction to Transaction Documents
      • Displaying & Adding Transaction Documents
      • Copying Transaction Documents
      • Transaction Documents Fields Help
      • Transaction Documents Line Items Help
      • Printing & Sending Transaction Documents
      • Managing Transaction Document Currencies
      • Managing Transaction Document Statuses
    • Credit Notes
    • Customer Orders
    • Invoices
    • Quotations
    • Supplier Orders
    • Contract Management
      • Displaying & Adding Contracts
      • Using Contracts with Cases
    • Sagelink
  • Auditing
    • Auditing
  • Configuration
    • Introduction to System Administration
      • Quick Start Wizard
    • Users & Security
      • Users
        • Setting up your Users
        • Disabling Users
      • User Groups
        • Capabilities
        • Creating & Modifying User Groups
      • Permissions
        • Sharing Policies & Mandatory Permissions
          • Configuring the Advanced Security Module
            • Configuring the Advanced Security Module: Segmenting Users by function
            • Configuring the Advanced Security Module: Segmenting Users by location
      • Account Settings
      • Licences & Modules
    • Database
      • Databases
      • Storage Usage
      • Prefixes & Numbering
        • Modifying Object References
      • Export Database
      • Database Settings
    • Accounting
      • Accounting Periods
      • Exchange Rates
        • Setting Exchange Rates
      • Tax Regimes
        • Setting Tax Rates
        • Sales Tax Rulesets
          • Using Sales Tax Rulesets
      • Own Organisations
        • Setting up your Own Organisation
    • Email & Integration
      • Email Settings
        • Setting up your Email Server
        • Using Workbooks Server to send Emails
      • API Keys
      • Web to Case and Web to Lead
        • Setting up a Web2Case Form
        • Setting up a Web2Lead Form
        • Using Web Forms in Workbooks
        • Editing a Web Key Form
      • Preference Centre
      • MailChimp, Constant Contact & dotMailer
      • Loqate
      • Bank Account Validation
    • Customisation
      • Creating & Modifying Picklists
      • Record Types
        • Creating Custom Fields
          • Dynamic Linked Items & Picklists
          • Constrained Dynamic Linked Items (DLI) & Picklists
          • Creating relationships with Dynamic Linked Items (DLIs)
          • Linking Custom Field Values
        • Report-based Custom Fields
        • Linked Fields & Reference Fields
        • Record Templates
        • Form Layouts
          • Customising an Organisation form
          • Read-only Assigned to Fields
          • Card View
        • Customising relationships between parties
          • Configuring Custom Party Relationships
        • Opportunity Stages
      • Custom Records
        • Enabling Custom Records
        • Creating Custom Record Types
          • Editing Custom Record Types
        • Using Custom Records
    • Automation
      • Plugins
      • Processes
        • Process Logging
      • Workbooks Scripts
        • Script Library
        • How Workbooks Runs Scripts
        • Workbooks Script External Access
      • API Data
      • Triggers and Webhooks
        • Configuring Triggers and Webhooks
    • PDF Configuration
      • Modifying Document Templates
        • Adding Terms & Conditions to your Documents
        • Multi-line Value Tags
      • Modifying Default Colours & Images
      • Creating Custom Document Templates
  • Contact Support
    • Contacting Workbooks Support
    • Workbooks CRM Advisory Packs
    • Introduction to the Administrator Service
  • Releases & Roadmap
    • Roadmap
    • December 2020 Release
    • September 2020 Release
    • April 2020 Release
    • January 2020 Release
    • September 2019 Release
    • February 2019 - Event Management Release
    • January 2019 Release
    • October 2018 Release
    • May 2018 Release
    • February 2018 Release
    • January 2018 Release
    • November 2017 Release
    • September 2017 Release
    • June 2017 Release
    • March 2017 Release
    • December 2016 Release
    • August 2016 Release
    • January 2016 Release
  • Workbooks Glossary
    • Workbooks Glossary

De-duplication and Merge

Did you know...

There are template reports to help you identify duplicate People and Organisations? These are available within Start > Reports > New Template Report. Simply searching for 'Template Name Contains Duplicate' will highlight these reports.

It's easy for duplicate records to creep into your database, no matter how careful you are to avoid it.  Workbooks detects duplicates using the main email address on Person records. On Organisations, it removes the common business suffixes from the end of the name, like Ltd or Corp, then does a 'starts with' search on Organisation names.  For example, for 'Aerosystems PR Ltd' Workbooks would consider 'Aerosystems Products' as a duplicate.

If you have duplicate records in your database, Workbooks has the ability to merge them together. Only Person or Organisation records can be merged and up to 5 records can be merged at a time.

You must have the Merge module enabled, and the user must have the Merge Duplicate Records Capability. The user must also have full permissions on the records that are about to be merged. NOTE: Merging CANNOT be undone and the duplicate records will be deleted once the merge has completed. Therefore, we advise that only System Admins are given this capability, especially if you have any integrations that would fail if the records required by the integration are no longer in the system.

Users with the Merge Duplicate Records capability will see a Merge button at the top of Person and Organisation records. As shown below, if Workbooks finds a duplicate, the button will change to orange and indicated the number of duplicates that have been found.

Click the orange button to view the duplicates that Workbooks has identified. 

  1. Click Add additional duplicate records to open a search window where you can find other records that you know to be duplicates, even if the name is somewhat different.
  2. Tick the checkbox(es) next to any records that show in the list that you know are not duplicates, then click Selected records are not duplicates.  This will stop the orange button from appearing in future.
  3. Click Cancel Merge if you don't want to proceed in any way.
  4. Tick the checkbox(es) next to any records that show in the list that you know ARE duplicates, then click Merge selected records. 

If you click the fourth option, Merge selected records, you'll see a screen similar to the one below, which will display each record you've selected to merge in a separate column.

By default, Workbooks treats the record you started with as the 'master' record and assumes you want the values in that record to be kept.  You can see that each field has a radio button next to it.  If you want to keep the specific field's value from one of the duplicate records, click the radio button next to that field  

NOTE:  If you have an integration with an external system, or regularly use Object References in your imports, then be careful that you are not deleting records with Object References that are used in these processes.

Clicking Next takes you to a screen showing you the values that be kept in your resulting merged record.  If you do not want to go ahead, click the cross in the top right hand corner of the screen.  If you're happy that the information is correct, click Merge.  You'll be asked if you're sure so click Yes or No as appropriate.

A background task will now be started to merge the records together, which includes moving Notes, Activities and Relationships across to the remaining merged record, and updating any records with fields linked to the original records so that they relate to the merged record. These background tasks and their status can be found in the Data Quality Landing Page by going to Start > Bulk Changes > Data Quality. You will receive a notification once the merge is complete.

The Contact Details tab of the record will now show a greyed out row for the previous Main Location Contact Details for each of the records you just merged together.

To help you identify duplicate records that haven't been highlighted with the orange merge button you can use the template reports that we provide for you. Three are available:

  1. Template - Possible Duplicate Leads
  2. Template - Possible duplicate organisations - suffix and prefix
  3. Template - Possible Duplicate People

They give you some variants, providing counts of things like People with the same name or Organisations with the same name and postcode.  It's worth running them from time-to-time and merge anything appropriate to help keep your database as clean as possible.

NOTE:

  • It is not possible to merge any Organisation records with your Own Organisation.
  • If merging 2 people with different employers, i.e. the past employer and the current employer, we advise that you go through the Change of Employer wizard first, to ensure that the 'previous employer' relationship is created.
  • Some information may be lost. For example, if more than one of the Person records had been members of a single Campaign. Only one of the Campaign memberships can be kept, so the membership status and information in custom fields on the other memberships will be lost.

 

  • Third Party Relationships
  • Data Quality

© 2021 Workbooks.com - privacy & terms
  • Linkedin
  • Twitter
  • Youtube
  • Facebook