Click here to Skip to main content
13,860,547 members
Click here to Skip to main content
Add your own
alternative version


44 bookmarked
Posted 27 Mar 2007

Microsoft Dynamics CRM Vista Sidebar Gadget

, 27 Mar 2007
Rate this:
Please Sign up or sign in to vote.
Accessing Microsoft Dynamics CRM information from a Sidebar Gadget
Screenshot - 2_small.jpg


Microsoft Dynamics CRM is a powerful program, and what sets it apart from the many other choices in the CRM application space is its tight integration to the Microsoft platform. When Vista shipped, I immediately started looking for new and exciting ways to demonstrate the value of Microsoft CRM and the Microsoft platform, and the first interesting area I discovered is gadgets. Being a true propeller head, my favorite gadget is the CPU utilization meter, and I also love the pictures slideshow gadget. I decided to create a gadget that can display the accounts and contacts from Microsoft Dynamics CRM on the user desktop.

Note that this article assumes familiarity with developing gadgets for Windows Vista. If you're new to gadgets, I suggest first reading the article:

About CRM and the gadget

While a properly implemented CRM system can be a very powerful tool, a complaint heard often is that there is so much information in the system, it is impossible to make any sense of it. The tools provided with Microsoft CRM can be designed so that the users can quickly access the important information stored in the system, and the MSCRM gadget is designed to make this process even faster.

