Microsoft Dynamics 365 Blog

DIXF – Importing data using Excel and ODBC 

2 min read

Consider a scenario where you are running AX 2012 R3 and you want to import data from Excel files using ODBC. Having recently worked a case on this topic, I thought I’d share some of the details on how this can be set up. 1. Background The main reason we were looking into this way…Read more

0 Comments

DIXF – Cannot Preview source file – CommunicationException – An error occurred while receiving the HTTP response from DMFServiceHelper.svc 

1 min read

Consider a scenario where you are importing data using DIXF, and you get an error when you try to “Preview source file”. 1. The error The error you see looks something like this: System.ServiceModel.CommunicationException: An error occurred while receiving the HTTP response to http://servernamehere:7000/DMFService/DMFServiceHelper.svc. This could be due to the service endpoint binding not using the…Read more

0 Comments

DIXF – Importing Data – How to establish which rows you need to look at when you aren’t able to import every row in your input file 

2 min read

Consider a scenario where you are importing a lot of data using DIXF, but one or more of the rows in the input file contain “bad data” that result in some rows not being imported OK into your staging table. How do you establish which rows are the problem, so that you can correct them?…Read more

0 Comments