Answered by:
Is it possible to export schema names for attributes used in all entity forms to a CSV-file?

Question
-
Hi!
Preferably I would like to export only those attributes used in forms for all entities in my CRM, but I realize that it might be hard to find such a tool. Second best would be to export all attributes with name, schema name, data type etc regardless if they are used in a form or not, to an excel file or something. At first I thought that the CRM Meta data browser included in the SDK would solve my problem, but it didn't help that much. Unfortunately it's not possible to export all attributes, the only thing you can do is right click on an attribute and click copy... no CTRL + A, CTRL + C or export to excel :(
Do you guys have any ideas on how I could get attributes with name, schema name out of CRM without writing a custom application myself?
Cheers!
Tuesday, May 31, 2011 1:45 PM
Answers
-
- Proposed as answer by Gonzalo Ruiz RModerator Wednesday, June 1, 2011 12:59 AM
- Marked as answer by Peter Hörnell Wednesday, June 1, 2011 7:27 AM
Tuesday, May 31, 2011 9:42 PM
All replies
-
There is no native way of doing so in CRM as metadata cannot be exported to excel. There is a tool that gives you a nice summary view of all the metadata but it also does not support exporting to Excel (http://crm2011metabrowser.codeplex.com/)
Other than that, I think you'd have to write your own application using the CRM SDK.
Gonzalo | gonzaloruizcrm.blogspot.com
- Proposed as answer by Gonzalo Ruiz RModerator Tuesday, May 31, 2011 2:10 PM
- Unproposed as answer by Peter Hörnell Tuesday, May 31, 2011 3:25 PM
Tuesday, May 31, 2011 2:10 PMModerator -
Can you export in any way with that tool?Tuesday, May 31, 2011 3:24 PM
-
no sorry
Gonzalo | gonzaloruizcrm.blogspot.com
Tuesday, May 31, 2011 3:34 PMModerator -
You may want to consider using the 'MetadataSchema' tables to create an SSRS report, which you can then export. Although direct database access is obviously not a supported way to 'customize' the system, I have used this method for documentation purposes in the past.
Ken Heiman
Tuesday, May 31, 2011 8:02 PM -
- Proposed as answer by Gonzalo Ruiz RModerator Wednesday, June 1, 2011 12:59 AM
- Marked as answer by Peter Hörnell Wednesday, June 1, 2011 7:27 AM
Tuesday, May 31, 2011 9:42 PM -
Thanks for sharing Aaron, quite useful actually!
Gonzalo | gonzaloruizcrm.blogspot.com
Wednesday, June 1, 2011 12:59 AMModerator -
Looks promising! Thanks Aaron!Wednesday, June 1, 2011 7:28 AM