Riva CRM Integration - Documentation and Knowledge Base

How Do You Want Riva On-Premise to Sync Your CRM and IBM Notes Data

Article ID: 1243
Last updated: 01 Feb, 2017

Audience: Project Team Lead, End-User Evaluation Team, and Riva Administrators

(For a similar article intended for end users, see How Does Riva Sync Your CRM and IBM Notes Data.)

Objectives and the means to reach them

  • To understand Riva's basic sync features, watch videos and read highlights.
  • To glimpse some of Riva's many sync options, look at Riva sync policy screenshots.
  • To start planning your Riva sync policy to achieve your syncing goals, ask yourself questions.

We recommend that, while working through this article, you also keep referring to Create and configure a sync policy for Exchange and IBM Notes.

Contents

Which Users Do You Want Riva to Sync?

Riva supports assigning target users to the sync policy by using mailbox users or IBM Notes groups. If a large number of users will be added to a sync policy, it is easier to use groups. User management would be done in Notes group management. Changes to group member lists will be picked up once daily or if the Riva sync service is restarted.

Riva also supports syncing multiple sync policies at the same time. This allows Riva administrators to design sync policies that best meet sync requirements based on the type of user (in an office or mobile), geographic location (North America, EMEA, APAC, etc.), or type of data being synced (full data sync, calendar only, email only, etc.).

Key questions to ask

  • Q1: How many users will be synced in production?

  • Q2: Is there a requirement for different sync policies?

  • Q3: Will users be moved between sync policies? How often will this occur?

How Far into the Past Do You Want to Go?

When Riva performs a first time sync for a user, it queries the CRM for contacts, leads, calendar items, and tasks to copy to the user's IBM Notes mailbox. Riva includes a Sync Start Time filter option that Riva applies depending on the type of data.

  • Contacts and Leads are filtered based on create or last modified date. Items created or last modified before the Sync Start Time filter are not copied to a user's address book.
  • Calendar items are filtered against the schedule start date. Items scheduled to start before the Sync Start Time filter are not copied to the user's primary calendar.
  • Tasks are filtered based on the scheduled start date or, if a start date is not specified in the task, the filtering is based on the create or last modified date. Items scheduled to start before the Sync Start Time filter are not copied to the user's to-do task list. Items with no start date and created or last modified before the Sync Start Time filter are not copied to the user's to-do task list.

Key questions to ask

  • Q1: How far back into the past do you want to query the CRM to select contacts, leads, calendar items, and tasks to sync to the user's mailbox?

  • Q2: Do you want to set a different Sync Start Time filter for the address book, the calendar, and task items?

How Do You Want Riva to Sync Your Contacts and Leads?

Watch the following videos on contact and lead sync.

Sync contacts and leads between your CRM and IBM Notes

Sync new contacts from IBM Notes to CRM using a category

Sync new contacts automatically from IBM Notes to CRM

First Time Sync: Once a user has been added to a sync policy and Riva runs a first time sync against that user, Riva syncs a filtered list of contacts and leads from the CRM and creates those as contact records in IBM Notes. Those contact records appear in the user's Notes Address Book.

Normal Data Sync: Riva can support bidirectional or unidirectional data syncing between the CRM and IBM Notes. When bidirectional syncing is enabled, Riva, by default, syncs contacts and leads as follows:

  • Riva syncs created, modified, and deleted contacts and leads from the CRM to IBM Notes.
  • Riva syncs created and modified contact records from IBM Notes to the CRM. By default, Riva does not sync deleted IBM Notes contacts to the CRM, because Riva considers the CRM contact, lead, and account records as authoritative over email records.
  • Riva automatically syncs contact and lead changes from the CRM to IBM Notes.
  • Riva can be configured to require a Riva category to be applied to an IBM Notes contact record item before Riva syncs that item to the CRM.
  • Riva can support de-duping IBM Notes contact records against existing CRM contacts for on-boarding and creation purposes.
  • All contact records in IBM Notes that Riva has synced with the CRM are categorized in IBM Notes with a Riva-created category.
  • Riva can filter contact sync based on visibility in the CRM or ownership of the contact record in the CRM, creation or modification dates of contact records, maximum record counts, and custom filters that can be designed by Riva professional services.

Key questions to ask

  • Q1: Do you want Riva to sync contacts?

  • Q2: Do you want Riva to sync leads?

  • Q3: Do you want bidirectional sync, unidirectional CRM to Exchange sync, or unidirectional IBM Notes to CRM sync?

  • Q4: What category name and colour do you want to use to sync contacts? to sync leads?

  • Q5: Do you want Riva to create contacts in the existing default address book or in a separate address book?

  • Q6: Do you want Riva to require a category to sync new or modified IBM Notes contacts or leads to the CRM, or do you want Riva to sync all new or modified items automatically?

  • Q7: In which format do you want Riva to save and display contacts in the IBM Notes client address book ?

  • Q8: Do you want to Riva to filter CRM contacts and leads by all visible or ownership, or apply a custom filter?

  • Q9: Do you want to apply a max record count filter for CRM contacts and leads synced to IBM Notes? If so, what value should be applied to that filter?

  • Q10: Are there any custom CRM contact fields that need to be synced to IBM Notes contact records?

How Do You Want Riva to Sync Your Calendar Events and Tasks?

Sync appointments and meetings between IBM Notes and CRM

Sync CRM tasks between CRM and IBM Notes to-do's

Syncing calendar events

First Time Sync: Once a user has been added to a sync policy and Riva runs a first time sync against that user, Riva syncs calendar items from the CRM and creates those as calendar items in the user's primary calendar in IBM Notes. Those contact records appear in the user's IBM Notes client primary calendar and are colour-coded according to the Riva synced category added to the IBM Notes client.

Normal Data Sync: Riva supports bidirectional and unidirectional data syncing between the CRM and IBM Notes. When bidirectional syncing is enabled, Riva, by default, syncs the calendar as follows:

  • Riva syncs created, modified, and deleted appointments, events (meetings), phone calls, and service calls (for Microsoft Dynamics CRM only) from the CRM to IBM Notes.
  • Riva syncs created, modified, and deleted appointments and meetings from IBM Notes to the CRM.
  • Riva automatically syncs calendar changes from the CRM to IBM Notes.
  • Riva can be configured to require a Riva category to be applied to an IBM Notes calendar item before Riva syncs that item to the CRM.
  • Riva can be configured to ignore private appointments and can treat CRM deletions as cancellations in IBM Notes. For example, if a user deletes a calendar item in CRM, Riva syncs it to IBM Notes and modifies the title of the calendar item to show "Deleted in CRM".
  • Riva syncs recurring appointments from the CRM to IBM Notes (if supported by the CRM).
  • Riva syncs IBM Notes recurring appointments and meetings to the CRM and creates individual calendar items in the CRM.

Note: Riva does not sync marking CRM calendar items as "completed" to IBM Notes.

Calendar syncing questions to ask

  • Q1: Do you want Riva to sync appointments, phone calls, and/or service calls (Microsoft Dynamics CRM only)? Do you want bidirectional sync, unidirectional CRM to IBM Notes sync, or unidirectional IBM Notes to CRM sync?

  • Q2: What category name and colour do you want to use for appointments? for phone calls?

  • Q3: Do you want Riva to require a category to sync new or modified IBM Notes calendar items to the CRM, or do you want Riva to sync all new or modified items automatically?

  • Q4: Do you want to disable reminder sync?

  • Q5: How do you want Riva to sync recurring appointments from IBM Notes to the CRM: sync only the first item, or sync the entire recurring series?

  • Q6: Do you want to treat CRM deletions as cancellations in IBM Notes instead of deletions?

  • Q7: Do you want to ignore all-day IBM Notes events marked with "Show as Free"?

  • Q8: Do you want to skip syncing IBM Notes appointments marked as "Private"?

  • Q9: Are there any special filtering options required for calendar sync?

  • Q10: Do you want to use separate processing rules for calendar sync and email sync?

Syncing tasks

First Time Sync: Once a user has been added to a sync policy and Riva runs a first time sync against that user, Riva will sync task items from the CRM and create those as tasks items in the user's primary to-do list in IBM Notes. Those task items will appear in the user's IBM Notes client primary to-do list and be colour-coded according to the Riva synced category added to the IBM Notes client.

