{"id":717,"date":"2021-08-07T20:10:51","date_gmt":"2021-08-07T20:10:51","guid":{"rendered":"http:\/\/markedcode.com\/?p=717"},"modified":"2025-04-07T11:49:44","modified_gmt":"2025-04-07T11:49:44","slug":"d365-exporting-csv-file-from-dmf-without-headers","status":"publish","type":"post","link":"https:\/\/markedcode.com\/index.php\/2021\/08\/07\/d365-exporting-csv-file-from-dmf-without-headers\/","title":{"rendered":"D365 &#8211; Exporting CSV file from DMF Without Headers"},"content":{"rendered":"<p>The other day, I had a requirement to export a CSV file from Dynamics 365 for Finance and Operations without header values indicating the fields.<\/p>\n<p>To do this, I navigated to the Data Management workspace. Then I created a new data project.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-718\" src=\"http:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/DMF-205x300.png\" alt=\"\" width=\"205\" height=\"300\" srcset=\"https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/DMF-205x300.png 205w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/DMF.png 580w\" sizes=\"auto, (max-width: 205px) 100vw, 205px\" \/><\/p>\n<p>I added the data entity to the project that I wanted to export and made the export format CSV.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-719\" src=\"http:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/AddEntitiy-300x203.png\" alt=\"\" width=\"300\" height=\"203\" srcset=\"https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/AddEntitiy-300x203.png 300w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/AddEntitiy-1024x693.png 1024w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/AddEntitiy-768x520.png 768w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/AddEntitiy.png 1098w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>When the data entity is added to the line of the data project, I clicked on the source data format (CSV).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-720\" src=\"http:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/Line-300x48.png\" alt=\"\" width=\"300\" height=\"48\" srcset=\"https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/Line-300x48.png 300w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/Line-1024x164.png 1024w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/Line-768x123.png 768w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/Line.png 1325w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>From here I see both formats for CSV, and clicked into CSV.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-721\" src=\"http:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/sourceDataFormat-300x85.png\" alt=\"\" width=\"300\" height=\"85\" srcset=\"https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/sourceDataFormat-300x85.png 300w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/sourceDataFormat-768x217.png 768w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/sourceDataFormat.png 862w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Now I can see several ways to format the output of my file, most importantly I can toggle on and off showing headers when exporting this data entity, in the project.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-722\" src=\"http:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/ConfigureDataSource-300x136.png\" alt=\"\" width=\"300\" height=\"136\" srcset=\"https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/ConfigureDataSource-300x136.png 300w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/ConfigureDataSource-1024x464.png 1024w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/ConfigureDataSource-768x348.png 768w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/ConfigureDataSource-1536x697.png 1536w, https:\/\/markedcode.com\/wp-content\/uploads\/2021\/08\/ConfigureDataSource.png 1669w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>I gave it a run and success, the first row in my CSV file is data!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The other day, I had a requirement to export a CSV file from Dynamics 365 for Finance and Operations without header values indicating the fields. To do this, I navigated to the Data Management workspace. Then I created a new data project. I added the data entity to the project that I wanted to export<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[7],"tags":[6],"class_list":{"0":"post-717","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-d365","7":"tag-d365"},"_links":{"self":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/comments?post=717"}],"version-history":[{"count":1,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/717\/revisions"}],"predecessor-version":[{"id":723,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/717\/revisions\/723"}],"wp:attachment":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/media?parent=717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/categories?post=717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/tags?post=717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}