CommaIO for Flat File Integrations
By Kent Smith in Development, Dynamics AX, System - AX, Uncategorized on Tuesday, May 12th, 2009
I was reminded this week that while the Application Integration Framework is a fantastic tool, many systems that people integrate with do not have XML capability out of the box. Most systems however, will have the ability to export a flat file (.csv, etc). While I prefer the ease of use of the exchange of AIF, sometimes it is not cost effective to implement. The flat files can instead be easily integrated with Dynamics AX by creating a class that extends RunBaseBatch to get a file name from a user, then use the CommaIO class to process that file. The method below is an example of a method that could be run after getting the Filename back to the class:
About Kent Smith
Posted in Development, Dynamics AX, System - AX, Uncategorized
Need Expert Help With Dynamics AX?
Get the support you need to effectively manage your business.
Learn more about our Dynamics AX support options
Hi,
I want to create file on the server behind from scene from dynamics AX.
Do you have any code which will do that.
I am using Asciiio to create file but its not getting created.
Any help will be appreciated
Hi Hirdey,
If you use a W instead of R, AsciiIO will perform the same function. You’ll also want to change the read method call to a write method. That should do the trick for you.
Also, be sure to set the class and the menu item to run on the client, not the server. If its set to server or called from, it will generate an error.
Kent Smith
[...] fantastic tool, many systems that people integrate with do not have XML capability out of the box. CommaIO for Flat File Integrations | Microsoft Dynamics AX, CRM & GP Blog home • contact • blog • fb • twitter to experience pearltrees [...]