Did you just disable duplicate detection in CRM by accident?

0 comments

Posted on 3rd April 2012 by Jukka Niiranen in Annoyances |Tips

, , , , ,

Duplicate detection rules in Dynamics CRM are an example of a configuration item that may often be active only in production environments. Since you don’t actively enter data into development or test environments, why bother thinking too much about them? Well, the one place where you need to be thinking about them is when you are importing new solutions and publishing changes to customizations.

Life would be easy if you could just set up and publish your duplicate detection rules once during the initial configuration of your Dynamics CRM production environment, thus stopping the unintentional entry of duplicate records into the customer database. However, you may run into a situation where a rule that you’ve once published has later on returned to an unpublished state. “What? Who touched my duplicate detection settings?”

The likely answer to the question is “You did, but unintentionally”. You see, the duplicate detection rules are sensitive to changes in your entity customizations. As noted in the Madrona Solutions Group blog article, whenever any entity metadata is changed, all duplicate detection rules associated with that entity are unpublished.

If you look at this from the system’s perspective, the process does make sense. After all, you might have set up a duplicate detection rule that is comparing records based on a criteria that that references fields you’ve changed or removed as a part of your CRM customization actions. Still, the fact that a publish event on a CRM 2011 solution triggers an unpublish event somewhere else is not very intuitive and most system administrators are likely to be unaware of the impact. As a result, there are certainly several production CRM environments out there where the once carefully planned duplicate detection rules have been deactivated because of this dependency between solutions and duplicate detection. In fact, you might want to check your own Dynamics CRM environment right now and check if you see duplicate detection rules with the status reason “unpublished” which should in fact be published.

What this means in practice is that anyone who’s deploying solution updates to an environment that is using duplicate detection rules needs to instructed to always re-enable the rules after they’ve updated customizations that reference an entity which is being monitored for duplicates. In my opinion, it would be very practical to have the system notify you about this task, for example by asking “would you like to re-publish the affected duplicate detection rules?” when publishing a solution. If you would like to see this functionality changed in a future version of Dynamics CRM, please sign in to Microsoft Connect with your Windows Live ID and vote for the item “Automatically re-publish duplicate detection rules after deploying a solution”. Thanks for your contribution.

Convergence 2012 in a (virtual) nutshell

3 comments

Posted on 24th March 2012 by Jukka Niiranen in News and events

, , , , , , ,

Full disclosure: I didn’t actually physically attend Microsoft Convergence 2012 in Houston, Texas. However, that doesn’t mean you have to feel left in the dark, thanks to the immersive experience that is the social web of our times. With live webcasts, near-live blogging and some 6000 tweets on the #CONV12 hashtag, keeping up with the online buzz has never been easier. Here’s my summary of what the event looked like through the eyes of a virtual attendee and some thoughts on where Microsoft and its Dynamics product line appear to be heading based on the announcements at Convergence.

Microsoft Convergence 2012 keynote summary on StorifyKeynote

The opening keynote is where the stage is set for the rest of the event, so watching the live broadcast on Monday was definitely on my agenda. Sure, it’s all about building up hype for your products by telling how great you’ve done so far, how excited you are about your future roadmap and showing off with future concept demos that have little to do with the current reality. So what! You need a little show business alongside your business applications conference.

Having the luxury of my PC keyboard & mouse at my disposal during the event allowed me to experiment with Storify, a social media storytelling tool. I captured the best tweets, photos and screenshots during the keynote and compiled them into my Convergence 2012 story. If you’re anything like me, the mental barrier for sitting down and watching a recorded conference event for 1.5 hours is quite high, so why not glance through the highlights of the show on the Storify summary? After that, you can decide if you want to read the full transcript or watch the recording on the Virtual Convergence site.

Some notes picked up from the opening keynote included:

  • The Dynamics CRM momentum now stands at 2,250,000 users in 33,000 customer organizations.
  • “There are no happy Siebel customers in the world, there just aren’t.” - COO Kevin Turner on Microsofts internal journey from Siebel to Dynamics CRM.
  • Nearly half of the deals won by Microsoft over Salesforce.com have been due to the on-premises option and the hybrid model.

Metro

It’s Windows reimagined time all across Redmond now as we’re nearing the launch of Windows 8 later this year. This means everything that can be shown as a Metro style app running on a tablet, will be shown precisely that way. The fictional Contoso Electronics scenario of the big keynote demo used a highly customized UI built for the retail store experience only. A much more interesting demo was the project management Metro app that looked so realistic you could imagine it becoming an actual UI to some future Microsoft product to be rolled out at Windows 8 launch.

