Skip to main content

Posts

Showing posts with the label DYNAMICS AX Import Export Tool advanced uses

DYNAMICS AX Import Export Tool - digging a bit deeper.

Normally when I've used the export/import-tool in AX, it's because you want to dump data from a small database and import it in another environment, or if you want to install some sort of demonstration database in an environment. Up until now, if I've been presented with a task of importing data into a customers environment, i've always programmed some sort of class that handles the import. A couple of weeks ago, a colleague of mine showed me that the import/export tool, can be used for the same task - that is importing data, from e.g. a .csv-file, that your customer prepared in Excel. I was thrilled to discover that I do not actually always need to make a class to import data in a specific (or more specific) table(s). The procedure is: 1) Create your own Definition group - make sure it is empty by removing all checkmarks on the Set up and include table groups tabs pages, and choose the type User defined. Save the def. group. 2) Now click the Table setup button. Choose