32

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

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 would accept a comment on the Excel column header describing the attributes of the column (size, label, helptext).

Category: Data Management

I

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

Category: Data Management

I

Really a great Idea!


Also thanks for the tip with the table browser.

Category: Data Management

I

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