Introducing Erik’s ClientUserSettings.config Editor

One of the things that Microsoft has chosen to hide well is the configuration of the role tailored client. There is a file called ClientUserSettings.config that is hidden away on your PC. This file controls how the client connects to the service tier. Most of the times you don’t need to change anything in the file, but sometimes it is needed.

If you are a NAV developer it can happen quite often of you got installations with different authentication styles or other settings.

The file is located under AppData, a hidden folder, under your user account.

I got tired of searching and editing this file, so I created a small utility that would help me, introducing Erik’s ClientUserSettings Editor.

Simply run this program, it will search your PC for all .config files (in case your got more than one version of NAV installed)

client-config1

It will show all parameters in the file with values in the right column.

client-config2

If you got more than one config file on your PC, select the correct on from the combo box in the top.

bclient-config3

And as an extra little bonus, I’ve added the help text from Microsoft’s website to each field, so when editing, you’ll get a helping tooltip presented.

As soon as you have enter a value in a field the file is saved and ready to use.

Download from here: EriksNAVClientConfigEditor

Windows 10 on Lenovo X1 Carbon Touch (2014)

I just spend 3 hours trying to upgrade to Windows 10 on my lenovo X1 Carbon touch (2014 model).

The upgrade failed with error code 80240020 – Lots of suggestion on the net about deleting all content from the download folder in c:\windows\softwaredistribution. That didn’t work :(

The culprit turned out to be the driver for the builtin 4G LTE modem. From Sierra Wireless, the EM7345. This software have not been update by Lenovo System Update.

Download from:

http://support.lenovo.com/my/ms/downloads/ds101007

Microsoft Dynamics NAV and Windows 10

So July 29 2015 is the big day for Windows 10.  I have tested all the versions of NAV I have available on Windows 10 and the list is basically the same as with Windows 8.

The first version I tried was “Navision 3.56a” – The character based predecessor to Microsoft Dynamics NAV.

navi356

That worked fine (With the NAVIN.EXE executable).

After this, Financials 1.30 was up, but a rather disappointing result. FIN.EXE does not start, it ask for elevated permissions, and the bombs out.

windows10-fin260

The same things happens for:

Financials 2.00
Financials 2.60
Attain 3.01
Microsoft MBS Navision 4.00sp3

The oldest version that works with Windows 10 is:

Microsoft Dynamics NAV 5.0

windows10-nav50

This is not really a surprise, since Windows Vista, Windows 7 and Windows 8 had the same problem. But after the Windows 10 team showed that even Microsoft Office 95 worked on Windows 10, I had my hope up for the select few that still runs Financials 2.60 and therefor have to stay on XP for now.

Anyway, the rest just works, 2009, 2009SP1, 2009R2, 2013, 2013R2, 2015 and the beta of NAV2016 also works fine on Windows 10.

windows10-nav2016

Microsoft Dynamics NAV2016 Announced

Here are some good stories from my fellow MVPs on the NAV2016 release.

Gary:  http://www.garywinter.net/2015/07/13/the-skys-the-limit-nav-2016-continues-cloud-integration/
Waldo:  www.waldo.be/2015/07/14/dynamics-nav-2016-it-is/
Mark:  http://nav-skills.com/2015/07/13/dynamics-nav-corfu-will-be-named-nav-2016/
Totovic:  http://totovic.com/2015/07/13/nav-corfu-is-now-nav-2016/
Saruav: http://saurav-nav.blogspot.be/2015/07/microsoft-dynamic-nav-2016-yes-thats.html

Azure SQL Introduction for NAV Users

Yesterday is was announced that NAV2016 will have support for Azure SQL. This is a short introduction to Azure SQL for Microsoft Dynamics NAV users and developers.

Azure SQL is “SQL as a Service”, access to a SQL database without having to host or run a Microsoft SQL Server installation. Currently with NAV2015 you have to host a MSSQL Server on a virtual machine to have a NAV database in cloud.

So, to get started, you need to access your Azure administration, either through the old manage.windowsazure.com or the new portal.azure.com (Used here)

Click new, select Data+Storage and select SQL Database:

azure-sql-1

Unless you have already created a “server”, you need to do that. The server defines in what datacenter your database will be located, and defines the credentials needed for access.

azure-sql-2

After you got a server, you must create the database. You have the following configurations options:

Select Source – Azure SQL has the this really cool extension SQL method “CREATE DATABASE <name> AS COPY OF <other name>. So it is really easy to duplicate databases within same “server”. If you  don’t have other databases yes, just keep “Blank database”.

Pricing Tier – Select how powerful this database should be. Standard S0 is rated a 512 transactions pr. minute. A P3 server is 735 transactions pr. second.

You can see prices here: http://azure.microsoft.com/en-us/pricing/details/sql-database/

And you can read more about SQL sizing here: https://msdn.microsoft.com/library/azure/dn741327.aspx

The price tier also selects for how long Azure keeps backups.

Collation – This is the same at “normal” SQL – So select the collation you need.

Resource Group  – Not very important at first. If you got lots of different Azure services, you can group them in resource groups.

Subscription – Who is picking up the bill for this. If you got more than one Azure subscriptions, select the right now.

Click create, and you got a database (and a server).

azure-sql-3

All Azure SQL servers are firewalled as default, so you must click on the server, and select Show firewall settingsazure-sql-5

In firewall settings you must add the IP address of server and networks that will have access to the Azure SQL server. When you create the server, you can select “Allow access to Azure services” to allow access from other Azure services.

azure-sql-6

 

And right now, this is a far as we can come, with the current information released from Microsoft.

This next question that comes is, how do we get data from a local SQL database to our new Azure SQL database. Clicking on “Restore” in the top does snot help. That is access to the automated backups that happens on Azure SQL.

The official way, is to use bacpac https://msdn.microsoft.com/en-us/library/azure/jj156148.aspx

I find this cumbersome and so far, the best solution I have found for transporting data to and from Azure SQL is the “SQL Database Migration Wizard” https://sqlazuremw.codeplex.com/

This tool will export any database to script files that can be imported on Azure (and the other way). It has a lot of powerful features from selecting specific tables to stripping collation information on columns and much more.

Azure SQL has a very powerful backup/restore functionality,  a backup is made every hour, and transaction logs are backed up every 5 minutes. Standard tier backup are saved for 14 days, Premium for 35 days.

azure-sql-4

You can read more here: https://msdn.microsoft.com/en-us/library/azure/jj650016.aspx

This is one of the corner stones for a cloud ERP, and is a really important step for NAV to become a 100% cloud solution. Next step would be to run the service tier as a worker role – One can only wish :)

 

