Connections don’t merge, so be careful with duplicate records

4 comments

Posted on 12th November 2011 by Jukka Niiranen in Annoyances |Features

, , ,

Update 22.3.2012: this has now been fixed in Update Rollup 7 for Microsoft Dynamics CRM 2011 (KB 2600643). Go and get the file here, unless you’re using CRM Online.

Connections are a nice new feature in Dynamics CRM 2011 that allow you to create ad-hoc relationships between two records of almost any entity type. Additionally, you can specify roles for both the Connected To and Connected From parties, to describe the connection in more detail, as well as provide start and end dates for the connection. These are very handy for recording non-hierarchical relationships between contacts and accounts that tend to exist in the real world. As an example, a person working as the CEO of Company A might be a member of the board in Company B, which means they should be visible under both accounts. Company A would then be the parent account of the contact, whereas there would be a connection between the contact and Company B.

Another common real life phenomena is that duplicate records find their way into the CRM database. This can be due to data imports from external databases, web forms feeding in new contacts, or simply two users being unaware of each other’s records and entering data with slightly different spelling or email address variations. Luckily Dynamics CRM has a built-in functionality that allows you to merge duplicates from the database. This process will move all the child records from the subordinate record to the master record, thus ensuring that everything remains linked to the active record and not the deactivated duplicate.

Except that for connections this doesn’t happen! Once the merge is done, all the connections will still be referencing the inactive record, not the master record. In the aforementioned example, you would have effectively lost the information about the contact’s relationship with Company B. Even though you could still see it by opening up Company B’s record and seeing the connection there, how would you ever have known where to look?

There is an existing feedback item 683301 on Microsoft Connect regarding this functionality:

Here’s a quote of the comment I’ve posted on the item:

I think this is a serious flaw that undermines the perceived reliability of the Merge Duplicates feature in the eyes of the end users. The merge screen indicates that all child records related to the subordinate record to be deactivated would be transferred to the master record, but it doesn’t warn that connections would need to be manually checked.

The merge process works just fine for custom entities, activities and pretty much everything except connections. Why would the user ever want to leave behind some non-duplicate information to the deactivated record? By merging two accounts or contacts the user is effectively declaring that these represent the same object in the real world. If something in the database has a relationship with either of these records, it should be carried over to the active record, as the inactive record no longer serves any other purpose than indicating the prior existence of a duplicate entry and the possible differences in attribute values compared to the current active record.

If you think connections should be transferred over to the master record when merging duplicates, be sure to log in to Microsoft Connect with your Windows Live ID and cast your vote on this item. In the meantime, if you’re planning to use the connections entity for recording any data related to accounts, contacts, or leads, my suggested options are:

  • Don’t do it. Create a new custom entity for recording this data, as they will merge over to the master record just fine.
  • Develop you own plugin for capturing any merge events and updating the related connection records accordingly.
While we’re on the topic, I also tested what happens to the old Relationship records that were used for connecting account, contact and opportunity records in versions prior to CRM 2011 (and are still visible in an upgraded organization). The result? When merging two contacts, any relationships referencing the subordinate record are deleted! Yeah, crazy, I know. If you’ve got any insight on what is the reason behind this perplexing system behavior for either connections or relationships when dealing with duplicate records merging, please leave a comment in the box below.

Office 365 launches without Dynamics CRM integration for document management

9 comments

Posted on 28th June 2011 by Jukka Niiranen in Annoyances |News and events

, , , , , ,

Today was finally the big day when Microsoft’s cloud productivity platform BPOS was replaced with Office 365, which is now available for subscription. Having played with the beta version for a while now, I’m overall quite impressed with how close the SharePoint Online environment now is to its on-premises counterpart. While the limitations are still somewhat more visible than when comparing CRM Online vs. CRM 2011 on-premises versions, I think it’s already close enough to enable a significant part of traditional business requirements for SharePoint to be fulfilled with the cloud platform.

Microsoft confirmed already last fall that also Dynamics CRM Online will eventually be migrated onto the same Online Services Delivery Platform as Office 365. In addition to being a natural fit with SharePoint and Exchange, CRM Online should also gain benefits into both its subscription management as well as authentication options as a result of  this migration. However, there’s no official timeline or feature set communicated yet, so we’ll have to keep waiting possibly until Q4/2011, when the next update for Dynamics CRM has been scheduled to become available, as announced in the latest Statement of Direction document.

