Archive for October, 2009

User Group Session: C360’s Productivity Pack for Dynamics CRM 4

The October meeting of the Dynamics CRM User Group (www.DynamicsCRMUserGroup.com) featured two presentations, the first of which was by Brad Burks and Patrick Sells of C360 (www.C360.com) presenting on their best-selling product, the Core Productivity Pack for Dynamics CRM 4.

I thought they gave an excellent presentation! I recorded and posted the  presentation for your viewing pleasure.    

I won’t write too much here on it, since Brad and Patrick cover it thoroughly in the recording, but here are a a few comments:

  • You can tell the product planning people at C360 spend a lot of time either using Dynamics CRM or talking to people who do. For example, users often remark that the Dynamics CRM web UI is extremely “clicky” (or words to that effect), meaning you have to click a lot and open lots of windows to drill down to the information you need. As you’ll see in the recording, the “Console” (one of the primary features of the Productivity Pack) relieves about 90% of that clickiness. The tradeoff is a slightly busier screen, but I think a lot of users will prefer the busier screen/fewer clicks UI presented by the Console.
  • Personally, the editable grid they also include with the CPP (how soon we geeks lapse into acronyms!) was my favorite. I think that would make batch editing of records way easier than it is out of the box.
  • The SharePoint integration part is new, apparently, and it looks like a great start. Basically, it sounds like they’ve automated the process of creating a SharePoint site or document library when a new account is created in CRM. I’d like to know more about it, such as how much control you have over determining which accounts get sites created automatically, how the integration UI looks and so forth. In any event, this is an important function for a lot of organizations and I’m glad C360’s added it to the CPP.

Let me know what you think.

Here’s the full URL to the recording: http://www.imginc.net/images/stories/videos/dcrmug/C360_DCRMUG_October2009.wmv

Leave a Comment

Many to Many Relationships and Advanced Find

In another article I discussed the different kinds of entity relationships that can be created in Dynamics CRM 4, and in particular, how to create many to many (a.k.a. “N:N”) relationships. But once you’ve created an N:N relationship and entered some related information, how can you tell what’s related? Advanced Find works great for this, but as David Challener pointed out in a recent comment on my article, it’s not exposed very obviously within the AF UI.

Anyway, here’s a short video that shows how to create an N:N relationship, and how to create an Advanced Find query to see which records are related:

Leave a Comment

Dynamics CRM News You Can Use, October 2009

Dear colleague,

I’ve been busy lately, working on a project with Microsoft authoring updated self-paced E-Learning courses for Dynamics CRM Online. The courses are going to be great (if I do say so myself!), and I’ll post links to sample content as soon as I can.

With that project, plus my company’s somewhat rocky migration of our web site to a new platform (www.IMGinc.net), well…September got away from me, so without further ado, here’s the October edition of Dynamics CRM News You Can Use:

Upcoming Dynamics CRM User Group meeting

C360 is the leading provider of add-on products for Dynamics CRM, and we’re excited to have them lined up for a presentation at the October meeting of the Dynamics CRM User Group. Representatives from C360 will kick off the session with a demonstration of their best-selling “Dynamics CRM Productivity Pack”, and Richard will follow up with a presentation on their “BI Analytics” product. The meeting will be held October 29 at 3:00 PM Central time, and you can attend online or in person at the Microsoft office in Downers Grove. For more information and to register, please visit this page.

Dynamics CRM and the XRM Platform

The emergence of Dynamics CRM as the platform for “XRM” application development has been an important theme lately, and at the September DCRMUG meeting, Microsoft’s Bob Piskule gave an excellent presentation on the topic. We were impressed by how well-developed the Microsoft messaging is; here’s an article on the session with a link to the recording. Here are a couple of related articles you might find interesting:

Cloud Computing with Dynamics CRM Online

Over the last 12 months, we’ve (almost!) completely migrated our IT services from on-premise to cloud-based. The transition was wrenching at times, but the result will be worth it! Dynamics CRM Online was (and is) by far the best part of our migration. Here’s an article I wrote about our migration, and here’s a more specific one on the Top 5 Reasons to Like Dynamics CRM Online.

Building Workflows in Dynamics CRM

