Search This Blog

Wednesday, September 21, 2016

New XrmToolBox plugin : Attribute Usage Inspector

A colleague of mine recently asked if it was possible to inspect data usage to determine which attributes are useless in a CRM 2016 organization because not filled with any value. My first answer was: no. I used to know a solution named CRM Data Detective that does the same but for CRM 4 and CRM 2011 only.

Ok, I was wrong and found out that a version for CRM 2015/2016 also exists.

Anyway, the major problem with this solution is the fact that if the entity you want to inspect has more records than the AggregateQueryRecordsLimit (which is 50,000 in CRM Online and cannot be updated), then you don’t get real usage statistics.

This plugin resolves this limitation by querying actual records instead of performing aggregation query (only if aggregation query fails because of the limit). This can impact performance but if you really needs it, you get it.

You can also export the result in a raw Excel file.

Here is a screenshot


As usual, please use the Plugins Store in XrmToolBox to get this plugin.

Happy inspection!

Friday, June 10, 2016

Improved Iconator for XrmToolBox

Hi Dynamics CRM community! It’s been a long time since the last article on this blog!

Today, I want to share with you what’s new on Iconator plugin for XrmToolBox and where these changes come from.

Believe it or not but,  in my day to day consultant work, I’m not customizing Dynamics CRM anymore but mainly focus on development. So, working with Dynamics CRM icons was not part of my job. But lately, I had to work on a project with me and myself only, so it did require that I create entities and update their icons to have a shiny CRM application. And even if Iconator is a helpful plugin, it was not helpful enough. The major concerns were:

  • Cannot set entities color. You can do it in customizations but one by one entity.
  • Icons used in SiteMap (the 32x32 pixels white ones) don’t fit well if the white color touch icon edges. This is particularly true with icons from (which I recommend, by the way)

You know me, it couldn’t stay that way… So I updated Iconator plugins

First, I added possibility to optimize 32x32 images. To do so, click on “Optimize 32x32 Images” button. A dialog opens and shows all 32x32 images that don’t have a 2 pixel transparent border. The dialog shows how the optimized images will fit in its 32x32 canva. You can also change the background and icon color (for preview only) to see what it looks like with you own custom theme. Select images to optimize and click on “Update Icons” and Voilà!


Second point, being able to change Entity color. Let’s imagine I optimized and apply the above icon to the selected entity. By clicking on “Change color” button, I can select another color for the entity, preview the change and apply it by clicking on “Apply color change” button.


Last point, it’s now possible to select multiple entities to update their icons and color in one single operation.

This update will be available soon in the XrmToolBox Plugins Store so keep an eye on it or follow me on Twitter (@TanguyTOUZARD) to be notified when the plugin update is available.

Thursday, April 28, 2016

Welcome to the XrmToolBox Plugins Store

Wow! It's been a long time since I did not write an article on my blog!

Today, I'm releasing the April 2016 version of XrmToolBox. This new version comes with an integrated plugins store. So, what does it mean?

It means each and every developer can share his/her XrmToolBox plugins without the need to ask me permissions or help to distribute the plugins across the world.

Here is what the Plugins Store looks like

As you can see, Jonas Rapp and Daryl Labar already shared their plugins through this new channel. To install their plugins, just select them and click on "Install selected packages" button and you are good to go!

The Plugins store is also capable to detect that a new version of an installed plugin is available and let syou update it.

The Plugins store is launched automatically after XrmToolBox startup but you can disable this in the store form itself or in XrmToolBox options. The Plugins Store is also available from the main application toolbar.

So, what do you need to do if you want to share your XrmToolBox plugin? Just follow this procedure on XrmToolBox wiki

Finally, you can download this new version on the XrmToolBox website, as usual. Or maybe you installed March version and if everything goes as expected (crossing fingers), you should be able to update your XrmToolBox application automatically thanks to the XrmToolBox auto updater released in previous version.