“Not In” \ “Does Not Have” Query in Dynamics CRM – By Cobalt

In Dynamics CRM Advanced Find, Querries can be built for various conditions \ for various filter criteria. But, “Not In” type queries cannot be built and it doesn’t work with OOTB querying. Cobalt has a cool feature which allows users to make “Not In” \ “Does Not Have” types of queries in Advanced Find and for Views.

The Problem:

One Account can have many Cases. Dynamics CRM can display all the “Accounts which has Cases” in Advanced Find\Views. But, Dynamics CRM cannot display all the “Accounts which has no Cases” using Advanced Find\Views.

query1

Solution:

Use “Does Not Contain Data” clause for filtering Continue reading ““Not In” \ “Does Not Have” Query in Dynamics CRM – By Cobalt”

Advertisements

Microsoft Dynamics CRM content packs for Power BI – Web and Mobile

Power BI transforms data into rich visual forms such as Different Graphs, tables, Reports and into many more types. Power BI is capable of taking data from files, databases, and online services.

Power BI has Sales Manager and Service Manager content packs which can be used to connect to Dynamics CRM Online and Power BI. Following content packs can be used to connect and visualize a rich set of predefined Dashboards and Reports. Content packs use OData feeds to get data from OOTB entities in Dynamics CRM Online 2016.

  • Microsoft Dynamics Online Sales Manager Content Pack
  • Microsoft Dynamics Online Service Manager Content Pack

This is how you can use it with Power BI and Sample Data comes with Dynamics CRM 2016 Online have been used for examples.

1. Connect to Power BI with the Office 365 account.

1

2. Click on “Get” under the “Services” tile to get the content packs. Continue reading “Microsoft Dynamics CRM content packs for Power BI – Web and Mobile”

Solution Enhancements in Dynamics CRM 2016

Clone a Patch, Clone Solution, and Apply Solution Upgrade are the cool new features released with Dynamics CRM 2016.

CRM Solution is an excellent way of transferring customizations from one environment to another and solution version helps to identify each set of customizations of transferring. CRM solutions will contain different components such as entities, processes, plugin assemblies, user roles etc…. There are two types of CRM solutions called unmanaged and managed. Usually, development environment of any CRM solution will contain the unmanaged solution and that will be transferred to test\production environment as a managed solution, which is not supposed to edit directly in those environments.

However when transferring CRM solutions from one environment to another, even if you change only one component or only one piece of a component you have to send the whole solution to the other environment to apply the change in the other solution.  Also, the changes will be applied in the other destination environment as soon as you import the managed solution from the development environment.

1

Dynamics CRM 2016 has set of new features added to solve the above difficulty and has introduced a more methodical way of managing patches and solution versions. Following topics describe those new features in detail using a CRM solution named “CORE” containing 3 system entities(Contact, Account and User) and one custom entity(Application). Continue reading “Solution Enhancements in Dynamics CRM 2016”

Dynamics CRM – Azure Integration (Part 3) : Explore Service Bus Messages

Detailed explanation on Dynamics CRM – Azure Integration. Technologies, mechanisms, tools and issues are enclosed under three topics in three connected posts.

Connected Posts:
Dynamics CRM – Azure Integration (Part 1) : Create Azure Service Bus Namespace
Dynamics CRM – Azure Integration (Part 2) : Create Dynamics CRM Service Endpoint
Dynamics CRM – Azure Integration (Part 3) : Explore Service Bus Messages


Azure Portal Queue\Topic Dashboard

Azure portal shows stats, monitoring, usage for each component in the Namespace such as Queue, Topic etc.

QueueUsage

Service Bus Explorer

Service Bus Explorer is a good tool to manage, monitor and test entities (Queues\Topic-Subscriptions\Relays\Event Hubs). Service Bus Explorer tool can be Continue reading “Dynamics CRM – Azure Integration (Part 3) : Explore Service Bus Messages”

Dynamics CRM – Azure Integration (Part 2) : Create Dynamics CRM Service Endpoint

Detailed explanation on Dynamics CRM – Azure Integration. Technologies, mechanisms, tools and issues are enclosed under three topics in three connected posts.

Connected Posts:
Dynamics CRM – Azure Integration (Part 1) : Create Azure Service Bus Namespace
Dynamics CRM – Azure Integration (Part 2) : Create Dynamics CRM Service Endpoint
Dynamics CRM – Azure Integration (Part 3) : Explore Service Bus Messages


Detecting a Change in Dynamics CRM Records

In Dynamics CRM there are few ways of detecting record changes. It is really important to track\trigger changes in Dynamics CRM systems when synchronizing data between systems.

Change Tracking is a new feature comes with latest Dynamics CRM version and this feature can be used to get a bulk of records changed in an entity. It always provides changes compared to the last retrieval  of changes. Also, this will not raise the change as soon as it happens. Some code has to be executed externally and should get the changed records from the specific entity.

CRM Workflow executions in an event is another solution of detecting changes. With the real-time workflows, the workflow can be started before or after the change.

In this post, we discuss sending Plugin Execution Context to Azure and solving issues related to that.

 

Get the Plugin Execution Context Out

Plugins can be registered to track record changes. Plugin execution context has lots of information on the record change such as data changed, images, plugin step information etc. If we need to get the record changes and related information out of CRM we can use plugins and perform any action on that data. Also, we can integrate Dynamics CRM and Windows Azure using a Service Endpoint to Azure.

