CRM Programmer

TFS 2010 SharePoint Project Portal 403 Forbidden

2010-07-27T19:00:00.002+04:00

When you try to open or create the workitem through the project portal you'll get an 403 forbidden error. This is because you have not enough privileges to the folder Inetpub\wwwroot\bin at the TFS server machine.

Just set the next rights to the all domain users.

From IT Blog Posts

Via http://www.cnblogs.com/patrick/archive/2010/04/30/1725167.html

How to hide a section or field by picklist value

2010-06-22T19:33:00.006+04:00

That code snippet will hides a section by name(label) or by label of any field wich is in this section.

if(crmForm.all.new_1!=null)
{
 var oField = crmForm.all.new_1;
 
 // field to hide
 var FieldToHide;
 if(document.getElementById("IDENT") != null)
 {
  FieldToHide = document.getElementById("IDENT");
  FieldToHide.style.display = "block";  
 }
 
 
 // section to hide
 var td = document.getElementsByTagName("td");
 var tableH;
 for(var i=0; i<td.length; i++)
 {
  // enter the correct section name
  if(td[i].innerText == "Section name")
  {
   tableH = td[i].parentNode.parentNode.parentNode;
   tableH.style.display = "block";
  }
 }
 
 
 // here set the needed picklist value
 if(oField.DataValue == 1)
 {
  // field to hide
  if(FieldToHide != null)
  {
   FieldToHide.style.display = "none";  
  }
 }
 else
 if(oField.DataValue == 3)
 {
  // section to hide
  if(tableH != null)
  {
   tableH.style.display = "none";
  }

 }
}

Tooltip

2010-06-10T19:03:00.002+04:00

To add a tooltip at some field on form, jast add next snippet with your changes to form On Load

var ele = document.getElementById("firstname_c");
ele.title = "Name Name Name!";

Get the localized names of all entities

2010-02-27T13:10:00.002+03:00

select  ObjectTypeCode, Name, LogicalName, l.Label
from MetadataSchema.Entity e left join
MetadataSchema.LocalizedLabel l on e.EntityId=l.ObjectId
where l.ObjectColumnName='LocalizedName'
 and l.CustomizationLevel=1

union

select  ObjectTypeCode, Name, LogicalName, l.Label
from MetadataSchema.Entity e left join
MetadataSchema.LocalizedLabel l on e.EntityId=l.ObjectId
where l.ObjectColumnName='LocalizedName'
 and l.CustomizationLevel=0 
 and ObjectTypeCode not in 
  ( select  ObjectTypeCode
   from MetadataSchema.Entity e left join
   MetadataSchema.LocalizedLabel l on e.EntityId=l.ObjectId
   where l.ObjectColumnName='LocalizedName'
    and l.CustomizationLevel=1
  )

Get the params of all localized attributes and all picklist values

2010-02-27T13:09:00.003+03:00

SELECT
 e.Name as EntityName
 ,l.Label as 'Наименование атрибута', a.LogicalName ,at.Description as 'Тип атрибута' ,a.AttributeLogicalTypeId
 ,apv.Value as 'Значения пиклиста', lp.Label as 'Наименования пиклиста'
 ,[AttributeRequiredLevelId]
 ,[MaxLength]
 ,[MinValue]
 ,[MaxValue]
 ,LookupClass
 ,LookupStyle
 ,LookupBrowse
FROM
 [NaviconGroup_MSCRM].[MetadataSchema].[Attribute] a
 join MetadataSchema.Entity e on e.EntityId=a.EntityId
 join MetadataSchema.AttributeTypes at on at.AttributeTypeId=a.AttributeTypeId
 join MetadataSchema.LocalizedLabel l on l.ObjectId=a.AttributeId and l.ObjectColumnName='DisplayName'
 left join MetadataSchema.AttributePicklistValue apv on apv.AttributeId=a.AttributeId
 left join MetadataSchema.LocalizedLabel lp on lp.ObjectId=apv.AttributePicklistValueId
order by EntityName, l.Label, at.Description,apv.Value

Get Picklist Value By Picklist Name

2010-02-04T19:22:00.002+03:00

I wrote some method to get picklist value by knowing picklist name.

namespace test
{
    public class CrmServiceProvider
    {

  private WebMetadataService.MetadataService _MetaService = null;
  
  ///* Create a MetadataService end point */
        private WebMetadataService.MetadataService MetaService
        {
            get
            {
                if (_MetaService == null)
                {
                    _MetaService = new WebMetadataService.MetadataService();
                    _MetaService.Url = "http://localhost/mscrmservices/2007/metadataservice.asmx";

                    // Use a special user credentials
     NetworkCredential cred = new NetworkCredential();
                    cred.Domain = ConfigurationManager.AppSettings["Domain"];
                    cred.UserName = ConfigurationManager.AppSettings["UserName"];
                    cred.Password = ConfigurationManager.AppSettings["PassWord"];

                    _MetaService.UseDefaultCredentials = false;
                    _MetaService.Credentials = cred;

                    _MetaService.UnsafeAuthenticatedConnectionSharing = true;

                    WebMetadataService.CrmAuthenticationToken token = new WebMetadataService.CrmAuthenticationToken();
                    token.AuthenticationType = 0;
                    token.OrganizationName = ConfigurationManager.AppSettings["Organization"];

                    _MetaService.CrmAuthenticationTokenValue = token;
                }
                return _MetaService;
            }
        }


  public int GetPicklistValueByPicklistName(string PicklistName, string EntityLogicalName, string LogicalName)
  {
   int retval = -1;
   
   /* Retrieve the attribute metadata */
   WebMetadataService.RetrieveAttributeRequest attributeRequest = new WebMetadataService.RetrieveAttributeRequest();
   attributeRequest.EntityLogicalName = EntityLogicalName;
   attributeRequest.LogicalName = LogicalName; //picklist

   WebMetadataService.RetrieveAttributeResponse attributeResponse =
      (WebMetadataService.RetrieveAttributeResponse)MetaService.Execute(attributeRequest);

   /* Cast the attribute metadata to a picklist metadata */
   WebMetadataService.PicklistAttributeMetadata picklist =
      (WebMetadataService.PicklistAttributeMetadata)attributeResponse.AttributeMetadata;


   foreach (WebMetadataService.Option op in picklist.Options)
   {
    if (op.Label.UserLocLabel.Label == PicklistName)
     retval = op.Value.Value;
   }

   return retval;
  }
 }
}

To call this method use the next construction:

int psv = GetPicklistValueByPaymentSystemName(categorycode, "account", "accountcategorycode");
if (psv > 0)
{
 acc.accountcategorycode = new Picklist();
 acc.accountcategorycode.Value = psv;
}

Upgrade of javascript function to hide "Add Existing ..." button

2009-12-21T16:51:00.002+03:00

I improved the source code for one of my previous post — Remove 'Add Existing...' button from associated view entities form.

function HideAssociatedViewButtons(areaPrefix, loadAreaId, buttonTitles,addAreaParams){
 var navElement = document.getElementById(areaPrefix+loadAreaId); 
   if (navElement != null)    {
        navElement.onclick = function LoadAreaOverride(){
            if(addAreaParams.length>0)
    loadArea('area'+loadAreaId, addAreaParams[0]);
   else
    loadArea('area'+loadAreaId);
            var iframeid='area' + loadAreaId + 'Frame';
   HideViewButtons(document.getElementById(iframeid), buttonTitles);
        }
    }
}
 
function HideViewButtons(Iframe, buttonTitles) { 
    if (Iframe != null ) {
  Iframe.onreadystatechange = function HideTitledButtons() { 
            if (Iframe.readyState == 'complete') { 
                var iFrame = frames[window.event.srcElement.id]; 
                var liElements = iFrame.document.getElementsByTagName('li');
 
    for (var j = 0; j < buttonTitles.length; j++) { 
                    for (var i = 0; i < liElements.length; i++) { 
                        if (liElements[i].getAttribute('title') == buttonTitles[j]) { 
                            liElements[i].style.display = 'none'; 
                            break; 
                        }
                    } 
                } 
            } 
        } 
    }
}

