Email Connector: Difference between revisions

From RangerMSP Wiki - PSA software for MSPs and IT services providers
Jump to navigation Jump to search
No edit summary
No edit summary
Line 26: Line 26:
For more details see [[Ticket Management#Email Distribution via CommitCRM Email Connector|Email Distribution via CommitCRM Email Connector]].
For more details see [[Ticket Management#Email Distribution via CommitCRM Email Connector|Email Distribution via CommitCRM Email Connector]].
<br><br>
<br><br>
[[File:Commit_email_connector_email_threading_flow.gif|center]]
[[File:email_connector_email_threading_flow.gif|center]]
<br>
<br>



Revision as of 14:27, 15 May 2020

User Manuals > Email Connector

Introduction

The CommitCRM Email Connector module allows you to process incoming emails and perform appropriate actions (like creating new Tickets). It also allows you to parse and analyze XML formatted emails that contain new Tickets, Accounts, Assets or other CommitCRM record information.

The CommitCRM Email Connector module automatically provides the following features:

  1. Generates new Tickets from emails sent by clients to a defined public email address.
  2. Manages email threads for existing Tickets (Email Distribution via CommitCRM Email Connector).
  3. Provides a full API to CommitCRM using XML formatted email messages.

This instructional video covers the basic Email Connector Installation flow, to review it please click here.

File:Commit email connector overview chart.zoom542.PNG

Email Threading

The Email Connector manages email threads for you. If a customer replies to your support email in regards to a specific ticket, or if you, as a technician, reply to the customer, the correspondence will be automatically filed under the ticket in the system and distributed automatically to the recipients defined for the Ticket.

File:Commit email connector flow.gif

There are two email threading scenarios:

  1. A customer replies to Support regarding an email sent from the system, which contains a ticket number in the email subject. In this case, the system files the email under the ticket and distributes it to the Ticket Recipients.
  2. An employee replies on a customer email, which contains the ticket number in the email subject. The employee needs to send the email to the support email address, and CommitCRM Email Connector will automatically file the email in the system and distribute it to the Ticket Recipients. When a technician Cc or Bcc's the Email Connector, the email will be filed in the ticket, and will not be distributed to Ticket Recipients.


Note that the email threading management will apply only when the sender email address is defined as one of employee's emails (Email1 or Email2), and the employee is marked as an Active employee in CommitCRM. See more details on matching the email to an account in Matching by Email or Domain Name. In both cases, the Email Connector receives the email, finds the ticket in the subject, finds the ticket in the database, and then files the email as a document under the ticket history.

For more details see Email Distribution via CommitCRM Email Connector.


Matching by Email or Domain Name

CommitCRM connects an incoming support email to specific accounts based on the full email address of the sender, or by the domain name (if defined for the account).

If one of your clients has many possible email addresses, you should either add each of the email addresses as the email in the secondary contact (in the Account Contacts tab), or define the client's domain name in one of the Account's email addresses or secondary contacts.

To define a domain name for an account:

Set the domain name (e.g. "commitcrm.com", with or without the @ sign) as the email address in one of the following places:

  • Account's Email field (in the General tab)
  • Account's Email 2 field (in the Address tab)
  • Add a secondary contact, and set the domain in the contact's email field

Notes:

  1. Account detection will first try finding the full email address.
  2. Only if this email address does not exist in the database, the system will search by the domain name.
  3. Duplicate domain names will create an error when processing the incoming email. Note that the system does not prevent entering duplicate domain names.
File:Commit email connector setup processing domain name.gif

CommitCRM Email Connector Setup

The CommitCRM Email Connector is a plug-in for the CommitCRM Server. Setting up the CommitCRM Email Connector module includes using general settings used by the CommitCRM Server, and specific settings for the Email Connector plug-in.

To run the configuration application:

  1. Log into the Server with a Windows Administrator user. Note that the setup program must run from the same server as the one where the CommitCRM installation sits and from where you plan to run the Email Connector.
  2. Run <Installation_DIR>\CommitCRM\Server\ServerConfig.exe

The following window will open:

[[File::Server_outgoing_mail_server_settings.png|center]]

The server configuration window consists of the following tabs:

  1. Public Email Address - the main email address used by you and your clients. All emails sent to this address will be processed by CommitCRM Email Connector.
  2. Outgoing Mail Server Settings - outgoing emails settings for sending emails by the CommitCRM Server.
  3. Email Connector Settings - CommitCRM Email Connector settings.
  4. Email Alerts Settings - CommitCRM Email Alerts settings (not in the scope of this document).

In order to use the CommitCRM Email Connector, the following settings should be configured (in this order):

  1. Public Email Address - The Public Email Address is the main support email address (e.g. support@yourdomain.com) to which customers can send support-related emails.
  2. Outgoing Email Settings - These settings will be used by the CommitCRM Server for all outgoing emails (by CommitCRM Email Connector or CommitCRM Alerts Server).
  3. Incoming Email Setup – These settings include the Public Email Address for all emails processed by the CommitCRM Email Connector.
  4. Email Processing Setup - Define how incoming email is processed. CommitCRM Email Connector reads each email and performs the actions as defined in these settings.
  5. Internal Support Team Email - Define settings for the Internal Support Team Email, which is used if the system cannot decide what to do with the Email, or if there are errors.
  6. Installing and Running CommitCRM Email Connector Service - After setting up all of the above, you should actually install the Email Connector service and run it on your server.

Only once the setup is complete can you run the CommitCRM Server and start using the CommitCRM Email Connector plug-in.

Public Email Address

The Public Email Address is the main support email address (e.g. support@yourdomain.com) to which customers can send support-related emails. Tickets are automatically created out of these emails, and this address is also used to process XML-formatted emails (API) sent by external systems, such as a form on your website. All Emails sent to this email address will be analyzed and processed by the CommitCRM Email Connector.

Note: This email address should ONLY be used as the incoming email for the Email Connector. You should define a different address for your internal email which will be used for unrecognized emails and error handling (see Internal Support Team Email).


Outgoing Email Settings

The Outgoing Email settings are used for any outgoing emails sent from CommitCRM Server.

Note: The Outgoing Email settings should be set only once for the CommitCRM Server, so if you already defined this for the Email Alerts Server, you can skip this step.

The Outgoing Email settings should be set in the Outgoing Mail Server tab.

To reduce errors and improve security, it is strongly recommended to use SMTP authentication, with a user name and password for SMTP access.

Parameters:

  • SMTP Host - your Outgoing SMTP Mail Server
  • Port - the Outgoing SMTP port
  • My outgoing server (SMTP) requires authentication - if checked, must fill in the authentication details below:
    • User Name - the User Name to be used for SMTP authentication
    • Password - the password related to the specified User Name


Note: If you use SSL on your Email servers, this should be automatically supported (for users working with CommitCRM 6.0 or higher). If for some reason you are facing problems connecting via SSL, please contact our support directly ar support@commitcrm.com.

Verification Tests (required!):

  • Test SMTP Connection - click this option to verify that your account is working. If there is missing or incorrect information, such as your password, you will be prompted to supply or correct it.
  • Send Test Email - Use this option to send an outgoing email using the settings you defined. After clicking it you need to specify the From email address and the To email address that will be used for sending the Test Email message.

After completing the Outgoing settings, move on to the next step > Setting up the Incoming Email Settings.

Incoming Email Settings

After setting up the Outgoing Email settings, you should now define the incoming mailbox settings.

To set up the Incoming settings, go to the Email Connector tab:

In this window, fill in the settings as explained in the following sections:

  1. Email Connector Status.
  2. Public Email Address (defined separately in the Public Email Address tab).
  3. Incoming Mail Server.
  4. Backup Settings (optional).

Email Connector Status

The CommitCRM Email Connector status can be one of the following:
ON (default) - CommitCRM Email Connector is active and processes incoming emails.
OFF – CommitCRM Email Connector is not active and does not process incoming emails (emails are left in the defined mailbox until you review them manually or turn the connector to ON again.

Note that in order for the status changes to take effect, you should restart CommitCRM Server Service (see Running CommitCRM Email Connector).


Public Incoming Mail Server

In this section you will define the pop server settings of the incoming email server:

Server Information
POP3 Host - your Incoming Mail Server (POP3)
POP3 Port - the Incoming Mail Server port (POP3)

Logon Information
User Name - this is the incoming public support email account used for the Incoming email address described above.
Password - the password for this email account.

Note: To use CommitCRM Server service with Microsoft Exchange servers, ensure that POP3 is enabled for the relevant account in the Exchange server.

Note regarding SSL: If you use SSL on your Email servers, please read this article in order to find out how to set up the CommitCRM Email Connector with SSL.

Misc.
Test - click Test to verify that your account is working. If there is missing or incorrect information, such as your password, you will be prompted to supply or correct it.
Advanced - set up timeouts for the connection and polling interval (in most cases you should use the default values).

After filling in the information on this screen, we recommend you test your account by clicking the Test button (requires you to run the setup program from the Server).



Email to Ticket Settings

After setting up the Incoming Email Settings, you should now define the settings which will be used when converting incoming emails into Tickets in the system.

When receiving a new incoming email, the system recognizes the email sender's address or domain from the CommitCRM Accounts database; it automatically opens a Ticket and copies the email content into the Ticket description (the text/plain part). The Ticket will be automatically linked to the Account that matches the email address.

Incoming emails which relate to existing Tickets will be filed under the Ticket History. See more details in Email Distribution via CommitCRM Email Connector.

Matching by Email or Domain

Matching the incoming email to a CommitCRM Account is performed based on the full email address of the Account, or by the domain name (if defined for the account). This is because clients may be using generic email addresses (such as Yahoo®, Gmail®, etc.) and the system cannot rely on any domain name. If one of your clients has many possible email addresses, you should either add each of them as a secondary contact (in the Account Contacts tab), or define the client's domain name in one of the Account's email addresses or secondary contacts. See more details in Matching by Domain Name.

Auto-Response Settings

You can configure the system to automatically send response emails to customers, confirming that a new ticket has been created for their email message.

to configure the automatic response settings, scroll down to the Email to Ticket tab:

To activate the Auto-Response feature:

  1. Send Response – Select this option in order to send automatic email responses and notify your customers who sent emails that became new Tickets.
  2. Use the following Email Template – Choose the Ticket Email Template which will be used when sending the auto-response email for new Tickets.

See more advanced options for the Auto-Response feature in Advanced Options.

Email messages from unrecognized senders

When creating tickets from unrecognized senders is enabled, such email messages are converted into the Tickets under your business record. The ticket then can be easily reassigned to the relevant Account. See Move a Ticket from one Account to another.

Use ServerConfig to turn this feature on or off:

Notes: Verify that you have a Spam filter installed on your mailbox, otherwise all spam messages will get converted into tickets!

Advanced Options

Note that the Email Connector also provides more advanced processing options, such as using the Email Connector as an API (via XMl transactions), or using Automated Emails. You can read more about the advanced Email Connector options in the Advanced Email Processing section.

Clicking the Advanced Options button in the Email to Ticket tab opens the following window:

Here you can define the following options.


Store-Folder Settings

When creating Tickets from emails, all original email files (.eml) are stored on a dedicated folder on your server's local disk, so that they can be attached to their Ticket.

Using this option you can define an alternative default filing folder on your server. Note that this is an advanced option that should only by used by advanced users. Please contact support@commitcrm.com before using this option.


In order for the Email Connector service to be able to save the emails in the new folder, you must configure the folder location so that the service will have the correct access to it.

In the Default Filing Folder, and define both paths, as the server recognizes it and as the client recognizes it.


Backup Settings (optional)

Once an incoming email has been processed by the system, it is removed from the email server (i.e. deleted from the mailbox). For backup and tracking purposes, you can automatically forward all emails to a dedicated email account for storing.

This is an advanced option, and we do not recommend on using it without consulting our support team at support@commitcrm.com.


To set up the backup email account:
Backup ALL Incoming Emails – select this option to activate the backup.
Send ALL to this Email Address – Enter the Backup Email Address which will be the backup mailbox. Note that this must be a different email address than the Email Connector Incoming Email Address to avoid deadlocks where the backup email is being sent to the Incoming Email Address over and over again

After completing these settings, move on to the next step > Setting up Email Processing Settings email-to-ticket settings).

Automatically Add Ticket Email Recipients

As part of the Email Connector email threading management, it offers the ability to automatically scan processed email message headers to find relevant email recipients (To and Cc) and automatically add them as Recipients in the relevant Ticket in CommitCRM.

Administrators can control whether to activate the automatic scanning of email messages for recipients from this window under General Settings > Automatically find and add Ticket Recipients.

File:Commit email connector setup email header scan advanced.gif


In this window you can determine whether to automatically find and add ticket recipients for employees or external recipients.

See Automatically Add Ticket Email Recipients in the Ticket Management user guide for more details about this powerful feature.

Auto-Response Advanced Options

Clicking the Auto-Response Emails options button opens the following window:


Here you can define the following options:

  1. Embed Web Links - Web Links allow your customers to quickly open the customers' Web portal and view or edit the Ticket details. This saves the need to go explicitly to the Web Interface site, login and search for the Ticket in order to see its details. Choosing this option will add Web Links if defined in the email template selected above.
    Note: Web Links require using CommitCRM Web Interface for Customers, and that Web Links are enabled in Options > Web Interface tab.
  2. Attach the original email to each response – Select this option to attach the original email sent by the client to the response email.



Send Auto-Response to all external recipients

When this feature is enabled, auto-response emails sent by the Email Connector will be sent to all Ticket Recipients – this includes those marked in CommitCRM as default recipients for the Account as well as all other recipients existing in the original customer email. This way everyone can easily participate in the email thread and their reply will automatically be filed under the Ticket in CommitCRM.

Auto Adding of New Secondary Contacts for Recognized Account

If an email arrives from a new address and the sender domain exists in the Accounts database then a new Secondary Contact can be automatically created under the relevant Account, with the email sender display name taken as the Contact Name.

If appropriate, a new Ticket is created with that new Secondary Contact set as the Ticket Contact. If the email is a reply to an existing Ticket from a previously unknown sender at the known domain then a Secondary Contact is created based on the new sender.

To configure this:

  1. Run the ServerConfig utility.
  2. Click the Email Connector tab.
  3. Go to Advanced Options.
  4. Click Configure in the General Settings section
  5. Check the relevant box to enable/disable.



Show Ticket in Dispatcher

New Tickets that are created by Email Connector automatically appear in the Dispatcher Ticket list by default. This means that all new Tickets that are created will automatically be marked as "To be Dispatched" by the system.

Users can change this behavior:

  1. From any CommitCRM client, go to Tools > Options > Tickets-1 tab.
  2. Select or deselect the option Show in Dispatcher > By default, set to display new Tickets in Dispatcher to make the system behave as you require.
  3. Then restart CommitCRM Server service on your server so new Tickets will be marked accordingly.

Note: The Show in Dispatcher flag can be modified by any user and it affects tickets being created from anywhere - in the client application, by the CommitCRM Email Connector or by other applications. Make sure you use it consistently.


Notifying Customers and Technicians on new Tickets

Email Connector allows you to notify your customers that the emails they sent became new Tickets.

You can set Email Connector to send an automatic response back to the customer, notifying him or her that a Ticket was opened out of his /her email. When you configure this in the ServerConfig, you can also define a BCC address for keeping track of these emails. In the BCC address you can enter your Internal Support email to receive each notification as an email.

All automatic responses are automatically forwarded back to the Email Connector, and filed under the Ticket as part of the ticket history.

Assigning SLA to New Tickets Automatically

Tickets that are created automatically by the Email Connector, can be automatically assigned to an SLA by defining a default SLA for the Account or for the default Contract of this Account (see How does the system select a Default Contract?). The SLA Feature helps you provide services to your customers within the time frame agreed with them.

If a default SLA is defined for the Account (see Default SLA for Accounts and Contracts), the ticket created by Email Connector will be automatically assigned to it.

Internal Support Team Email

After setting up the Outgoing Email Settings and the Email to Ticket Settings, you should now define the Internal Support Team Emails (for forwarding purposes).

The Internal Support Email address is your main activity support mailbox which should be constantly reviewed by your support team. This mailbox will be used by the system in cases where the system cannot decide what to do with the email. The Email Connector will automatically forward these messages to this email address which should be reviewed by a "human" support team to identify emails which need to be handled manually.

Note: If the Ticket was not found in the CommitCRM database, the email will be forwarded to the Internal Support Team email, with an error indicating that the Ticket cannot found.

The Internal Support Email Address is set in the following window:

Email Address - This is an internal mailbox which will be used by your support team (e.g. support-internal@yourdomain.com). This mailbox should be manually reviewed on a regular basis to make sure there are no customer issues awaiting response which were filtered out for one of the reasons listed above.


The Internal Support Email address is used for the following purposes:

  1. Unrecognized emails – Unrecognized emails from new customers not yet in the CommitCRM database will be forwarded to this address (and no Ticket will be created).
  2. Error Handling - Emails which could not be processed due to errors during the process (such as the wrong format in XML formatted emails) will be forwarded to this mailbox.

Make sure not to use the same email address for the Internal Support Email as you do for the "Public Email Address." Also, make sure that emails sent to the Public Email address and the Internal Support Email address do not end up in the same physical mailbox (i.e. that they are not synonyms/aliases for the same mailbox).


After setting up all of the above, you are now done with the setup and can move on to actually running the service and activating the Email Connector. See more details in Running CommitCRM Email Connector.


Running CommitCRM Email Connector

After you finish setting up all of the required settings (see CommitCRM Email Connector Setup Overview), you can move on to the next step and install the CommitCRM Server service.

The CommitCRM Email Connector runs as a plug-in for the CommitCRM Server service. The CommitCRM Server runs as a Windows Service on your server.

Before you install the CommitCRM Email Connector

  1. Make sure to complete the above Setup steps prior to installing the Windows Service.
  2. Make sure to allow the CommitCRM Email Server Service in your DEP settings.


Install Service

This part of the installation should be performed on the server itself.


Automatic installation       (requires CommitCRM 14 and up)

Log in to to your Server with a Window's Administrator account and run the installer from:

<Installation_DIR>\CommitCRM\Utils\Install\InstallServerSideWindowsServices.exe



OR   -  

Manual installation

  1. Open a command prompt window: Right-click the command prompt icon and and choose 'Run As Adminsitrator'.
  2. Type the following command:

    <Installation_DIR>\CommitCRM\Server\CommitServer.exe -install

    Note: The <Installation_Dir> must refer to a LOCAL server path (e.g. C:\ or D:\Software, etc.) and NOT to a shared network name/path.
  3. Wait for a success message to appear, indicating the service was installed successfully.
  4. Open the Windows Services Management windows from Control Panel > Administration Tools > Services.
  5. Verify that a Window's service called CommitCRM Server is now displayed the services list.
  6. If the service is not there, make sure again that you are running the command prompt Window using 'Run as Administrator' and try again.

Running CommitCRM Server Service

  1. Once the CommitCRM Server Service is installed, setup the CommitCRM Alerts Server as explained in CommitCRM Alerts System Settings.
  2. You should also make sure all the users (employees) configure their own Email Alert settings so they will receive Alerts.
  3. Open the Windows Services Management windows from Control Panel > Administration Tools > Services.
  4. Locate the CommitCRM Server service and start the service (right-click > Start).
  5. Make sure that it is set to start automatically with a Delayed Start (Startup type > Automatic Delayed Start) each time the server is restarted.
  6. (Optional) Allow the CommitCRM Server Service in your Windows' Server DEP settings. DEP can be found under Windows: System Properties -> Advanced -> Performance - Settings -> tab DATA EXECUTION PREVENTION.

Troubleshooting:
In any case of problems, see the CommitCRM Email Connector Troubleshooting.

Uninstall Service

To Uninstall CommitCRM Server service:

  1. Open the Windows Services Management windows from Control Panel > Administration Tools > Services.
  2. Stop the CommitCRM Server service.
  3. Open a command prompt window: Right-click the command prompt icon and and choose 'Run As Adminsitrator'.
  4. Type the following command:

    <Installation_DIR>\Server\CommitServer.exe -uninstall



Advanced Email Processing

API by Email

The Email Connector provides advanced processing options, such as using the Email Connector as an API by sending in XML transactions by email.

Setting up the API by Email section is optional and is required only when working with external system which send XML formatted emails to the Email Connector.

See more details in API by Email

Automated Emails

The Email Connector provides advanced processing options, such as using formatted Automated Emails.

Setting up the Automated Emails is optional and is required only when working with external systems (such as external MSP system) which send formatted email alerts to the Email Connector.

The Automated Email feature in CommitCRM processes incoming emails that have been sent to the Email Address defined for the Email Connector. The emails processed are from automated sources, such as an MSP alerting application, and the Automated Email feature analyzes the email's header in order to create the relevant Tickets in CommitCRM.

This feature allows you to define a set of rules which will be activated one after the other to help the system detect pre-defined email formats, and create Tickets for them. As opposed to the "New Ticket From Email" feature, automated emails do not necessarily originate from a customer's email address, so it is difficult for the system to determine the customer for whom a new Ticket should be opened.

The Automated Email feature allows you to define a set of rules that will help the system detect automated incoming emails which contain information about specific customers, and create Tickets for them.

See more details in Automated Emails


Labels

Since version 7 the Email Connector can have default Labels defined so that all Tickets created through Email to Ticket or Automated Emails will have the default labels applied automatically. See more details here.



Troubleshooting

For troubleshooting, see Email Connector Troubleshooting


See Also