Normal Data Sync: Riva supports bidirectional and unidirectional data syncing between the CRM and IBM Notes. When bidirectional syncing is enabled, Riva, by default, syncs tasks as follows:

  • Riva syncs created, modified, status-updated, and deleted tasks from the CRM to IBM Notes and from IBM Notes to the CRM.
  • If a task is marked as "completed", Riva syncs it as an update and changes the status to "completed" in the corresponding system. Once marked as "completed", Riva stops syncing any changes to the task item.
  • Riva automatically syncs task changes from the CRM to IBM Notes.
  • Riva can be configured to require a Riva category to be applied to an IBM Notes task item before Riva syncs that item to the CRM.

Task syncing questions to ask

  • Q1: Do you want Riva to sync tasks? Do you want bidirectional sync, unidirectional CRM to Exchange sync, or unidirectional IBM Notes to CRM sync?

  • Q2: What category name and colour do you want to use for task sync?

  • Q3: Do you want Riva to require a category to sync IBM Notes tasks to the CRM, or do you want Riva to sync all new or modified tasks automatically?

  • Q4: Do you want to delete previously synced tasks from the CRM if marked as private in IBM Notes?

  • Q5: Do you want to relate IBM Notes task items to CRM contacts?

How Do You Want Riva to Sync Your Email to the CRM?

Riva supports archiving emails into the CRM. Emails will be related to email recipients that can be matched to CRM users, contacts, and leads. Riva does not sync emails created in the CRM into IBM Notes. Emails can be used as a source item to create opportunities, cases, or other module items in the CRM, depending on the CRM. Learn more about how Riva can sync emails.

Sync emails to the CRM as emails

Archive emails from IBM Notes to CRM

First Time Sync: During the first sync, Riva builds, in the user's mailbox, a new folder structure that contains "drop folders". A user can sync an email to the CRM by moving it or copying it into an appropriate "drop folder".

Normal Data Sync: By default, Riva archives emails and matches the email recipients to the CRM user first, then to CRM contacts, and then to CRM leads (if enabled in the sync policy). Riva can be configured to sync emails and create module items in the CRM, typically new opportunities, cases, projects, or quotes. Riva also supports custom objects for some CRMs. For each email placed in a "drop folder", Riva archives it to the CRM as follows:

  1. Riva attempts to match each email recipient and the sender to CRM users. If no match is found, Riva attempts to match to CRM contacts. If no match is found, Riva checks against leads (if configured to do so).
  2. If a match is not found, Riva attempts to create a contact (or lead if configured to do so). For a new contact, Riva tries to match the new contact to an existing CRM account by matching the Company field to CRM account names, then by email domain name (for example, @example.com) to the website field or email address field of CRM account records. If a match is found, the new contact is created and related to the existing CRM account. If no match is made, Riva creates a new account using the Company name field or email domain name, depending on how the sync policy is configured.
  3. For most CRMs, Riva creates an email item. For some, like Salesforce, Riva creates an activity item that appears as a completed task if matched to a CRM contact or lead, or as an uncompleted task if matched to a system user.
  4. Riva moves the email from the drop folder back to either the Inbox or the Sent Items folder and assigns the Processing Complete! category to the email.

The SmartConvert tab of the sync policy has many options that control how email sync is implemented.

Email syncing questions to ask

  • Q1: Do you want to enable email sync?

  • Q2: Do you require that emails must match an existing CRM contact or lead in order to archive them to the CRM? (Such a required match prevents archiving internal emails.)

  • Q3: Do you want to match CC and BC recipients against CRM users, contacts, or leads?

  • Q4: Do you want to disable all contact, lead, and account creation in the CRM?

  • Q5: If you allow the creation of CRM contacts and/or leads, do you want to edit the creation filter to filter out certain domain names like your company domain names? (This filtering prevents creating employee contacts.)

  • Q6: If no matching contact is found, do you want to match against CRM leads?

  • Q7: If the recipient is not matched, do you want to create CRM leads instead of CRM contacts?

  • Q8: Do you want to CRM user and contact matching to be mutually exclusive? (This prevents matching recipients to both a CRM user and a CRM employee contact record.)

  • Q9: Are there any specific special filters or custom categories that need to be supported?

Sync CRM module data to email

Manage, connect to and edit CRM opportunities directly from IBM Notes

Use summary emails to quickly look up Items in the CRM

