Service Tier
-
Connecting to NAV Web Services from the Cloud–part 4 out of 5
If you haven’t already read part 3 you should do so here, before continuing to read this post. By now you have seen how to create a WCF Service Proxy connected to NAV with an endpoint hosted on the Servicebus (Windows Azure AppFabric). By now, I haven’t written anything about security yet and the Proxy1 which is hosted on the Servicebus is available for everybody to connect to anonymously. In the real world, I cannot imagine a lot of scenarios...
-
Connecting to NAV Web Services from the Cloud–part 3 out of 5
If you haven’t already read part 2 you should do so here, before continuing to read this post. In part 2 I talked about how to connect to my locally installed NAV Web Service Proxy from anywhere in the world and towards the end, I promised that I would explain how the proxy was build. Problem was, that while writing this post I ran into a bug in the Servicebus – which was really annoying. The bug causes my service...
-
Connecting to NAV Web Services from the Cloud–part 2 out of 5
If you haven’t already read part 1 you should do so here, before continuing to read this post. In part 1 I showed how a service reference plus two lines of code: var client = new Proxy1.ProxyClassClient("NetTcpRelayBinding_IProxyClass"); Console.WriteLine(client.GetCustomerName("10000")); could extract data from my locally installed NAV from anywhere in the world. Let’s start by explaining what this does. The first line instantiates a WCF client class with a parameter pointing to a config section, which is used to describe bindings...
-
Edit In Excel R2 – Part 2 (out of 2) – the final pieces
It is time to collect the pieces. The full Edit In Excel R2 solution looks like this Slightly more complicated than the first version – but let me try to explain the pieces NAVEditInExcel is the COM object, which we use from within NAV. This actually hasn’t changed a lot, the only small change is, that the EditInExcel method now takes a base URL, a company, a page and a view (compared to just a page and a view earlier)....
-
Auto Deployment of Client Side Components – take 2
Updated the link to the ComponentHelper msi on 12/11/2009 Please read my first post about auto deployment of Client side components here before reading this. As you know, my first auto deployment project contained a couple of methods for automatically adding actions to pages, but as one of my colleagues in Germany (Carsten Scholling) told me, it would also need to be able to add fields to tables programmatically in order to be really useful. In fact, he didn’t just...
-
Running Code on the Client without deploying COM objects
Yes, it can be done! No, it isn’t .net code – nor AL code. Why? It started out as me being a little too fast when stating that you could easily download a file to the Client and attach it to Outlook without any user interaction – and as you might know that is true, but you might also know that if you go the recommended route: FILE.DOWNLOAD(FileName, ", '<TEMP>',", ToFile); Mail.NewMessage(",",Name,",ToFile,TRUE); FILE.ERASE(FileName); Then you will get an e-mail that...
-
Word Management
As with the release of Microsoft Dynamics NAV 2009, I was also deeply involved in the TAP for Microsoft Dynamics NAV 2009 SP1. My primary role in the TAP is to assist ISVs and partners in getting a customer live on the new version before we ship the product. During this project we file a lot of bugs and the development team in Copenhagen are very responsive and we actually get a lot of bugs fixed – but… not all...
-
Auto deployment of Client Side Components
NOTE: There is an updated post on Auto deployment of Client Side Components here. When you install the RoleTailored Client on a number of clients, you might need to install a number of Client side components as well. This might not sound as too much of a problem when you need to install the client anyway – but lets say you install an ISV Add-on with a live customer, who already have 100 clients install – and now you need...
-
Multiple Service Tiers – SP1
Right around the release of Microsoft Dynamics NAV 2009, I wrote a blog entry with some .bat files on how to create multiple Service Tiers when working with NAV 2009. The blog post is here: http://blogs.msdn.com/freddyk/archive/2008/10/29/multiple-service-tiers.aspx Now NAV 2009 SP1 is about to be released, it is time for a small update. One of the files of the package is a CustomSettings.template file, which really is just the CustomSettings.config with a few values replaced with variable names, so that we...
-
Installing NAV 2009 without A/D
The majority of installations of NAV 2009 will be in a network environment, you will have a domain server and an Active Directory with your users and your biggest worries will be how to setup a 3T environment on 3 different boxes, getting the delegation setup correctly all of that stuff. But in a few cases we might run into situations, where there is only a LAN between a number of machines and no server. In this post I will...
-
Search in NAV 2009 – Part 1 (out of 3)
During the partner keynote and during a couple of the other presentations, we showed a small application, which was able to search in NAV 2009 through multiple tables, display a result set and allow people to drill into task pages in NAV 2009 from the search result window. During the next 3 posts, I will explain how this demo is done and make it available for download. The sample comes with absolutely no warranty, but you can download it and...
-
NAV 2009 and Unicode!
The title might be a bit misleading, but I am writing this post as a response to a problem, which a partner ran into with NAV 2009 – and the problem is caused by Unicode. I am not a Unicode expert, so bare with me if I am naming some things wrong. As you know, NAV 2009 is a 3T architecture and the Service Tier is 95% managed code (only the lower pieces of the data stack is still unmanaged...
-
Transferring binary data to/from WebServices (and to/from COM (Automation) objects)
A number of people have asked for guidance on how to transfer data to/from COM and WebServices in NAV 2009. In the following I will go through how to get and set a picture on an item in NAV through a Web Service Connection. During this scenario we will run into a number of obstacles – and I will describe how to get around these. First of all – we want to create a Codeunit, which needs to be exposed...
-
4 BAT files for the Client Tier
If you haven’t done so, please read the post about Multiple Service Tiers before reading this:-) In my previous post (Multiple Service Tier) I promised to talk about what to do on the Client Tier if you have installed a number of services on a Service Tier computer that all are set to start manually. Do you really have to go to the Service Tier machine in order to start the services or is there a simpler way? As you...
-
The Service Tier
My first technical blog post is going to describe some details about the service tier, that some people might find interesting (and some people might think that this is common knowledge:-)) What is the Service Tier? Very briefly – the Service Tier is the middle tier in a Microsoft Dynamics NAV 2009 installation. This is where all database access is performed and all business logic is executed, meaning also that this is where the application is running. The Database Tier...
-
Multiple Service Tiers
NOTE – there is an updated post reg. Multiple Service Tiers in NAV 2009 SP1 here. If you haven’t done so, please read the post about the Service Tier before reading this:-) A very typical scenario with both partners and customers is to have more than one database. This can be because you have a development database and a production database – or it could be the partner having a copy of all customer databases locally for troubleshooting. You could...