The workflow engine is one of the very best things about Dynamics CRM, and it’s the same thing whether you’re using the on-premise or Online version. My book — Building Workflows in Dynamics CRM 4.0 — continues to do well; if you’ve purchased it I thank you, and if you haven’t, I recommend it!  If you’re wondering about how workflow will change in the upcoming 5.0 release, anybody who purchases the current edition of my book gets the updated 5.0 edition free when I publish it shortly after the new product ships.


Support independent publishing: buy this book on Lulu.


Thanks again for your continued support, and let me know what you think of our new web site (remember: www.IMGinc.net). I know it isn’t fancy yet…but at least it’s always up!

Regards,

Richard Knudson, CEO, IMG
Microsoft Gold Certified Partner
www.IMGinc.net
www.DynamicsCRMTrickBag.com
www.DynamicsCRMuserGroup.com

Comments (1)

Dynamics CRM Mobile Solutions Update

CWR Mobility Releases 4.2 version for Windows Clients; iPhone Client Coming Soon!

CWR Mobility — www.cwrmobility.com — has an excellent set of solutions for organizations that want to make the Dynamics CRM experience available to mobile sales and service teams. The new product release is for Windows mobile clients only; I’m told that  the iPhone client is set for early November.

The CWR folks gave a nice presentation at the August meeting of the Dynamics CRM User Group, and recently posted a recording of the presentation. Here’s a link to the recorded session.

Unlike my esteemed colleague David Yack, whose blog should be a must-read for you if you like the kinds of things I write about on the Trick Bag, I think the iPhone is perhaps the best consumer electronics device ever created. So I’ll have to wait until early November to give a full review of the CWR iPhone client. (Here’s David’s article about his iPhone experience.)

Leave a Comment

14 Years Later, Still the Best

It must have been in 1990 I was in a record store in Ballard, WA, asked the clerk what he thought of this album “Facelift” by some band called “Alice in Chains”. I’d read about it in a review in the NY Times of three albums from Seattle bands Alice, Soundgarden, and I’m not sure who the third one was but I don’t think it was Nirvana, maybe Screaming Trees. Anyway, I’ll never forget what the clerk said. He got a glazed look in his eyes and said, “Dude. I’ll take it song for song over Houses of the Holy, any day.” That was weird since Houses of the Holy has been my rock album gold standard since the first time I heard it. With a recommendation like that of course I bought it. I was skeptical at the time but the clerk was right: Facelift was an awesome record, and Alice in Chains was an awesome band. After a 14-year absence from the recording studio, AIC’s released a new album, Black Gives Way to Blue. Judging by this song (Check My Brain), the band’s as good as ever.

Dude. After I give the new album a listen, I’ll let you know if I take it song for song over Facelift, any day.

Leave a Comment

Top Five Reasons to Like Dynamics CRM Online

Background: Our Move to the Cloud