On form load set some selected value for related entity pick-list

2009-12-03T18:52:00.001+03:00

I had to set the value for related entity pick-list — filter of date for Activities of some account, like it was default Selected value.

SelectArea('Activities', 'scheduledend');
SelectArea('ActivityHistory', 'actualend');

function SelectArea(loadAreaId, selectId)
{
var navElement = document.getElementById('nav'+loadAreaId); 
if (navElement != null) 
{
 navElement.onclick = function LoadAreaOverride() {
  loadArea('area'+loadAreaId);
  var iframeid = 'area'+loadAreaId + 'Frame';
  var Iframe=document.getElementById(iframeid);
  if (Iframe != null ) {
   Iframe.onreadystatechange = function SetAllasDefault() { 
    if (Iframe.readyState == 'complete') { 
     var iFrame = frames[window.event.srcElement.id]; 
     var oSelect = iFrame.document.getElementById(selectId);
     var oOption = oSelect.options[oSelect.options.length-1];
     oOption.selected = true;
     oSelect.FireOnChange();
    }
   }
  }
 
  
 }
}
}

Put at form OnLoad() event;

Passing parameters between MS CRM plugins

2009-11-13T16:24:00.002+03:00

I was needed to pass a variable from one plugin to another. If you have a two plugin at pre and post stage registered for on entity, then you can use a SharedVariables context property. But, if every plugins is a different assembly, and they are registered for a different entities... So, when the first plugin is firing, the second, which is starting after that, needed to know some information for redirecting it logic to another way.

I had created some common assembly with helper methods and called it "Helper". Then I had created a static class with static variable and had put the value into it, at the first plugin execution runtime. In the second plugin I just get the value from the static common variable.

And nothing about read\write DB operations.
Helper assembly.

namespace Helper
{
    public static class Keeper
    {
        private static bool _UpdateOppAfterHistory = true;
        public static bool UpdateOppAfterHistory 
        {
            get { return _UpdateOppAfterHistory; }
            set { _UpdateOppAfterHistory = value; }
        }
        
    }
    public class OpportunityHelper
    { ... }
}

First firing plugin code

Keeper.UpdateOppAfterHistory = false;

OpportunityHelper.CreateOpportunityHistory(Opp,crmService);
                
// removing the flag to the back
Keeper.UpdateOppAfterHistory = true;

Second firing plugin code

// common shared variable analysis
bool UpdateOppAfterHistory = Keeper.UpdateOppAfterHistory;
if (UpdateOppAfterHistory)
{ ... }

How to hide an items of drop-down list?

2009-11-10T12:37:00.000+03:00

"We should not be able to choose some steps of Opportunity History, if the opportunity has no quotes or sales orders." - that was they said.

And that was I wrote.

var oService = null;
var oppid = null;

function FormOnLoad()
{
 oService = new Ascentium_CrmService(null, null);
 
 var oParentCrmForm = window.opener.parent.document.all.crmForm;
 if(oParentCrmForm)
 { 
  oppid = oParentCrmForm.ObjectId;
 }
 
 HideComboboxItems();
}


window.HideComboboxItems = function()
{
var newstep = document.getElementById("new_step");
if(newstep)
{
 // checking opportunity for quotes
 var sFetchXml ='<fetch mapping="logical" aggregate="true" version="1.0"><entity name="quote"><attribute name="quoteid" aggregate="count" alias="count" />'+
  '<filter><condition attribute="opportunityid" operator="eq" value="'+oppid+'" /></filter></entity></fetch>';
 
 var aoFetchResult = oService.Fetch(sFetchXml); 
 var quoteCount = 0;

    if(aoFetchResult.length > 0)
    {
       quoteCount = aoFetchResult[0].attributes["count"].value;
    }
 
 // if no qoutes, then hiding items 4,5,6,7 of dropdown list
 if(quoteCount == 0 )
 {
  var allDropDownElements = newstep.childNodes;
  var lastnodevalue = allDropDownElements.length;
  for(var i=lastnodevalue; i >= 4; i--)
  {
    newstep.options.remove(i);
  }
 }
 else
 {
  // if there is some qoutes, then checking for salesorders
  var sFetchXml ='&lr;fetch mapping="logical" aggregate="true" version="1.0"><entity name="salesorder"><attribute name="salesorderid" aggregate="count" alias="count" />'+
   '<filter><condition attribute="opportunityid" operator="eq" value="'+oppid+'" /></filter></entity></fetch>';
  
  var aoFetchResult = oService.Fetch(sFetchXml); 
  var SOCount = 0;

  if(aoFetchResult.length > 0)
  {
     SOCount = aoFetchResult[0].attributes["count"].value;
  }
  
  // if no salesorders, then hiding items 6,7
  if(SOCount == 0)
  {
   var allDropDownElements = newstep.childNodes;
   var lastnodevalue = allDropDownElements.length;
   for(var i=lastnodevalue; i >=6; i--)
   {
     newstep.options.remove(i);
   }
  }
 }
 
}
}

Salesorder Fulfill state

2009-11-09T17:24:00.000+03:00

I was trying to catch the Fulfill state of sales order and my try was successful, with registering plugin to Update message at Child pipeline. But there was a one little problem - you can't get the salesorderdetail thru service. I don't know why, but the simple code like in "Example 1" was falling down with Generic SQL error x80044150.

//  Example 1
QueryByAttribute qba = new QueryByAttribute();
qba.EntityName = EntityName.salesorderdetail.ToString();
qba.ColumnSet = new AllColumns();
qba.Attributes = new string[] { "salesorderid" };
qba.Values = new object[] { soid };
BusinessEntityCollection bec = crmService.RetrieveMultiple(qba);

Then I was switch on the Fulfill Sdk Message and everything start working fine!

1. open up the SdkMessage view, filter by Name and find the SdkMessageId
2. open up the SdkMessageFilter view, filter by SdkMessageId you got from step 1.
3. change IsCustomProcessingStepAllowed to 'True'

update dbo.SdkMessageFilter
set IsCustomProcessingStepAllowed=1
where SdkMessageId=
(select top 1 SdkMessageId from dbo.SdkMessage where name ='Fulfill')

I have a question, why the Fulfill message has been unplugged from customization?

Parse XML date in CRM date with Javascript

2009-11-02T17:01:00.001+03:00

A JavaScript function to parse an XML (ISO-8601) date string (e.g., "2008-01-18") that returns a JavaScript Date object.

// parsing
function parseDate(xmlDate)
{
      if (!/^[0-9]{4}\-[0-9]{2}\-[0-9]{2}/.test(xmlDate)) {
           throw new RangeError("xmlDate must be in ISO-8601 format YYYY-MM-DD.");
      }
      return new Date(xmlDate.substring(0,4), xmlDate.substring(5,7)-1, xmlDate.substring(8,10));
}

// and using
if(retrievedOpp.attributes["estimatedclosedate"] != null && retrievedOpp.attributes["estimatedclosedate"] != undefined){
     crmForm.all.new_estimatedclosedate.DataValue = parseDate(retrievedOpp.attributes["estimatedclosedate"].value);}

Source http://dev.ektron.com/blogs.aspx?id=14140

How to determine on which pipeline a plugin is executing - Parent or Childe

2009-10-29T13:30:00.005+03:00

The InvocationSource property is an integer value that you can use to determine whether the current plug-in is running in a child pipeline.

MessageInvocationSource Values

Field	Value	Description
Child	1	Specifies a child pipeline
Parent	0	Specifies a parent pipeline

MS CRM Fetch and Retrieve from javascript

2009-10-20T12:15:00.005+04:00

This code snippet was writing exactly like recommended in MSCRM SDK 4.09.
I was put it in OnLoad() event of my account form, and in the lookup field(at my example - new_postalcodeid) at OnChange() event I was calling my function.

There is two function that are doing the same work but with different methods.

var authenticationHeader = GenerateAuthenticationHeader();
crmForm.all.address1_city.ForceSubmit = true;

window.GetRegionByIndex_Retrieve = function()  
{  
 
if (crmForm.all.new_postalcodeid.DataValue == null)
{
  crmForm.all.address1_city.Disabled = false;
 crmForm.all.address1_city.DataValue = "";
 return;
}

var lookupItem = new Array;

lookupItem = crmForm.all.new_postalcodeid.DataValue;
if(lookupItem[0] != null)
{
 // Prepare the SOAP message.
 var xml = "<?xml version='1.0' encoding='utf-8'?>"+ 
 "<soap:Envelope xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'"+
 " xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'"+
 " xmlns:xsd='http://www.w3.org/2001/XMLSchema'>"+ 
 authenticationHeader+ 
 "<soap:Body>"+ 
 "<Retrieve xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+ 
 "<entityName>new_postalcode</entityName>"+ 
 "<id>"+lookupItem[0].id+"</id>"+ 
 "<columnSet xmlns:q1='http://schemas.microsoft.com/crm/2006/Query' xsi:type='q1:ColumnSet'>"+ 
 "<q1:Attributes>"+ 
 "<q1:Attribute>new_regcityarea</q1:Attribute>"+ 
 "</q1:Attributes>"+ 
 "</columnSet>"+ 
 "</Retrieve>"+ 
 "</soap:Body>"+ 
 "</soap:Envelope>";
 // Prepare the xmlHttpObject and send the request.
 var xHReq = new ActiveXObject("Msxml2.XMLHTTP");
 xHReq.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
 xHReq.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/Retrieve");
 xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
 xHReq.setRequestHeader("Content-Length", xml.length);
 xHReq.send(xml);
 // Capture the result.
 var resultXml = xHReq.responseXML;

 // Check for errors.
 var errorCount = resultXml.selectNodes('//error').length;
 if (errorCount != 0)
 {
 var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
 alert(msg);
 }
 // Display the retrieved value.
 else
 {
 crmForm.all.address1_city.DataValue = resultXml.selectSingleNode("//q1:new_regcityarea").nodeTypedValue;
 crmForm.all.address1_city.Disabled = true;
 }
}
}



window.GetRegionByIndex_Fetch = function (){
if (crmForm.all.new_postalcodeid.DataValue == null)
{
  crmForm.all.address1_city.Disabled = false;
 crmForm.all.address1_city.DataValue = "";
 return;
}

var lookupItem = new Array;

lookupItem = crmForm.all.new_postalcodeid.DataValue;
if(lookupItem[0] != null)
{
 var xml = "<?xml version='1.0' encoding='utf-8'?>" +
 "<soap:Envelope xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'" +
 " xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'" +
 " xmlns:xsd='http://www.w3.org/2001/XMLSchema'>" +
 authenticationHeader +
 "<soap:Body>" +
 "<Fetch xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>" +
 "<fetchXml>" +
 "&lt;fetch mapping='logical'&gt;" +
 "&lt;entity name='new_postalcode'&gt;" +
 "&lt;attribute name='new_postalcodeid'/&gt;"+
 "&lt;attribute name='new_regcityarea'/&gt;"+
 "&lt;filter type='and'&gt;"+
 "&lt;condition attribute='new_postalcodeid' operator='eq' value='"+lookupItem[0].id+"'/&gt;"+
 "&lt;/filter&gt;&lt;/entity&gt;&lt;/fetch&gt;" +
 "</fetchXml>" +
 "</Fetch>" +
 " </soap:Body>" +
 "</soap:Envelope>";

 var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");
 xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
 xmlHttpRequest.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/Fetch");
 xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
 xmlHttpRequest.setRequestHeader("Content-Length", xml.length);
 xmlHttpRequest.send(xml);
 
 var resultXml = xmlHttpRequest.responseXML;
 // Check for errors.
 var errorCount = resultXml.selectNodes('//error').length;
 if (errorCount != 0)
 {
  var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
  alert(msg);
 }
 // Process and display the results.
 else
 {

  // Capture the result and UnEncode it.
  var resultSet = new String();
  resultSet = resultXml.text;
  resultSet.replace('&lt;','<');
  resultSet.replace('&gt;','>');

  var xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
  xmlDoc.async = false;
  xmlDoc.loadXML(resultSet);
  var results = xmlDoc.getElementsByTagName('result');
  
  for(i=0;i<results.length;i++)
  {
   crmForm.all.address1_city.DataValue = results[i].selectSingleNode('//new_regcityarea').nodeTypedValue;
  }
   crmForm.all.address1_city.Disabled = true;
 }
}
}

How to retrieve from many-to-many entity.

2009-10-13T16:41:00.005+04:00

If you need to retrieve something from many-to-many relationship entity, and there is no such entity in CRM, then you should use the FetchXml, instead of Query.

// Base bodel of FetchXml for get relationship entity
string fetchXML =
"<fetch distinct='false' mapping='logical'>" +
"<entity name='" + relationshipName + "'><filter type='and'>" +
"<condition attribute='" + relatedEntityName + "id' operator='eq' value='" + relatedId + "' />" +
"<condition attribute='" + typeEntityName + "id' operator='eq' value='" + profileId + "' />" +
"</filter></entity>" + "</fetch>";

For example, next code snippet is checking a count of relations between the Account entity and New_Industry entity, wich relationship is many-to-many. To achieve this, I need to check the relationship entity - New_industry_account, wich is contains all of relation of our two entities.

ICrmService crmService = context.CreateCrmService(true);

// check for relation
#region FetchXML
string fetchXML =
"<fetch distinct='false' mapping='logical'>" +
"<entity name='new_industry_account'><filter type='and'>" +
"<condition attribute='accountid' operator='eq' value='" + accountid.ToString() + "' />" +
"</filter></entity></fetch>";
#endregion

string fetchresult = crmService.Fetch(fetchXML);
XmlDocument xmldoc = new XmlDocument();
xmldoc.LoadXml(fetchresult);
XmlNodeList xnodlist = xmldoc.SelectNodes("resultset/result");
if (xnodlist.Count > 0) { return; }

Update a number of custom attributes of DynamicEntity with TargetUpdateDynamic.

2009-10-13T14:42:00.001+04:00

This code I was used in plugins for updating the custom attributes using Microsoft.Crm.SDK.

using System;
using System.Collections.Generic;
using System.Collections;

// Microsoft Dynamics CRM namespaces
using Microsoft.Crm.Sdk;
using Microsoft.Crm.Sdk.Query;
using Microsoft.Crm.SdkTypeProxy;

...

// Extract the DynamicEntity from the request.
entity = (DynamicEntity)retrieved.BusinessEntity;

// declare a property array
ArrayList arrProps = new ArrayList();

// create some property
CrmBooleanProperty new_withindustry = new CrmBooleanProperty();
new_withindustry.Name="new_withindustry";
new_withindustry.Value= new CrmBoolean();
new_withindustry.Value.Value=true;
arrProps.Add(new_withindustry);

// create another property
CrmMoneyProperty new_industrydeal = new CrmMoneyProperty();
new_industrydeal.Name = "new_industrydeal";
new_industrydeal.Value = new CrmMoney();
new_industrydeal.Value.Value = 12345.0m;
arrProps.Add(new_industrydeal);

//   Update the properties array on the DynamicEntity.
entity.Properties.AddRange((Property[])arrProps.ToArray(typeof(Property)));

// Create the update target.
TargetUpdateDynamic updateDynamic = new TargetUpdateDynamic();

// Set the properties of the target.
updateDynamic.Entity = entity;

//   Create the update request object.
UpdateRequest update = new UpdateRequest();

//   Set request properties.
update.Target = updateDynamic;

//   Execute the request.
UpdateResponse updated = (UpdateResponse)crmService.Execute(update);

Dynamic hyperlink in Reporting Services 2008

2009-10-13T02:01:00.001+04:00

I had a custom entity - project and was needed to open a project card from the report.
So I had done exactly as saying in http://msdn.microsoft.com/en-us/library/ms157159.aspx and in the expression field of hyperlink I was typed next

="http://SERVERNAME/ORGANIZATIONNAME/userdefined/edit.aspx?id=%7b" & Fields!projectid.Value.ToString() & "%7d&etc=10005"

SERVERNAME and ORGANIZATIONNAME must be replaced with your crm values.

Registering plugins for event on many-to-many entities

