Thursday, February 23, 2012

CRM 2011 How to change attribute type in database

Recently I wanted to change the attribute type from 'Single line of text' to 'Multi line text' in CRM 2011. but we cannot do from CRM form. but there is a way to do it.

First you have to find the Single line attribute and multi line attribute from the "Attribute" table. and get the attributetypeId.

then simply update the Multi line attributetypeId with single line attributetypeId.

After that you have to Export the Entity and then Import it again to the CRM system.

Now open the Entity Form and remove the attribute and add it again to the form.

Save and Publish the Form.

That's it. now you will see the changes. btw, this is 'UNSUPPORTED' way.

5 comments:

  1. Please mention this action is not supported

    ReplyDelete
  2. Live on the edge!, i would go for it

    ReplyDelete
  3. Fantastic, It worked like a charm for me :)

    ReplyDelete
  4. At the end, Can you import the modified CRM solution to existing deployment?

    ReplyDelete
    Replies
    1. Yes... You can do Import/Export without any issue.

      Delete

MS CRM 2011 KB Article customization Issue.

Recently I have encountered some issue while customizing Kb Article Entity. I was doing following configuration in Article form. 1. Add Ba...