Ever since Dynamics CRM 2011 was launched with built-in SharePoint document library integration, there’s been a bit of anxiety on when this functionality could be leveraged with the cloud versions of CRM and SharePoint. Since BPOS was built on SharePoint 2007, it wasn’t possible to utilize the Microsoft Dynamics CRM 2011 List Component for Microsoft SharePoint Server 2010 in the Online environment. This meant that setting up a document management enabled trial environment with CRM Online required an on-premises SharePoint server, which wasn’t too convenient. Nor was it for any customer looking to go “all in” with their MS applications. Oh well, but now that Office 365 is available, that’s all a thing of the past, isn’t it?

Wrong! Despite of the better together marketing message surrounding Office 365 and CRM Online, there’s actually still no way to integrate the SharePoint document libraries with the CRM List Component. Sure, you can upload the solution file into a SharePoint Online site and publish it. What you cannot do in the Online version is to take care of the second part of the installation steps, which involves the AllowHtcExtn.ps1 PowerShell script,used for enabling .htc file extensions to be served from SharePoint.

Why is this important? Because without the .htc support, you can’t actually do anything with the document library. The folder creation can be configured and it flows through as it should when accessing the Documents menu for a new record, such as an account. However, after that you are presented with the following prompt:

“The action buttons are disabled because the SharePoint server that you are using does not allow HTC component files. To enable the buttons, contact your system administrator.” What this means is that the document library will be rendered nicely inside the CRM entity form, but you can’t upload any documents to it. Clicking on the buttons does nothing, as they’re all disabled.

How about on the SharePoint side of things then? We can see that the entity specific document libraries are created and also the corresponding folders for each record where the document location has been defined. We can also of course use the native SharePoint UI to upload documents into the library.

Then when you access the corresponding record through CRM, you can see that the document does appear in the library. But with all the controls disabled, you again cannot do anything with it, like open the document, for example. How nice…

How did we end up in this situation where the latest and greatest cloud offerings from Microsoft are not working together like they obviously were inteded to? That’s a very good question. The problem with Office 365 SharePoint Online limitations and their implications to Dynamics CRM document management functionality has been a known issue throughout the whole beta phase of Office 365. There are several threads on the Office 365 community forums regarding this. Yet the response from Microsoft has been that this cannot be resolved by GA (general availability) of Office 365 (as in “today”), but rather we’ll have to wait for the first service update, probably. Come on! How can 6 months not be enough to allow one .htc file to perform its work and provide the document integration between CRM and SharePoint? I find it extremely strange that the product management behind Office 365 has allowed such a flaw to be included in the initial release version.

Of course eventually this issue will be solved and we’ll be able to experience the full document management process flow with Microsoft’s cloud applications.

Upgrade gotchas: Outlook client for Dynamics CRM 2011

10 comments

Posted on 12th March 2011 by Jukka Niiranen in Annoyances |Tips

, , , , , , , ,

Last weekend I finally did my first installation of the RTM versio of CRM 2011 Outlook client onto a machine with Outlook 2010. I had previously only worked with the Outlook 2007 client version, which is lacking a few nice features in the UI, as described in my earlier post.

I came across a few issues that might cause problems in the installation process, so I decided to link the relevant KB articles and other related content into this blog post to help you save some time when upgrading to the latest version of Microsoft Dynamics CRM on your client machine. I’m using CRM Online here, so some things may differ from the on-premises client version, which no longer has a separate client version, but of course the authentication methods do differ.

Before you begin: go with 32-bit

Yeah, I’m sure most of the new business laptops nowadays come with a 64-bit (a.k.a. x64) version of Windows 7. Nevertheless, you should treat 64-bit applications with caution. Why? Well, it’s a bit like with IPv4 vs. IPv6. Everyone knows the old world as we know it is coming to an end, but there simply isn’t a concrete enough reason for developers or companies to go “all in” with the 64-bit apps.

With Microsoft Dynamics CRM 4.0 the situation was quite nasty, as there was not and there will not be support for the 64-bit versio of Microsoft Office. You simply had to tell the users to “downgrade” their Office, which is not the most optimal starting point for getting someone to adopt a new application such as Dynamics CRM. Now with the arrival of Dynamics CRM 2011 we do in fact have an x64 client for Outlook, so everything should be in order, right? In theory, it is, but if you’re planning to install any fancy RIA apps from the Dynamics Marketplace into your CRM 2011, you should read this blog post from Customer Effective. That’s right, Microsoft hasn’t releases a 64-bit version of the Silverlight add-on for Internet Explorer, which leads us into the following situation:

KB2500373: Microsoft Silverlight web resources cannot be viewed in the 64-bit version of the Microsoft Dynamics CRM Client for Microsoft Office Outlook

