How to: Microsoft CRM 2011 Integration example (Part 2 – Get data out of CRM 2011)

First things first, at this point in time I assume

  • you’ve read the previous post
  • downloaded and installed the CRM2011 SDK
  • have a working CRM2011 environment to your proposal.
  • you have an account for CRM2011 with sufficient rights (I’d recommend System Administrator)
  • have visual studio 2010 installed.
  • downloaded and extract my visual studio example solution

 

So you’ve met all the requirements mentioned above? Good; let’s get started.

 

Note: all code should be used for Demo/Test purposes only! I did not intent it to be Production Grade. So, if you decide to use it, don’t use it for Production Purposes!

 

Building your Custom Workflow Activity for CRM2011

Once you’ve downloaded and extracted my visual studio example solution, it is time to open it and fix some issues.

 

 

Ensure your references are correct

Go to the Crm2011Entities Project and extend the references folder and remove the following two references

 

image

 

Once done, we are going to re-add these references; so right click on the References folder of the Crm2011Entities Project and click ‘Add Reference’

 

image

 

Now click on the ‘browse’ button, in the add reference dialog window

image

 

Now browse to your Windows CRM 2011 SDK BIN folder (in my case: B:InstallMicrosoft CRMSDK CRM 2011bin) and select the following two assemblies:

  • microsoft.xrm.sdk
  • microsoft.xrm.sdk.workflow

 

image

 

Now repeat the above mentioned steps for the other project

 

image

 

 

Generate a strongly typed class of all your existing CRM entities.

Open op the “Crm2011Entities Project”, and notice that it does not contain any files except a readme.txt file.

 

Q&A session

Me: Well let’s add a file to this project, shall we?

You: Hmmm, what file you ask?

Me: Well this project will hold a class file which contains all the definitions of your CRM 2011 Entities.

You: O no, do I need to create this myself?

Me: Well lucky you, there is no need for this.

You: So how do I create this file then?

Me: Well just follow the steps mentioned below

 

So let’s fix this, and open up a command prompt with administrator privileges.

image

 

Now navigate to your CRM 2011 SDK Folder (in my case this would be: B:InstallMicrosoft CRMSDK CRM 2011bin)

image

 

Note: Before you proceed, ensure that you know the url of the  the CRM2011 OrganizationService. Just test it, by simply browsing to this address, and if everything goes right you should see the following page:

 

image

 

 

now type in the following command (and replace the values between <….> with your values (see readme.txt)):

 

image

 

Once completed, you should be presented with the following output:

image

 

The actual file should be written to the location you set and in my case this is: c:Temp

image

 

Once the actual class has been generated, open Visual Studio and right click on the CRM2011Entities project and select  ‘Add Existing Item’

image

Browse to the directory in which the generated class was saved, and select the generated class.

image

 

At this point you should be able to compile the complete solution, so go ahead and do so.

Note: The source code; includes comments which should be self-explanatory

 

 

Making the custom workflow activity available in CRM2011.

So you’ve successfully compiled the solution, so what’s next? Well now it’s time to import this custom created activity in CRM2011.

 

In order to do this we will use this nifty application which comes with the CRM2011 SDK. This application is called ‘pluginregistration’ and can be found in the subdirectory tools/pluginregistration of the CRM2011 SDK (in my case the location is

B:InstallMicrosoft CRMSDK CRM 2011toolspluginregistration)

 

Note: As you will notice, only the source code of the pluginregistration is available; so you need to compile it; in order to use it.

In the pluginregistration folder, browse to the bin folder and either open the debug or release folder and double click the application PluginRegistration.exe

 

image

 

You will be presented with the following GUI:

image

 

Now click on “Create New Connection”

image

 

Fill out the connection information, consisting of:

  • Label:   Friendly name of connection
    • In my case I named it: CRM2011
  • Discovery Url:   Base url of CRM
  • User Name: Domain Account with sufficient rights in CRM 2011
          • In my case I used: LABAdministrator

 