We didn’t get any official screenshots of a Dynamics CRM Metro app yet, but luckily Garth Knutson was able to snap & tweet this picture of a UI concept presented in one of the sessions. Just imagine if assigning users onto a Dynamics CRM opportunity record would look like this, how much higher would the user adoption of a CRM system be among sales people? Ah, CRM reimagined…

Microsoft Dynamics CRM and Metro UI

But the road to metro is paved with Apples. The actual tablet product Microsoft had to show at Convergence was the Dynamics CRM Mobile client for iPad, which meant that Apple devices were well presented in many of the Convergence sessions. Funnily enough, during the conference an internal email leak revealed that Microsoft was banning the use of company budget to buy any Apple products for its Sales, Marketing, Services, IT, & Operations Group. Oh well, guess we won’t be seeing many iPads on stage anymore in the following events. For those of you who haven’t seen the current client yet (developed by CWR Mobility), see my previous post on Microsoft Dynamics CRM Mobile iPad screenshots.

Microsoft Dynamics Metro app running on a Windows 8 tabletAn important aspect to note is that the move towards Metro apps and tablet devices does also have an impact on traditional desktop usage of Dynamics CRM. Back in November I speculated that the legacy of Outlook could not be carried over to the world of Windows 8 tablets in its existing form. Since then this assumption has only been enforced by the announcement of Windows on ARM (WOA) tablets with no classic Windows application support and no sign of Outlook in the list of Office apps promised for these “iPad killers”. What this means is that the functionality exclusive to Dynamics CRM Outlook client must be moved to the cloud. At Convergence, the following functionality was more or less revealed to be included in the R9 release later this year:

  • Direct synchronization of activities through Exchange (instead of Outlook)
  • Support for “track in CRM” functionality in Outlook Web Access (OWA client)

Woo-hoo! It’s been a long time coming, but to me this is a clear sign that Dynamics CRM is definitely on the right track in terms of becoming more compatible with the habits of today’s mobile workforce; how they manage their activities and messages on multiple clients, not just the single Outlook on their work laptop. Making the CRM features available through new channels, such as the Office 15 Agaves, is very important for making Dynamics CRM a relevant tool for knowledge sharing as the applications and devices surrounding it are evolving.

(more…)

Microsoft Dynamics CRM Mobile iPad screenshots

1 comment

Posted on 9th March 2012 by Jukka Niiranen in News and events

, , , , , ,

Microsoft has released a YouTube video where Ruben Krippner talks you through the upcoming features of the Q2 2012 Service Update, a.k.a. Dynamics CRM R8. Since we already know much of the new release details through the Release Preview Guide, the most interesting part of the video is the live footage of Microsoft Dynamics CRM Mobile running on an iPad. For those of you who want to get a quick glimpse of what the client looks like, I took the liberty of taking a few screenshots from the video.

Sitemap & Dashboards

Microsoft Dynamics CRM Mobile iPad dashboards

As we know, the “new” client is actually a rebranded version of the CWR Mobility client for Dynamics CRM. The UI looks almost identical, apart from a new set of Metro style entity icons. The sharp edges and “authentically digital” appearance look somewhat out of place in the otherwise iOS-style app, but let’s hope that there will be a full Metro app for Dynamics CRM available once the Windows 8 tablets hit the stores.

Dashboards appear to be close to the web UI as far as charts go. If you have other types of web resources on your dashboard (say, a Silverlight component), the results may be a bit less so. Also, I’m assuming entity grids will not be rendered on the iPad Dashboard, at least not in their original format.

Views

Microsoft Dynamics CRM Mobile iPad views

The iPad UI does support filtering data through views, just like you do on the web client. However, the views themselves will not be presented in the familiar grid style with columns, rather you’ll see a list of records with the primary field and some other data stacked on top of each other. Whether this is because of iOS limitations or an inherited design from the iPhone app, I’m not sure.

Forms

Microsoft Dynamics CRM Mobile iPad forms

The standard fields are presented on a form that has a single column. Picklist and date fields use native iOS controls, also field types like phone numbers or email addresses will open native apps for respective actions. Why an iPad app shows you the options to dial a phone call or send SMS, I don’t know, because at least my iPad won’t allow me to do those without jailbreaking the device, but maybe Ruben has a special version of the Apple tablet ;)

As you can see from the form, it’s not specifically optimized for landscape mode viewing on a tablet, but rather looks like a big iPhone app. Entity forms with many columns will therefore be presented as a long list the user has to scroll up & down.

Maps

Microsoft Dynamics CRM Mobile iPad Google Maps

As a funny little detail that Ruben mentions on the video how the account address opens up on Google Maps. Why not Bing Maps? Well, because the native map application on an iOS device comes from Google…

Off-topic: It’s great that the mobile clients for iOS, Android and Windows Phone now have the basic address mapping integration in place, now we just need to get it for the web and Outlook clients as well. While the integration itself is technically quite trivial, the requirement for purchasing a Bing Maps license for using the map data on a non-public application is currently a big barrier in the desktop world. But enough about that, let’s get back to the mobile client.

Related records

Microsoft Dynamics CRM Mobile iPad related records

Because the sitemap navigation pane is permanently visible on the left hand side of the screen, which on a normal web client entity form would show the related records, in the mobile client these are accessed through a button on the lower right corner of the screen. Subgrid type of functionality is not available on the tablet UI, which can make it a bit cumbersome to navigate through long hierarchies of records. As a result, using the iPad client for tasks such as order entry while on the road is not really optimal in the Microsoft Dynamics CRM Mobile client. These types of use cases will still be better met with a custom developed tablet application equipped with specific data entry screens, so toolkits like Resco will remain relevant even after this official Dynamics CRM iPad client gets released.

Configuration

Microsoft Dynamics CRM Mobile iPad configuration

The mobile client is not just an alternative UI for CRM, but there is a wealth of management options for user and client management, synchronization settings, usage reports etc. Since the way you use a mobile/tablet application is quite different from the normal desktop client usage scenario, it’s important that the information presented to the user can be optimized. Microsoft Dynamics CRM Mobile allows you to do this by defining different user groups and assigning them tailored mobile profiles containing only relevant entities in the sitemap. Also the contents of the mobile forms can be adjusted, so you don’t have to show all the tens of attributes that your entities contain.

Microsoft Dynamics CRM Mobile iPad mobile profile and entities

Conclusions

The CRM Anywhere theme is definitely a step in the right direction for Microsoft Dynamics CRM to become an application that truly “works the way you do”. Even though the cross-browser compatibility will enable users to open up the CRM web client on their iPad Safari browser, for any serious work on a tablet you’ll want to have a client that is optimized for:

  1. touch based user interface
  2. streamlined data presentation to support the “working in short bursts” mode of mobile device usage
  3. offline access for those moments when 3G or WiFi just doesn’t reach you

For the subscription price of $30 per user per month (or the perpetual license you can still acquire from CWR Mobility), you can install a fully capable Dynamics CRM mobile client on both your iPad and your iPhone, and still have one user license left for trying out the latest Android phone (whether the non-offline Windows Phone 7 client will consume a license, I don’t know yet).

You can read more of my thoughts on Microsoft Dynamics CRM Mobile on this article I wrote after the announcement at eXtreme CRM 2012 Berlin.

Using hashtags in Activity Feed posts to automate processes

2 comments

Posted on 23rd February 2012 by Jukka Niiranen in Tips

, , , , ,

Improving internal collaboration has been the driving idea behind Dynamics CRM Activity Feeds. Even though the efficient usage of stream-like notifications may not be immediately obvious to users who’ve come to think of CRM data as permanent records presented in views, they provide a great enhancement on top of the existing customer data that focuses on answering the “what’s going on right now?” question, rather than the “what/who/how much” types of  queries that CRM systems typically have focused on. Joel Lindstrom wrote a great article on the Customer Effective blog about how Activity Feeds are different from RSS feeds, which I recommend everyone to read.

Originally launched in the Q4 2011 Service Update (R7), the Activity Feeds solution is about to receive some enhancements in the upcoming R8 release that will allow users to better filter the content of their wall and also click “like” on posts. (Note: contrary to some comments, the “unlike” feature will most likely be simply the undo action of “like”, rather than a real “thumbs down” reaction.) Compared to other social business applications like Yammer, there still doesn’t seem to be built-in support for features such as groups or hashtags that we’ve come accustomed to use on many platforms. I’ve already written about a DIY approach for leveraging custom groups to follow posts on specific topics. Next, I thought I’d see how we could make use of the hashtag concept in Dynamics CRM.

What’s a #hashtag & what’s it good for?

Whether you’re an active Twitter user or not, it’s likely you’ve come across a person using the # sign in his or her online writing. What started out as a user driven policy of grouping tweets has later turned into a whole movement that’s gotten both users as well as commercial entities get very interested on following, measuring and encouraging the use of #hashtags on social media channels.

Twitter allows the users to click on hashtags turned into hyperlinks, thus enabling them to view all recent posts containing the same hashtag. Although Dynamics CRM is a flexible platform for LoB application development, tweaking the default Activity Feeds solution web resources to support this kind of filter functionality wouldn’t be exactly a walk in the park. However, we can certainly explore the concept and see what else the platform might have available for us that could make the Activity Feeds more intelligent. Hmm, how about workflows?

