How to use the Business Contact Manager Migration Assistant tool to export into Outlook Customer Manager

The Business Contact Manager (BCM) Migration Assistant tool automates migration of business contacts, accounts, and opportunities to Outlook Customer Manager (OCM).

Key features of the BCM Migration Tool:

  • Migrates default business contacts, accounts, and opportunity fields to the equivalent Outlook Customer Manager fields
  • Ability to map additional BCM fields to Outlook Customer Manager custom fields
  • Automatically migrates BCM opportunity stages and creates new Outlook Customer Manager deal stages
  • Migrates Business Notes and Phone Log history to Outlook Customer Manager’s activity timeline
  • Automatically links imported Contacts to Companies, and Deals to Companies and Contacts

FAQ

Q: Do I need Outlook 2016 or the Outlook Customer Manager add-in installed to use the tool?

A: No. You just need to login with the tool using an Office 365 account in a subscription that has Outlook Customer Manager enabled.

Q: Do I need to run the tool on a PC with BCM installed or on the BCM server?

A: No. You can run the tool on any PC that has access to the BCM database on your network while logged into Windows as an authorized BCM user.

Q: Will the tool create duplicates of existing items or will it update them?

A: If an OCM Company or Contact exists with the same Display Name value in the equivalent BCM Account or Contact Full Name field, they will be UPDATED. The relevant fields will be updated with non-empty values from BCM

NOTE: Existing Deals are currently NOT being updated. You may wish to subscribe to the relevant issue to be notified when this logic changes.

Q: What happens if I run the migration again?

A: Previously imported items will NOT be updated, but existing items will be updated again if changes have been made in BCM.

Q: Is the tool free?

A: Yes. However, the tool is currently registered as an Office 365 application associated with Eric Legault Consulting Inc./Rockin’ Software and hosted in that company’s Office 365 tenant. This application will only work in its current state as long as it continues to be hosted in that tenant but there are no guarantees that the application will continue to work due to unforeseen circumstances with the application registration or the Office 365 subscription, or that it will continue to be available for installation from the URL published below. The code can always be changed to use a different application and tenant ID for a different Office 365 account, or compiled and distributed through other means.

Q: Is the source code available?

A: Yes, it is published on GitHub under an MIT license: https://github.com/elegault/BCMMigrationAssistant.

Custom Migration Services

If you would like the migration to be done for you, or customized to accommodate special business scenarios or to export to a different data format, please contact Rockin’ Software by email, web form or book an appointment online.

To start the migration, please use the following steps:

1. Install the BCM Migration Assistant tool

From the BCM machine (or the machine that host the SQL database for BCM), download and install the tool from https://www.ericlegaultconsulting.com/BCM_Migration_Tool/publish.htm

2. Connect to the BCM database

By default, the tool is configured to use the local SQL server name. If you are not sure of your BCM database info, please open Outlook and navigate to File > Business Contact Manager and look for “Manage Database” section below. For example:

If the BCM database name is “OCM10\MSSmallBusiness3”, then use the following value in the tool:

SQL Server: OCM10\MSSMLBIZ

Database Name: MSSmallBusiness3

After you check the information, click “Test Database Connection” before continuing.

3. Connect to Outlook Customer Manager

We recommend that you test the migration with a test Outlook Customer Manager account before running the tool while signed into your actual Office 365 production account. Outlook Customer Manager does not provide a functionality to delete migrated data, and you need to delete every migrated item manually in case you need to redo the migration.

To create a test account, you can sign up for a 30 day Office 365 Business Premium trial from https://go.microsoft.com/fwlink/p/?LinkID=507653 (please note that after you created an Office 365 account, it may take another 24 hours before Outlook Customer Manager appears on the test account).

After you are connected to the database, click the “Login to Office 365” label in the “Connect to Outlook Customer Manager” section and enter your O365 account email to connect when prompted. After you are connected, the account name will be displayed on the upper right corner.

4. Map BCM fields to Outlook Customer Manager fields

For each entity type (Accounts, Business Contacts, and Opportunities), some of the default BCM fields are automatically mapped to default Outlook Customer Manager fields.

Optionally, you may map additional fields to Outlook Customer Manager custom fields (note: you will need to create the custom field before you run the tool (refer to this page for information on how to add custom fields in Outlook Customer Manager).

For example, see below if you want to map BCM’s DoNotCall field (left column) to a custom field of the same name in Outlook Customer Manager (right column):

5. Migrate to Outlook Customer Manager

Click “Start” to begin the migration:

Review the migration reports for any errors during the migration.

Eric Legault

Full-stack product builder & consultant for Microsoft 365 & Graph. Microsoft MVP 2003 - 2019. Outlook add-in guru. Rocker. Video/audio engineer. Collects Thors.

You may also like...

8 Responses

  1. Marco says:

    Hi, I am getting an error when importing the 1285 I already imported with CSV import: ERROR updating ‘Helen Burden’: {“error”:{“code”:”ErrorIncorrectUpdatePropertyCount”,”message”:”An object within a change description must contain one and only one property to modify.”}} Everything else imports properly

  2. Hi Eric, awesome job here! Does this tool also migrate email communication history?

  3. Patrik says:

    Hi,
    testdriving version 1.0.14.0
    when import runs ( a couple of times tried)


    Getting BCM Contacts data
    Found 3171 BCM Contacts:

    Previously imported contacts:
    -xxxxx (BCM ID: 706d248c-da9a-461f-8716-6fefdae83d99)
    Importing Contacts…
    Contact ‘xxxx’ previously imported; skipping
    System.NullReferenceException: The object reference is not set to an instance of an object.
    at BCM_Migration_Tool.Objects.ContactsHelper.d__29.MoveNext()
    Getting contact IDs…

    after this all company’s are imported but only 1 contact

    is this a data or import tool issue

  4. Matt Tognolini says:

    Does this Tool also Migrate Emails that have been imported to BCM?

%d bloggers like this: