Posted on 21. November 2016

Dynamics 365 Application User

What is great to see with Dynamics 365 is the concept of the Application User. This means that subscribing systems can be connected to external systems using a 'Service Account' style user rather than the previous technique of providing username and passwords.

One of the knock on effects of this is the new 'Application User' form on the User record. I've had some questions from people who see this form by default. You simply need to change the form back the standard 'User' form:

If you try to save the user record on this form you will receive the error 'You must provide a value for Application ID' since this is a mandatory field.

If you want to learn more about the Multi-tenant server to server application user integration scenarios that are used by App Source, then check out the following article:

https://msdn.microsoft.com/en-us/library/mt790170.aspx

Posted on 22. August 2016

Will the Common Data Model change my Dynamics CRM Database?

This is question on the lips of many after the recent Dynamics 365 anouncements.

Watch my short video to see how Dynamics CRM sits alongside the Common Data Model: https://youtu.be/fYIPXx9zjj8

Posted on 22. August 2016

Debugging JavaScript in the Interactive Service Hub (Part 1)

Those that read regularly my blog and follow my work with Sparkle XRM will know I'm a massive fan of using Fiddler to debug JavaScript. One of the most productive 'superpowers' that Fiddler gives us is the ability to change JavaScript on the disk and not have to upload/publish – we can simply refresh the form and the new script will be used.

The Interactive Service Hub (ISH) was first introduced in CRM2016 and has been improved with more support for customisations in CRM2016 Update 1.

I see the purpose of the ISH at this stage is not to replace the main User Interface but rather as a testing ground for the principle of bringing the MoCA mobile/tablet native client platform to the web client. I think of it similar to the introduction of the Polaris UI back in CRM2011 – there are many similarities in that they both only support a limited set of entities and have limited customisations features. The main difference is that the ISH is being incrementally improved with each release, where the Polaris UI was more of a throw away proof of concept. At this stage the ISH is only supporting 'case' oriented operations but I'm sure it'll eventually graduate to support all Sales, Service and Marketing features.

So why the new approach the UI?

Surely it would be better to improve the existing UI incrementally rather than replace it?

One of the key drivers for the Dynamics CRM Team over the last few releases has been 'configure once deploy everywhere'. This allows us to configure business rules that can be run on all devices/platforms reliably without having to perform separate testing and perhaps re-write to target different clients. The maintenance of having multiple user interface platforms is considerable so it's a natural step to try and achieve some degree of convergence between the mobile/tablet/web/outlook interfaces.

A little background on how the ISH loads metadata

