Storing custom configuration settings in Microsoft Dynamics CRM

Since some years, I’m using two custom entities to store some parameters used in JavaScript, Plugins and Custom Workflow Activities. As I have been asked to share them with the community, I’m doing it today?

I have created a managed solution that contains these two entities:

  • Parameters Category : Used to define parameters groups
  • Category : This is the main entity that stores the parameter with the following attributes:
    • Name : This is a display name that can be changed anytime
    • Logical name : This is a name editable only during creation
    • Category : To indicate in which group of parameters the parameter belongs
    • Description : no need of explanation here
    • Value type : define the type of value
    • Value : depending of the type, the appropriate control is displayed. When saving the value is also copied to a global text attribute named “global value”

This way, I can store typed parameters for multiple usages:

  • Storing counter current value
  • Storing url of an external application
  • Storing a date of a last execution of any process
  • Setting a debug flag to display additionnal information in some process
  • etc.

Here is a screenshot of the form

image

The solution supports French and English languages and is compatible with Microsoft Dynamics CRM 2011 and 2013.

As usual here, the solution is available on CodePlex

Comments

Andy said…
tanguy, there's a bug in the plugin on update (the given key was not present in the dictionary)
April 17, 2014 at 1:45 AM
Andy said…
private static void CopyLocalToGlobal(Entity inputData)
{
switch (((OptionSetValue) inputData.get_Item("mctools_valuetype")).get_Value())
{
case 1:
inputData.set_Item("mctools_globalvalue", inputData.get_Item("mctools_textvalue"));
break;
case 2:
inputData.set_Item("mctools_globalvalue", inputData.get_Item("mctools_memovalue"));
break;
case 3:
inputData.set_Item("mctools_globalvalue", (bool) inputData.get_Item("mctools_boolvalue") ? (object) "Oui" : (object) "Non");
break;
case 4:
inputData.set_Item("mctools_globalvalue", (object) ((int) inputData.get_Item("mctools_integervalue")).ToString());
break;
case 5:
inputData.set_Item("mctools_globalvalue", (object) ((Decimal) inputData.get_Item("mctools_decimalvalue")).ToString());
break;
case 6:
inputData.set_Item("mctools_globalvalue", (object) ((float) inputData.get_Item("mctools_floatvalue")).ToString());
break;
case 7:
inputData.set_Item("mctools_globalvalue", (object) ((DateTime) inputData.get_Item("mctools_datevalue")).ToString("dd/MM/yyyy"));
break;
}
}
April 17, 2014 at 1:46 AM
Microsoft Dynamics CRM said…
Thank you tanguy.. it is fine.. working with me...
June 5, 2014 at 4:29 PM
microsoft dynamics crm said…
thank you tanguy for given Storing custom configuration settings in Microsoft Dynamics CRM
June 20, 2014 at 11:54 AM
Unknown said…
This is really interesting, You are a very skilled blogger. Thanks for sharing with us
January 3, 2015 at 11:29 AM
Post a Comment

Popular posts from this blog

New XrmToolBox plugin : Import/Export NN relationships

Image
Two plugins in one day! wow! This one was, in fact, developed a couple of months ago. One of my colleague was using a solution from my fellow MVP Andrii Butenko which allows to import/export NN relationships in a silverlight web resource. This was nice but my colleague was using other attributes than primary key to do the mapping and Andrii’s solution does not support this. So he asked me to develop a XrmToolBox’s plugin that could do this. And, here it is! You can select entities and relationships and moreover, choose mapping attributes on both enitities. I only let text and number attributes selectable as other does not really make sense for mapping purposes. Then you can import or export NN relationships! Here is a preview As usual, this plugin, among other, is available with XrmToolBox on CodePlex
Read more

Searchable Propery Attribute Updater

Image
Hi, The previous post was not the last one... :) You can find in this post the first tool that will make your life easier: Just remember when you customer asked you to remove all these unused attributes form the attribute list of the advanced find form... You navigated through all attrbutes form to modify the Searchable property of each attributes for hours... (maybe am I exaggerating a bit...) The program I give you allows you to update all attributes in a single winform application! Yes it can be! Do not hesitate to give me your comments about this program if you think improvements can be done... Download:
Read more

Full featured CRM grid in HTML/JS

Image
In last December, I was asked to write a web resource to display a grid with CRM records. I was quite frustrated because I didn’t succeed to manage some grid features easily like fixed header with horizontal scrolling among others. I delivered a fixed table which was not so bad but absolutely not something that look like the application grid views. So I decided to work harder to find a way to do this CRM style grid view. After some works (almost two full days), I have succeeded to create a full featured CRM grid view by using only JavaScript. Here is a screenshot: And this is how I can create a grid view from only a div in a HTML page < html > < head > < title > Page de test </ title > < script src ="json2.js"></ script > < script src ="jquery.js"></ script > < script src ="XrmServiceToolKit.js"></ script > < script src ="sdk.metadata.js"></ script > ...
Read more