Page History
Contents
- Dynamics CRM Solution
- CRM Updates Service Component
- Custom Dynamics CRM Workflow
- Creating Reports for CRM Workflows
Many clients who use SharePoint to manage their customer facing websites also use Microsoft Dynamics CRM to monitor leads and maintain client relationships. CardioLog allows you to integrate Dynamics CRM into the workflow for more robust report data. Here is a general outline on how the Microsoft Dynamics CRM integration works:
...
Note: Adding customer CRM entities requires customization.
Anchor | ||||
---|---|---|---|---|
|
This custom Dynamics CRM Solution is implemented through the application UI. The solution creates the following entity fields:
...
The CardioLog Report iFrame
Installing the SharePoint Marketing Suite - Follow these steps to install the Dynamics CRM Solution:
- Download the solution file from our site here.
- Open Dynamics CRM and go to the Settings tab > Solutions > Import > and select the solution zip file (CardiologIntegration_0_2_0_5_managed.zip)
- Reload the Dynamics CRM main page
- Under SharePoint Marketing SuiteCardioLog, click Configuration and add the following 3 fields:
- Name = Cardiolog.API.URL, Value = http://[CardioLog App]/cardiologapi/events.asmx/SendEvent?param1=¶m2=&useragent=&clientip
The CardioLog SendEvent web service URL. Edit the CardioLog application server name.
- Name = Cardiolog.API.URL, Value = http://[CardioLog App]/cardiologapi/events.asmx/SendEvent?param1=¶m2=&useragent=&clientip
- Name = Cardiolog.Group.CategoryID, Value = [Category ID]
The CardioLog Category ID - - After the first execution of the CRM Updates Service component, a new category will be created. This category contains the possible values for CardioLogGroupID.
To retrieve the Category ID execute the following query against the CardioLog database:
select Category_Id from tab_category_categories
where Category_Name = 'int_cardiologgroupid'
- Name = Cardiolog.Report.URL, Value = http://[CardioLog App]/CardioLog/CLReport/ContextBasedReport.aspx?timeframe=0&timeInterval=864000000000&startDate=30d&endDate=today&templateId=[user template ID]&entityId=[entity id]
The CardioLog web analytics report URL. Edit the CardioLog application server name. - Create the CardioLog web analytics report for CRM entities:
- In the CardioLog navigation pane go to Settings > Templates > click Add next to User content type and publish it.
For - See Report Templates for more information
about report templates, see http://support- .
intlock.com/entries/20746103-6-report-templatesOpen SharePoint Marketing Suite > Report Center tab > Sample Reports > Visitors > Unique Visitors > edit the report filters and click on Go > drill down on a user in - In the CardioLog navigation pane go to Report Center and browse to the Individual Report Samples folder > Visitors folder > Unique Visitors > Drill down on a user in the Unique Users table, and select the report template.
For more information about drill down see http://support.intlock.com/entries/20445137-5-visual-controls#5.7- Copy the report URL.
- Open SharePoint Marketing Suite > Administration tab > Templates > create a new report template under the User content
The Dynamic CRM Solution Settings dialog
Anchor | ||||
---|---|---|---|---|
|
This service component has 2 functionalities:
- Updating the score field for CRM entities.
- Retrieving CRM entity fields for filtering and segmenting reports. User names correspond to CardioLog IDIDs.
Configuring the SharePoint Marketing Suite Follow these steps to configure the CardioLog - CRM Updates service component:
- Configure the User Categories Updates service in SharePoint Marketing Suite CardioLog in order to retrieve CRM entity fields:
- Open [CardioLog Installation Folder]\CardioLogScheduleServices\Settings.config and edit the following:<param><handlerId>4</handlerId><name>webServiceURL</name><val><![CDATA[http://[CardioLog App]/VisitorSegments/DynamicsCRM2011Users.aspx]]></val></param>
- Open [CardioLog Installation Folder]\VisitorSegments\CRMSettings.xml and edit the following:<CRMSettings><instance id="1" type="dcrm"><webServiceUrl url="http://[DCRM server]/MSCrmServices/2007/CrmService.asmx" /><organizations><organization id="1" name="[Organization Name]"><entities><entity name="[Entity Name]" cardioLogIDFieldName="int_cardiologid"><attributes><attribute id="1" name="[Field Name]" /></attributes></entity></entities></organization></organizations></instance></CRMSettings>
- DCRM server name
- Organization Name
To retrieve the organization name, open CRM > Settings > System > Administration > Business Units > Name - Entity Name
To retrieve the entity name (only entities supported by CardioLog - Lead, Opportunity, Contact and Customer), open CRM > System > Customization > Customizations > Customize the System > Components > Entities > Name (for example the name of the Lead entity is lead) - Field Name
To retrieve the field name, open CRM > System > Customization > Customizations > Customize the System > Components > Entities > Entity Type (for instance Lead) > Fields > Name (for example the name of the Lead Source field is leadsourcecode)
3. Open SharePoint Marketing Suite > Administration tab > CardioLog In the CardioLog navigation pane, go to Administration > CardioLog Scheduling Service > CRM Updates > and set the desired scheduling type for this service and restart the . Click Restart Service in the upper right hand corner of the CardioLog Scheduling Service windows servicewindow.
Note: The CardioLog application pool account should have read/write access to Dynamics CRM.
Filtering and segmenting SharePoint Marketing Suite CardioLog Reports by CRM entities and entity fields:
- Filtering reports by CRM entities:
- Open SharePoint Marketing Suite > Report Center tab > click CardioLog and from the navigation pane select Report Center, then click the desired report and select Edit
- Click Under Filters, click Users and Groups roups and select the Customize option
- Enter the CRM entity name (CardioLog ID) in the Name field and then click Add.
- Segmenting reports by CRM entity fields:
- Open SharePoint Marketing Suite > Open CardioLog and from the navigation pane select Report Center, then tab > click click the desired report and select Edit
- Click Under Filters, click Visitor Segments and select the Customize option
- Click the CRM entity field (under User Categories) and select the Customize option
- Enter the field value in the Name field and then click Search. Select the desired result and click the Add button to add include it to in the filter setting.
Anchor | ||||
---|---|---|---|---|
|
This custom CRM workflow sends entity events (Lead, Opportunity, Contact and Customer) events (such as status update) by calling eg., status updates) by accessing the CardioLog SendEvent web service:
- CRM asynchronous workflow rules (using a custom workflow assembly) will react to the desired entity events.
- For each event the workflow calls CardioLog's web service and sends the relevant data.
- Event URL has the following format: CRM | entity | status | reason
For more information about the default Microsoft CRM values for status (StateCode) and reason (StatusCode), see http://msdn.microsoft.com/en-us/library/ms914670.aspx
The Custom CRM Workflows dialog
Anchor | ||||
---|---|---|---|---|
|
- From the Navigation Pane, click on Report Center tab > create a new report. For more information about how to create a report, see http://support.intlock.com/entries/20451026-6-report-center#6.1
- Add the Page Views > Events and Visitors > Unique Users by Events reports
- Enter "CRM" in the Portal Item URL field and click Go
...