I think we are all fairly comfortable with the normal Web 2.0 paradigm of loading resources. This is where with each operation the client requests an html page and then the browser requests all the additional resources (JavaScript, CSS etc. ) that are referenced by that page. JavaScript can then make additional XHR/Ajax requests to the server to display further dynamic content. The CRM2016 UI is very similar on this front as can be seen below. I documented the CRM2013 script loading sequence which hasn't significantly changed even in CRM2016.

  • Page Load Sequence Diagram
  • Each time you open the web client, the homepage.aspx or Main.aspx has to request the metadata for the specific resource (view or form) and then combine it with the requested data. Although there is browser and server side caching in place, this is still costly in terms of the requests and rendering overhead of the browser. The 'turbo forms' update in CRM2015 Update 1 has really helped with the speed of this since it minimises the resources that requested with each navigation however fundamentally it is still limited by the page per browser request architecture.

    ISH works very differently…

    The ISH is more what we would call a 'single page application'. The sequence is very different in that there is an initial download of metadata and then subsequently all user interactions only request the actual data using the Organization.svc and OrganizationData.svc.

  • New Page Load Sequence Diagram
  • This single page approach has the advantage that it makes navigation super slick but with the rather annoying drawback that there is an initial wait each time the ISH is opened where the metadata changes are checked. The first time you open the ISH all the metadata is downloaded but from then on only the differences from the last open are downloaded. If there haven't been any changes then it's super quick because all the metadata is stored in the browsers indexed Database but if you've done a publish then the next open can take a while. Furthermore, the new metadata won't be downloaded until you close and re-open the ISH - this is different to the Web 2.0 UI and can lead to the client working with stale metadata for a time. The Indexed Database is one of the significant differences between and HTML5 single page app and a more traditional Web 2.0 architecture.

    Note: For now the ISH mostly uses the SOAP/Xml based Organization.svc rather than the new JSON based Web API.

    The speed of the metadata sync can be helped further by using the 'Prepare Client Customizations' button on the solution since this will pre-prepare the download package rather than waiting for the first person to open the ISH to detect the changes in the metadata. The difference between the MoCA client and the ISH is that the MoCA asks if the user wants to download the updates – presumably because you may be on a low bandwidth connection.

    So where does that leave us with respect to JavaScript debugging?

    If you've been keeping up so far (you have right?) then you'll realise that because the metadata (this includes JavaScript) will be all stored in the browser Indexed DB and not relying on the browser cache. As a result, we can't simply prevent the files from being cached and download the latest version with each page load as we used to do with Fiddler. We're back with the uncomfortable debug cycle of having to make a change to a JavaScript web resource, upload it to CRM, publish, close and re-start the ISH - urgh!

    To preserve our collective sanity, I've created a little debug utility solution that you can use to clear the cache of specific web resources so that you can quickly make changes to JavaScript on your local disk and then reload it in the ISH without doing a full publish cycle. Here is how:

    1. Install the latest build of SparkleXRM
    2. Install the Interactive Service Hub Debug Helper Solution
    3. Setup Fiddler's Auto Responder to point to your local webresource file as per my instructions.
    4. Start the ISH to load your JavaScript
    5. Make a local change to your JavaScript
    6. Open the ISH Debug Utility Solution configuration page and enter the name of your script name, then click 'Refresh JavaScript Webresource'
      Note: You can enter only part of the webresource name and it will use a regular expression to match.
    7. Use Ctrl-F5 on your ISH Page and when re-loaded the Web Resource will use the new version since the debug utility has forced a new download and updated the Indexed DB storage.

    Sweet – but what about the MoCA client?

    Obviously this technique is not going to work for mobile client running on an iPad, iPhone etc. The good news is that you can run the MoCA client in the Chrome browser in the same way you can run the ISH – just navigate to:

    <crmserver>/nga/main.htm?org=<orgname>&server=<crmserver>

    Note: You must be pre-authenticated for this to work.

    OnPrem

    http://dev03/nga/main.htm?org=Contoso&server=http://dev03/Contoso

    OnPrem IFD

    https://myorg.contoso.com/nga/main.htm?org=myorg&server=https:// myorg.contoso.com

    Online

    https://myorg.crm4.dynamics.com/nga/main.htm?org=myorg&server=https:// myorg.crm4.dynamics.com  

    Since the ISH and the MoCA client are build using the same platform you can now use the ISH Debug Helper from the same browser session to perform the same script refresh! This is actually an excellent way of testing out your Scripts on the MoCA client! For more information, check out the comments in this tip of the day.

    Looking forwards to the future

    I'd really encourage you to check out the ISH and use the New CRM Suggestions site to record anything you find that you would like to see in subsequent releases. Whilst I suspect that the existing 'refreshed' UI will be available for some releases to come, it is likely at some point to become the new 'legacy' UI and with on-going investment being made in the ISH style UI.

    In part 2 we'll look at some limitation of the ISH and how to get around them.

    Any comments, just tweet me! @ScottDurow

    Posted on 22. July 2016

    Install Project Service Automation (PSA) – Where’s it gone?

    If you have tried to install Project Service recently you might have found that it's disappeared from the 'preferred solution' list in the Office 365 admin portal. So where has it gone?!

    Although the CRM Online Help hasn't yet been updated to reflect the fact, it has now moved to the recently release and very exciting AppSource!

    On the 11th of July Michael Kushinsky of Microsoft helpfully posted in the dynamics community the new instructions on how to install and upgrade from a trial installation – and there will be an official blog post about it soon.

    I thought I would quickly show you how easy it is to use App Source to install PSA:

    1. Select Settings -> Dynamics Marketplace

    2. Search for 'Project Service' and click 'Try'

    3. Accept the T&Cs (you always read them in full right!)

    4. Wait for the solution to install and you're off!

    I can't wait to see AppSource grow and mature!

    Posted on 8. July 2016

    Mastering Ribbon Workbench 2016

    Since the release of the Ribbon Workbench 2016 I am in the process of updating the documentation to reflect the new user interface.

    This video series on mastering the Ribbon Workbench 2016 will take you through from installing to performing advanced customisations.

    Part 1 - Downloading & Installing

    Part 2 - User Interface Overview

    Part 3 - Hide Actions

    Part 4 - Moving Managed Buttons to a Flyout Menu

    Part 5 - Hiding buttons conditional to the form context

    More to follow!...

    Posted on 8. July 2016

    Ribbon Workbench Version Compatibility

    I'm pleased to announce that in addition to the managed solution that you can install inside Dynamics CRM, the Ribbon Workbench 2016 is also available in the XrmToolbox (if you hadn't already noticed!).

    When you open the XrmToolbox you will see that there is the Ribbon Workbench available for download in the plugin store.

    Keep checking out the store because tools are being added regularly by some great plugin authors.

    Thank you to all those who are helping to beta-test, I have been really encouraged by your comments and suggestions. The re-write of the Ribbon Workbench (to remove its dependency on Silverlight) and the XrmToolbox version has been on my 'to-do' list for much longer than I would have liked and so I'm particularly pleased with this release.

    The new Ribbon Workbench 2016 solution installs alongside the older version – so if you have an upgraded org you might get them all sitting there on your command bar. 

    I'm keeping there on one of my organisations for posterity but you can safely uninstall older versions without losing any of your customisations.

    Here is a version compatibility matrix for users of the older versions:

    Name

    Ribbon Workbench

    Ribbon Workbench 2013

    Ribbon Workbench 2016

    Icon

    Latest Version

    1.0.1.9

    2.0.1.3

    3.0.16

    Requires Silverlight?

    Yes

    Yes

     

    XrmToolbox Version?

       

    Yes

    CRM 2011
    (Inc. UR12+)

    Supported

       

    CRM 2013
    (Inc. SP1+)

     

    Supported

     

    CRM 2015
    (Inc. Update 1+)

     

    Supported

    Supported

    CRM 2016
    (Inc. Update 1+)

     

     

    Supported

    Supported

    Posted on 8. July 2016

    Dynamics 365 – what’s that?

    Ever since Microsoft's announcement in 2005 of the 'Dynamics' brand, the strategy (code named 'Project Green') to homogenise the range of ERP products together into a single technology has been all but been forgotten. This has largely been due to Microsoft's investments in 'mash-up' technologies such as Power BI and integration platforms such as Power Apps and Microsoft Flow. The concept of 'metamodeling' your Enterprise to make integration and consolidated reporting easier is clearly not a new concept but now with these technologies and the prevalence of open APIs it has become a reality that's available to practically any organisation. The investment in the 2016 release of Dynamics NAV to integrate more natively with Dynamics CRM Online was a step in the right direction to bring the products closer together and with the recent Dynamics 365 announcement it seems like there is a concrete commitment to use Power BI, Power Apps and Microsoft Flow to make the whole greater than the sum of the parts.

    The idea of having a single system to drives every single process within a business may seem like nirvana but in reality would become so complex, hard to maintain and inflexible to business changes (such as mergers and acquisitions) that it would quickly prove to be as undesirable as having no system at all. In a previous life as a Microsoft BizTalk Consultant the Service Orientated Architecture was the perceived anti-dote to the monolithic systems of the 1990's. Unfortunately, the fact that the systems being integrated together naturally assumed that they were the only application you ever needed to use and had closed APIs, integration was not only difficult and expensive but also prone to failure.

    I really welcome Microsoft's Dynamics 365 strategy and hope it will make the Business Solutions sit comfortably within the promised 'common data model' with ease so that we can also include other non-Dynamics parts of the business into the mix. I suspect that the individual product brands will remain intact as products in their own right (On-Premises deployments are not covered by Dynamics 365) and so much of the investment will be as applicable to third-party integration as it will be for the Dynamics brand applications. I really hope that we are starting to see this 'platform first' approach that the Azure team have always taken under Scott Guthrie's leadership now being applied to the Dynamics Business Solutions.

    Why not check out the technologies that are making Dynamics 365 possible:

     

    Posted on 6. May 2016

    CRMUG European Congress 2016

    CRMUG EC Logo

    If you are attending the CRMUG European Congress 2016 in Stuttgart, come and join me in the following sessions:

    Calculate This! (Administrative/ Technical Track)
    Anxious? Indecisive? Do you find it hard to decide on which of the many calculated field options to use when customising Dynamics CRM?

    Lie back and relax as I perform psychoanalysis on the various possibilities with an overview of writing plugins, workflows, portable business logic and using Calculated and Rollup fields.

    "xRM Factor" Panel (Technical Track)

    Let the CRM extensibility games begin. This fun-filled topic embraces a panel of Dynamics CRM users sharing their favourite xRM tool and why they think so. The audience will vote on the top two "xRM Factor" winners who will share their xRM tool or shortcut in a deeper education session to follow shortly.

    Data Migration Tools & Best Practices (Upgrading Track)

    From 3rd party tools to best practices of data migration, join me as we examine planning, upgrading, and overall migration best practices to ensure data quality is at the forefront for your Dynamics CRM deployment.

     

    I'm looking forwards to spending an action packed 2 days with like-minded Dynamics CRM folk!

    @ScottDurow

    Posted on 25. April 2016

    Ribbon Workbench 2016 Beta

    A couple of weeks ago I had both the privilege and a most enjoyable hour on CRM Audio chatting with George, Joel and Shawn about the Ribbon Workbench and SparkleXRM. You'll have heard me mention that I'd be posting details on how to get involved with the Beta version of the new Ribbon Workbench 2016 that's written using HTML and JavaScript rather than Silverlight – so here it is!

    I've had a fruitful relationship with Silverlight over the years and it has been the enabler in many successful rich client Dynamics CRM customisations but things have moved on! In July 2015 the time had come to say goodbye in part because there was no Silverlight in Windows 10's Edge Browser. My main blocker for writing pure HTML and JavaScript Web Resources in the past had always been one a lack of productivity tooling, but that had moved on as well not least because of SparkleXRM, my framework for building rich user interface Dynamics CRM web resources. The Ribbon Workbench 2016 is written using SparkleXRM (although it comes pre-packaged in the solution) and if I'm honest I think one of my drivers originally for working so hard on that project was the inevitability of having to re-write the Ribbon Workbench in HTML one day. Without the framework it would have been a bridge-too-far, but as it happened I was pleasantly surprised as to how easy the conversion process went and I am really pleased with how it's turned out. Here are some highlights…

    Drag and Drop Flyout Editing

    Drag and Drop Flyout Editing

    Delete Undo

    Undo

    Drag and Drop Command Editing

    Drag Drop Command Editing

    Can you help with Beta Testing?

    You can download the beta version by signing up to beta test today!

    Please report issues and bugs via UserVoice! Thank you!

    Posted on 19. February 2016

    SharePoint Integration Reloaded – Part 5 (belated)

    In previous articles in this series we've talked about the differences between Server Side Sync and the old List Component. Since I published the first articles, a new MSDN article on the topic has been posted which I thought would be good to signpost folks to => Important considerations for server-based SharePoint integration.

    One of the topics that has come up recently for people using Server Side Sync to SharePoint is the 5000 item limit of Document Libraries which has led to a bit of panic amongst some so I thought I'd dispel the rumours!    

    Here are the facts about the Throttling Limitation

    1) You can see how many items you have in a Document Library by opening the site in SharePoint and selecting 'Site Content' from the left hand navigation menu. The number of items will show below the Document Library name – this includes documents and folders.

    2) If you have more than 5000 items you can still use Server Side Integration with SharePoint provided that you only use the default sort order of the document view in CRM.

    The default sort is by Location Ascending. You can change this to sort Descending but if you change the sort to any other column you will receive the error "Throttling limit is exceeded by the operation"

    3) If you have a record with only 2 documents in the associated document locations folder you will still not be able to sort by any other column other than Location if the root Document Library has more than 5000 items overall.

    3) If the user clicks on 'Open SharePoint' then they will be able to do all the sorting they need since the limitation is not experienced by the native SharePoint interface – only the CRM document lists.

    I find that this sort limitation is not an issue because I encourage users to use SharePoint freely due to its rich interface. Don't try and hide SharePoint from them because it's important to understand the way in which documents are stored and the additional features that SharePoint has to offer. The documents view in CRM is simply to be used as a quick reference for documents associated with the CRM Record.

    Hope this helps!