When you open a data entity in Data Connector in Excel (usually from an F&O form by Open in Excel), not all fields must be displayed by default. You can go to Designer and add more fields from Available to Selected. But what if you want some fields included by default? You could create a …
Data management in Dynamics 365 for Finance and Operations supports several types of files for import and export. I usually see XML, Excel and CSV used, but sometimes we also need to deal with a text format with fixed-width columns. It means that there is no column separator as in CSV – we know that …
Continue reading ‘Fixed-width text files in data management (F&O)’ »
I imported data to AX with the Test Data Transfer Tool and it told me that some errors occured. The log file is quite large, so I asked myself what’s the easiest way to find these errors. This is my approach, using a very simple Powershell script: [xml]$dplog = Get-Content C:\Windows\System32\dplog.xml $dplog.root.item | ? Status …
Continue reading ‘Test Data Transfer Tool: Getting errors from log’ »