web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Limits in programmatic...
Microsoft Dynamics CRM (Archived)

Limits in programmatically creating new attributes in CRM

(0) ShareShare
ReportReport
Posted on by Macoy 275

Hi,

Are there any limits in programmatically creating attributes in Dynamic CRM 2016 aside from MaxAllowedAttributesForEntity and MaxAlloweColumnsOnSqlViewOrTable. I'm trying to build a solution that creates fields to custom entities using a plugin. I have a list of fields in an excel file with columns Entity Name, Field Name, Data Type. Then I also have a custom entity that have these 3 fields and 3 more custom entities to where the new attributes will be created . So when I try to import my excel file to create records in my custom entity it will trigger my plugin. There where new attributes created in my custom entity  but not all in the excel file where created. When I check the Imports in Data Management all where successful and no errors. 

What seems to be the problem here. Also after import is done, when I try to refresh my page it just show sql error message.

 

Thanks,

Macoy

*This post is locked for comments

I have the same question (0)
  • Verified answer
    ThomasN Profile Picture
    ThomasN 3,190 on at

    Hi Macoy, thank you for reaching out.

    Have you thought about using the CRM Import Wizard to create a data map for the fields you need created, rather than using a plugin to create the fields? You can also export one of the data maps that already exist to explore how you can create your own using XML. It is fairly straight forward. Let me know how we can help.

    Tom

    If this resolved the issue, please mark as an Answer.

  • Macoy Profile Picture
    Macoy 275 on at

    Hi Tom, thanks for the reply.

    I have read this article www.powerobjects.com/.../creating-attributes-import-wizard-crm-2011

    and its really helpful. I already tried the steps in the link to create text,date,optionset fields and its working. But if there are for example 200+ custom fields needed to be created, I have to set create new field 200x. Are there any way to do this without setting configurations or aside from using the wizard.

  • ThomasN Profile Picture
    ThomasN 3,190 on at

    Hi Macoy,

    There may be a way to do that. I am not aware of one, and I previously when I have had that many fields to create I found it was taking less time to create the data map in xml than to write something. Given all the metadata associated with fields it may be best to create the fields individually as well through the customizations interface. The benefit of the data map is it is reusable for importing data later or throughout the migration process. Sorry I could not be more help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans