Daren Turner

The following code will pull entity information, using the Metadata service, using javascript.  This code is useful for pulling the objecttypecode dynamically when they may differ between environments.

var _sWebServicesNamespace = "http://schemas.microsoft.com/crm/2006/WebServices";

function _RemoteMetaCommand(sCommand, sAction)
{
var xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
xmlhttp.open("POST", "/mscrmservices/2006/metadataservice.asmx" , false);
xmlhttp.setRequestHeader("Content-Type","text/xml; charset=utf-8");
xmlhttp.setRequestHeader("SOAPAction", _sWebServicesNamespace + "/" + sAction);

var soapmessage = "<?xml version='1.0' encoding='utf-8'?>"
soapmessage += "<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'>"
soapmessage += "<soap:Body>" + sCommand + "</soap:Body></soap:Envelope>"
xmlhttp.send(soapmessage);

return xmlhttp.responseXML;
}

var entity = "new_country"
var query = "<RetrieveEntityMetadata xmlns='http://schemas.microsoft.com/crm/2006/WebServices'>"
query += "<entityName>" + entity + "</entityName><flags>EntityOnly</flags></RetrieveEntityMetadata>"

//Get ObjectTypeCode

var result = _RemoteMetaCommand(query, "RetrieveEntityMetadata").selectSingleNode("//ObjectTypeCode");

var countryentitytypecode = result.text;

Here is the response.

This is a plugin that I developed to audit transactions in CRM 4.0.  The records that are created are stored in CRM and can be related to the entities in CRM.

Features

• Audit entities in CRM
• Show differences with each audit
• Take advantage of CRM features since the Audit records are CRM entities.
• Made generic to work with most, if not all, messages in CRM

Messages Tested

• Create
• Update
• Delete
• Retrieve (Read) - Use caution when using this one.  A read transaction occurs after other messages.
• Assign
• SetStateDynamicEntity (Change State)

Download Here

• Guide
• Plugin DLL
• Customization File
• Source Code

This customization may not be supported by Microsoft and is provided as-is with no warranty.

In this post, I'm going to show you how to modify the entity drop down for the Customer Lookup without changing the security for the whole application.  

I'm going to use the customer lookup for opportunity as our example.   By default you have Account and Contact in the drop down for the 'Look For:' search criteria.

If you look at the html for the customer lookup field, on the opportunity form, it looks like this.

<img src="/_imgs/btn_off_lookup.gif" id="customerid" class="lu" tabindex="1010" lookuptypes="1,2" lookuptypenames="account:1,contact:2" lookuptypeIcons="/_imgs/ico_16_1.gif:/_imgs/ico_16_2.gif" lookupclass="BasicCustomer" lookupbrowse="0" lookupstyle="single" defaulttype="0" req="2">

The 3 attributes we will need to change is lookuptypes,lookuptypeNames and lookuptypeIcons.

Reorder the Dropdown

To reorder the drop down, add the following code to the 'OnLoad' of the Opportunity form.

crmForm.all.customerid.lookuptypes = "2,1"
crmForm.all.customerid.lookuptypenames = "contact:2,account:1"
crmForm.all.customerid.lookuptypeIcons = "/_imgs/ico_16_2.gif:/_imgs/ico_16_1.gif"

The dropdown should default to Contact when it's opened.

Remove an Entity from Dropdown

To remove Contact from the customer lookup for Opportunity add the following code on the 'OnLoad' of opportunity.

crmForm.all.customerid.lookuptypes = "1"
crmForm.all.customerid.lookuptypenames = "account:1"
crmForm.all.customerid.lookuptypeIcons = "/_imgs/ico_16_1.gif"

The lookup should only be for accounts.

Although it may be possible, I wouldn't add entities to the lookups since the customer relationship does not exist.

This customization may not be supported by Microsoft and is provided as-is with no warranty.

I'm always getting the question on how to view a logo or image in Microsoft CRM.  Well here is a quick customization you can add to your account form and view a logo.   Once you add this script on the 'OnLoad' event of the form, all you need to do is add an image called 'logo.jpg' as an attachment and everything will show up properly.   This customization will even work offline.

Script

var Loaded = false;

if(crmForm.FormType ==2 || crmForm.FormType ==3 || crmForm.FormType ==4)
{
    // get the notescontrol object
    var oNotes = document.getElementById("notescontrol");

    // attach an event so we know when the notecontrol is done loading
   oNotes.attachEvent('onreadystatechange', LoadLogo);

   // refresh the notecontrol
   oNotes.Refresh();
}

