Wednesday, May 11, 2011

Maximizing the Export record count in CRM

If you need to make it a higher value you have to update the CRM database.
Organizationbase table contains a field MaxRecordsForExportToExcel which needs to be updated.

I was helped here by one of my colleagues regarding this.

Update Organizationbase 
set  MaxRecordsForExportToExcel = 150000

Delay in sending Emails through CRM Email Router

When sending emails through CRM email router some of our clients have come back to us saying that the email takes around 1 hour time to be send. After searching this with our technical director we found out that there is a field in the CRM email router configuration that can be changed to set this delay.

You can find the config file at C:\Program Files\Microsoft CRM Email\Service.

The file name is “Microsoft.Crm.Tools.EmailAgent.xml”. You might not be able to edit this as this is protected by default. Have to give yourself permission to edit this file.

Please set the following attributes value. PendingStatusDelay

PendingStatusDelay - 300000 - PendingStatusDelay"

300000

Here we have set it to 5 minutes. 60 *5 *1000

Searchable Option in Attributes in CRM

We can set the value of this to No for attributes that we do not want the customer to be seeing in the advanced find. By setting this value to No you customer/user will not be able to use the attribute to search criteria. However the attribute will be made visible in the column list that will be displayed with the result set.

Retrieving Calendar of a Bookable Resource in Dynamics

There are occasions where we need to retrieve working days and working times of a resource in Dynamics grammatically. This is quite possible...