2009-10-12T16:05:00.008+04:00

I found that from the box MS CRM 4.0 are not supported the events on many-to-many relationship entities(bridge entities). But Aaron Elder has hack it.

All you need is just register it at AssociateEntities or DiassociateEntities event with empty Primary and Secondary Entity fields.

-- ============================================================================
-- Enable Associate and Disassociate Plug-in Events Script v1.0
-- ----------------------------------------------------------------------------
-- (c) 2009 Aaron Elder
-- ============================================================================
-- DISCLAIMER:
-- This script is provided "AS IS" with no warranties, and confers no rights.
-- ============================================================================
-- While this is obviously "unsupported", I think the fact that these events
-- are not available is a bug and hopefully it will be fixed in a rollup.
-- ============================================================================

USE AscentiumCrmDev_MSCRM
GO

-- Find the deployments SDK Filter ID for the
-- Associate and Disassociate Entity SDK Messages
DECLARE @DisassociateEntitiesFilterId uniqueidentifier
DECLARE @AssociateEntitiesFilterId uniqueidentifier
SET @DisassociateEntitiesFilterId = (SELECT SdkMessageId FROM SdkMessageBase WHERE [Name] = 'DisassociateEntities')
SET @AssociateEntitiesFilterId = (SELECT SdkMessageId FROM SdkMessageBase WHERE [Name] = 'AssociateEntities')

-- Enable the Associate and Disassociate Filters to be valid for custom processing
-- Custom Processing means "you register plug-ins against it"
-- Note: We only do this for the "generic" (OTC == 0) case, just to be safer
UPDATE SdkMessageFilterBase SET IsCustomProcessingStepAllowed = 1
       WHERE SdkMessageId = @DisassociateEntitiesFilterId AND PrimaryObjectTypeCode = 0


UPDATE SdkMessageFilterBase SET IsCustomProcessingStepAllowed = 1
       WHERE SdkMessageId = @AssociateEntitiesFilterId AND PrimaryObjectTypeCode = 0

Window redirect and close

2009-10-07T17:58:00.005+04:00

This was the window that was opened from CRM form menu (ISV.Config.xml). The window has received some parameters and then redirected to another window, which is preparing and opening the MS Word document, but the pop-up window was still open - this is rude. So, I've closed it.

// call this code on body onload event
function redirect()
{
    // needed URL of pop-up window or modify current location URL
    window.opener.location = window.location.href.replace(/Default2/, "Default");
    window.top.close();
}

Close window from server-side

2009-10-07T17:36:00.004+04:00

// closethe page if successful update
RegisterStartupScript("load", "<" + "script type=\"text/javascript\">\n" +
"self.close();\n" +
"<" + "/script>");

Dim strscript As String = "<"+"script language=javascript>window.top.close();<"+"/script>"
If (Not ClientScript.IsStartupScriptRegistered("clientScript")) Then
ClientScript.RegisterStartupScript(Page.GetType(), "clientScript", strscript)
End If

System.Text.StringBuilder sb = System.Text.StringBuilder ();

sb.Append("");

