Support for COUNT(DISTINCT) in Fetch XML queries

Please see the crm post for more details on Aggregate functions supported by MS CRM 4.

Read More

MS CRM Social Networking Workflow DateTime Format Error.

The accelerator code as supplied does not correctly parse Twitter timestamps. DateTime.ParseExact breaks on the odd time zone value, which in (GMT/UK) comes from twitter with the value "+0000".

DateTime.ParseExact can use a format string of "z", "zz", or "zzz", corresponding to "+0", "+00" or "+00:00" respectively, none of which match the Twitter format.

You need to change the code in teh BuildDynEntity() method, in msa_datapump.cs, as follows:

case "CrmDateTimeProperty":
//Twitter timestamps contain odd timezone specifier "+0000" that doesn;t work
// well with DateTime.ParseExact().
CrmDateTimeProperty crmDateTimeProperty = new CrmDateTimeProperty();
CrmDateTime crmDateTimeValue = new CrmDateTime();
DateTimeOffset parsedDateTime = DateTimeOffset.ParseExact(CRMAttrValue, "ddd MMM dd HH:mm:ss zzz yyyy", null);
DateTime localDateTime = new DateTime(parsedDateTime.Ticks, DateTimeKind.Local);
crmDateTimeProperty.Value = CrmDateTime.FromUser(localDateTime);
crmDateTimeProperty.Name = CRMAttrName;
crmEntity.Properties.Add(crmDateTimeProperty);
break;

Save / Complile / Build the assembly.
Register the assembly using plug-in registration tool.
Restart the Microsoft Crm Async Service.

Start Creating the Twitter User. Now the workflow won't failed (i mean it will not be on the Waiting state anymore !!!).

Hope this will resolves the issue.

Read More

MS CRM Social Networking Workflow Error (Twitter-Get External Updates / Missing Attributes)

Recently I've installed MS Social Networking Accelerator for MS CRM 4. The installation is very simple, it will get installed very easily. Once you installed and run you will encounter the Workflow errors:

Basically the MSA_snStatus Entity Customisation has some bugs. It does not include the below three attributes: You need to manually create those three attributes.

Open MS CRM App -> Go to Settings -> Go to Customisations -> Customise Entity -> Open MSA_snStatus entity -> Go to Attributes (left hand navigation panel)

Step 1. Add new attribute
Step 2. Specify attribute Display name = Contributors
Step 3. Specify attribute name = msa_snContributors [make sure your application default prefix is msa]
Step 4: datatype = nVarChar
Step 5: specify length = 200
Step 6: Save and clsoe

Repeat the same steps for below attributes:
2. MSA_snCoordinates attribute [Display name = Coordinates / nVarchar / 200]
3. MSA_snPlace attribute [Display name = Place / nVarchar / 200]

Save and Publish the entity.
Reload the MS CRM Application.

Start Creating the Twitter User. Now the workflow won't failed (i mean it will not be on the Waiting state anymore !!!).

Hope this will resolve the issue.

Read More

xRM - Many Applications, One Platform

xRM - Many Applications, One Platform

Read More

SharePoint Products and Technologies: 2010 (Technical Preview) Developer Documentation

Sharepoint 2010 VPC Image would be available soon. Till then you should download Sharepoint 2010 Technical Documentation.

Sharepoint 2010 developer documentation contains details about
How to Customizing the Ribbon in Windows SharePoint Services "14". The Ribbon is now included in the user interface for Windows SharePoint Services “14” and Microsoft SharePoint Server 2010.

This developer tutorial for sharepoint 2010 describes how developers extend it using a combination of XML and ECMAScript (JavaScript, JScript).

Customizations to the Ribbon in the included example are created using the Feature infrastructure, and can be deployed using a solution package (.wsp file). This tutorial for sharepoint 2010 is provided in both PDF and XPS format.

This compiled help (.chm) file contains reference topics focusing on types and members that are called by other Microsoft applications. This reference does not reflect the entirety of the SharePoint Products and Technologies 2010 managed object model.

The full SharePoint Products and Technologies 2010 SDK will accompany the public release of SharePoint 2010.
Download Sharepoint 2010 Technical Documentation

Read More