There’s a lot to like about Microsoft’s SaaS version of CRM, Dynamics CRM Online (http://crm.dynamics.com ). In a recent article, I provided an overview of my company’s experience over the last year as we migrated all of our mission-critical IT functions from a traditional on-premise infrastructure to hosted services. Whatever you call it – SaaS, cloud computing, hosted – the most important benefit of migrating is that you don’t have to worry about the purely technical aspects of hosting: they become the job of whoever’s doing the hosting.

The IT functions we migrated to the cloud included E-mail, our web site, my blog, our CRM, and our Intranet site for document management and collaboration. Of all of these, our CRM migration – from the on-premise Microsoft Dynamics CRM 4.0 Enterprise version to the hosted Dynamics CRM Online – was far and away the best experience. It fulfilled the promise of cloud computing in many important ways, so I thought I’d recount them, in the form of a top five list.

So, without further ado, the…

Top Five Reasons to Like Dynamics CRM Online

  1. Great up and running experience. The process of getting up and running is flawless. In my opinion, most businesses will be able to sign up, add users, and be up and running in a day, without requiring dedicated IT staff or any previous CRM experience. This seems to be the whole point of cloud computing, and not everybody gets it right. (BPOS, for example, is Microsoft’s cloud combination of Exchange E-mail, SharePoint and Live Meeting. The BPOS on-boarding experience is time-consuming, complex and will for most organizations require the assistance of experienced specialists. )

    What I’m describing as the “up and running” experience for Dynamics CRM Online is the alternative to the installation process for the on-premise version. The on-premise version is installed on your own servers, and must be installed on top of an already-solid platform consisting of Windows Server 2003 or 2008, SQL Server 2005 or 2008, the correct version of the .NET Framework, the latest hot fixes and security patches, and some other things. After going through your “pre-installation checklist”, the installation of Dynamics CRM isn’t too bad…but still, it’s a multi-step process that takes some experience to really feel comfortable with, and it really should be done by an IT professional. 

    Contrast the on-premise installation process with the Dynamics CRM Online up and running experience: Choose a name for your organization. Pay for at least five users ($44/month per user, Microsoft will charge your credit card after each month). Add the users with the (what else?) New Users wizard. That’s it: nothing to install, Microsoft does the heavy lifting for you.

     

  2. No (unplanned) downtime. Starting in March of 2008, I’ve either had a demonstration organization or our production version running on Dynamics CRM Online, and as far as I know we’ve never had any unplanned downtime. Periodically we are notified, well in advance of planned downtime for server maintenance or upgrades performed in the Big Data Center in the Cloud. It’s usually on a weekend night and it’s usually for about 4 hours.

     

  3. No server maintenance. Not only do we have 100% planned up-time, but we don’t have to perform backups, install patches or hot fixes, do performance tuning, etc. I’m still not sure what the precise argument was in the famous article by Nicholas Carr, IT Doesn’t Matter, but I do know this: if by “IT” we mean installing and maintaining server software, maintaining connectivity and providing bandwidth, then all that matters to me is whether it works, not who actually does it.
  4. Two deployment options, one platform architecture. Microsoft is nearly unique in having both an on-premise and an online option, and as far as I know entirely unique in having the same architecture for both options. What this means is that you can migrate data and customizations either way: from on-premise to online, or from online to on-premise. There are lots of scenarios this single-architecture supports. Here are three examples:
  • I can prototype customizations in an on-premise organization, demo them to a client running Dynamics CRM Online, and then export them from the on-premise organization to the client’s production online system when ready.
  • An organization might start with the online platform, and then migrate to on-premise if its user-count grows enough to justify the IT investment.
  • The flip-side is just as easy: an organization currently running on-premise can migrate everything to the online platform.

    I should add a caveat to this last point: there are some customization techniques supported for on-premise that are not supported for online (see below). If your organization relies on some of these, a migration from on-premise to online will be more difficult.

5. In the Cloud, new features just happen! This is something it took me a while to fully appreciate. If you’re running the on-premise version, you don’t get new features until the next product version ships. If you’re running online, you get new features every time Microsoft does a “service update”. According to my count, there have been two service updates so far for Dynamics CRM Online, and each one has added very important new functionality in an area of special interest to me, Internet Marketing. There’s another one coming in a month or so that will feature some more cool new features.

So if you’re running Dynamics CRM Online now, you’re getting a sneak preview of features the on-premise product won’t see until Dynamics CRM 4.0 comes out! For example, some important new features will be in the November 2009 service update. Here’s a preview.

What’s not to Like?

Nothing’s perfect, including Dynamics CRM Online. Here are a few areas where the online experience suffers in comparison to on-premise:

  • Some limitations on ability to extend. While the customization architecture is the same, there are some limitations on how you can extend the product in its online version. Basically, the customizations you can perform are either ones that use the built-in tools, or ones that extend the platform using web services and the methods they expose. This includes a LOT of customizations…but not everything you might want to do. Here’s a quick summary of all of the customizations tactics available in the on-premise version, and the subset of those available in online, ca. October 2009:

     

Customization Type Available in Dynamics CRM Online?
Forms and views Yes
Entities and attributes, entity relationships Yes
Workflows using the native web environment Yes
Custom site map, ISV.config Yes
Form scripting Yes
Web services Yes
Custom workflow actions and plug-ins No
Custom ASPX files on server No
Custom reporting services reports No

 

  • Many add-on products not yet available for online version. This is actually a corollary of the previous point: since many of the ISVs who have developed add-ons for Dynamics CRM have exploited the extension techniques that aren’t yet available for online, some of their extensions aren’t yet available. I won’t provide a long list here, but suffice it to say that the ISVs who have versions of their products available for online as well as on-premise now are more the exception than the rule.

 

  • No “multi-tenancy” for online. Multi-tenancy is available only in the (on-premise) CRM 4.0 Enterprise Edition, and means you can create multiple “organizations” within a single deployment. Since data and customizations live at the organization level, multiple organizations give you LOTS of important benefits, such as support for separate development, test, and production organizations. I use them all the time to implement prototype and demo organizations I can show a customer, before migrating customizations to a production system.

    Anyway, this feature isn’t available for online, so unless you’re fortunate enough to also have an on-premise Enterprise Edition, it means prototyping and testing must happen in your production environment.

All these Tradeoffs!

Like I said, nothing’s perfect, and the fact that Dynamics CRM Online has a few limitations compared to the on-premise version shouldn’t be too surprising. For many small-medium sized organizations, the advantages of cloud computing – wonderfully realized in the online version of Dynamics CRM – are going to be compelling reasons to consider the platform.

A couple years ago, we regularly saw clients decide to go with Salesforce for the simple reason that it was the only option. These were obviously organizations that had already seen the advantages to cloud computing and were sympathetic to the “no software” pitch.

Now, things have changed a little. Salesforce isn’t the only option anymore, and must now win deals based on good old-fashioned dimensions such as features, price and value. Judging by Microsoft’s recent revenue and revenue-share growth, the CRM marketplace seems to think Dynamics CRM stacks up pretty well!

Leave a Comment

In the Cloud, New Features Just Happen!

 

     Here’s an e-mail I received from the Microsoft Dynamics CRM Online team regarding the upcoming November 2009 service update. This is one of the things I like best about the Dynamics CRM Online version of cloud computing: important new features just happen, and I don’t have to install anything! 

Dear Richard Knudson,

As part of Microsoft’s commitment to ongoing innovation and customer success, we are set to deliver our next Microsoft Dynamics CRM Online service update in November 2009. This update will provide your organization with increased business benefits that accelerate time to value in areas such as:

  • Access to Microsoft Dynamics CRM Online through a range of mobile devices
  • In-page help and how-to guidance to provide an even richer experience for new users
  • The ability to add additional storage capacity to accommodate even larger customer databases
  • The introduction of a Home Page dashboard that gives improved visibility into data through embedded charts
  • A new release of Microsoft Dynamics CRM Online for Outlook with improved performance and usability
  • Enhanced data import capabilities through an updated import wizard experience

We will begin upgrading existing organizations in early November. We plan to conduct the upgrades during off-peak hours to minimize the impact to your business. You will receive advance notice of your scheduled upgrade time approximately one week prior. If you have any questions about this update or about Microsoft Dynamics CRM Online, please contact our Customer Service team by dialing 1-877-CRM-CHOICE (1-877-276-2464).

We appreciate your business and look forward to your continued success with Microsoft Dynamics CRM Online.


Thank you,

The Microsoft Dynamics CRM Online Team 

 

Quick Links
Contact us
Learn more

Comments (1)

Dynamics CRM Online

The Highlight of our 12-Month Cloud Migration

I’ve written elsewhere about my company’s recent 12-month migration from a traditional (and dysfunctional!) on-premise IT infrastructure to an  all-cloud one.  The process was about as much fun as a 12-month root canal, but the outcome is lovely: no more server maintenance, no more worries about sites going down.

We migrated a LOT of important services — e-mail, collaboration/document management, blogs, web site, CRM — and the best part of the migration was CRM: to Dynamics CRM Online. This is the hosted version of Microsoft’s fast-growing CRM application, and you can find out more about it (and whip out your credit card and sign up for it, if you like) at http://crm.dynamics.com/

I’ll write a LOT more about our experience with Dynamics CRM Online, but in the meantime I wanted to share out this presentation I gave a while back at the very first meeting, back in December of 2008, of the Dynamics CRM User Group. I uploaded the slide deck to a site called SlideShare.net, and you can view it in its embedded form here, or go to SlideShare and see it there.

The first part of the presentation is a comparison of the Dynamics CRM Online and on-premise versions. About the only thing in the presentation that isn’t correct anymore is the $39/user/month price I included for the Pro version of CRM Online (that was a special, only good through 12/31/2008, and now the price is $44/user/month) 

Leave a Comment

Further Adventures in Cloud Computing

It took 12 months, but I’ve nearly reached Cloud Nirvana

In other articles, I’ve described myself and my company as ideal candidates for so-called “cloud computing”. As with lots of concepts, it’s tough to beat Wikipedia’s definition of cloud computing, virtually every potential advantage of which has been a huge trouble-spot for my firm over the last year or so. Here’s a summary of our migration from a traditional “on-premise” IT infrastructure to an almost all-cloud platform. While every business is unique, my guess is that our experience mirrors that of lots of others; let me know if your experiences have been similar…or not!

Setting the Stage

A year ago I sold the part of my business that had traditionally provided open-enrollment classroom-based IT training services. With the part of the business I sold went a lot of overhead expense (classrooms take up a lot of room, require lots of computers to fill up the space, and require administrative and support staff to set computers up, move them around, schedule, cancel and reschedule classes, and the like). I was determined my new business would be profitable, so I wanted to minimize non-billable IT resources. Then the economy tanked, so keeping non-billable headcount wasn’t an option in any case!

In short, I found myself with zero dedicated IT staff…and an IT infrastructure consisting of at least eight internal servers apparently required to keep us up and running with e-mail, blogs, accounting, intranet, and our web site. We had a lot of bandwidth coming into our office, provided with byzantine complexity and benign neglect by AT&T. We had switches, routers, internal and external name servers, domain controllers…oi!

Making the Move(s)

We had a lot of different services that needed to be migrated – blogs, e-mail, intranet, internet, accounting, crm – and some that didn’t – domain controllers, internal name servers. This table lists them in the order of the migration date, and shows the platform we were running a year ago and what we migrated to:

Function Platform in October 2008 Migration Date Migrated to
Blogs Internal SharePoint Server February 2009 Hosted WordPress
Email Internal Exchange Server March-April Hosted BPOS
Intranet Internal SharePoint Server March-April Hosted BPOS
Accounting/ERP Internal Accounting Server July Hosted QuickBooks
CRM Internal CRM Server July Hosted CRM Online
Public web site/extranet Internal SharePoint Server October-November Hosted Joomla (almost!)
Domain controller Internal DC Server   NA
Internal and external name servers Internal Name Servers   NA

 

Results

Most small to medium sized businesses are going to be better off with cloud-based services. The more legacy infrastructure you have the harder it is to migrate (see above), but it’s still gotta be done! Here is my executive summary, the high and low points and some editorial opinion. Of all the apps we needed to migrate, I have the most expertise on CRM, SharePoint and blogging, and I’ve written more detailed articles on those pieces, and will write more.

Forthwith, the executive summary:

  • Dynamics CRM Online. This was the highlight of this adventure in cloud migration. The platform is rock solid (and simple to administer) and the architecture is the same as the on-premise version so there are no substantive migration issues. I’ve written about this elsewhere, and enthusiastically recommend Microsoft’s cloud CRM.
  • BPOS for E-mail. BPOS (for Business Productivity Online Suite) is Microsoft’s hosted combination of Exchange, SharePoint and Live Meeting, and I can’t recommend it for most small businesses’ e-mail service. It’s complex enough that it requires internal IT skills, or a certified (and competent!) partner to assist you. One of the most important reasons for going with hosted services is to eliminate the need for specialized IT resources, and in my experience BPOS simply puts the internal support bar too high.
  • BPOS SharePoint. I was careful in the previous paragraph to dis-recommend BPOS for e-mail. Its SharePoint implementation is actually quite good. The only two problems with the hosted SharePoint experience are:
    • It’s Intranet only, so we had to figure something else out for our public web site;
    • It’s bundled with BPOS e-mail.
  • WordPress for blogging. I spend a lot of time blogging in my new slimmed-down me-centric business model. In February I moved my blog from MOSS 2007 to WordPress, and I’ve been blown away by the WordPress platform. I was a late-comer to the open-source phenomenon, and what an eye-opener it’s been! I use a company called DreamHost for blog and web site hosting, and I recommend them as well.
  • Accounting. My company had a dedicated ERP server for years. We ran Dynamics GP, and while that’s a solid ERP application, it’s overkill for most small businesses and it too effectively requires dedicated IT staff to maintain, upgrade, customize. We switched to a hosted QuickBooks in July and it was a good move.
  • Domain controllers, internal and external name servers…yuck! I can’t quite pull the plug on those yet, but I’m close, and when I finally do my IT staff and I are going to have a Big Party!
  • Web site. This was a tough one, as it involved the most wrenching migration, at least from a philosophical standpoint: we’re close to completing a migration of our public web site from MOSS 2007 to Joomla. If you’re as true-blue Microsoft as I’ve been for most of my career, you might wonder what the heck Joomla is. It’s one of the leading open-source platforms for web sites, and in the end, as much as I love SharePoint, I had to conclude that for small to medium sized businesses, hosting your public-facing web site on SharePoint just isn’t the best option. This migration is worth a more detailed treatment, so stay tuned for that.

Comments (3)

More Thoughts on XRM

I’ve written a few articles on the “XRM thing”, and why the Dynamics CRM 4.0 is such a great platform for the development of line-of-business applications. At a recent meeting of the Dynamics CRM User Group we had a very good presentation from Microsoft’s Bob Piskule. Along with Bob, Microsoftie John O’Donnell provides adult supervision when we DCRMUG’ers meet at their Downers Grove office for our monthly meetings. Bob and I had a brief exchange towards the end of the session (you can view the recording from this page) that crystallized my thinking on some XRM topics, which I’ll try to summarize here.

What if they took the “C” out of CRM?

I’ve had a few recent customer conversations where the “C” part of CRM got in the way of the conversation. They were interested in developing a custom application that I knew would be a great fit for Dynamics CRM, but it wasn’t going to use much if any of the baseline feature-set of the product (sales, marketing, customer service). If you aren’t familiar with the platform, I can imagine it’s a little hard to think about an application built in Dynamics CRM that has nothing to do with its core features! But that’s really what the XRM concept comes down to: you can use the platform to develop any application, whether it has anything to do with “customers” or not.

The exchange I had with John was an extension of these XRM lines of thought: what would a real XRM platform look like? It won’t be too long before companies who aren’t using any of the built-in functionality start wondering why they’re paying for it. I’d be surprised if Microsoft hasn’t been approached already on the topic.

Or what about a developer who builds an application on the XRM platform and wants to sell a jillion seats. At $44/seat (the retail price of the Pro version of Dynamics CRM Online, on a per-user per-month basis), $44 jillion might be cost prohibitive, but he might be willing to pay $25k for an unlimited seat license in return for not being able to use any of the sales, marketing or service core feature-set.

XRM you can do Now

There actually are some options along these lines available now. There’s a “connector” license you can purchase for a one-time fee. If you have the connector you can expose read/write forms to users without a per-seat license fee. The catch is that the forms have to be ones you create yourself with custom .NET code, and you don’t get any of the built-in user experience goodness like reports, Advanced Find and so forth.

This approach is better than nothing, but it excludes what in my view is the secret sauce of of the platform: the native customization techniques exposed entirely through the web UI in Dynamics CRM.

Create an XRM Application in 5 Minutes

I’ll present an example here that illustrates the bare essentials of what you can do now, using the current capabilities of the Dynamics CRM customization feature-set (this works identically in the CRM Online or on-premise versions). It is simple, but if you’re new to this it illustrates some important customization techniques. And even if you aren’t the person who will be implementing customizations for your organization, it shows how you can “take the C out of CRM”, which is essentially what the XRM discussion is all about. Here’s the executive summary:

  • Create a new security role. New security roles (created “from scratch” – that is, NOT by copying an existing security role) contain no privileges to any entities by default, so the only way to expose entities to a user with this security role is to explicitly add privileges. I called it “XRM User”, for the purposes of the demo.
  • After creating the XRM User security role, I added privileges to it that will expose only some of the custom entities my organization uses.
  • For a specific user, remove any existing security roles and assign the XRM User security role only.
  • For the custom entities I wanted this user to see, I customized them so that they only appear in the “Workplace” area in the site map.
  • I also customized our Site Map, changing the name of the “Workplace” are to “IMG Workspace”. This isn’t essential, but it does illustrate that you can make the site map appear however you want it to.

The main point of this exercise is that you can easily strip down Dynamics CRM so that users see only the entities you want them to see, mixing and matching entities from your Great American XRM application with anything from the core feature set.

Let me know what you think of my awesome XRM application, and if you want to do it yourself, follow these steps:

Create the XRM User Security Role with privileges to none of the built-in entities, and only to the “XRM” entities you want to expose:

  1. In the left navigation area, click Settings, then click Administration.
  2. Click the Security Roles link, then click New to create a new security role.
  3. Call it “XRM User”, use all of its default settings (remember: a security role created from scratch like this has permissions to almost nothing!) and save it.
  4. Click on the “Custom Entities” tab for the security role, and add the privileges you want for any custom “XRM” entities you want to expose to these users.
  5. Pick a user, and remove all of their current security roles, and assign them this new “XRM User” security role only. (If you want to prank you buddy, use his or her user account. If you’re in one of those buttoned down corporate environments where things like messing with people’s user accounts are taken seriously, use a dummy account or do this in a sandbox environment.)

Customize XRM Entities so they appear only in the “Workplace”

For each entity, follow these steps:

  1. In the left navigation area, click Settings, then click Customization.
  2. Click the Customize Entities link, then select the entity you want to customize.
  3. Double-click it to open its customization form, then uncheck everything in the “Areas that display this entity” section except for the Workplace.
  4. Save and close the form, then publish.

Customize the Site Map

  1. In the left navigation area, click Settings, then click Customization.
  2. Click the Export Customizations link.
  3. Select Client Extensions from the View drop-down, and select Site Map from the list.
  4. Click Export Selected Customizations, and OK to confirm.
  5. Save the file to disk somewhere you won’t forget about it.
  6. Extract the zip file and edit the extracted XML file with Visual Studio, or XML Editor, or Notepad or whatever text editor you like.
  7. Find the line that looks like this:

<Area
Id=Workplace
ResourceId=Area_Workplace
ShowGroups=true
Icon=/_imgs/workplace_24×24.gif
DescriptionResourceId=Workplace_Description>

 

  1. At the very end of the line, add a “Title” attribute with whatever custom title you want for your XRM Workplace:

<Area
Id=Workplace
ResourceId=Area_Workplace
ShowGroups=true
Icon=/_imgs/workplace_24×24.gif
DescriptionResourceId=Workplace_Description
Title=IMG Workspace>

 

  1. Save the file, and go back into XRM – er, Dynamics CRM.
  2. In the left navigation area, click Settings, then click Customization.
  3. Click the Import Customizations link. Browse to the saved XML file, and import it.
  4. When you refresh the browser, you will see the Workplace customized with the new name you’ve given it.

After you complete these steps, you can get a good visualization of how customizable the platform is by signing in first as a System Administrator or somebody with lots of privileges. Here’s what it looks like for me, for example, in my “normal” CRM Online production organization:

Then, sign in as the user you assigned the “XRM User” security role to. Make sure that’s the ONLY security role they have, otherwise it spoils everything! Here’s what it looks like to that user:

 

This user doesn’t have privileges to see any entities except for the five custom ones exposed on the “IMG Workspace” site map area, so none of the traditional CRM areas – Sales, Marketing, Service – appear. She can click Advanced Find but can’t see anything except the specific entities her security role grants her privileges to.

Wrapup

Like anything else, it takes some time to learn how to build custom XRM applications on the Dynamics CRM platform. But once you’re up to speed, there’s no question that it’s a more productive approach to application development than most of the alternatives. My guess is, it would take about 10-20% of the time to create an XRM application on Dynamics CRM that it would to create it using C# and SQL Server. To be clear, I’m saying it’s reasonable to expect, for a comparable application, 5-10x more productivity on Dynamics CRM than with traditional development approaches.

The flip side, of course, is the licensing model. With the DIY C#/SQL approach I don’t have any user CALs to purchase. So the platform decision amounts to trading off developer productivity against licensing costs. I’ll close out by characterizing three scenarios I think are pretty common and provide some guidance on the decision process for each:

  • Organizations who have already licensed Dynamics CRM have an easy choice: don’t do any more development of line of business apps in Access or C#/SQL or whatever other alternatives you might consider. Most or all of your application development should be done in CRM.
  • Organizations considering the purchase of a CRM should incorporate the potential XRM benefits of Dynamics CRM into their decision process. It might not be obvious that when you’re comparing different CRMs for your sales/service/marketing functions, you should incorporate developer productivity on entirely different XRM apps into the decision process. But I think sometimes this could be an important factor.
  • Organizations or individuals developing standalone XRM apps with potentially large user populations, many of whom might be outside the firewall. For this scenario the current licensing model for Dynamics CRM will make it prohibitively expensive for many. Let’s hope that changes!             

 

Comments (6)