PluginExecutionContext

Plugin steps can be created for different entities at different events of Continue reading “Dynamics CRM – Azure Integration (Part 2) : Create Dynamics CRM Service Endpoint”

Dynamics CRM – Azure Integration (Part 1) : Create Azure Service Bus Namespace

Detailed explanation on Dynamics CRM – Azure Integration related technologies, mechanisms, tools and issues is enclosed under three topics in three connected posts.

Connected Posts:
Dynamics CRM – Azure Integration (Part 1) : Create Azure Service Bus Namespace
Dynamics CRM – Azure Integration (Part 2) : Create Dynamics CRM Service Endpoint
Dynamics CRM – Azure Integration (Part 3) : Explore Service Bus Messages


 Windows Azure Services

Microsoft Windows Azure or Azure’s compute mainly offers three types of offerings; Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS).

Simply under Infrastructure as a Service (IaaS), Azure offers servers in the cloud \ virtual machines which give the feeling like a server that has been setup manually with hardware, operating system and running other applications in it. It provides Networking, Storage, Servers and Virtualization.

Windows Azure itself can be taken as a Platform as a Service. Windows Azure offers Middleware services including messaging, listening services, processing messages etc. under this. These components are really awesome when extending application behaviours, exposing to other systems and distributing services to other systems. Service Bus and its entities such as Queues, Topics, Relays, Event Hubs and Notification Hubs play a vital role under this.

Azure Websites are cheapest and easiest method of getting an application on the cloud. Web applications can be deployed from anywhere and Azure take care of CI, network traffic, availability etc.

Understanding Windows Azure Service Bus

Azure Service Bus is a generic, cloud-based messaging system for connecting applications, services and devices. Service Bus is a multi-tenant cloud service which can consist of namespaces with different types of messaging mechanisms. Depending on the requirement messaging mechanisms can be selected and the choices are; Queues, Topics, Relays and Event Hubs.

AzureServiceBusNamespace

Namespaces can be defined under Azure Service Bus. Namespace is Continue reading “Dynamics CRM – Azure Integration (Part 1) : Create Azure Service Bus Namespace”

Publishing Products in Dynamics CRM

Products in the CRM product catalog need to be published before they used in Quotes, Orders and in Invoices. There are several ways to publish products. Recently I wanted to import a list of products to a Dynamics CRM from another system. I imported them directly to the CRM using data import wizard but faced difficulties when publishing them in CRM. From Products view, CRM doesn’t allow to publish multiple products at once as bulk edit feature.

Publish Products under a Product Family

Select the product family and from the ribbon select Publish Hierachy. CRM will publish the product family and all the items under it such as products, bundles and kits.

2

 

Publish Products with no Product Family

Whenever a product created in CRM, that is published(Active) automatically by enabling this setting under System Settings in CRM. But this is only applicable for the products with no product family.

3

 

You can Publish Products programmatically using CRM SDK as well 🙂

 

Azure Topic Issue : This client is not supported for a partitioned entity. The client version should be greater or equal than version ‘2013-10’

Dynamics CRM execution context can be sent to Azure Service Bus by using a registered plugin step using the plugin registration tool. However there can be issues when triggering events from Dynamics CRM entity and sending the context to the Azure service bus topic.

Issues raised when trying to send any context to Azure are shown in System Jobs (Settings>System Jobs).

1IssueShowsInCRM_Fortress.png

The records which have issues are waiting under the System Jobs and if you open up any such record you will see the actual issues raised from the CRM as follows.

1IssueShowsInCRMDetail Continue reading “Azure Topic Issue : This client is not supported for a partitioned entity. The client version should be greater or equal than version ‘2013-10’”

Sending Dynamics CRM Execution Context to Azure Service Bus

Nowadays different software systems are connected with each other in different ways to exchange data and services among them. Also maintaining cloud spaces for hosting and using cloud services have become very popular in the industry. Dynamics CRM 2016 can be hosted as on premise and it’s available as Online as well and it supports exposing its execution context to Microsoft Azure Service Bus to easily communicate with the other applications, services or devices connecting from anywhere. Dynamics CRM plugin registration tool can make Azure aware the executions in CRM.

Service-Bus-Fanout1

Assume that there’s a need to update some other system on a change of data in an entity in CRM. One approach is to bring changed data in to an online location and the other system to read those data and update its data stores accordingly. Azure service bus is a cloud service that maintains queues and topics to act as intermediate location between two systems. Specialty is that; Dynamics CRM can automatically send data with its context in an event available in Dynamics CRM such as Create, Update, Delete etc…

Azure Service Bus

Azure service Bus is a generic, cloud based messaging system for connecting services, applications and devices from anywhere. It supports two types of communication models such as Queues and Topics.

Understand Azure Service Bus using following resources; Continue reading “Sending Dynamics CRM Execution Context to Azure Service Bus”

Creating Word Document Templates for Dynamics CRM 2016

DocumentTemplates

Found a very good article on creating word document template for Dynamics CRM 2016 and just experienced the cool feature in CRM 2016 Online, provided from Dynamics CRM team.

Using document templates, users can generate standardized documents with data in CRM. Also Excel document templates can be created under document templates.

Here’s the link to the article;

https://www.microsoft.com/en-us/dynamics/crm-customer-center/using-word-templates-in-crm.aspx