Error compiling dynamic control expression

Dynamic expressions in NAV2015 is a great way to automate user interfaces behavior. In the example below we wants to control the Editable status of a field.

The special part is, that if you start using boolean operators like OR AND NOT – You might hit an error message like this:

dynamicexpression

Funny enough, it is actually a case sensitivity bug in NAV. Change the lowercase and into AND and everything works as excepted.

So even if C/AL is not case sensitive, the dynamic expressions are :)

So my NAV 2015 help server does not return anything when searching

If your NAV 2015 Help Server just replies:

No Results Found For: customer

No matter what you search for, it because the help server uses the indexing service on your server and you have not added the “help” folder to indexing.

index1

So if your Indexing Options dialog look like this (opened from the Control Panel) you need to add the “Help” folder (found in c:\inetpub\wwwroot\DynamicsNAV80Help\ ) to indexing, like this:

index2

Don’t be alarmed if it takes 10-15 minutes before the search returns results, it just need to index all the files…

All of the Microsoft pages dedicated to the Help Server fails to tell that the Indexing service is used and required:

https://msdn.microsoft.com/en-us/library/dn271697%28v=nav.80%29.aspx

http://blogs.msdn.com/b/nav/archive/2013/11/01/how-to-deploy-the-microsoft-dynamics-nav-2013-r2-help-server.aspx

 

Been thinking a lot about my HoloLens Academy Experience ..

After I attended the HoloLens Academy at Build 2015, one question continues to come back in my head:

What would I do with a HoloLens “Dev Kit” ?

Well the HoloLens is about two things:

1. Bringing objects into the physical world and interact with them

2. Change the appearance of the physical world

There is still one more barrier that needs to crossed before we can have a true Star Trek HoloDesk experience – and thats the physical properties of the holograms. We cannot touch them, there is not tactile feedback from a Hologram. Next step would be to combine the HoloLens with with something like this:

https://courses.cit.cornell.edu/ee476/FinalProjects/s2008/crs54_tz36/crs54_tz36/twocolumn.html

The HoloLens can only project holograms in the sweetspot of our vision, so anything that need peripheral vision will not work. An example of that would be soccer, you don’t want to walk around looking at your feet with a HoloLens.

In many ways, you can compare the HoloLens introduction with the Nintendo Wii. There is going to be a few games (Like the Wii Play suite) to get users confortable with the HoloLens. I would love to make a paint throwing game for that:

Imaging a game, where you can throw “paint bombs” in your living room. Use the gaze to aim, perhaps even get a hologram laserpointer, and then use a voice command to throw the paint. That would be fun :)

Another “no-brainer” App would be Cortana – Imaging calling out the “Hey Cortana” and she materialize right in from of your, again in true Star Trek transporter style, and ask what she can help you with. That would be a very cool demo app.

When it comes to business apps, its more in the visualization department I see the HoloLens. If we ever wanted to add a cargo configurator to Glomaris that would be a fun place to add HoloLens support. Imaging your vessel and the different cargoes as a holograms, and you can start trying to see if the jigsaw can be solved. In Foqus Finance a car configurator (change colors, rims, etc.) could also be a HoloLens experience.

I have the www.3dmouthpieces.com website, where you can design mouthpieces for brass instruments. How about a HoloLens designer, where you can, in real-time, construct your mouthpieces. And the finally with a voice command “Print mouthpiece” – sends the model to your 3D printer !