The gadget displays the list of accounts and contacts associated with the currently logged on user (made possible by MSCRM's integration with Active Directory) and then if the user clicks an item in the list, the MSCRM record will load in a browser window.

Please note that in order to use this gadget, you must have access to a functioning MSCRM installation, and you must know the URL of your MSCRM server.

Using the code

The code itself consists of three HTML files: index.htm, accounts.html, and contacts.html. The working machinery is all JavaScript, made possible by JavaScript's ability to instantiate and access ActiveX objects. The index.html file uses JavaScript to implement a tabbed interface, one tab for Accounts, one tab for Contacts.

// Index.html
// The JavaScript for the tabs
<script type="text/javascript">
var stl=""
var bChecked=false
function handlelink(aobject)
  bChecked=(document.tabcontrol && document.tabcontrol.tabcheck.checked)? true : false
  if (document.getElementById && !bChecked)
    var theTab=document.getElementById("tablist")
    var theTablinks=theTab.getElementsByTagName("A")
    for (i=0; i<theTablinks.length; i++)
    return false
    return true

Microsoft Dynamics CRM provides a very powerful web services API which provides access to the underlying system. So the basic idea behind this gadget was to instantiate a Microsoft.XMLHTTP ActiveX object, and then use that object to call into the MSCRM web services to retrieve the account and contact information. The challenge is that the call is not as simple as a SQL query like "select * from Accounts". We need to build an actual SOAP message. In order to do this I cheated a bit and enabled logging on my MSCRM server, made a call to the web services to retrieve the accounts and contacts, and then parsed the resulting log file to find the call I needed. For those interested, the log file is included with the downloadable source files for this project.

I then built the message thus:

// Accounts.html
// The JavaScript to build the SOAP message

// The following line must be changed to match the users MSCRM server URL
var serverUrl = "http://danubecrm:5555/mscrmservices/2006";

var xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");"POST", serverUrl + "/crmservice.asmx", false);
xmlhttp.setRequestHeader("Content-Type", "text/xml; charset=utf-8")
xmlhttp.send("<?xml version='1.0' encoding='utf-8'?>"+"\n\n"+"<soap:Envelope"+
' xmlns:soap=""'+
' xmlns:xsi=""'+
' xmlns:xsd="">'+
' <soap:Body>' +
' <query xmlns:q1= 
' xsi:type="q1:QueryExpression" xmlns="">'+
' <q1:EntityName>account</q1:EntityName>' +
' <q1:ColumnSet xsi:type="q1:ColumnSet">' +
' <q1:Attributes>' +
' <q1:Attribute>accountid</q1:Attribute>' +
' <q1:Attribute>name</q1:Attribute>' +
' </q1:Attributes>' +
' </q1:ColumnSet>' +
' <q1:Distinct>false</q1:Distinct>' +
' </query>'+
' </soap:Body>'+
' </soap:Envelope>')

The next step is to parse the XML returned by the CRM web services call and separate the returned entities. The code below also prints out the returned entities inside HTML anchors so they are clickable.

var result = xmlhttp.responseXML.xml;
var BEs= result.split("<BusinessEntities>");
var BE = BEs[1].split("<BusinessEntity");
for (i = 0; i < BE.length; i++)
firstname = BE[i].indexOf("<name>")+6;
secondname = BE[i].indexOf("</name>");
firstid = BE[i].indexOf("<accountid>")+11;
secondid = BE[i].indexOf("</accountid>");
  if (BE[i].substring(firstid,secondid).length > 0 )
    // The URL below must also be changed to the users MSACRM server URL
    document.writeln("<a href=\"http://danubecrm:5555/sfa/accts/edit.aspx?id=" + 
    BE[i].substring(firstid,secondid) + "\" target=\"new\"><font size=\"2px\"" +
    "name=\"verdana\">" + BE[i].substring(firstname,secondname) + "</font></a><BR>");

The body of the Accounts.html file is straightforward, we must call the JavaScript function we created. I called my function AccessCrmWebServices() but of course the name does not matter.

<body bgcolor="#eff3f7">
<script language="JavaScript" type="text/javascript">
AccessCRMWebServices() ;

And that's pretty much it! Now we just deploy the gadget files to the Vista machine as described in the overview article referenced in the beginning of this article, and the gadget will be available.


  • v1: March 26, 2007


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author

No Biography provided

You may also be interested in...

Comments and Discussions

GeneralHelp with Access Denied message Pin
cenvia200223-Mar-09 10:17
membercenvia200223-Mar-09 10:17 
GeneralRe: Help with Access Denied message Pin
cenvia200223-Mar-09 10:35
membercenvia200223-Mar-09 10:35 
GeneralMentioned in the book Pin
LakshmiChava17-Dec-08 9:59
memberLakshmiChava17-Dec-08 9:59 
Generalaccess problem in sidebar (msxml3.dll) Pin
mrv7927-Oct-08 7:54
membermrv7927-Oct-08 7:54 
QuestionCRM 4.0 changes? Pin
Mike Bailey8-May-08 7:49
memberMike Bailey8-May-08 7:49 
AnswerRe: CRM 4.0 changes? Pin
John.Straumann31-May-08 13:01
memberJohn.Straumann31-May-08 13:01 
AnswerRe: CRM 4.0 changes? Pin
Member 32068271-Dec-08 5:12
memberMember 32068271-Dec-08 5:12 
GeneralVery nice article Pin
Raj Lal3-Sep-07 10:36
memberRaj Lal3-Sep-07 10:36 
GeneralHelp for CRM Vista Gadget install Pin
Hans Veldman28-Jun-07 21:43
memberHans Veldman28-Jun-07 21:43 
General0x80040216 soap:Server Server was unable to process request Pin
inferano22-Jun-07 1:16
memberinferano22-Jun-07 1:16 
QuestionWhat about operators Pin
Gorillaman3-Apr-07 15:27
memberGorillaman3-Apr-07 15:27 
AnswerRe: What about operators Pin
John Straumann3-Apr-07 15:45
memberJohn Straumann3-Apr-07 15:45 
GeneralRe: What about operators Pin
Gorillaman3-Apr-07 15:52
memberGorillaman3-Apr-07 15:52 
GeneralRe: What about operators Pin
Gorillaman3-Apr-07 15:54
memberGorillaman3-Apr-07 15:54 
Generalsystem is undefined Pin
phgordon28-Mar-07 6:28
memberphgordon28-Mar-07 6:28 
AnswerRe: system is undefined Pin
John Straumann28-Mar-07 8:44
memberJohn Straumann28-Mar-07 8:44 
GeneralRe: system is undefined Pin
twinsen8321-May-07 5:44
membertwinsen8321-May-07 5:44 
GeneralRe: system is undefined Pin
John Straumann21-May-07 9:34
memberJohn Straumann21-May-07 9:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web05 | 2.8.190214.1 | Last Updated 27 Mar 2007
Article Copyright 2007 by John Straumann
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid