--- title: 'D365 F&O Fixed width file format' url: 'https://kb.hills-family.uk/blog/d365-f-and-o-fixed-width-file-format' markdown: 'https://kb.hills-family.uk/blog/d365-f-and-o-fixed-width-file-format.md' date: '2021-06-16' description: 'Fixed width a.k.a. fixed-character file is a file that is not delimited. That is, a file which contains rows and columns where the columns are not delimited by any special characters like commas (comma separated files .csv) or tabs (tab delimited files) but the columns are broken down based on the character length of each field/column. Configure fixed wid' taxonomy: tag: - 'Dynamics AX' - 'D365 Finance and Operations' - 'Data Management Framework' --- # D365 F&O Fixed width file format [ Home ](https://kb.hills-family.uk/) [ Blog ](https://kb.hills-family.uk/blog) D365 F&O Fixed width file format 16 *Jun* #### [D365 F&O Fixed width file format](https://kb.hills-family.uk/blog/d365-f-and-o-fixed-width-file-format) [Dynamics AX](https://kb.hills-family.uk/blog/tag:Dynamics%20AX) [D365 Finance and Operations](https://kb.hills-family.uk/blog/tag:D365%20Finance%20and%20Operations) [Data Management Framework](https://kb.hills-family.uk/blog/tag:Data%20Management%20Framework) ![](https://kb.hills-family.uk/images/f/6/8/0/8/f6808b04f940c2338e76c753b2eb678492de3bcd-configuredatasource.png) Fixed width a.k.a. fixed-character file is a file that is not delimited. That is, a file which contains rows and columns where the columns are not delimited by any special characters like commas (comma separated files `.csv`) or tabs (tab delimited files) but the columns are broken down based on the character length of each field/column. #### Configure fixed width file for import and export using DMF In your D365 F&O navigation menu navigate to either - Workspaces → Data Management, or - Modules → System administration → Data management. In the Data management area, click the button *Configure data source*. ![ConfigureDataSource](https://kb.hills-family.uk/images/1/c/3/0/6/1c306fd3e18a0a199c72ccff03ca5febbdd4861f-configuredatasource.png "ConfigureDataSource") Create a new data / file format, specify a name and select *fixed-width* in the file format option. ![FileFormat](https://kb.hills-family.uk/user/pages/03.blog/d365-f-and-o-fixed-width-file-format/FileFormat.png "FileFormat") You can also specify your row delimiter to be `CR,LF`, etc. Let’s say that we build a file with the following schema of fields and number of characters that constitute each field. - Code – 3 characters - Name – 5 characters - Some text – 6 characters - Description – 30 characters - ID – 8 characters - Level – 1 character - Long description – 29 characters Here’s an example of a flat file with the above mentioned fixed-width file format. ``` AAAME123WORKS THIS IS A TEST COLUMN DATA 12345 JEVERYTHING IS POSSIBLE AAAME421SUPER EVERYTHING IS POSSIBLE 56789 AFOR A DEVELOPER ``` If we had to split the first row of the file into columns it should be - Code – `AAA` - Name – `ME123` - Some text – `WORKS␣` - Description – `THIS IS A TEST COLUMN DATA␣␣␣` - ID – `12345␣␣␣` - Level – `J` - Long description – `EVERYTHING IS POSSIBLE␣␣␣␣␣␣␣` Hope this gives an idea of how a fixed-width file is supposed to work. Happy learning! [ Next Post](https://kb.hills-family.uk/blog/fixed-width-file-export-row-delimiter-issue) [Previous Post ](https://kb.hills-family.uk/blog/overcoming-d365-f-and-o-fixed-width-character-file-limitations) #### Knowledge Base Tips, tricks and how-to guides on various topics. #### Popular Tags [Linux](https://kb.hills-family.uk/blog/tag:Linux) [Dynamics AX](https://kb.hills-family.uk/blog/tag:Dynamics%20AX) [D365 Finance and Operations](https://kb.hills-family.uk/blog/tag:D365%20Finance%20and%20Operations) [Network](https://kb.hills-family.uk/blog/tag:Network) [Data Management Framework](https://kb.hills-family.uk/blog/tag:Data%20Management%20Framework) [Logic Apps](https://kb.hills-family.uk/blog/tag:Logic%20Apps) [JavaScript](https://kb.hills-family.uk/blog/tag:JavaScript) [netcat](https://kb.hills-family.uk/blog/tag:netcat) [SSH](https://kb.hills-family.uk/blog/tag:SSH) [PowerShell](https://kb.hills-family.uk/blog/tag:PowerShell) [Virtual Machines](https://kb.hills-family.uk/blog/tag:Virtual%20Machines) [VMware](https://kb.hills-family.uk/blog/tag:VMware) [SQL Server](https://kb.hills-family.uk/blog/tag:SQL%20Server) [Wireshark](https://kb.hills-family.uk/blog/tag:Wireshark) [Python](https://kb.hills-family.uk/blog/tag:Python) [Licensing](https://kb.hills-family.uk/blog/tag:Licensing) [Ubuntu](https://kb.hills-family.uk/blog/tag:Ubuntu) --- ## Navigation - Parent: [Blog](https://kb.hills-family.uk/blog.md) - Previous: [Fixed width file export row delimiter issue](https://kb.hills-family.uk/blog/fixed-width-file-export-row-delimiter-issue.md) - Next: [Overcoming D365 F&O fixed width/character file limitations](https://kb.hills-family.uk/blog/overcoming-d365-f-and-o-fixed-width-character-file-limitations.md)