All around NAV dev and test
One of these of every day things that makes work so easy; you just take them for granted. Getting the 2.2.0 update mail from Christian Clausen, I realized that's what Statical Prism has become for me. No fuss of whatever setup, except for having my code in .txt objects in a directory. Using a source repository, that's what is on my system by default. But hey, let's not repeat what I wrote before.
If you haven't used Statical Prism before, go and try it. If you did and stopped because of some missing features, you might want to pick it up again as the 2.2.0 release has some major features added to it:
Just to mention two.
The first was something really missing; I mean, we very often would like to know where the OnInsert trigger was being called, don't we.
The second as a very nice-to-have one. Typically not on my list, but now looking it ... it's neat. In many cases Find Usages on fields yields a long result list. Often overwhelming. Now it's possible to filter this list.
Say you want to find the usages of the primary key (Code) on the Currency table (4). This would be the result:
451 hits, maybe too many just to browse through. Say you're only interested in the usage related to SETRANGE. Use the Text filter to filter out only hits relating SETRANGE, this will show the following:
Once again: great guys!
As you know my daily work is highly depending on Visual Studio Team Foundation Services, so when last week VS 2017 was released, I immediately installed it and continued my work as before. It's one of those great things of VS: a high up- and downward compatibility. It makes me smile.
Nevertheless there are always a couple of things that I need to reinstall to have my setup the way I want it. Among them:
For this I lately used Steve Fenton's post Add Visual Studio Command Prompt To Visual Studio 2015. Straight forward to implement. However for 2017 it needs some tweaking with respect to the argument:
The VS Command Prompt will now be available in: Tools > VS Command Prompt
Last weekend I spent time to get things working on my Azure machine for the fourth week of the Junior Developer Training. A five week course I am running since last fall for Dynamics 365 Training Ltd. in the UK. While compiling the code of our example application I ran in to the following error:
"Ouch," I thought, "not again."
I had ran into this issue on my laptop a couple of months ago. At that time I was working on some label printing issue with Torben Wind Meyhoff and Niels-Henrik Sejthen, of the NAV team in Lyngby (thanx again guys for stepping in). To solve the label printing issue Torben had proposed to use a WORD layout. But ever since we had upgraded from 2009 to 2016, all our NAV developers did get this error message when compiling any report containing a WORD layout.
Niels-Henrik suggested to make sure to run windows update to see if that might fix the issue. And it did! At least ... on my laptop and our RAS development server. Unfortunately the issue continued for a couple of colleagues on their own laptop. As it wasn't a show stopping case so far we haven't paid much attention to it since then.
But last Sunday ... it hit me again. Arggggg. And I needed to get the WORD reports working! As all updated had been installed on the Azure machine and having not a lot of to time to go and search for a solution, I decided to create a new machine to see if that would work fine.
"And of course it would have the latest NAV 2017 CU!", my mind ran.
YES, the WORD reports compiled. Again issue solved. But not for long as on Tuesday morning when wanting to run my WORD report example, the same error stopped me.
"No time to fix it, pal." So I left it for later, already considering to create, once again, a new Azure machine during evening hours. Nevertheless I had quick look in the Event Log, showing:
---------------------------A call to Microsoft.Dynamics.Nav.DocumentReport.WordReportManager.MergeWordDocument failed with this message: Could not load file or assembly 'DocumentFormat.OpenXml, Version=2.5.5631.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.---------------------------
"A corrupt DocumentFormat.OpenXml assembly?" I wondered, "Let's find out later."
That evening some more important work had to be done first, being, among others, the preparation the Data Upgrade demo for the next course day. The TableSyncSetup part ran as a charm. The real data upgrade part unfortunately didn't, and stopped with an error:
"Great, that's what I needed just now."
"The application will close?" Nope, my NAV development Environment was still running; likewise the NAVCSD Service Tier. What was happening?
Looking at the Event Log I was quite surprised to read:
Exactly the same as with the WORD report issue.
"So solving this would in one go solve two issues," I thought out loud.
Googling around I found some reference to the Open XML SDK 2.5 for Microsoft Office, which I knew is one of the prerequisite components on the product NAV DVD: $\\Prerequisite Components\Open XML SDK 2.5 for Microsoft Office.
"Aha, lets reinstall and see."
YES, both the WORD reports compiled and the data upgrade ran without an errors!
Maybe this post will save you the searching I had to do.
This week my annoyance got that high that I decided to spent some time on getting the issue fixed. I guess we all run into this once in a while: things do not exactly go the way you would like it, but, OK, you manage having some kind of work around. And, best reason of all: you need to get the thing done and don't have time for it to find the proper fix. Or most probably: you don't give yourself time to do that.
"So what was bothering you, brother Luc?", you might be asking yourself. "What mankind thrilling thing did bug you, lat?"
I really love the tiles in Windows 10. Yes, I already loved them in Windows 8, and still wonder why people were detesting it. Nevertheless, what was annoying me lately, was the fact that I could not find a tile for the Dynamics NAV 2017 Administration Shell. I did have one for the Development Shell. I even had a tile for the 2016 Admin Shell. But this one seemed lost somewhere.
As said I had a workaround, but still didn't have the tile. Finally last week I decided to spent some time Goog...., sorry Binging. No, let's be honest. Yes, I am a former MSFTy, and yes, I have been using Bing a lot, but somehow, unconsciously, I did move to Google. My guilty pleasure?
Right ... I was googling and ended up on this page: NAV 2016 Administration Shell shortcut is missing. Seeing the blog title I immediately knew who the author was. Some kind of happiness touched me, seeing your name in the Dynamics blog-o-sphere, Ibrahiem. Great that you joined the community, with a lot of valuable and practical information. And of course, thanx helping me getting rit of my annoyance.
And at the same time I owe you some kind of apology as your blog goes back already 2 years. Totally unnoticed by me. Sorry for that.
Keep us informed!
Haven't been blogging a lot lately, and then it's good to realize I am not the only NAV blogger and thus information sharing keeps going anyway. So thumps up to all my peers!
And even more it's good to know that new bloggers show up regularly. I haven't been welcoming any of them for a long time, so let's use this morning to pick up that series again. Do I hear the drums roaring?
Last week ... finally ... this guy opened his cabinet of NAV experience and knowledge. And hopefully he will keep it ajar for a long time. Offline he proclaimed this is going to be on a monthly basis. Sounds promising, not in the least as I can tell you I have a hard time gertting that done.
So go for it Jan Boes. Welcome to the Dynamics blog-o-sphere!