It’s a fact of life: the world is not 64-bit just yet. With the Office applications there’s not likely to be a significant performance boost from using the x64 version, so take the easy way out and just install the 32-bit Office 2010. Let’s revisit the topic when we all have Windows 8 and Office 2013, shall we?

Favorite folders no more

KB2494600: There is no option to add Microsoft Dynamics CRM entities to favorites in Microsoft Office Outlook 2010

The Solutions Module is a new feature that has become available in Outlook 2010, as described here in the MSDN library article. It allows developers to integrate their applications directly into the Outlook navigation pane, which is what Dynamics CRM 2011 Outlook client is doing to achieve the seamless integration into the native Outlook navigation items.

What’s the downside? Unfortunately the add-on solution folders cannot be added to the Outlook favorite folders group. Bummer. This was one of the first things I always instructed people to do when training them on how to use Dynamics CRM. There’s no better way to drive CRM adoption that getting the list of the company’s accounts and contacts to be available right below the Outlook inbox folder, where most people start their day at the (MS) office. Even though the CRM folders are now more visual and available under the CRM navigation pane tab, there’s still likely to be tens of entities visible for most CRM users, out of which they typically access just 3-4 most popular ones. I, for one, hate navigating through hierarchical folders that require you to expand them to see the what’s hidden on the next level, so always visible one-click navigation is how I prefer to arrange my working environment, be it SharePoint workspaces or CRM menus in Outlook.

Following the instructions in the KB article, you can achieve the old favorite folders functionality also in Outlook 2010, but this will require you to disable the Solutions Module. Which, if I’ve understood correctly, will again turn the flashy CRM folder icons into the generic folders that we see in Outlook 2007 or Outlook 2003. Guess we’ll just have to figure out which is a bigger loss for the end user experience and make a choice, until there is a feature enhancement available for the Outlook 2010 Solutions Module (I hope there’s no technical limitation on why this couldn’t be implemented in a future service pack).

Clashes with Windows Live Essentials

KB2498892: Unable to Configure the Microsoft Dynamics CRM Client for Outlook against Dynamics CRM Online

Seems like the Windows Live ID authentication in CRM Online has some issues with the “consumer products” for Windows Live. This might not be a big issue in big corporate environments with locked-down client machine configurations that don’t allow using consumer targeted services such as Hotmail or Skydrive. However, as Dynamics CRM Online is clearly making the former enterprise level applications like Customer Relationship Management suites available to even the smallest organizations with its low monthly cost per user and ease of deployment, there’s likely to be more and more users who’ll be transitioning from Microsoft’s consumer product lines to the new cloud-based business product lines, such as CRM Online and Office 365.

Basically you’ll need to run a repari install on the Windows Live ID Sign-in assistant or Windows Live Essentials 2011 to make it compatible with the Outlook client for CRM Online, which is also using Windows Live ID to connect you to the CRM server. That should do the trick.

But wait, isn’t Dynamics CRM Online a business product? Why is it using the WLID authentication method meant for the consumer products? For comparison, here’s an aswer from Allen_MSFT on the Office 365 FAQ to a question regarding weather using Office 365 will require WLID.

“Re Windows Live ID, you don’t need a Windows Live ID to use Office 365 or to use your Windows Phone 7 with Office 365.  Windows Live services are for consumers, so they are not linked within the Office 365 portal.”

Indeed. I’m waiting for the day when also Dynamics CRM Online will be migrated over to the new Microsoft Online Services Delivery Platform, which will hopefully give us better tools for managing CRM user accounts and authentication.

Missing Outlook ribbon after CRM client installation

KB2494581: The Outlook and CRM ribbons disappear from Microsoft Outlook when you use the Microsoft Dynamics CRM Client for Microsoft Office Outlook

I had this one happen to myself, since I had been using a previous beta version of the CRM 2011 client on my machine. I had uninstalled both Office and CRM, but there still remained a few lines in the registry that needed to be removed to get the Outlook ribbon to reappear.

I have to tell you, Outlook 2010 really looks naked when the ribbon is gone (not just hidden). I’m not sure if there even was a way to do any basic Outlook operations like sending emails with the ribbon completely blank, so I started googling around immediately and came up with the instrcutions that pointed to the following steps required to restore the ribbon:

  • Run Regedit.exe
  • Locate the HKEY_CLASSES_ROOT\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52} key
  • Delete the 2.4 key that’s found under it. It’s not needed anymore, there should only be 2.5