function LoadLogo()
{
   if (oNotes.readyState != 'complete')
      return;

   var oDoc = (oNotes.contentWindow || oNotes.contentDocument);
   if (oDoc.document) oDoc = oDoc.document;
   // attachment use SPAN tags
   var attachments = oDoc.body.getElementsByTagName("SPAN");

   //Iterate through all the attachments.
   for (var i = 0; i < attachments.length; i++)
   {
       // let's be certain we have an attachment here
       if (attachments[i].attachmentId)
       {
            // is this an image attachment
            if (attachments[i].innerHTML.match(/.*logo\.jpg$/i) && !Loaded)
            {
                  //Get a reference to the table
                 var tr = crmForm.all.name.parentNode.parentNode.parentNode.insertRow();
                 var td = tr.insertCell();
                 td.align="right"
                 td.colSpan=4;
                 td.innerHTML = "<img src='" + attachments[i].url.concat("?AttachmentType=", attachments[i].attachmentType,                                    "&AttachmentId=", attachments[i].attachmentId) + "'/>"
                  Loaded = true;
             }
       }
    }
}

When your done, your form should look like this.

If you really want to get creative you can go a little further and build a viewer to page through all images that are attached to the record.

This customization may not be supported by Microsoft and is provided as-is with no warranty.

A friend of mine called me up and asked if it was possible to create records in one CRM system when they are created in another one.  Well here is a quick example of how to do it.   

Assumptions

• Both CRM Systems have the exact same fields for the records you will copying.
• All records in the two CRM systems have the same guids for matching records.

If there are discrepencies with the guids in each system, there will be issues with this example.   When the postImageEntityXml is Deserialized into a DynamicEntity, it has the guid of the source system. When it's created in the target system, it's created with the same guid. 

For this example I will show you a simple Post Callout to replicate a Create action, but I recommend sending these transactions to a Message Queue and then processing them from there.   It's also not only limited to Create, the same thing can be done for other actions.

Code

public override void PostCreate(CalloutUserContext userContext, CalloutEntityContext entityContext, string postImageEntityXml)
{
    //Create the Service and connect to remote server.
   CrmService service = new CrmService();
   service.Url = "http://<CRMSERVER>/mscrmservices/2006/crmservice.asmx"

   //build the credentials for access if the current user doesn't have access.
   service.Credentials = new System.Net.NetworkCredential("username","password","domain");

    DynamicEntity entity = (DynamicEntity)Serialization.DeserializeBusinessEntity(postImageEntityXml);

    TargetCreateDynamic targetCreate = new TargetCreateDynamic();
    targetCreate.Entity = entity;

    CreateRequest request = new CreateRequest();

    request.Target = targetCreate;

    CRMSDK.CreateResponse response = (CRMSDK.CreateResponse) service.Execute(request);
}
private Object DeserializeBusinessEntity( string xml)
{
    XmlTextReader readerText = new XmlTextReader(new StringReader(xml));
    try
    {
    // De-serialize XML stream using .NET XmlSerializer class
    XmlRootAttribute root = new XmlRootAttribute("BusinessEntity");
    root.Namespace = "http://schemas.microsoft.com/crm/2006/WebServices"
    XmlSerializer xmlSerializer = new XmlSerializer(typeof(BusinessEntity), root);
    BusinessEntity entity = (BusinessEntity)xmlSerializer.Deserialize(readerText);

    return entity;
    }
    catch (Exception) { throw; }
}

This code isn't entity specific so it will work for most of the entities in CRM. All the entity information is in the postImageEntityXml and is Deserialized into the DynamicEntity.

Callout Registration

<callout entity="account" event="PostCreate">
      <subscription assembly="Callout.dll" class="Callout.Migrate">
          <postvalue>@all</postvalue>
      </subscription>
</callout>

<callout entity="contact" event="PostCreate">
      <subscription assembly="Callout.Migration.dll" class="Callout.Migrate">
         <postvalue>@all</postvalue>
      </subscription>
</callout>  

There are a lot more things you can do to improve this process.   This is just a simple example.  Some other things to consider adding into your solution is Message Queueing and Exception Handling.

Hope this helps.

A big shout out to Henry who is out in Ohio this week :).

This customization may not be supported by Microsoft and is provided as-is with no warranty.