Edited: added a “warnings” section below Did you ever have to empty a certain table entirely in NAV? Well, I admit, you don’t need to do this too often. And definitely not in a repetitive way. Well, I came across a situation where I needed to delete all millions of records from a table every …
Tag: Development
Permanent link to this article: https://www.waldo.be/2016/06/30/delete-all-records-in-table-with-cal-truncate/
NAV Upgrade: Import and Compile crashes when NST is running
This is just a small blogpost to mention a few things you need to take into account when you’re working with objects on a large scale – I mean importing, exporting, upgrading, compiling, .. whatever. My scenario I was upgrading a customer from CU3 to CU8. Sure, you might wonder why it took me so …
Permanent link to this article: https://www.waldo.be/2016/06/16/nav-upgrade-import-and-compile-crashes-when-nst-is-running/
Invoke-NAVSQL: Execute SQL queries on NAV databases with PowerShell
Just another CmdLet to bother you with (no really, it’s quite an interesting one – try to keep awake … ;-)). The more you use PowerShell .. and the more you use it for NAV .. you just realize that you have to call out to SQL Server quite regularly. Just a few examples: Backup …
Permanent link to this article: https://www.waldo.be/2016/06/08/invoke-navsql-execute-sql-queries-on-nav-databases-with-powershell/
NAV 2016: All Published Events
Blogging has been low lately. I have been insanely busy with providing content for the Cloud SureStep for Product Development on the DLP, which means: less free time :(. But .. Together with a brilliant colleague, I’m also working on an internal project: A code analyzer in PowerShell. Why in PowerShell .. well .. because …
Permanent link to this article: https://www.waldo.be/2016/05/30/nav-2016-all-published-events/
Apply-NAVDelta to add and remove customizations
Yep, PowerShell again. So the people that deny PowerShell can stop reading now :-). Although I do think this is quite an interesting blogpost on how to work somewhat more easily with deltas, by the use of a function that is part of my PowerShell Module, called: Apply-NAVDelta. I was actually just thinking after my …
Permanent link to this article: https://www.waldo.be/2016/03/16/apply-navdelta-to-add-and-remove-customizations/
Export NAV Application Objects
When working with NAV, you’re familiar of working with objects. And nowadays, we have quite a lot of options, like: Fob file Text file Split text files Delta’s Reverse Delta’s … (more?) Depending on the situation, you might be interested in one of these kinds of exports – if not all. Now, I have been …
Permanent link to this article: https://www.waldo.be/2016/03/11/export-nav-application-objects/
Remove customizations with (Reverse) Deltas
I’m going to explain you a concept that is so simple that you’re probably going to react like: “dude .. come on .. you just totally wasted my time .. this is so obvious.. can’t believe you just don’t take this for granted”. But I’m still gonna. Just because of the fact that the concept …
Permanent link to this article: https://www.waldo.be/2016/03/07/remove-customizations-with-reverse-deltas/
Discovery Event Pattern
I have been working on describing this very interesting NAV Design Pattern that uses events. We have been implementing it a few times, and I just didn’t want to hold it from you. You can find the pattern on “The Microsoft Dynamics NAV Design Patterns Wiki“. The actual design pattern can be found here, but …
Permanent link to this article: https://www.waldo.be/2016/03/02/discovery-event-pattern/
NAV 2016: Hooks or Events?
You don’t get the chance to blog on the 29th of February too much. In fact, you only get one chance in 1461 days .. . So let’s take this opportunity, to bother you with something that I have been thinking about from the moment Microsoft Dynamics NAV 2016 was release: What do we do …
Permanent link to this article: https://www.waldo.be/2016/02/29/nav-2016-hooks-or-events/
NAV 2016 Extension Development Shell on the Azure Demo VM
Now, that’s a long title, isn’t it? 🙂 I was in a conversation with Freddy Kristiansen .. the so called “father” of the “Azure Demo VM Image for NAV 2016” (or how do you kids call it these days). If you haven’t heard about that, I strongly advise you to check out for example MVP …
Permanent link to this article: https://www.waldo.be/2016/02/25/nav-2016-extension-development-shell-on-the-azure-demo-vm/