Update Nov 9th 2011: Since this appears to be quite a popular post on my blog, I decided to append this information here. Today I was creating a new Windows user profile on a PC that already had the CRM 2011 Outlook client installed on a different user profile. When launching Outlook for the first time as this user, the ribbon was missing from the CRM menus (not the whole Outlook as in the aforementioned case), even though everything was working fine for the previously configured user account. In this particular occasion the client was linked to a CRM Online organization which had received the R7 update (a.k.a. Q4 2011 Service Update), but the Outlook client was still on Update Rollup 3 level. After I deployed Update Rollup 5 on the machine and rebooted, the ribbon was restored for this new user profile. So, be sure to check that the client and server hotfix levels match if you encounter a ribbon display problem.

Reading pane always shows the contact layout

Dynamics CRM Deployment Forum: CRM 2011 reading pane error in Outlook 2010

Unfortunately this one doesn’t have a knowledge base article or a fix yet. I encountered this issue briefly when installing the Beta version of CRM 2011 Outlook client. Back then, all it needed was a reboot and the reading panes and icons were restored. With the RTM version of CRM 2011 client, the issue is more persistent. Each and every CRM entity appears as if it was a contact, presented in a business card layout that only contains the entity primary field (name) and not any other data. Click the image below to see an example of the account record shown as a business card with the contact icon.

Update Nov 10th 2011: Thanks to Wimco’s post on Dynamics CRM Forums, I was finally able to fix the reading pane layout problem on my PC. I simply uninstalled the Office 2007 Primary Interop Assemblies, after which I also applied the latest Update Rollup package and voilá: the reading pane now shows the fields specific to each entity.

Further update, March 23th 2012: The EMEA Dynamics CRM Support has published an article, where they suggest another fix for the Outlook client preview pane problem. Apparently an existing DisableFormRegions registry key can cause the contact form to be shown instead of the correct entity form.

Update Rollup 27 has been… Seriously, guys!

3 comments

Posted on 24th September 2010 by Jukka Niiranen in Annoyances |News and events

, ,

Got a Dynamics CRM blog? Like to tweet about all things Microsoft Dynamics? You’re in luck, because Microsoft is providing you a steady supply of topics in the form of CRM Update Rollups (or UR’s if you prefer acronyms). Right now Microsoft Dynamics CRM 4.0 is on level 13 and will certainly continue to receive plenty more until the end of its support lifecycle. In January 2009 Microsoft stated that they aim to release a new update rollup every 8 weeks. If you multiply 13 x 8, that gives you 104 (two years), which means the actual release schedule is even tighter.

When a UR comes out, you’ll be certainly well informed about it through the Dynamics CRM community, as this tends to generate a massive number of blog posts, tweets and retweets in celebration of the event. Having new hotfixes is of course important for anyone working with CRM, but has the whole UR phenomena gotten a little bit out of hand by now? The recent tweet by Jerry Weinstock from CRM Innovation highlights the issue perfectly:

Let’s make one thing clear: there is no newsworthy content in just posting that “Update Rollup X has been released”. Nada. It’s like stating that a new copy of Wired is now available at the news stands.

I’ve seen a countless number of practically abandoned Dynamics CRM blogs where the author no longer has the time or energy to produce original content. Yet they see it as their duty to keep posting UR notifications one after another. Wow, writing a blog has never been so easy! Ok, so you guys may have way more posts than I do, but do you really think you’re contributing to the CRM community in a meaningful way?

I’m not saying that UR’s cannot be meaningful topics for a post, but you absolutely must provide some editorial content of your own, in addition to the KB article cut&paste. Tell about your experiences with the update, what was the reason why a particular hotfix was significant for you, what possible problems the UR installation may cause etc. Say something that not every one of us CRM geeks out there wouldn’t already know through their RSS feeds and Twitter lists.

The amount of great information you can acquire just by following a Twitter hashtag like #MSDYNCRM is truly incredible and I don’t want to play down the value of an active Dynamics CRM community in any way. Quite the contrary, that’s the one thing we should all celebrate. All I’m asking is that the next time you see the news about a new UR, think for a moment how likely it is that all your followers and readers have already received the news through their own channels. And if you RT, at least put a funny twist on it!

As for the UR release process in general, I propose that Microsoft registers the @UpdateRollup account on Twitter and we can all just start following it. Or better yet, replace the old Announcements section inside Dynamics CRM with a dashboard of all the official MS Dynamics CRM tweets in one convenient place. Of course in CRM 2011 we’ll already be able to configure those dashboards ourselves.

« Older Entries
Newer Entries »

Switch to our mobile site