August 31, 2016

Recurring Data import/Export in AX7

Hi Folks,

Since we have AX7 in market now and many of us already started on this excited version. There are many new things coming in and some are deprecated as well. 

I was facing a requirement on DIXF in AX7 where I need to import a file from a shared path. As AX7 is on Azure now and every export/import will be using blob. So here issues come, how we can use our shared path to import/Export the files. However, I didn’t found any straight forward method for dequeue (export), but successfully done with enqueue(Import).

You can refer below link for more details and download API to support your customization. 




If you check the README file in DIXF sample, where they mention some compatibility issue with CTP8 version, so EXCEL will not have supported there, you may face version issue 

"The version of Microsoft Excel is not supported. -Exception from HRESULT: 0xC020801C"

There is one blog also which can help you somehow but again ODBC is not supported in AX7 because of Azure/cloud thing. 

So what I did here is, I used an XML file to import and it worked for me. It will pick XML file from your defined path and push file into your AX recurring job. All you need to do after getting all parameter for this API, insert your data into an XML file and use this, it should work.

Soon I will post a blog on this API, how to use this with more details on prerequisite.

You can post your question in comment, I would be happy to discuss.

Thanks to my friend Sharran sundar Balasubramaniam who helped me a lot on .net part.

-Harry Follow us on Facebook to keep in rhythm with us. @Facebook https://www.facebook.com/theaxapta