31 October 2013

Search and Replace new lines in Excel

To search and replace newlines in Excel I just found out that you don't use "\n\r" like in all other Tools I know but instead just press STRG + J. Than the cursor changes a little an it will find new lines in cells. Thank you Microsoft for hiding this feature :)

29 October 2013

Data Import Export Framework Installation (DIEF)

If you are installing DIEF for AX 2012 on the AOS and SQL Server you might get an error requesting the GacUtil

To solve this issue I tried to install Microsoft Windows SDK for Windows 7 and .NET Framework 4

But that didn't solve the problem. After the installation I navigated to the folders of the Microsoft SDK where I couldn't find the gacutil. On another machine it was located there. So I just copied itinto the following folders:

C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0\Bin
C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0\Bin\NETFX 4.0 Tools

If you don have the Folder v7.0A instead of v7.0 just use this one. 

For all of you looking for the gacutil it can be downloaded here (without any warranty).

14 October 2013

The specified client configuration does not contain valid WCF settings

When you get the error Message: The specified client configuration does not contain valid WCF settings in Dynamics AX 2012



there is an easy way to fix it. Just open Microsoft Dyanmics AX Client Configuration Tool and load the Configuration or the .axc file that results in this error message.
Got to Connections and click configure. In some cases you need to confirm upcoming dialogs in my case it just went through and after thet the error is gone :)