if(!IsClientScriptRegistered("myScript",sb.ToString())
   this.RegisterClientScriptBlock("myScript",sb.ToString());

All of code was found in Internet

Mask the phone fields

2009-10-05T19:28:00.002+04:00

I was need some mask on the "mobilephone" field in contact card. So I was combine some google search result with my experience and got next code:

//base maskphone function 
window.applyMask = function()
{
    // var of fields wich must be masked
    var ele = document.getElementById("mobilephone");

var FormatPhoneHandler=function()
    {
      var PH = this.value;
      var re = /\D/g;
      // +7 - this is country code of Russia, so this is decision only for one country
      PH = PH.replace("+7","");
      PH = PH.replace(re,"");
     
      if(PH.length <1)
      {
          this.value = "";
      }
      else if(PH.length <= 3)
      {
            this.value = "+7 (" + PH;
      }
      else if(PH.length > 3 && PH.length <= 6)
      {
            this.value = "+7 (" + PH.substring(0,3) + ") " + PH.substring(3,6);
      }
      else if(PH.length > 6)
      {
            this.value = "+7 (" + PH.substring(0,3) + ") " + PH.substring(3,6) + "-" + PH.substring(6,10);
      }
    }

    ele.onkeyup = FormatPhoneHandler;
}

// turn it on
applyMask();

Place this code in onLoad event in the entity wich you need and don't forget change names of the field for the right one.

Embeded notification

2009-08-20T16:50:00.004+04:00

We were needed some kind of notify message for user without any pop-up or an alerts.


function CreateRequestObject() {
  if (window.XMLHttpRequest) {
    try {
      return new XMLHttpRequest();
    } catch (e) { }
  } else if (window.ActiveXObject) {
    try {
      return new ActiveXObject('Msxml2.XMLHTTP');
    } catch (e) {
      try {
        return new ActiveXObject('Microsoft.XMLHTTP');
      } catch (e) { }
    }
  }
  return null;
}

function RetrieveEntity(sEntityName, GUID, sAttributeNames) {
  var attributes = "";
  if (sAttributeNames.length == 0)
    return null;
  for (var i = 0; i < sAttributeNames.length; i++) {
    attributes += "" + sAttributeNames[i] + "";
  }
  var soapBody = "" +
        "" +
         "" + sEntityName + "" +
        "" + GUID + "" +
        "" +
        "" + attributes + "" +
        "" +
        "" +
        "";
  var soapXml = "       "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/'>";
  soapXml += GenerateAuthenticationHeader();
  soapXml += soapBody;
  soapXml += "";

  xmlhttp = CreateRequestObject();
  xmlhttp.open("POST", "/mscrmservices/2007/crmservice.asmx", false);
  xmlhttp.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
  xmlhttp.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/crm/2007/WebServices/Retrieve");
  xmlhttp.setRequestHeader("Content-Length", soapXml.length);
  xmlhttp.send(soapXml);

  // Capture the result.
  var resultXml = xmlhttp.responseXML;
  // Check for errors.
  var errorCount = resultXml.selectNodes('//error').length;
  if (errorCount != 0) {
    var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
    alert(msg);
    return null;
  }
  // Display the retrieved value.
  else {
    var retEntityValues = new Array();
    var retrieveNodes = resultXml.selectNodes("soap:Envelope/soap:Body/RetrieveResponse/RetrieveResult/q1:*");
    for (var i = 0; i < retrieveNodes.length; i++) {
      var nodeName = retrieveNodes[0].baseName;
      var nodeValue = retrieveNodes[0].nodeTypedValue;
      retEntityValues[nodeName] = nodeValue;
    }
    return retEntityValues
  }
}

function AddNotification(noticationId, text) {
  if (crmForm.all.Notifications.all[noticationId] != null)
    crmForm.all.Notifications.all[noticationId + '_text'].innerHTML = text;
  else {
    crmForm.all.Notifications.innerHTML += ' ' + text + '
';
    crmForm.all.Notifications.style.display = 'block';
  }
}

function RemoveNotification(noticationId) {
  if (crmForm.all.Notifications.all[noticationId] != null) {
    crmForm.all.Notifications.all[noticationId].removeNode(true);
    if (crmForm.all.Notifications.childNodes.length == 0)
      crmForm.all.Notifications.style.display = 'none';
  }
}

var customer = crmForm.all.customerid;
if (customer.DataValue != null && customer.DataValue[0].typename == 'account') {
  var cs = new Array();
  cs[0] = 'new_attention';
  var acc = RetrieveEntity('account', customer.DataValue[0].id, cs);
  if (acc != null && acc['new_attention'] == 1) {
    AddNotification('NotificationAccount', 'Клиент требует внимания! Для более подробной информации перейдите в карточку клиента.');
    crmForm.all.customerid_d.getElementsByTagName('SPAN')[0].style.color = 'Red';
  }
  else {
    RemoveNotification('NotificationAccount');
  }
}
else {
  RemoveNotification('NotificationAccount');
}

Get contact status in custom extended marketing list

2009-08-19T15:27:00.001+04:00


declare @contactid uniqueidentifier
declare @campaignactivityid uniqueidentifier
-- some Guids
set @contactid='48CF39EE-AA8C-DE11-A526-000C2989FA53'
set @campaignactivityid='72CE8156-AD8C-DE11-A526-000C2989FA53'

select exL.New_ExtMarketingListsElementId, exL.New_contactStatus
from dbo.New_ExtMarketingListsElementExtensionBase exL
 JOIN dbo.ContactBase cnt ON exL.new_contact=cnt.ContactId
 JOIN dbo.ListBase lst ON exL.new_list=lst.ListId
 JOIN dbo.CampaignActivityItemBase cai ON lst.ListId=cai.ItemId
where cnt.ContactId=@contactid 
 and cai.CampaignActivityId=@campaignactivityid

How to get Marketing Lists by Campaign Activity Id

2009-08-19T15:21:00.005+04:00


declare @campaignactivityid uniqueidentifier
-- an example GUID
set @campaignactivityid='72CE8156-AD8C-DE11-A526-000C2989FA53'

-- связь между маркетинговым списком и кампанией осуществляется через промежуточную таблицу CampaignActivityItemBase
select * 
from dbo.CampaignActivityItemBase cai
 JOIN dbo.ListBase lb ON lb.ListId=cai.ItemId
where cai.CampaignActivityId=@campaignactivityid

Remove 'Add Existing...' button from associated view entities form

2009-08-13T13:31:00.007+04:00

I was found this code at Dave Hawes blog — http://blog.davehawes.com/post/2008/04/23/MSCRM-4-Remove-Add-Existing-xxxxx-button.aspx
This code should be added to onLoad event for the form of the entity where you want to hide buttons for the associated views of other entities.


HideAssociatedViewButtons('new_account_new_accountclassificate', ['Добавить к этой записи существующий объект Классификация организации']);  
 
function HideAssociatedViewButtons(loadAreaId, buttonTitles){
    var navElement = document.getElementById('nav_' + loadAreaId); 
   if (navElement != null)    {
        navElement.onclick = function LoadAreaOverride()        {
            loadArea(loadAreaId);
            HideViewButtons(document.getElementById(loadAreaId + 'Frame'), buttonTitles);
        }
    }
}
 
function HideViewButtons(Iframe, buttonTitles) { 
    if (Iframe != null ) {
        Iframe.onreadystatechange = function HideTitledButtons() { 
            if (Iframe.readyState == 'complete') { 
                var iFrame = frames[window.event.srcElement.id]; 
                var liElements = iFrame.document.getElementsByTagName('li'); 
 
                for (var j = 0; j < buttonTitles.length; j++) { 
                    for (var i = 0; i < liElements.length; i++) { 
                        if (liElements[i].getAttribute('title') == buttonTitles[j]) { 
                            liElements[i].style.display = 'none'; 
                            break; 
                        }
                    } 
                } 
            } 
        } 
    }
}

Publishing it here for memory.

How to get a PhoneCallId

2009-08-12T19:52:00.001+04:00


SELECT
  ActivityPartyBase.PartyId AS ContactId,
  ActivityPartyBase.ActivityId AS PhoneCallId
FROM

CampaignActivityBase
INNER JOIN ActivityPointerBase

ON (ActivityPointerBase.RegardingObjectId = CampaignActivityBase.ActivityId)AND (ActivityPointerBase.DeletionStateCode = 0) 

INNER JOIN PhoneCall 

ON ((PhoneCall.ActivityId = ActivityPointerBase.ActivityId) AND (ActivityPointerBase.StateCode = 0) AND (PhoneCall.DeletionStateCode = 0))

INNER JOIN ActivityPartyBase

ON ((PhoneCall.ActivityId = ActivityPartyBase.ActivityId) AND (PartyObjectTypeCode = 2))

INNER JOIN ContactBase

ON (ContactBase.ContactId = ActivityPartyBase.PartyId) AND (ContactBase.DeletionStateCode = 0)


WHERE 
  (CampaignActivityBase.ActivityId = @CampaignActivityId)

How to write into the eventlog custom journal with impersonalization in code

2009-07-20T19:03:00.003+04:00


private const string LOG_NAME = "MSCRM.Common";

/// 
/// Write message in log
/// 

public static void WriteLog(string message, Exception exception)
{
      System.Security.Principal.WindowsImpersonationContext ctx = null;
      ctx = System.Security.Principal.WindowsIdentity.Impersonate(IntPtr.Zero);
      try
      {
        string logSource = "MSCRM.Common.Web.Controls.Grid";

        if (EventLog.SourceExists(logSource))
        {
          if (!EventLog.LogNameFromSourceName(logSource, ".").Equals(LOG_NAME))
          {
            EventLog.DeleteEventSource(logSource, ".");
            EventLog.CreateEventSource(logSource, LOG_NAME);
          }
        }
        else 
        {
          EventLog.CreateEventSource(logSource, LOG_NAME);
        }
        EventLog el = new EventLog();
        el.Log = LOG_NAME;
        el.Source = logSource;
        el.WriteEntry(String.Format("{0}\nDetails:\n{1}", message, GetLogInfo(exception)), EventLogEntryType.Error);
      }
      catch (Exception ex)
      {
        throw ex;
      }
      finally
      {
        ctx.Undo();
      }
}

Get selected item in CRM grid

2009-07-20T18:31:00.006+04:00

The following snippet will allow you to retrieve an array containing the Id values of the selected records in the grid:


    //    get array of selected records
    var a = document.all['crmGrid'].InnerGrid.SelectedRecords;
    var selectedItems = new Array(a.length);
    for (var i=0; i < a.length; i++)
    {
        selectedItems[i] = a[i][0];
    }
    alert(selectedItems);

To get all of the records in the grid (ie. “All Records on Current Page”):


    //    array of all records on current page
    var iTotal = document.all['crmGrid'].InnerGrid.NumberOfRecords;
    var o = document.all['crmGrid'].InnerGrid;
    var allItems = new Array;
    var ii = 0;
    for (var i=0; i < iTotal; i++)
    {
        allItems[ii] = o.rows[i].oid;
        ii++;
    }
    alert(allItems);

The source: http://blog.customereffective.com/blog/2009/02/javascript-snippets-for-working-with-grids-in-crm.html

How to programmatically launch an application under a specific user

2009-07-16T20:09:00.012+04:00


ProcessStartInfo psi = new ProcessStartInfo("cmd", @"/C c:\SomeApp.exe");
psi.UserName = "UserName";
psi.Domain = "DomaiName";
psi.Password = ReadPassword("password");
psi.UseShellExecute = false;
psi.RedirectStandardInput = true;
psi.RedirectStandardOutput = true;
psi.RedirectStandardError = true;
using (Process p = Process.Start(psi))
{  
  // if you need to wait the end of the process
  p.WaitForExit();
}

public System.Security.SecureString ReadPassword(string password)
{
 System.Security.SecureString secPass = new System.Security.SecureString();
 for (int i = 0; i < password.Length; i++)
  secPass.AppendChar(password[i]);
 return secPass;
}

MSCRM, SQL and Localization

2009-07-10T17:48:00.003+04:00

If you need to look at localized name of some attribute thru the SQL then check out next code


select l.* 
from MetadataSchema.LocalizedLabel l
 join MetadataSchema.Attribute a on l.objectid=a.AttributeId
 join MetadataSchema.Entity e on a.EntityId=e.EntityId  
where a.name= 'address1_city' and e.name='account'

Campaign Activity status = Pending

2009-06-26T19:19:00.009+04:00

If campaignactivity status is "pending" all the time, when you are distributing the activities, then check out the Microsoft CRM Asynchronous Processing Service was started on the server.

Convert HTML to plain text and remove tags

2009-06-26T19:09:00.006+04:00


// convert HTML to plain text
string Description = System.Web.HttpUtility.HtmlDecode(HTML_encoded_string);

Description = StripTags(Description);

...

// remove tags from HTML-parsed string
private string StripTags(string HTML)
{
 System.Text.RegularExpressions.Regex objRegEx = new System.Text.RegularExpressions.Regex("<[^>]*>");

 return objRegEx.Replace(HTML, "");
}

TargetUpdate VS Update method

2009-06-09T12:16:00.006+04:00

If you have a question what is better for use: UpdateRequest with TargetUpdate or Update method, then first of all you must to look at MS CRM SDK "CrmService Common Methods" article.

There was said:

"The CrmService Web service provides a set of methods used to perform the most common operations on system and custom entities. These operations can also be performed by using the Execute method and the corresponding message. However, the methods will perform faster so they should be used whenever possible."

So service.Update is a winner.

CrmDateTime conversion to DateTime

2009-06-04T17:42:00.003+04:00


Convert.ToDateTime(crmdatetime.Value)
DateTime.Parse(crmdatetime.Value)

For more information on the CrmDateTime, look in the SDK:
http://msdn2.microsoft.com/en-us/library/aa613542.aspx

Open any entity for edit

2009-06-04T13:18:00.005+04:00

The universal URL to open any entity for edit is

http://server name/company name/CRMReports/viewer/drillopen.aspx?ID=objectguid&OTC=object type code

Object type code you can find at Microsoft Dynamics CRM SDK Entity Type Codes article.

Also like that:
http://server name/company name/CRMReports/viewer/drillopen.aspx?ID=objectguid&LogicalName=entity name (contact, account, e.t.c.)

Error: "Unable to connect to the remote server"

2009-05-29T15:31:00.004+04:00

To resolve this error you can edit registry at MS CRM Server - look through the article (PartnerSource) at Microsoft Dynamics: KB913515

Also here is another way, to use the unsafe connection sharing.
Article at blogs.msdn.com: "Best Practices for Better Performance from Your Custom Code"

MS CRM database fragmentation

2009-05-12T14:03:00.005+04:00

If your CRM is very slow, then check the indexes fragmentation.
And if received table was not empty then you must rebuild the indexes.


USE AdventureBase
GO
SELECT a.index_id, name, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(N'AdventureBase'), NULL,NULL, NULL, NULL) AS a
 JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id    
