Broken Ribbon Icons and Jscript code when using IP Address/Organization with CRM 2011
I noticed odd behavior whenever I used the IP address in the URL in my CRM 2011 environment. If I used the server name (or on my VM, localhost) everything worked as expected. However, when using the IP Address/organization, custom ribbon icons are broken.
Dynamics CRM & Bing Maps Integration
Many of the clients we speak with wish to have Microsoft Bing map integrations, but want to use standard address fields instead of latitude / longitude. Using CRM 2011’s OData query capabilities and Microsoft’s Bing web API, this can be achieved using a single HTML page within the CRM solution file. Madrona Solution Group has developed a simple HTML file that works the out-of-the-box contact entity using the standard address fields.
CRM 2011 Logging to Event Viewer Application
Recently, one of our clients decided to move their CRM installation to an internal server. Their team had been using CRM Online, but the reporting limitations (fetchxml) and a few other issues became high priority issues, and so inside the network we went.
Scribe for Excel to Microsoft CRM 2011: Optionset / Picklist Value Lookup
Sometimes, we just need a good example of how to write some simple code. We don't have the time to parse / read / undertand all the possible ways of doing something - just tell us what to do for this one thing I know everyone has to do already.
Scribe for Excel to Microsoft CRM 2011: Date values
When using Scribe to import data into Microsoft CRM 2011 organization from Excel, sometimes date values need to be pull into strings (e.g. ensuring unique names) with the serial number Excel stores for the values. This often happens when I use Functions. I just want the date, so how do I do it?
Creating Pivots From Excel Exports of Reports Made With the Report Wizard
There is an error generated when users try to pivot on an Excel export generated from a report made with Ad Hoc report wizard in CRM:
"The PivotTabIe field name not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTabIe field, you must type a new name for the field."
Duplicate Detection Rules Automatically Unpublished
I have been discussing the need for some duplicate detection rules for our custom entities with a client. I created them. I published them. I tested them, they worked great, and I deleted the duplicate records in our test environment. Note: for more information on CRM Duplicate Detection Rules, please see the MSDN post from a few years ago, it's pretty much the same. http://blogs.msdn.com/b/crm/archive/2007/11/20/duplicate-detection-rules-defined.aspx
A Critical Framework to Turn Goals into Results
Without clarity into how your company operates, it is easy to make uninformed decisions, which materialize in costly projects that deploy poor solutions that produce little benefit.
This is the first in a series of blogs that explores a critical framework used to avoid producing meaningless solutions, and help turn company goals into meaningful results.
Nucleus Research Confirms Microsoft Dynamics CRM and Salesforce.com as Top CRM Applications
Nucleus Research recently completed a technology value matrix for CRM applications. This matrix utilizes overall application functionality and usability to rate CRM applications.
Dynamics CRM 2011 Auditing
Microsoft has provided out-of-box auditing functionality that far exceeds what was manually available in Dynamics CRM 4.0. In CRM 4.0, audit logs had to be created manually with custom entities and subsequent mappings. There were also third party tools available to address this need, but they were often cumbersome to use and expensive.
Showing Related Entities on a Form in CRM 2011
Frequently, businesses want to see 1-N and N-N entities displayed on related forms. In CRM 4, this required custom coding with an i-frame, but CRM 2011 provides this functionality thru out of the box configuration.
The steps below will walk you through adding a 1-N or N-N entity using the Sub-Grid customization.
Fetch XML - 2000 Character Limitation
FetchXML is among one of our favorite tools within the Microsoft Dynamics CRM platform. On the client, we use fetch XML along with Avanade’s CrmService.jsfile to retrieve very small amounts of data usually less than 5 records. We recently found fetchXML has a limitation that isn’t related to joins, filters or aggregates (all limitations related to these areas are well documented in the CRM SDK).
Dependent Option Sets in CRM 2011
It is a very common businesses requirement to limit the values in one Option Set (called picklist in previous versions of CRM) based on the value set in another one. After investigating several ways of addressing this common business requirement, we have come up with code that does the following:
- Provides robust filtering code that can be used globally (on any form).
- Relationship setup must be easily done in one place.
- Actual option set values and not the index must be used.
Dynamics CRM 2011 Security Features
Many of our clients have complex business requirements associated with the securtiy of their CRM application. The Madrona team employed a mix of CRM configuration and custom code in earlier CRM versions to meet the business requirements, but the tool supports many more items natively with the release of Dynamics CRM 2011. This is an overview of the security changes and provides some interesting details to consider while configuring CRM 2011.
CRM for Professional Services
CRM for Professional Services
This is another of a series of posts we'll do exploring how to best setup a CRM system to fit a specific organization's needs. A few specific business challenges to keep in mind when looking at setting up CRM for professional services organizations, and a few suggested approaches when modeling the system are outlined below.
Key Challenges
Capturing the right early and late stage sales metrics that are most indicative of how the sales team is performing - Most of the services organizations we work with have quite a few metrics they live by around their operations. They tend to track staff utilization, average bill rates, and revenue in the pipeline. However, the most successful organizations also have a couple of key additional metrics that they keep a close eye on to evaluate the true health of their pipeline. This depends a little bit from organization to organization, but there are a couple of common elements.
CRM for Publishers
CRM for Publishers
This is one of series of posts we'll do exploring how to best setup a CRM system to fit an identified business need. We will provide a few things to keep in mind when looking at CRM packages, and a few suggested approaches when modeling the system are outlined below. This specific post will focus on publishers, specifically those focused on selling advertising.
Key Challenges
Setting up the relationship between Advertisers and Agencies - Almost all publishers are dealing with a complicated landscape where on some deals the buyer is the advertiser, on others it's an agency, and on some the buyer may be one organization and the payer separate. Regardless, it is critical to work with systems and people who understand this relationship and have the capacity to setup the CRM system to track not only the advertiser and agency on the deal, but also to roll up metrics that give insight into who the most influential agencies are, as well as provide the ability to track specific agency individuals and their inter-relationship with multiple advertisers.
Keys to the Adoption of a CRM Platform
Having seen hundreds of CRM implementations, the most common complaint that crops up over and over is "We invested a significant amount of energy and money, but our team (particularly sales) just isn't using the system the way we expected, and as a result we don't get much out of it".
Over some upcoming posts we'll explore all the things you do during the process of building an application to make it great, but for now, we'll take a minute and address the elephant in the CRM room. Most CRM systems fundamentally are not consistently adopted by sales and marketing organizations. Here's a list of the top 10 areas you can focus on to drive adoption regardless of whether you are starting a new implementation or struggling with adoption.
Is the application simple enough? Virtually every organization wants to provide things that are easy to use for their peers, but far too frequently the CRM tools will get cluttered with layer after layer of fields, workflows, and customizations to the point where sales and marketing users are thoroughly confused about how to do their day to day job. It simply can't be overstated that the CRM system is a tool to enhance sales and marketing's ability to get their work done, and with that in mind it must be simple for even the shortest attention span user to quickly click through the forms and record key data. We very frequently find that some of the most robust applications end up as shelf-ware while applications that were consciously designed with a minimalist structure end up heavily used, and it's this initial adoption that drives them to become a core part of the business. If there's one thing you retain from this post, it should be that if you are struggling with adoption today, the most likely thing you can do to improve the situation is to simplify the UI, remove excess fields, get rid of extraneous workflows, and pare to the core business process followed by most users.
Keys to a Successful CRM Strategy
There is always more than one way to deliver great CRM tools, and there are many, many ways to design and deliver an application that sits idly by while people go about working in email and spreadsheets. However, we've found that every organization that masters the following components ends up with a platform with high rates of adoption that drives the business forward.