Client Tier

  • 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...

  • Displaying Company information in Card pages

    I received a question from a customer, who is running multiple companies and often have multiple instances of NAV open with different companies. On the main page, they do have information about what company is the active: but when they have opened a number of Task Pages in the various instances of NAV, they cannot distinguish one from the other. Example: This image tells you the page and the Customer name – and you can easily identify the right page...

  • Timer events on a page

    Have you ever wanted to have an event raised every 10th second on a page in the RoleTailored Client? Wait no more – here is how you can do just that in Microsoft Dynamics NAV 2009SP1. A Timer control is a Non-Visual Add-In I have seen a number of development platforms treat a Timer as a Non-Visual Add-In (including .net) – so I thought I would try to create a non-visual Add-In for NAV – and what better than create...

  • Using touchscreens with the RoleTailored Client

    I LOVE the RoleTailored Client, I LOVE the fact that everything is metadata driven and i LOVE what this will give us (us being everybody using NAV) going forward. As a result of the investments leading to NAV 2009, NAV has by far the most modern UX and the new framework allows us to innovate faster and more consistent than any other ERP solution out there. We can change the UX to follow Microsoft Office 2010 if we decide to,...

  • 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...

  • 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...

  • Creating and Running Hyperlinks

    In the developer help for NAV 2009 (nav_adg.chm), there is a description for creating and running Hyperlinks – I will not try to repeat all the information in the documentation – so please read the documentation before reading this post. There are however a couple of thing, which are not described in detail. My next post is about the Search demo, which was shown at Convergence yesterday (Partner day) – I will describe how this demo is done, in a...

  • Edit In Excel – Part 4 (out of 4)

    If you haven’t read part 3, part 2 (and part 1), you should do so before continuing here. We have seen how to put code inside Excel, using VSTO and connect to NAV 2009 Web Services. We have seen how to add this to a table inside Excel and how to write data back to NAV through Web Services. We can delete, add and modify records in Excel and we can even do so with both Customers, Vendors and Items....

  • 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...