where avg_fragmentation_in_percent>30
GO

Replace non-digit symbols with RegEx

2009-05-08T20:03:00.007+04:00

If you need to restrict input in nvarchar field(only the digit symbols for example), you may write some code to OnSave() event.
This code is replace all of non-digit symbols in new_telephonenumber field to nothing, i.e. "".


//before: new_telephonenumber = "555-555$#5"
//after: new_telephonenumber = "5555555"

var re = /\D/g;
if(document.crmForm.all.new_telephonenumber.DataValue != null){
   crmForm.all.new_telephonenumber.DataValue = crmForm.all.new_telephonenumber.DataValue.replace(re,"");
}

The Microsoft Dynamics CRM Developer Toolkit

2009-05-06T13:11:00.005+04:00

Microsoft Dynamics CRM 4.0 toolkit for Visual Studio 2008. Download link

Test before save

2009-05-05T20:47:00.007+04:00

I don't want to write a server code if I can do the same at the client side.
Here is the test for INN field, that must contain only the numbers.


var re = new RegExp("[^0-9]");
if(crmForm.all.new_inn.DataValue != null){
   if(re.test(crmForm.all.new_inn.DataValue == true){
      alert("ИНН должен содержать только цифры");
      event.returnValue = false;
      return false;
   }
}

Error: 0x80042f09 SecLib::CheckPrivilege failed. Returned hr = -2147209463

2009-05-04T13:34:00.020+04:00

If you get an exception like next one:

0x80042f09
SecLib::CheckPrivilege failed. Returned hr = -2147209463, User: 529cc8c0-23b6-dd11-a373-001cc458db68

You should check the user roles, because the error code 0x80042f09 means "The user has not been granted any licenses or the user has not been assigned any roles."
The user can have the role that can have no rights to the entity or to the entities witch have the owner-member relationship with base entity.
For example:
We have two entities organization -> opportunity and one role "salesperson" with rights on the organization and no rights to the opportunity. If you set the user with just "salesperson" role to the Owner of some organization, you will get the error 0x80042f09.

Same is fair to all errors "SecLib::CrmCheckPrivilege failed."

DateTime in MSCRM

2009-04-26T14:43:00.005+04:00

How to format string to write in CrmDateTime attribute:


string startdate; // - can be a parameter in method

opportunity oop = new opportunity();

opp.new_startdate = new CrmDateTime();

if(startdate!="")
   opp.new_startdate.Value = (Convert.ToDateTime(startdate)).ToString("yyyy-MM-ddTHH:mm:ss");
else
   opp.new_startdate.Value = DateTime.Today.ToString("yyyy-MM-ddTHH:mm:ss");

Null Values - based on MS CRM SDK

2009-04-10T11:12:00.012+04:00

From Microsoft CRM SDK :

When you update an entity instance there is a mechanism you can use to differentiate the absence of a value from a null value. To set an attribute value to null you must set both IsNull and IsNullSpecified to true. For attributes of type String, you must assign the value to String.Empty. This same mechanism is used when you create a query to find a null value.

Another option is to use the type helper code available in Microsoft.Crm.Sdk assembly and in the CRMHelpers classes.

Example
The following code example shows you how to create null instances of the various Microsoft Dynamics CRM attribute types.


CrmBoolean boolean = new CrmBoolean();
boolean.IsNull = true;
boolean.IsNullSpecified = true;

CrmDecimal dec = new CrmDecimal();
dec.IsNull = true;
dec.IsNullSpecified = true;

CrmFloat f = new CrmFloat();
f.IsNull = true;
f.IsNullSpecified = true;

CrmMoney money = new CrmMoney();
money.IsNull = true;
money.IsNullSpecified = true;

CrmNumber number = new CrmNumber();
number.IsNull = true;
number.IsNullSpecified = true;

Lookup lookup = new Lookup();
lookup.IsNull = true;
lookup.IsNullSpecified = true;

PickList list = new PickList();
list.IsNull = true;
list.IsNullSpecified = true;

Status status = new Status();
status.IsNull = true;
status.IsNullSpecified = true;

Owner owner = new Owner();
owner.IsNull = true;
owner.IsNullSpecified = true;

Example
The following code example shows you how to create null instances of the various Microsoft Dynamics CRM attribute types using the type helper classes.


CrmBoolean boolean = CrmBoolean.Null;

CrmDecimal dec = CrmDecimal.Null;

CrmFloat flt = CrmFloat.Null;

CrmMoney money = CrmMoney.Null;

CrmNumber number = CrmNumber.Null;

Lookup lookup = Lookup.Null;

Picklist list = Picklist.Null;

Status status = Status.Null;

Owner owner = Owner.Null;

My Example
Moving the data from one field to another and cleaning the first field after that.


opportunity opp = new opportunity();
opp.opportunityid = new Key();
opp.opportunityid.Value = findedopp.opportunityid.Value;

opp.new_profittreshold = new CrmMoney();
opp.new_profittreshold.Value = (decimal)findedopp.new_investmenttreshold.Value;

opp.new_investmenttreshold = new CrmFloat();
opp.new_investmenttreshold.IsNull = true;
opp.new_investmenttreshold.IsNullSpecified = true;

service.Update(opp);

JavaScript свойства объекта

2009-04-08T11:07:00.001+04:00

Посмотреть свойства объекта - можно использовать конструкцию


for(key in obj){alert(key)}

How to close window without prompt. JavaScript.

2009-01-21T15:09:00.005+03:00

For most of browsers work code like this:


window.opener = top;
window.close();

But for IE7 will work this code:


<script language=javascript>
function CloseWindow() 
{
  window.open('','_self','');
  window.close();
}
</script>

<input type=button name="closebutton" value="Close" class="Button" onclick="CloseWindow()"/>

Передача нескольких параметров JavaSript в XML

2009-01-21T14:54:00.003+03:00

In ISV.Config I was needed a <Button> with JavaScript on it for open modal dialog with 2 or more parameters. In the dialog I'll calculate some sums for displayed opportunities.

So this is example:


<Button JavaScript="var url='http://localhost/CalcTotals.aspx';var paramStr = 'viewid=' + crmGrid.GetParameter('viewid'); if (crmGrid.GetParameter('filterDisplay') != null) paramStr += '&amp;' + 'filter=' + crmGrid.GetParameter('filterDisplay');if (crmGrid.GetParameter('quickfind') != null) paramStr += '&amp;' + 'quickfind=' + crmGrid.GetParameter('quickfind'); url= url + '?' + paramStr; showModalDialog(url , '','status:no;dialogWidth:610px;dialogHeight:210px;dialogHide:true;help:no;scroll:no');" AccessKey="в" WinMode="1" PassParams="1">;

The character "&" must be replaced with "&".

An XML comment cannot contain '--', and '-' cannot be the last character.

2009-01-21T11:45:00.000+03:00

The most possible reason of this error is in your web.config or in your custom XML file.
There is great likelihood that is in AppSettings section.

Error: The request failed with http status 400: Bad Request

2008-11-13T16:01:00.001+03:00

Ошибка в переданных сервису данных.
Например, при создании systemuser или salesperson в логине вместо DomainName\UserName надо передавать DomainName\\UserName, иначе некоторые совпадения символов косой черты и последующей буквы могут быть распознаны как escape-последовательность.

Ownerid

2008-10-30T19:30:00.000+03:00

Если сущность создавать программно и не заполнять поле ownerid, то MSCRM сам заполнит это поле Guid'ом пользователя, вызвавшего метод Create().

Скрытие стандартных ссылок в панели навигации сущности.

2008-10-16T18:51:00.001+04:00

Узнаем наименование скрываемой ссылки, например с помощью IE DEV Tools.
И в форме сущности на событе OnLoad пишем следующий JavaScript:


if(document.all.navAddresses != undefined) {
  document.all.navAddresses.parentNode.style.display = 'none';
}

Закрытие окна CRM без подтверждения

2008-10-14T20:35:00.000+04:00

Если вы хотите закрыть окно CRM без подтверждения, до вызова window.close() вызовите функцию crmForm.detachCloseAlert()

На событие OnSave формы сущности account

2008-09-19T19:00:00.002+04:00


/*Start:Script added by Me*/
var CRM_FORM_TYPE_CREATE=1;
var CRM_FORM_TYPE_QCREATE=5;
var Return;
/******* comment 21.04 *******/
if ((crmForm.FormType==CRM_FORM_TYPE_CREATE)||(crmForm.FormType==CRM_FORM_TYPE_QCREATE))
{
    var str="http://servername/Dedup/duplicatelist.aspx?name=" + escape(crmForm.all.name.DataValue)+"&EntityTypeId=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX";
    Return = showModalDialog(str,"","resizable=yes;");
    if(Return==true)
    {     /* продолжить сохранение */
        event.returnValue = true;
        return true;
    }
    else
    {     /* отменить сохранение */
        event.returnValue = false;
        crmForm.detachCloseAlert();
        //return false;
        window.close();
    }
}
/******* comment 21.04 *******/
/*End:Script added by Me*/

Plugin's Starter Execution Method

2008-09-17T21:00:00.003+04:00

Have found excellent method at David Fronk blog Starter Execution Method and slightly update it in to separate method.

// based on Starter Execution Method

/// 
/// Return the opportunity id
/// 

/// Plugin context/// opportunityid
public string GetEntityId(IPluginExecutionContext context)
{
 string opportunityid = "";
 DynamicEntity opportunityClose = null;

 switch (context.MessageName)
 {
  case "Create":
   if (context.OutputParameters.Properties.Contains("id"))
   {
    opportunityid = context.OutputParameters.Properties["id"].ToString();
   }
   break;
  case "Update":
   if (context.InputParameters.Properties.Contains(ParameterName.Target) && context.InputParameters.Properties[ParameterName.Target] is DynamicEntity)
   {
    DynamicEntity entity = (DynamicEntity)context.InputParameters.Properties[ParameterName.Target];
    opportunityid = ((Key)entity.Properties["opportunityid"]).Value.ToString();
   }
   break;
  case "SetState":
   if (context.InputParameters.Properties.Contains("EntityMoniker"))
   {
    if (context.InputParameters.Properties.Contains("State"))
    {
     Moniker entityMoniker = (Moniker)context.InputParameters.Properties[ParameterName.EntityMoniker];
     opportunityid = entityMoniker.Id.ToString();
    }
   }
   break;
  case "SetStateDynamicEntity":
   if (context.InputParameters.Properties.Contains("EntityMoniker"))
   {
    if (context.InputParameters.Properties.Contains("State"))
    {
     Moniker entityMoniker = (Moniker)context.InputParameters.Properties[ParameterName.EntityMoniker];
     opportunityid = entityMoniker.Id.ToString();
    }
   }
   break;
  case "Win":
   opportunityClose = (DynamicEntity)context.InputParameters["OpportunityClose"];
   Lookup WonLook = (Lookup)opportunityClose.Properties["opportunityid"];
   opportunityid = WonLook.Value.ToString();
   break;
  case "Lose":
   opportunityClose = (DynamicEntity)context.InputParameters["OpportunityClose"];
   Lookup LoseLook = (Lookup)opportunityClose.Properties["opportunityid"];
   opportunityid = LoseLook.Value.ToString();
   break;
  case "Assign":
   if (context.InputParameters.Properties.Contains("Assignee") && context.InputParameters.Properties["Assignee"] is SecurityPrincipal)
   {
    Moniker assignEntity = (Moniker)context.InputParameters.Properties["Target"];
    opportunityid = assignEntity.Id.ToString();
   }
   break;
  case "Delete":
   if (context.InputParameters.Properties.Contains("Target"))
   {
    Moniker entityMoniker = null;
    entityMoniker = (Moniker)context.InputParameters.Properties[ParameterName.Target];
    opportunityid = entityMoniker.Id.ToString();
   }
   break;
 }
 return opportunityid;
}

Сущность template, plug-in и Javascript

2008-09-09T16:15:00.001+04:00

Начну с того, что сущность template не изменяемая, но настраиваемая. Однако, это не преимущество. Я не понимаю по каким причинам сущность template была скрыта от нас, но ни форма ни события на ней нам недоступны.
Более того, plug-in на шаг PreCreate для этой сущности дает поразительный результат - при выбрасывании InvalidPluginExecutionException стирает тело и тему самого template.
А задача простая - не дать или хотя бы уведомить пользователя о том, что шаблон с таким именем уже существует. Ну чтобы пользователь потом не выбирал из десятка шаблонов с одинаковым title.
Как же решить? Plug-in не функционален, скрипт вставить некуда. Решил внедриться в оригинальную страничку. Называется она emailtemplateeditor.aspx. Там есть функция Save в нее и написал свой код.
Но проблема обнаружилась и тут. Оказывается CRM не дает обратиться к значению поля templateid (нужно, чтобы title не сравнивать с самим собой), т.е. crmForm.all.templateid.DataValue не работает.
Что ж решил действовать старым проверенным способом через crmForm.FormType, чтобы узнать создаем новый шаблон(FormType=1) или редактируем старый(FormType=2). И тут Microsoft окончательно убедил меня в том, что его сотрудники видимо произошли не от углеродной формы жизни - FormType=0 (Undefined form type). Т.е. согласно SDK сущность создана для системных нужд "For internal use only".

Спасло свойство crmForm.ObjectId, которое и содержало значение поля templateid.
В результате скрипт был закончен и стал иметь такой вид:


var url = "http://mcrm4/wsTemplateCreateCheckDup/CheckTemplateTitleDup.asmx/IsDup";
var templateid="null";
if (crmForm.ObjectId != null)
{
 templateid=crmForm.ObjectId;
 templateid=templateid.slice(1, templateid.indexOf('}'));
}
var paramstr = "TemplateTitle="+crmForm.all.title.DataValue+"&"+"TemplateId="+templateid;
try{
 var oXmlHTTP = new ActiveXObject("Msxml2.XMLHTTP");
 oXmlHTTP.open("POST", url,false); 
 oXmlHTTP.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
 oXmlHTTP.send(paramstr);
 if(oXmlHTTP.status == 200) 
 {
  var retstr=oXmlHTTP.responseText;
  var retidx=retstr.indexOf(">found");
  if(retidx>0)
  {
   alert("Имя шаблона '"+crmForm.all.title.value+"' уже есть в списке.\n Пожалуйста, задайте другое имя.");
   SubjectEditor.focus();
   event.returnValue=false;
   return false;
  }
 }
 else
 {
  alert("Ошибка "+ oXmlHTTP.status+" при проверке на повторное использование имени шаблона.");
 }
}
catch(e){alert(e);}

Plug-in signing

2008-08-18T17:23:00.000+04:00

При разработке plug-in'а, нужно обязательно задавать сильное имя(strong name) и не забывать при релизе переподписывать(re-sign) библиотеку, если был выставлен атрибут Delay Sign Only.

sn - R <assembly> <keyfile>

"Not have enough privilege to complete Create operation for an Sdk entity" при регистрации плагина в CRM 4.0

2008-08-18T17:03:00.002+04:00

Эта ошибка возникает даже если пользователь обладает ролью System Administrator. Причина её возникновения, в том, что пользователь не является членом группы Deployment Administrators group в утилите CRM Deployment Manager.

Вы написали plug-in и пытаетесь его зарегистрировать. Не важно, делаете ли вы это с помощью Plug-in Registration Tool из SDK или с помощью собственного инсталлера, однако, даже если вы Системный Администратор, то возможно вам все-равно не удастся зарегистрировать plug-in, и вы получите следующую ошибку:

"Not have enough privilege to complete Create operation for an Sdk entity"

Оказывается System Administrator больше не царь и бог, и эта роль не обладает привилегиями развертывания(deploy). Есть отдельная роль Deployment Administrator. Изначально ее имеет тот, кто устанавливал CRM на локальную машину.
Чтобы регистрировать плагины, понадобится добавить пользователя из-под которого происходит регистрация в Deployment Manager.

Откройте CRM 4.0 Deployment Manager (Start -> All Programs -> Microsoft Dynamics CRM -> Deployment Manager)

Добавьте пользователя из Active Directory в Deployment Administrator'ы

После этого попробуйте еще раз зарегистрировать свой plug-in.

TargetUpdate Sample Code.

2008-08-05T17:55:00.002+04:00

Этого Sample Code я не нашел в SDK, однако нашел вопросы на форумах, оставленные без ответов и решенные с помощью CrmService.Update. Потому я решил написать такой пример.
Думаю кому-то будет интересно как же на самом деле может быть решена задача обновления через TargetUpdate.

private void EmailDeliveryChange(email emailResult, int new_delivery)
{
service = new CrmService.CrmService();
service.Credentials = System.Net.CredentialCache.DefaultCredentials;
service.Url = CrmServiceUrl;

TargetUpdateEmail tue = new TargetUpdateEmail();
// create new email entity for update
email emailUpdate = new email();

// Set the ID of entity which we want to update
emailUpdate.activityid = new Key();
emailUpdate.activityid.Value = new Guid(emailResult.activityid.Value.ToString()); // parameter

// set new value of attribute
emailUpdate.new_delivery = new Picklist();    
emailUpdate.new_delivery.Value = new_delivery;  // parameter

tue.Email = emailUpdate;    
UpdateRequest upreq = new UpdateRequest();

upreq.Target = tue;
UpdateResponse upres = (UpdateResponse)service.Execute(upreq);
}

Dynamics CRM 4.0 Solution Center

2008-07-23T11:43:00.000+04:00

Команда Microsoft Dynamics CRM 4.0 создали на сайте поддрежки Microsoft страницу Dynamics CRM 4.0 Solution Center, где публикуются решения, на часто возникающие проблемы и вопросы.

Кастомизируемость

2008-07-22T17:52:00.001+04:00

Очень меня печалит, что переводили CRM 4.0 видимо с помощью программы переводчика, а не лингвиста-переводчика. Особенно это заметно, когда в сущности template атрибут title переведен как "Должность".
Это не было бы критично, если бы разработчики CRM позволили менять названия атрибутов стандартными средствами.

Microsoft Dynamics CRM 4.0 SDK

2008-07-21T19:56:00.000+04:00

Если кто-то еще не знает где взять(скачать) Microsoft Dynamics CRM SDK, то это можно сделать вот тут:

Microsoft Dynamics CRM 4.0 Software Development Kit

P.S. Версия SDK 4.0.5

CRM 4.0 E-mail access type bulk setting tool

2008-07-21T12:31:00.000+04:00

Джим Ванг написан замечательную утилиту для правки email'ов.
Эта утилита, в помощь администраторам CRM, позволяет менять настройки доступа для всех писем попадающих в фильтр по определенному пользователю, т.е. массово. Сама Dynamics CRM не предоставляет такой возможности.

Скачачать ее можно здесь: http://code.msdn.microsoft.com/crm/Release/ProjectReleases.aspx

ISV.config.xml и русские символы

2008-07-14T20:17:00.002+04:00

Если при импорте ISV.config.xml у вас не отображаются русские символы, то посмотрите, есть ли у вас в начале файла строка


<?xml version="1.0" encoding="utf-8"?>;

ISV.config.xml

2008-07-14T19:33:00.002+04:00

В MS CMR 4.0 поменялся формат ISV.config.xml
Все Title и ToolTips теперь должны быть вынесены в отдельные тэги.
Например, вместо


<button
title="Dial..."
tooltip="Dials one of the phone numbers on this record"
icon="/_imgs/ico_16_137.gif" url="/C4Web/C4Dial.aspx" passparams="1"
winparams="directories=0,height=150,width=300,location=no,menubar=no,resizable=no,scrollbars=no,status=no,titlebar=no,toolbar=no" winmode="0" client="Web, Outlook" availableoffline="false">

следует писать


<Button Icon="/_imgs/ico_16_137.gif" Url="/C4Web/C4Dial.aspx" PassParams="1" WinParams="directories=0,height=150,width=300,location=no,menubar=no,resizable=no,scrollbars=no,status=no,titlebar=no,toolbar=no" WinMode="0" Client="Web, Outlook" AvailableOffline="false">
<Titles>
<Title LCID="1001" Text="Dial..." />
</Titles>
<ToolTips>
<ToolTip LCID="1001" Text="Dials one of the phone numbers on this record" />
</ToolTips>
</Button›

Microsoft.Crm.WebServices.Crm2007.MultipleOrganizationSoapHeaderAuthenticationProvider

2008-07-11T15:19:00.002+04:00

Проблема:
В MS CRM 4.0 столкнулся с проблемой размещения своего сайта в виртуальном каталоге сайта MS CRM.

Ошибка выдавалась следующая:

Microsoft.Crm.WebServices.Crm2007.MultipleOrganizationSoapHeaderAuthenticationProvider, Microsoft.Crm.WebServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' doesn't exist.
Parameter name: Microsoft.Crm.WebServices.Crm2007.MultipleOrganizationSoapHeaderAuthenticationProvider, Microsoft.Crm.WebServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35

Решение:
Было найдено на форуме Dynamics
Решение совершенно бредовое, но только так и удалось запустить свой сайт. Необходимо зарегистрировать в GAC библиотеку Microsoft.Crm.WebServices.dll(лежит в %CRM Web%/bin)

gacutil /i Microsoft.Crm.WebServices.dll

Если вы не нашли gacutil.exe, то можно в Explorer'е просто перетащить нужную DLL в папку WINDOWS\assembly.

Ожидания

2008-07-10T18:57:00.000+04:00

Под Microsoft CRM я начал писать недавно. До этого много сил отдал Navision, так и не достигнув нирваны, но добившись каких-то успехов.

MS CRM привлек сразу несколькими возможностями: писать под web с использованием нормального объектно-ориентированного языка C# и в нормальной рабоче среде Visual Studio. Это радовало. Особенно после Navision.
Но как оказалось все было не так радужно, как представлялось. MS CRM да и .Net Framework преподносит сюрпризы, которые могут по началу шокировать. Но задачи становятся настолько интересными, на сколько это вообще возможно!

Вот о некоторых таких задачах и их решении я и буду писать здесь. Возможно тематика будет не всегда касаться непосредственно CRM, но всегда программирования.