Archive of posts tagged data import

Fixed-width text files in data management (F&O)

Posted by on

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)’ »

Test Data Transfer Tool: Getting errors from log

Posted by on

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’ »