Normal Data Sync: Riva creates summary emails in the IBM Notes mailbox in the module folders of the drop folder structure, for example the Opportunities folder. Those emails contain summary information about each active module item (for example, an opportunity). Each email also includes a button or website link to open the module item in the CRM in either Edit or View mode.

Supporting CRM module sync questions to ask

  • Q1: Do you want to sync summary emails by module?

  • Q2: Which modules do you want to sync summary emails for? Quotes, opportunities, cases, projects, etc., depending on the CRM?

  • Q3: How do you want to filter summary emails? "Filter by all visible", filter by ownership, or filter by using a custom filter?

Create opportunities and cases from emails

Use SmartConvert to convert an IBM Notes email into a new CRM opportunity

First Time Sync: During the first sync, Riva builds, in the user's mailbox, a new folder structure that contains "drop folders". Drop folders (for example, "- Create New Opportunity") are added for each module that is enabled in the Other tab of the sync policy.

Normal Data Sync: When a user places an email in a "- Create New [module]" folder, Riva processes that email as follows:

  1. Riva attempts to match recipients to CRM users, contacts, and leads. The matching process is the same as when Syncing emails to the CRM.
  2. Riva creates a module item (for example, a new opportunity) in the CRM and assigns it to the user that Riva is syncing.
  3. Riva adds the email to the Activity History of the new module item and of the matched contacts and leads.
  4. Riva syncs a new summary email back to the parent module folder; for example, Riva syncs a summary email back to the Opportunities folder.
  5. If AssignTo is enabled (see Use AssignTo to archive email against existing opportunities and cases), Riva syncs a new email drop folder for the new item. For example, Riva creates a new opportunity drop folder under the \Opportunities\Assign To\ folder).
  6. Riva moves the email back to the Inbox or Sent Items folder and assigns the Processing Complete! category to the email.

SmartConvert questions to ask

  • Q1: For which modules do you want to see a "- Create New [module item]" drop folder, where you can drop emails for Riva to create corresponding module items in the CRM? (For each one of them, be sure to clear the Hide check box.)

Use AssignTo to archive email against existing opportunities and cases

A video to demonstrate the Riva AssignTo option has not been recorded for the IBM Notes client and is, therefore, not available for viewing. The AssignTo email tracking functionality is the same for IBM Notes, Outlook, Gmail, GroupWise, and all mobile clients. The following video demonstrates that functionality in an Outlook email client.

Use AssignTo to archive emails against existing opportunities and cases

Archive emails against opportunities and cases

First Time Sync: During the first sync, Riva adds an \Assign To\ folder under the parent module folder for each module enabled in the Other tab of the sync policy. Riva adds a drop folder for each active module item that is either visible to or owned by the user. The folder name is based on the module item:

  • Opportunity folder names include an index number, the title of the opportunity, and the value of the opportunity.

    Example: \Opportunities\Assign To\[1] 3000 Widgets for Acme Corp (120,000)

  • Case folder names include an index number, the case number, and the title of the case.

    Example: \Cases\Assign To\[1] [12934] Widget control not activating automatically on restart

Normal Data Sync: When a user places an email in an AssignTo drop folder, Riva processes that email as follows:

  1. Riva attempts to match recipients to CRM users, contacts, and leads. The matching process is the same as when Syncing emails to the CRM.
  2. Riva adds the email to the Activity History of the existing module item and of the matched contacts and leads.
  3. Riva syncs an update to the summary email back to the parent module folder. For example, Riva syncs a summary email back to the Opportunities folder.
  4. Riva moves the email back to the Inbox or Sent Items folder and assigns the Processing Complete! category to the email.

AssignTo questions to ask

  • Q1: Do you want to enable AssignTo, so as to archive emails to existing modules?

  • Q2: Do you want to limit the number of drop folders created in the AssignTo folder? (By default, there is a 30-folder limit.)

  • Q3: Do you want to limit the age of items for which drop folders are created and retained? (This option automatically removes drop folders for stale items.)

  • Q4: How do you want your email client to sort your AssignTo drop folders? By date modified, alphabetically, or—for cases—by ascending case number?

This article was:   Helpful | Not helpful
Report an issue
Article ID: 1243
Last updated: 01 Feb, 2017
Revision: 13
Views: 5649
Comments: 0