Friday, 30 January 2009
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>
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
Thursday, 22 January 2009
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
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
Monday, 19 January 2009
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
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
Tuesday, 13 January 2009
Monday, 12 January 2009
Should We Use Leads?
A good post discussing whether or not to make use of Leads
http://www.unitek.com/training/microsoft/crm/blog/2008/02/06/microsoft-crm-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.
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.
Customer Intelligence Article
Discusses Customer Relationship ABCs and the 360° customer view
http://www.bi-bestpractices.com/view-articles/4659
http://www.bi-bestpractices.com/view-articles/4659
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);
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;
}
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;
}
}
for (var index in crmForm.all) {
var control = crmForm.all[index];
if (control.req && (control.Disabled != null)) {
control.Disabled = true;
}
}
Wednesday, 7 January 2009
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;
}
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/
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/
here it is: http://blogs.javista.com/2008/12/19/workflow-e-mail-utilities/
