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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No