My blog has moved!

Please visit
http://crmdude.wordpress.com/
and update your bookmarks.

Wednesday, 4 February 2009

Performing a Javascript Web Service call to the Metadata Service

About a week ago a colleague of mine told me that he'd been able to use my JS script to retrieve fields from a related record upon the change of a lookup value- which worked exactly as he wanted. However, one of the fields he retrieved was a Picklist value- which was obviously a numeric value and pretty pointless since the field he was displaying the value in was nvarchar.

He had three options;

1) Hard code the text values for each option value in his code (yeah, right!),

2) Create a picklist with the same values (text and numeric) as the source picklist and ensure that his documentation clearly outlines that the two picklists will forever have to kept in sync (umm, no thanks),

3) Perform a web service call to the Metadata service and retrieve the options for the source picklist (!).

So I decided to put together the JavaScript code to achieve (3). In the example below, I'm retrieving the accountcategorycode field from the Account entity.



var request = "" +
"<?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\">" +
GenerateAuthenticationHeader() +
" <soap:Body>" +
" <Execute xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +
" <Request xsi:type=\"RetrieveAttributeRequest\">" +
" <MetadataId>00000000-0000-0000-0000-000000000000</MetadataId>" +
" <EntityLogicalName>account</EntityLogicalName>" +
" <LogicalName>accountcategorycode</LogicalName>" +
" <RetrieveAsIfPublished>false</RetrieveAsIfPublished>" +
" </Request>" +
" </Execute>" +
" </soap:Body>" +
"</soap:Envelope>" +
"";

var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");

xmlHttpRequest.Open("POST", "/mscrmservices/2007/MetadataService.asmx", false);
xmlHttpRequest.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/Execute");
xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest.setRequestHeader("Content-Length", request.length);
xmlHttpRequest.send(request);

var result = xmlHttpRequest.responseXML;
alert(result.xml);


Hope that helps somebody out there!

Thursday, 29 January 2009

Deleting records in MSCRM 4.0

As many of you would be aware, when deleting records from MSCRM, the record itself isn't removed from the SQL database straight away- instead the DeleteStateCode of the record in question is updated to '2'. There are a number of ways to forcing a delete of the row immediately (this may be necessary if you're testing a heavy data import script for example).

One way is to write a SQL script to empty the database tables representing your entities, so to remove all Contacts, you'd run the following script (this is assuming there are no relationships with any other entity- eg, no Contact has a Parent Customer):

delete from ContactExtensionBase
delete from ContactBase

Another way is to either delete your records from the application (thus setting DeleteStateCode to 2) or updating records in the database manually using SQL to set DeleteStateCode to 2 and then running the script Bill Owens has put up on his blog: http://billoncrmtech.blogspot.com/2008/05/delete-forcing-microsoft-crm-40-to.html. His script makes the CRM deletion job run immediately (after you restart the CRM Asynchronous service).

Finally, there is also the ScaleGroup Job Editor which is a nifty little tool that you run on the CRM server itself. The tool allows you to set how often you want the Deletion job to run (among other CRM jobs). More info and download from here: http://code.msdn.microsoft.com/ScaleGroupJobEditor/Release/ProjectReleases.aspx?ReleaseId=676

I'm sure people have discovered other (and better) ways to bulk delete records from CRM.. please feel free to share them with me!

Tuesday, 13 January 2009

Performing a JavaScript web service call

The following example shows to perform a web service call to work out whether the Potential Customer of an Opportunity is on Credit Stop or not. It should be placed in the OnChange event of the Customer field on the Opportunity record.



//Prepare variables for a account to retrieve.
var accountid = crmForm.all.customerid.DataValue[0].id
var authenticationHeader = GenerateAuthenticationHeader();

//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>account</entityName>"+
"<id>"+accountid+"</id>"+
"<columnSet xmlns:q1='http://schemas.microsoft.com/crm/2006/Query' xsi:type='q1:ColumnSet'>"+
"<q1:Attributes>"+
"<q1:Attribute>creditonhold</q1:Attribute>"+
"<q1:Attribute>name</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;


Monday, 22 December 2008

An early look at CRM “5”

The Microsoft CRM Team Blog's latest post has some information on the next version of CRM: http://blogs.msdn.com/crm/archive/2008/12/18/an-early-look-at-crm-5.aspx

Thursday, 6 September 2007

Quick Campaign Bug

A client of mine found a problem with Quick Campaign's in his CRM environment. He was playing with the QC functionality and created a new QC, and then deleted the associated merge Letter/Email without sending it/distributing it. He then could not delete the QC record and got an error message saying that "This record is currently being used by Microsoft CRM and cannot be deleted."

I had to remove the records from the database itself. The QC entity does not have it's own table in the database, instead it is recognised within the system a Bulk Operation Activity. I had to remove it from the following tables:
-
ActivityPartyBase,
- BulkOperationBase,
- ActivityPointerBase.


Tuesday, 14 August 2007

Microsoft CRM 4.0 (Titan)

I attended a Microsoft CRM 4.0 session at Microsoft NZ's offices here in Auckland early last week. The session was presented by Ed Martinez who is one of the Development Managers of the application.

Some of the new features in 4.0 are:
- multi organisation,
- multi currency,
- multi language,
- multi entity grid,
- improved workflow engine (WWF),
- reporting wizard,
- report scheduling wizard,
- web client mail merge,
- duplicate detection.

Unfortunately I am pressed for time so I can't go into further detail on each of the above..

"Send Direct Email" does not work

A client called me a few days ago and said that he couldn't 'Send Direct Emails'. After he'd select the template to send, it would simply do nothing, the History wouldn't show the send email nor would the recipient recieve any emails.

Naturally, the first place I looked was the Microsoft CRM Bulk Email service. I found that it was set to logon as the Network Service account. I changed this to Local System account (this is after I had tested to ensure that emailing was working from all other avenues in Microsoft CRM) and voila it started working.