Microsoft Dynamics CRM (Archived)

How to export schema name of all the fields in the entity into excel file of the Entity using c#

(0) Share

Report

Posted on by Community Member

Hello Guys,

I am developing a console application by which i want to export the list of fields schema name into a excel file.

The Entity Name is the parameter i am using and the connection to the CRM is being established by WEB API.

There is a condition i want to put that only DateTime type fields should be there in the excel.

And i am also trying the EntityMetaData class but its not getting done.

Any help from you guys would be greatful.

Shashikant Saxena

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Hi Shashikant,

I would really recommend, you use XRM tool box plugin "Metadata document generator" using which you can generate the schema excel file from any entity on a single cllick.

Later you can apply filter on your excel?

Regards,

Rawish

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Otherwise , have a look here :

docs.microsoft.com/.../jj733870(v%3Dcrm.8)

MetadataConditionExpression[] optionsetAttributeTypes = new MetadataConditionExpression[] {

new MetadataConditionExpression("AttributeType", MetadataConditionOperator.Equals, AttributeTypeCode.Picklist),

new MetadataConditionExpression("AttributeType", MetadataConditionOperator.Equals, AttributeTypeCode.State),

new MetadataConditionExpression("AttributeType", MetadataConditionOperator.Equals, AttributeTypeCode.Status),

new MetadataConditionExpression("AttributeType", MetadataConditionOperator.Equals, AttributeTypeCode.Boolean)

};

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Sashikant,

As Rawish already suggested, XRMToolbox metadata generator plugin is the best way to export entity schema in Dynamics CRM.

See here the steps-

bhoopathigoudk.blogspot.com/.../extract-ms-dynamics-crm-fields-to-excel_4.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply but that's the catch in this scenario that i cant use XRM TOOL box.

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Okay so you can use the MetadataConditionExpression class as shared earlier. Hope that will help.

docs.microsoft.com/.../jj733870(v%3Dcrm.8)

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Sashikant,

Sorry I missed your subject line C# . Here is the reference will be useful for you -

For Entity -

docs.microsoft.com/.../sample-dump-entity-metadata-file

For Attributes -

docs.microsoft.com/.../sample-dump-attribute-metadata-file

Was this reply helpful? Yes No
Suggested answer

Frank Miller 10 on at

Like (0)

Report

You can try ZetExcel. then your work will be easy. just try and get result. thanks

Was this reply helpful? Yes No