Problem viewing XML in IE via CRM2011 REST interface

I was trying to view a specific record in an entity set when my Internet Explorer showed the message “Internet Explorer cannot display this feed”.


It seems that this has something to do with the build in RSS feed reader in IE. If you want to view the raw XML returned from your REST query without this error, then you need to disable this RSS feed reader. The steps to do this are the following:

1) Go to Tools –> Internet Options

2) Click on the “Content” tab

3) Under the section “Feeds and Web slices”, click “Settings”

4) Uncheck “Turn on feed reading view”


5) Click “Ok” and again “Ok”

Now when I try to view the details of a specific account using the following link:

I will see something like this


Experimenting with CRM2011 adapter for Scribe

Some time ago I explained how you can connect Scribe to CRM2011 Online using the CRM4 adapter.
I also mentioned that the CRM2011 adapter would be released very soon. Well, good news, the adapter has been released.
More information on the release can be found on their website: Scribe software blog

Of course Scribe Soft has like always made all the necessary documentation available to ease the installation process and general use.
You can find the release notes, help file and the adapter installer on the following location: Download CRM2011 Scribe adapter

In this post I would also like to take the opportunity to go shortly over the installation process.

1) First of all you need to make sure that you have the latest Scribe Insight 7.0.2 installed
2) Next make sure to install Windows Identity Framework (WIF), this is something the new adapter requires. You can download this on the following location: Download Windows Identity Framework (WIF)
A little side note concerning Windows Identity Framework, this can’t be installed on Windows XP. If you have this OS and want to use this adapter, then it’s time to upgrade your OS.
3) You also need to make sure .NET 4.0 is installed. This can be downloaded from this location: Download .NET Framework 4
4) Now comes the tricky part, you need to make sure UAC is complete disabled before running the installer. If you don’t
do this, you’ll keep getting the error saying that you need to install the prerequisites. You can turn of UAC via “Run –> msconfig- Tools tab”. Click on "Change UAC Settings" and pull the slider all the way down to the bottom.


5) Now you need to restart your computer
6) Now we’re all set to run the adapter installer.

In Scribe Insight you immediately notice that there are two adapters. One for CRM4 and one for CRM2011.


I didn’t have time to do much elaborate testing but when trying to connect to CRM2011 online I noticed that we now need to enter the user friendly name instead of the unique name. The UI during the connection process has also changed a little bit.


Up until now I’ve had a very good experience using this adapter, so ScribeSoft, thank you very much, nice work!!

How to connect Scribe to CRM2011 Online

Scribe by default has a CRM adapter to connect to Microsoft Dynamics CRM. Now with the release of CRM2011, Scribe is working on a specific CRM2011 adapter. However, with the current CRM adapter it is also possible to connect to Dynamics CRM 2011 (online and on premises). Just for your information, the new adapter will be ready very soon (end of this month?).

While testing Scribe with CRM 2011 Online I had however a small issue to connect. This problem was quickly resolved by browsing the Scribe knowledge base. So If you are unable to connect to CRM 2011 Online using Scribe, try the following:

You need to add two strings to following registry locations (depending on your OS):

32-bit Scribe Servers


64-bit Scribe Servers


Here are the things you need to add:

String Value Name:  CrmOnlineUrlOverride


String Value Name:  PassportPartner


If there are any problems, let me know

How to disable the Get Started pane in CRM2011

You probably have noticed that CRM2011 now comes with a very handy pane at the top showing tips&tricks, videos etc. to help you work with CRM2011. This is truly a great help if you are just getting started with CRM2011. If you however have a little more experience with CRM2011 and you were wondering if you could disable or hide this pane. Yes you can! You can do it on a personal or user level or organizational (then it will be disabled for all the users in CRM2011 regardless of their personal setting).

If you don’t know what I’m talking about, see the image below Glimlach


Disable it on user level

Go  to File – Options


There on the “General tab” you change the setting.


Disable it on organization level

Go to Settings – Administration – System Settings


And again on the “General tab” you can change the setting


Creating a calculated field in Dynamics CRM2011

In this short post I’ll explain to you how you can create a calculated field in dynamics CRM2011. It’s actually just the same as in CRM4. The only thing now is that we have to use web resources. Web resources is new in CRM2011 and needs to be used whenever it comes down to using resources (like JavaScript) in dynamics CRM.

Ok lets start:

1) First create some fields. For this demo I’ll use: val1, val2 and result


2) The calculation will be a simple multiplication. I’ll multiply val1 and val2 and output the result in the result field.

3) Now we need to create the JavaScript that will do the actual calculation of the fields.

   1: function calculate()

   2: {

   3:     var val1 = Xrm.Page.entity.attributes.get['new_val1'].getValue();

   4:     var val2 = Xrm.Page.entity.attributes.get['new_val2'].getValue();


   6:     if(val1==null)return;

   7:     if(val2==null)return;


   9:     var result = val1 * val2;

  10:     Xrm.Page.entity.attributes.get['new_result'].setValue(result);

  11: }

Mind the new Xrm page model functions that I’m using. More information can be found on MSDN.

A little more information on the JScript. First I grab the data from both fields, check if they are not null and then do the actual calculation. Finally I set the result for the “calculated field”.

4) Now we need to add the JavaScript as a Web Resource. Go to the Web Resource section (Settings – customizations – Customize the System – Web Resources).

