Exporting to Excel in AX7

So, last week Microsoft released the RTW version of the new AX version called Microsoft Dynamics AX.

One of my colleagues was playing around with it a bit and bumped into a problem. When he tried to export to Excel he got the following:

The browser tries to connect to this address (and obviously this does not exist)

http://127.0.0.1:10000/devstoreaccount1/office-exports/

The reason for this is of course that the web app is trying to access the server on IP 127.0.0.1 port 10000 and since I am not doing this logged into the server console it will not work (it does work if i am logged in to the console)

To get this working you need to do these operations:

  1. On the server edit the file C:\Program Files (x86)\Microsoft SDKs\Azure\Storage Emulator\AzureStorageEmulator.exe.config and change the IP to the correct address (or name)
  2. Edit the file C:\CustomerServiceUnit\DOBind\Packages\Cloud\AosWebApplication\AosWebApplication.csx\roles\AosWeb\approot\web.config and change <add key=”AzureStorage.StorageConnectionString” value=”UseDevelopmentStorage=true” /> to <add key=”AzureStorage.StorageConnectionString” value=”UseDevelopmentStorage=true;DevelopmentStorageProxyUri=http://YourLocalIP” />
  3. Open the tcp ports 10000, 10001 and 10002 to the server
  4. Links:
    https://translate.google.com/translate?hl=en&sl=auto&tl=en&u=http%3A%2F%2Faxforum.info%2Fforums%2Fshowthread.php%3Fp%3D325949 (with a little help from Google Translate)

Leave a Reply