MS CRM 2011: Bulk refresh of user details from AD

When you create user in CRM all the available information is populated from AD into CRM user form. But in case information was changed in AD (email box, phone e.t.c.) - information will remain unchanged till the moment you will open form of user and change it. In case a lot of information was changed it will be quite boring to update users information one-by-one.

Following post describes how to allow bulk update of user details.

Integrating CRM 2011 using SQL Integration Services (SSIS)

I read this article and decided to make something similar for CRM 2011. You can see results in this post.

CRM 2011: Playing with notes control

If you want for some reason to allow/disallow user to insert or edit notes in Microsoft Dynamics CRM 2011 following code can help you:

function FormatNotesControl(AllowInsert, AllowEdit)
{
    var notescontrol = document.getElementById('notescontrol');
    if (notescontrol == null)
        return;
    var url = notescontrol.src;

    if (!AllowInsert)
        url = url.replace("EnableInsert=true", "EnableInsert=false");
    if (!AllowEdit)
        url = url.replace("EnableInlineEdit=true", "EnableInlineEdit=false");

    notescontrol.src = url;
}

function DisableNotesInsert()
{
    FormatNotesControl(false, true);
}

Copy script, insert it to webresource, add this webresource to required form and call it during onload/onchange of form. And you should not forget that this script is unsupported because it uses document object and it's methods.

CRM 2011: Creating a Network Path Text Control for Microsoft Dynamics CRM 2011

Following approach is a little bit unsupported so be careful using it.

Create JavaScript webresource, put in it following code, call OnLoad method during loading of form of your entity:

function OnLoad()
{
    Transform("new_name");
}

function Transform(fieldid)
{
    var c = document.getElementById(fieldid);
    if (c == null)
        return;

    c.style.textDecoration = "underline";
    c.style.color = "blue";
    c.style.cursor = "hand";
    c.ondblclick = function()
    {
        window.open(Xrm.Page.getAttribute(fieldid).getValue());
    };
}

Field has to be simple text type. Replace new_name with field you want to transform. Result for my case:

MVP Renewed - 2

Third year in a row I have got MVP award.
This year was the most complicated in my life and I'm glad to get this award one more time.

Visual Studio 2010 - The version of clr.dll in the target does not match the one mscordacwks.dll was built for

I have prepared new virtual machine for one project (WS 2008, SQL 2008, CRM 2011, VS 2010). I had to develop several plugins and I faced with issue - when I tried to debug plugin and attach to w3wp process I have got following error message - The version of clr.dll in the target does not match the one mscordacwks.dll was built for.



I googled and have found possible solution - Install SP1 for VS 2010. After installation and reboot of virtual machine I was able to attach to w3wp and debug plugins without any issue.

CRM 2011 - reports on data auditing

One of forum visitor asked about building reports based on Audited data. I have never worked with it in CRM 2011 so I decided to recheck how does it store information in DB. Confusing is wrong word for the feelings I've felt... Denormalized data which is impossible to analyse with SQL statements. Anyway following query can help you to build your own reports based on this information: