Friday, 30 January 2009

CRM Client AutoUpdate

Known issue after you install Update Rollup 2

When you publish a workflow in Microsoft Dynamics CRM 4.0 after you install Update Rollup 2, you may receive the following error message:

The selected workflow has errors and cannot be published. Please open the workflow, remove the errors and try again.

To resolve this issue, open the Microsoft CRM Web site Web.config file in a text editor such as Notepad, and then add the following lines to the authorizedTypes section:

<authorizedType Assembly="mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Namespace="System.Globalization" TypeName="CultureInfo" Authorized="True"/>
</authorizedTypes>

Saturday, 24 January 2009

Displaying CRM Views in IFRAMES

Thursday, 22 January 2009

Renaming Modules

Implementing Approval Verification Processes

Implementing Approval Verification Processes
For holiday request etc.

http://blogs.msdn.com/crm/archive/2009/01/12/implementing-approval-verification-processes.aspx

Wednesday, 21 January 2009

The Mysterious CRM Lookup

crmForm.all.regardingobjectid.DataValue[0].id; // The GUID of the lookup.
crmForm.all.regardingobjectid.DataValue[0].name; // The text value of the lookup.
crmForm.all.regardingobjectid.DataValue[0].typename; // The entity type name.


http://jianwang.blogspot.com/2008/05/mysterious-crm-lookup-i.html

Tuesday, 20 January 2009

Web Service Basics #1: CrmService.Fetch Method Using JScript

Monday, 19 January 2009

Convert a text field to a combobox at runtime

Scripting Sample Code

CRM Metadata Browser

Modifying the fullname

Courtesy of Mr. Lemmen;

UPDATE contactbase SET fullname = ISNULL(lastname, '') + ', ' + ISNULL(firstname, '')

Of course you can update the contactbase with other values for the fullname as well.

Keep in mind that you NEVER update the Contact view, always the contactbase. Updating the contact view will cause problems.

Anyway, you should always make a backup of your database before making any modification to the database.

http://ronaldlemmen.blogspot.com/2006/07/modifying-fullname.html

Sunday, 18 January 2009

CRM 4.0: Checkbox style Multi-Select Picklist

Update Rollup 2 for Microsoft Dynamics CRM 4.0 is available

Increase Maximum Records Exported to Excel

crm 4.0

Open SQL management studio
Expand organisation CRM DB
Open OrganizationBase
Set MaxRecordsForExportToExcel to an integer value


crm 3.0

Run Regedit
HKLMachine\Software\Microsoft\
MSCRM
Create new DWORD value 'maxrecordsforexporttoexcel'
Enter a value over 500

Tuesday, 13 January 2009

How Licensing for external CRM users works

Monday, 12 January 2009

Convenient reports in the nav bar

Auto formatting phone numbers

Is my CRM implementation successful?

Should We Use Leads?

More Than 8 Tabs on a Microsoft CRM Form

http://www.unitek.com/training/microsoft/crm/blog/2008/12/15/more-than-8-tabs-on-a-microsoft-crm-form/

In: C:\Program Files\Microsoft CRM Server\CRMWeb\Tools\FormEditor find your formeditor.aspx and select “edit.” Find the JavaScript variable “_iMaxTabs” and notice that it is set to 8. Change the value to your desired limitation, save and close, reset IIS and you should then be able to create the additional tabs needed from within the forms customization area.

or in my case: F:\inetpub\crmroot\Tools\FormEditor\formeditor.aspx

Note: this is unsupported.

Creating An Audit Trail In Microsoft CRM 4.0

Improving ASP.NET Performance

Best practices in plug-in development

Hidden privileges in System Roles

Forcing Microsoft CRM 4.0 to clean up deleted records

Customer Intelligence Article

Discusses Customer Relationship ABCs and the 360° customer view

http://www.bi-bestpractices.com/view-articles/4659

Microsoft Dynamics CRM Internet Facing Deployment Configuration tool

Microsoft Dynamics CRM 4.0 Internet Facing Deployment Scenarios

Close an Opportuntity using SDK

From here: http://msdynamicscrm-e.blogspot.com/2008/12/close-opportunity-via-sdk.html

opportunityclose close = new opportunityclose();
close.opportunityid = new Lookup();
close.opportunityid.Value = targetOppId;

WinOpportunityRequest request = new WinOpportunityRequest();
request.OpportunityClose = close;
// Update the status code according to your environment
request.Status = 1;

crmService.Execute(request);

Hide a view using a CRM 4.0 plug-in

Dynamically change the name of a tab

From here: http://dmcrm.blogspot.com/2008/06/dynamically-changing-name-of-tab.html

Sets tab 4 name to name of primary contact:

var title = crmForm.all.primarycontactid.DataValue;

if(title != null)
{
document.all.tab4Tab.innerText = title[0].name;
}


Disable all form fields

from stunnware:

for (var index in crmForm.all) {
var control = crmForm.all[index];
if (control.req && (control.Disabled != null)) {
control.Disabled = true;
}
}

Wednesday, 7 January 2009

Enabling Fields in Bulk Edit Forms

Tuesday, 6 January 2009

Set Currency to Pound Sterling

(from here: http://msdn.microsoft.com/en-us/library/cc468412.aspx)

Drop this into the onLoad form event:

var myCurrency = crmForm.all.transactioncurrencyid;

// Do Not overwrite an existing value that may be mapped.
if (myCurrency.DataValue == null)
{
// Create an array to set as the DataValue for the lookup control.
var lookupData = new Array();
// Create an object to add to the array.
var lookupItem= new Object();
// Set the id, typename, and name properties to the object.
lookupItem.id = '{0DC1106C-F686-DD11-A1E3-0019BBD28930}';
lookupItem.typename = 'transactioncurrency';
lookupItem.name = 'Pound Sterling';
// Add the object to the array.
lookupData[0] = lookupItem;
// Set the value of the lookup field to the value of the array.
myCurrency.DataValue = lookupData;
}

Thursday, 1 January 2009

Programming Microsoft Dynamics CRM 4.0 Code Samples

Download the Programming Microsoft Dynamics CRM 4.0 code samples from here: http://www.microsoft.com/mspress/companion/9780735625945/

URL Addressable Forms and Views

How to imbed dynamic hyperlinks in CRM Workflow generated Emails

This is from http://blogs.javista.com. Note: It uses Windows Workflow Foundation.

here it is: http://blogs.javista.com/2008/12/19/workflow-e-mail-utilities/