While the post box on a wall doesn’t currently allow us to include any other “magic characters” apart from the @ symbol used for performing mentions, the pound sign does have one clear advantage: it’s rarely used for other purposes than a hashtag (you might have the occasional shouts of “we are #1!” by excited sales reps appear on the wall after they close a deal, but that’s about it). This means we can quite safely use the # symbol as an identifier for our own little magic words.

Triggering processes from wall posts

Suppose you’re browsing through your personal wall on a Windows Phone 7.5 mobile while sipping on a Venti Latte at Starbucks, utilizing the free Microsoft Dynamics CRM Mobile app. You spot an item in your feed that you want to take note for further action once you’re back at your office desk. How are you going to do that?

While an email inbox is hardly a good way to manage a list of open tasks, Activity Feeds are even worse as action items, because they’re not even meant to be persistent records with read/unread status or flags/categories. The stream flows on as other CRM users perform actions such as winning opportunities and solving support incidents, which means that the item you spotted while enjoying your coffee may well be buried into the depths of history the next time you glance at your wall. Posts are merely notifications about something, not the object itself.

Instead of resorting to disconnected manual notes, what you could do is track the regarding record of the interesting wall post as a new task on your own list of CRM activities. All we need is the creation of a very simple workflow rule to achieve this. Create a new workflow process on the Post entity and mark it to be started whenever a new Post record is created.

What the hashtag concept will be used for is evaluating the content of a Post and seeing if the workflow process should be run or not. In our example, let’s use the hashtag #task to identify a Post which we would like to trigger the creation of a new task record. You might also want to check that the Post source is Manual Post instead of Auto Post (more about that later).

In your workflow rule definition, create a new task record and insert the contents of your post in the subject line. Set the regarding field to be the RegardingObjectId of the Post, owner as the person who created the Post, and a due date of 1 Day After Created On. Save your process, activate it and you’re all set.

Just type #task and let the system take care of the rest

In our example, we’ve spotted a Post regarding a new opportunity record. (Ok, so we’re doing this from the web client and not the mobile one, since believe it or not, screen capture on WP7 requires an unlocked device!) We want to mark an action item on the record for us, so we post a new item on the record wall, using the hashtag we defined: “#task Ask Chris for customer references”. Please note that simply commenting a Post will not trigger a workflow, since the PostComment entity is not available for workflows (bummer), so make sure to type a completely new Post on the item of interest.

After the Post is submitted to CRM database, the workflow is triggered and a new task will have been created on you My Activities view in a matter of seconds. Should you ignore your CRM list once you return to the office (shame on you!), the due date reminder we set on the task will cause your Outlook (and probably also your mobile phone) to alert you about the action item you created for yourself.

Drive any process with #hashtags

As you might know, the free mobile client does not allow you to create or update any CRM records, you can only read them on your mobile phone (unless you want to open the somewhat less pretty Mobile Express client). The only exception is Activity Feed Posts, which you can type on your Windows Mobile device and get the data updated into CRM in real time. Together with the creative use of hashtags and workflow processes, we can actually trigger also some other data entry and updates while on the road, as you saw from the #task example.

While you can’t create a workflow that would update the parent object of the Post, you can create new child items for it. In the example below, we’re creating a new case by using the #case hashtag.

The steps of the workflow process configuration are as follows:

  • Check if the Post contains the text #case
  • Create a new case record, set the title to post text, set customer as the RegardingObjectId(Post)
  • Create a queue item for the new case and move it to the Support queue for CSR’s to start working on
  • Wait for the case status to change from active to something else
  • Create a new post on the customer wall, containing a summary of the information recorded on the case after its creation
  • To finish the process with confidence on both sides, also send a direct email to the person who initiated the case creation with his/her wall post
All this process data neatly managed inside Dynamics CRM, just because you typed “#case Send an evaluation license of Product X to customer” on a record wall, with a mobile phone on your one hand and the latte on the other. You might as well have used a similar process to open a new opportunity and start your sales process automation tasks, with a predefined product specific hashtag like #opp_prodX_3m, if you really wanted to impress your colleagues that haven’t yet figured out why Activity Feeds and Auto Posts are a true productivity boost rather than just another new inbox to process.

A final word of warning: since you probably don’t want a workflow generated Post to trigger any new workflows accidentally, it’s a good idea to always set the right Post Source value (Auto Post, Manual Post) and also filter these in your workflow conditions. As an example, if you post “#case Customer asks for refund” and then later on use it as the case title that gets inserted into a new Post, you’ll soon be stuck in a loop of each case resolution creating a new case…

Switch to our mobile site