Archive for January, 2014

CRM Data Detective

January 27, 2014

CRM Data Detective allows you to see what CRM fields your users are actually using.


I’ve setup this project to be a managed solution so you can easily drop the latest version into your environment.  I’ve also provided the full source so you can enhance this project any way you see fit.

The purpose of the CRM Data Detective is to provide some extra visibility into CRM.  You can easily see which fields are not getting the user adoption you’re looking for.  You might find a lowly populated field and realize it’s buried deep on the form and so you simply need to give it more attention.  You may see a field is rarely populated and determine it should be removed.  Either way, the CRM Data Detective gives you a great first step into enhancing user adoption.

To use, append


to the end of your server URL.




SharePoint 2010 and BCS – Unable to display this Web Part

January 24, 2014

Using SharePoint Designer 2010 to create a external content type and external list is a good choice and spent a lot of time. But when you open the external list in your browser you can get the following error.

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

The reason is very easy. If your source return more than 2000 elements this error occurred. So here are the solutions.

  1. Filter your data by using stored procedure, view etc. and make sure that you didn’t get more than 2000 elements.
  2. Change the Throttling settings

The default value of the throttling is 2000 elements. So you can edit this throttling by run the SharePoint 2010 Management Shell as Administrator.

The console will be open and you have to enter the following command:


You get a list of all Proxy Services. The Service “Business Data Connectivity Service” is important for us. The rest is in this case Trash ;-)  .

Copy the GUID of the Business Data Connectivity Service and run the following comand, for showing the current throttling settings:

Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottlyType Items -ServiceApplicationProxy <GUID>

For editing the current settings you have to save them into a global variable.

$db = Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy <GUID>

Set-SPBusinessDataCatalogThrottleConfig -Identity $db -maximum 10000 -default 8000

Now the Throttling is set to a maximum of 10000 elements and a default value of 8000 elements. If you have a source with more then 1000 elements, then you have to set a higher value.


Microsoft Dynamics CRM 2011 Instance adapter updated

January 13, 2014

If you have been seeing the Just in Time debugger launch when attempting to run maps other than the Picklist to Picklist map, you’ll want to get the latest update for the instance adapter.  The update is now currently live on the download site.

For more information on the Microsoft Dynamics CRM 2011 Instance adapter, please see this blog entry:

Connector for Microsoft Dynamics V3 CU 1 released

January 9, 2014

Performance improvements and key suggestions on Connector V3 deployments are the primary new features in Connector for Microsoft Dynamics V3 CU1 (, which was posted today for download.

Additional new features with this release include:

  • Overall performance improvement in the Connector V3 service
  • Overall performance improvement in Connector’s log
  • Performance improvement  in the Microsoft Dynamics CRM 2011 adapter
  • When you reset the Retry feature, it will now run immediately

To download this release for your Microsoft Dynamics ERP system, go to CustomerSource:

  • Connector for Microsoft Dynamics AX
    • If you have applied Microsoft Dynamics AX 2012 R2 CU 6 or later, an XPO is no longer needed.  You can run the ConnectorHelper class that is included in this update to accomplish the required setup tasks in Microsoft Dynamics AX.
  • Connector for Microsoft Dynamics GP
    • All previously supported versions of Microsoft Dynamics GP 2010 and GP 2013 are supported as either new or existing integrations
  • Connector for Microsoft Dynamics NAV
    • Microsoft Dynamics NAV 2013 R2 is supported with this release, however this release is not required for an integration to Microsoft Dynamics NAV.  Any release after Connector V2 RU1 ( will support Microsoft Dynamics NAV 2013  R2.
  • Connector for Microsoft Dynamics SL

Would you like to know more?  Check out the User Guide for your ERP system and begin your installation preparation. I know, I know; reading documentation can be arduous. But you know what they say: an ounce of prevention is worth a pound of cure. So read the provided documentation to avoid the common mistakes and save yourself the support call.  The user guides for all of the ERPs have been updated for this release and all include a V3 upgrade sections that you should be familiar with before upgrading your existing integrations.  All of the known issues documents have been updated as well so please have a look at those too, they can all be found on the Connector for Microsoft Dynamics download pages.

Note: This release includes an update to the MSDI database that will mean any custom objects you have added to the database will be dropped, however this update will greatly improve the performance of the overall Connector system.

pfSense project free open source firewall and router

January 4, 2014

pfSense is a free, open source customized distribution of FreeBSD tailored for use as a firewall and router. In addition to being a powerful, flexible firewalling and routing platform, it includes a long list of related features and a package system allowing further expandability without adding bloat and potential security vulnerabilities to the base distribution. pfSense is a popular project with more than 1 million downloads since its inception, and proven in countless installations ranging from small home networks protecting a single computer to large corporations, universities and other organizations protecting thousands of network devices.

This project started in 2004 as a fork of the m0n0wall project, but focused towards full PC installations rather than the embedded hardware focus of m0n0wall. We also offer an embedded image for Compact Flash based installations now. The two projects have since diverged significantly.

We’ve grown to become one of the most widely used network firewalls in the world, with in excess of 167,000 known live installs  as of April 2013.

New to the project?

For those new to the project, we recommend reading the Common Deployments and Features page, and checking out the Screenshot Gallery.


MS Dynamics CRM Solution Deployer

January 2, 2014

Dynamics CRM 2011 Solutions are packages of customizations that allow you to build and maintain Dynamics CRM/XRM applications. In order to deploy the solutions, the CRM users need to manually move them for export and import from one organization to another or from one server to another.
The Solution Deployer is a very user friendly and easy to use application that allows the users to install a CRM solution automatically for them. The Utility pick the solution from one organization/server and install it on another one.
Solution Deployer
Some salient features of Solution Deployer:

  • Compactable with Dynamics CRM online, On-premise and IFD
  • Utility pick the solution from one organization/server and install it on another one

The Solution Deployer is FREE.
The Solution Deployer is a very user friendly and easy to use application that allows the users to install a CRM solution automatically for them. The Utility pick the solution from one organization/server and install it on another one.
Obviously, The Solution Deployer is compatible with MS Dynamics CRM 2011.
Please click here to download Solution Deployer
Please click here to download User Guide document