5) Add a new Web Resource. Here you can give a name, description etc. For the “type”, select Script (JScript). Finally click on the button “Text Editor” and add the code we’ve created above.


6) Once the Web Resource is created and published we can use it in our Account form where the custom fields are located.

7) Customize the form and select “Form Properties”. We first need to make the Web Resource available in this specific form.

8 ) Under the Events tab, add the Web Resource that we just created.


9) All that’s left to do is to configure the onChange events for the two fields and we’re done. Doubleclick on the field val1 and val2, go to the Events tab and configure the onChange event. The final result for each field should look like this:


10) Publish the form and you’re ready for testing.

xRM Cloud Acceleration Lab videos

I was watching these video’s, testimonials, from different companies that attended the xRM Cloud Acceleration Lab and I thought it would be interesting to share. I’m also a big fan of Dynamics CRM 2011 and when you see these people talking about how they will utilize the newest features of CRM 2011 in their products..It’s just nice to see. I was really inspired by this product called DefenseeReady from Permuda Technologies. A product used by DoD departments. Yet again, you see that Microsoft Dynamics CRM 2011 can be configured, customized for just about anything.

The videos and more information can be found on the following link:

Blog Post: Dynamics CRM 2011: xRM Cloud Acceleration Lab Videos

What do the CRM MVPs have to say about CRM2011?

Get Microsoft Silverlight

Corrupt winload.exe while installing Windows Server 2008 R2 64 Bit

Today I planned to setup Dynamics CRM 2011 RC in a new virtual test environment. My host system is Windows 7 64 Bit so I thought that installing a 64 Bit guest OS wouldn’t be that big of a deal. Seems I was wrong… I first tried Virtual PC, here I first saw the winload.exe problem. I read on some forums that Virtual PC doesn’t support 64 Bit OS’s. Then I read on a blog that VirtualBox is a good package to create 64 Bit images. When everything was set up and I wanted to load the iso, the installer immediately showed me that error again saying that winload.exe was corrupt.

I realised that there had to be something wrong with my system because I was sure that my ISO was OK.

Then I saw the following error in VirtualBox.


Actually I saw it already when I first loaded up the virtual machine, but I kinda ignored it. To solve the issue I went into the BIOS of my DELL Vostro laptop and enabled the Virtualization Mode. That solved the issue! Now I’m installing my Windows Server 2008 R2 64Bit.

How to migrate files from MS SQL Server to Dynamics CRM Notes via Scribe

To be honest, I’m quite new to Scribe Software. I just recently started working with the product because I need to do a heavy migration for a project at work. The standard Microsoft Data Migration Manager was not an option so I started looking for other 3rd party products. That’s where Scribe came in the picture. I’m quite enthusiastic about the product. If you need convincing, send me an email or post a comment.

This blog post will discuss how to migrate binary files from a Microsoft SQL Server to Microsoft Dynamics CRM. The attachments, files, will be placed in the notes section of an entity.

First off, let’s look at the SQL Server.

This is what my database structure looks like:

CREATE TABLE [dbo].[Files](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [FileName] [varchar](50) NOT NULL,
    [FileData] [varbinary](max) NOT NULL

The actual file is, like you would guess, in the varbinary datatype.

In Scribe we want to connect to this table, this will be our source. Our target will be the Microsoft Dynamics system.


On the left you will see that I’m connected to the SQL Server. This is done via an ODBC connection that I have set up. On the right, I’m connected to the Annotation entity of the Microsoft Dynamics CRM system. Notes in CRM are stored in a separate entity and the relation is created by setting the object id to the GUID of the object where your notes need to be shown.

I will not dive into the details on how to setup a source or target. That’s not the purpose of this post.

On the bottom, in the data links section, you’ll see that I did a reference lookup in the internal Scribe database to locate a GUID of an organization migration which I had done previously. For this demo I want to attach the files from the database to the Notes section of my Account entity.

The actual file data needs to be stored in the vfAttachment attribute. The blob data will be stored here. The filename can be set optionally.

Another thing that you definitely should not forget to set is the objecttypecode attribute. If you forget this Scribe will complain with the following error message: CreateEntity failed: The parent’s object type is invalid.

Make sure to set it to one, using the formula button.

Once you are done, you will see the following when you want to test your DTS. The GUID is retrieved and the BLOB data will nicely be stored.


Run the job and your file will be attached to the Notes section of your entity:


Dynamics CRM2011 Release Candidate released

Seems that the release candidate bits have been released to Microsoft Download. Looks like they already have been published a couple days ago too. Anyway, I just saw the news via Twitter. As you know this is not yet the final version. RTM will come soon though, I think it’ll be around the end of January.

Here are the download links:

Microsoft Dynamics CRM 2011 Server Release Candidate

Microsoft Dynamics CRM 2011 for Microsoft Office Outlook

Microsoft Dynamics CRM 2011 Language Pack

Microsoft Dynamics CRM 2011 E-mail Router

Microsoft Dynamics CRM 2011 Report Authoring Extension

Microsoft Dynamics CRM 2011 List Component for Microsoft SharePoint Server 2010


To help you with the installation, some handy installation guides:

Microsoft Dynamics CRM 2011 for Outlook Installing Guide (Online)

Microsoft Dynamics CRM 2011 E-mail Router Installing Guide (Online)

« Vorige paginaVolgende pagina »