image

 

Once everything is filled in, press Connect and wait until the discovery is finished. Once finished double click on the organization name (in my case: Motion10 Lab Environent ) and wait for the objects to be loaded.

image

 

Once the objects have been loaded; you should see a screen similar to the one depicted here below:

image

 

Now let’s add our ‘Custom Activity or plugin’. Do this by selecting the ‘Register’ tab and clicking on ‘Register new Assembly’

 

image

 

The ‘Register New Plugin’ screen will popup and click on the ‘Browse (…)’ button.

image

 

Now browse to the bin folder of the example project “SendCrmEntityToEndPoint“ (the one you compiled earlier) and select the SendCrmEntityToEndPoint.dll file and click on ‘Open’

 

image

 

Once done, select the option “None“ at step 3 and select the option “Database“ at step 4 and press the button ‘Register Selected Plugins’

image

 

Once done you should receive feedback that the plugin was successfully registered.

 

image

 

Creating a workflow in CRM2011 which uses the custom activity.

Now that we have registered our ‘plugin’, it is time to put it to action. In order to do so; we will logon to CRM2011 and create a custom workflow.

 

Once you’ve logged on to CRM2011, click on ‘Settings’

image

 

Now find the ‘Process Center’ section and click on ‘Processes’

image

 

In the main window, click on ‘New’

image

 

A dialog window will pop up; fill in the following details and once done press OK:

  • Process Name: Logical name for this workflow
            • I named it: OnAccountProspectStatusExport
  • Entity:  Entity which could trigger this workflow
            • I used the Account Entity
  • Category: Select WorkFlow

image

 

A new window will pop up; which is used to define the actual workflow. Use the following settings:

  • Activate as: Process
  • Scope: Organization
  • Start When:
                • check Record is created
                • check Record fields change and select the field RelationShipType

image

  • Now add the following step: Check Condition

image

 

  • Set the condition to be
            • Select “Account”
            • Select Field “RelationshipType”
            • Select “Equals”
            • Select “Prospect”

image

 

  • Now add our custom activity the following step: SendCrmEntityToEndPoint

image

  • Configure this activity like this:
              • Export to disk:  True
              • EndPoint location: <Path where entity needs to be written>
                      • In my case I used: c:temp (note this will be written on the c drive on the CRM server!)

 

image

 

  • Now once again add our custom activity the following step: SendCrmEntityToEndPoint

image

 

  • Configure this activity like this:
  • Export to disk: False
  • EndPoint location: Url path to your BizTalk webservice
          • In my case I used: the endpoint which points to my generated BizTalk WebService (which we will cover in our next blogpost)

image

 

Well at this point your workflow should look similar to this:

 

image

 

Now click on the ‘Activate’ button

image

 

Confirm the ‘Activation’

image

 

Save and close the new workflow

image

 

Test if everything works

So now it is time to see if everything works; in order to do so we will create a new Account and if everything went ok; we should see

  • An Account.xml file somewhere on disk
  • An Routing Error in BizTalk (as we send a document which was not recognized by BizTalk)

 

In CRM2011 click on the ‘Work Place’ button

image

 

Subsequently click on ‘Accounts’

image

And finally add a new ‘Account’, by clicking on ‘NEW’

image

 

A new window will pop-up; fill in some basic details

image

 

and don’t forget to set the Relationship type to ‘Prospect’

image

 

Once done click on the ‘Save & Close’ button

image

 

After a few minutes we can check both our output directory and the BizTalk Administrator, and we should notice that in the output directory a file has been written

 

image

and we should have an ‘Routing Failure’ error in BizTalk.

image

 

Closing Note

So this sums up our first part in which we build our own Workflow activity, imported it into CRM2011, constructed a workflow and last but not least saw that it worked.

 

Hope you enjoyed the read

 Cheers

 René

5 comments

Leave a Reply

Your email address will not be published. Required fields are marked *

WordPress spam blocked by CleanTalk.