ConnectWise Importer
Table of Contents
The ConnectWise Importer uses the ConnectWise API to bring your data over from ConnectWise to Syncro as historical data, and you will be able to view that information in your Syncro account.
The ConnectWise importer will import the following:
- Customers: (Companies) Business Name, Email, Phone
- Sub Contacts: Name, Address
- Tickets: Summary, Number, Date
- Ticket Notes: Text, Creator, Date
Note: If your import stops unexpectedly, it is safe to restart the import without risking duplicate records.
Prerequisites
- Register for a CW Developer account if you do not have one.
- ConnectWise requires a Client ID to use their API. You can register for a Client ID here (in the upper right, click Register).
Note: Like the API keys, Syncro does not store the Client ID after the import is complete. - Set up your API keys in the ConnectWise app: (see also this illustrated guide for screenshots, or the ConnectWise documentation below).
- In the upper right, click PSA > My Account.
- Click the gear icon tab.
- Click the API Keys item in the left-hand list, then click the right arrow button to move it to the right-hand list.
- Click Save & Close.
- Click the newly added API Keys tab.
- Enter a Description.
- Below the Defaults tab, click the disc icon to save.
- Copy the Public and Private keys generated and save them somewhere.
See also: this illustrated guide for screenshots, or Setting Up API Keys.
Import Your Data
- In Syncro, navigate to Admin > RMM Settings - Migration Tools.
- Click the ConnectWise Importer tile.
- Fill in the fields as follows:
- ConnectWise Company Name: This must match exactly what is in ConnectWise.
- Public API Key: The Public key you saved from the Prerequisites.
- Private API Key: The Private key you saved from the Prerequisites.
- ConnectWise API Host
-
Cloud Hosted:
- North American Cloud: api-na.myconnectwise.net
- European Cloud: api-eu.myconnectwise.net
- South African Cloud: api-za.myconnectwise.net
- Australian Cloud: api-au.myconnectwise.net
- Self-hosted/On-premise: Your on-premise public URL.
-
Cloud Hosted:
- Client ID: The Client ID you registered for in the Prerequisites.
- Click Import Now.
Test the API Using a PowerShell Script
Here's some sample code for testing in PowerShell. Replace the values as appropriate:
$CWMConnectionInfo = @{
# This is the URL to your manage server.
Server = 'server.example.com'
# This is the company entered at login
Company = 'My Company ID'
# Public key created for this integration
pubkey = '1234'
# Private key created for this integration
privatekey = 'abcd'
# Your ClientID found at https://developer.connectwise.com/ClientID
clientid = 'Go generate your own ClientID'
}
# ^This information is sensitive, take precautions to secure it.^
# Install/Update/Load the module
if(Get-InstalledModule 'ConnectWiseManageAPI' -ErrorAction SilentlyContinue){ Update-Module 'ConnectWiseManageAPI' -Verbose }
else{ Install-Module 'ConnectWiseManageAPI' -Verbose }
Import-Module 'ConnectWiseManageAPI'
# Connect to your Manage server
Connect-CWM @CWMConnectionInfo -Force -Verbose
Setting Up API Keys
Note: This is section is taken directly from the ConnectWise Documentation.
Using the same setup screen as creating a Member an API Member allows granular control over what type of information an integration has access to. A global user allows integrations to be turned on and off easily without requiring the person who initially setup the integration.
The Members screen can be found by going to the System Module and opening the Members page. After accessing the Members page, click the API Members tab. Here you can create a new user and generate API Keys for them.
API Members do not require a user license.