45
I

Generate Data Entity Workbook including field data types and length/attributes automatically from data management workspace

Ivan Cole on 7/29/2017 3:20:41 AM

Data Entity exports do not show field data types, lengths and attributes.  It also does not show a logical relationship for the related tables/entities. We have been asked by almost every client to provide these details up front so they can map their source data without trial and error.  What we found is that once an initial export is completed this data is populated in the table 


DMFDefinitionGroupEntityXMLFields


you can access this with a specific environment at using this url template.


https://Your.D365.URL.Here/?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntityXMLFields&cmp=USRT&limitednav=true&lng=en-us


We were able to extract the necessary details from this table manually in SQL. Using this data, we created the attached sample workbook. We would like to add a feature to automatically generate this workbook from the Data Management Workspace without manual intervention.  That would include:


1) Summary Workflow Sheet


2) Logical Data View - Context Diagram


3) Data Model with field data types,  lengths, descriptions, help text, etc from the example


4) Sample data extract tab


Thank you


Ivan


 DM - 006 - Customers-Example


 


 


 


 

Category: Data Management
STATUS DETAILS
Under Review

Comments

I

I

RE: Generate Data Entity Workbook including field data types and length/attributes automatically from data management workspace

Vijaykumar Dodia on 7/10/2020 7:21:53 AM

Thanks Ivan, great tip for table browser. Hope MS will action this soon!

Category: Data Management

I

I

RE: Generate Data Entity Workbook including field data types and length/attributes automatically from data management workspace

Valery Moskalenko on 1/15/2020 11:29:35 AM

We have created a tool that generates a similar report for Data Entities. It's Ciellos Dev Tools.

You may find it on the Visual Studio Marketplace or directly from VS. https://marketplace.visualstudio.com/items?itemName=Ciellos.CiellosD365FFOTools

Then use the Metadata Reports menu.

You may generate this report for custom Data Entities and the extended Data Entities.

Category: Data Management

I

I

RE: Generate Data Entity Workbook including field data types and length/attributes automatically from data management workspace

Jonathan Van Herreweghe on 9/25/2019 1:45:30 PM

Once you defined a project in DIXF, you can request the attributes such as (SQL) type, length and enum of all involved data entities in your project using Data entity "DMFDefinitionGroupEntityXMLFields"

/?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntityXMLFields

Category: Data Management

I

I

RE: Generate Data Entity Workbook including field data types and length/attributes automatically from data management workspace

James Chwaszczewski on 4/4/2019 3:27:13 PM

I would accept a comment on the Excel column header describing the attributes of the column (size, label, helptext).

Category: Data Management

I

I

RE: Generate Data Entity Workbook including field data types and length/attributes automatically from data management workspace

Eugen Blehm on 8/17/2017 9:44:44 PM

Vote up! By the way, how did you extract the "Description" information and create context diagram in your sample file? 

Category: Data Management

I

I

RE: Generate Data Entity Workbook including field data types and length/attributes automatically from data management workspace

Jan-Erik Siegmann on 8/15/2017 7:32:03 PM

Really a great Idea!


Also thanks for the tip with the table browser.

Category: Data Management

I

I

RE: Generate Data Entity Workbook including field data types and length/attributes automatically from data management workspace

Thomas Zak on 8/9/2017 2:30:49 AM

We have also had this requirement from most of our customers. We have implemented a solution by extracting the definition of the data entity to a text file (soon to be upgraded to Excel), with the fields, labels, datatypes and field lengths.We put the help text in there, but strangely enough Microsoft seems to have abandoned help text in D365FO. Only about 10% of fields still have help text.

Category: Data Management