This is my second gadget. My first gadget was the Search gadget, which you can find here.
- Running a Web Service method asynchronous
- Use the same gadget for invoking three different methods
What I want to do is to create a gadget that can show My Customers, My Vendors or My Items.
The flyout from the gadget should be additional information about the record in the gadget, like
Clicking on the customer number should open the Customer Task Page and it should be easy to add additional information to this window (the things that are interesting to quickly get access to for our users).
In the Settings dialog you should be able to control things like
I will not discuss My Activities in this post, although it would be cool to have a Vista Gadget with My Activities (must do that some other day).
Ready? – well here we go…
The GetMyStuff Codeunit
In NAV we need to expose something, through which we can get access to My Customers, My Vendors and My Items – and the easiest thing would of course be to just expose the 3 pages: 9150 (My Customers), 9151 (My Vendors) and 9152 (My Items).
The problem with this approach is, that we need to get a bookmark back (for opening Task Pages) from the Web Service – meaning that we either create another field in these pages – or we create another Web Service Method for returning the bookmark. I really don’t want to modify base objects if I can avoid it and adding another function just multiplies the number of times we invoke Web Service method by a factor, which I am not interested in doing either.
So I am going to go with a Codeunit, 3 XML ports – and the Codeunit basically just have these three functions.
GetMyCustomers(VAR result : XMLport “My Customers”)
GetMyItems(VAR result : XMLport “My Items”)
GetMyVendors(VAR result : XMLport “My Vendors”)
Now returning a XMLPort (which is a NAV construct) from a Web Service sounds weird – and of course we do NOT return the XML Port object to the Web Service Consumer. What we get is the output of the XMLPort – and if you send data into the XMLPort, it is going to run the XMLPort for input.
The XMLPort for My Customers looks like:
and if we take a look at the WSDL for a Codeunit which returns this XMLPort, the schema for the return type very much looks like the above definition
and the schema for the method references this as both input and output
In the XMLPort properties, I have set the following properties
and in the Table element properties MinOccurs is set to Zero. If MinOccurs is 1 (the default), the XMLPort will return an empty My Customer if the list is empty – we do not want that.
Codebehind on the XMLPort sets the three variables _Name, _Bookmark and _Phone.
MyCustomer – Export::OnAfterGetRecord()
rec.GET(“My Customer”.”Customer No.”);
_Name := rec.Name;
_Phone := rec.”Phone No.”;
_Bookmark := FORMAT(ref.RECORDID,0,10);
Where rec is type Record of Customer and ref is a RecordRef.
The My Vendors and My Items XMLPorts are created following the same pattern and my gadget code will be made in a way, so that additional fields in the XMLPort will be displayed in the flyout – so you can add whatever you want to this XMLPort.
The main HTML body contains two areas, in which I insert the content via DHTML. These areas are called CAPTION and CONTENT.
CAPTION is for holding the top part of the gadget, where is says My Customer, My Vendor etc. and CONTENT is for holding the list of records. The reason for the caption to be dynamic is that it changes based on the selected type of course.
The first code executed in the script (except for the variable declarations) is the onreadystatechanged event handler – and note that the construct
// Microsoft suggests using onreadystatechange instead of onLoad
document.onreadystatechange = function()
// Initialize Settings
System.Gadget.settingsUI = “settings.html”;
System.Gadget.onSettingsClosed = settingsClosed;
// Initialize flyout
System.Gadget.Flyout.file = “flyout.html”;
System.Gadget.Flyout.onShow = flyoutShowing;
// Set the Caption of the Gadget
// Initialize timer – to refresh every x seconds
setTimeout( “refresh()”, 1000 );
creates the delegate and assigns it to the event handler in one go.
In the event handler we setup the Settings dialog to use settings.html and the flyout to use flyout.html. setCaption creates a HTML string for the Caption and sets that into the CAPTION DHTML area and lastly, we setup the refresh method to be called in 1 second. This is done in order for the Gadget to be added smoothly and without any delays from connecting to Web Services etc.
The refresh function starts by adding another call to refresh delayed (depending on the RefreshInterval) and call setContent. setConent is the function, which does the actual Web Service method invoke.
// Refresh Gadget
// Initialize timer – to refresh every
setTimeout( “refresh()”, GetRefreshInterval()*1000 );
// Set the Content of the Gadget
The settingsClosed event handler is setup in the onreadystatechanged above and is called when the Settings dialog is opened (clicking on the wrench next to the gadget). This event handler will update the Caption and call refresh (in order to force a refresh now – and setup a new timeout).
// Refresh Gadget on Settings Closed
// User hits OK on the settings page.
if (event.closeAction == event.Action.commit)
// Caption might have changed based on settings
// Refresh content, update refresh Interval
The setContent function starts out by setting up some global variables based on the type shown in the gadget
// Setup variables and invoke Web Service method for getting My records
RTCpage = ”;
Type = GetType();
if (Type == ‘My Vendors’)
// Settings for My Vendors
RTCpage = ’26’;
WSfunction = ‘GetMyVendors’;
XMLPortResultNS = ‘urn:microsoft-dynamics-nav/xmlports/myvendors’;
XMLPortResultNode = ‘MyVendor’;
else if (Type == ‘My Items’)
// Settings for My Items
RTCpage = ’30’;
WSfunction = ‘GetMyItems’;
XMLPortResultNS = ‘urn:microsoft-dynamics-nav/xmlports/myitems’;
XMLPortResultNode = ‘MyItem’;
else if (Type == ‘My Customers’)
// Settings for My Customers
RTCpage = ’21’;
WSfunction = ‘GetMyCustomers’;
XMLPortResultNS = ‘urn:microsoft-dynamics-nav/xmlports/mycustomers’;
XMLPortResultNode = ‘MyCustomer’;
RTCpage = ”;
// Invoke GetMyStuff Web Service
xmlhttp = new ActiveXObject(“Msxml2.XMLHTTP.4.0”);
xmlhttp.open(“POST”, GetBaseURL()+”Codeunit/GetMyStuff”, false, null, null);
xmlhttp.setRequestHeader(“Content-Type”, “text/xml; charset=utf-8”);
// Setup event handler when readystate changes
xmlhttp.onreadystatechange = function()
if ((xmlhttp.readyState == 4) && (xmlhttp.Status == 200))
xmldoc = xmlhttp.ResponseXML;
myXML = xmldoc.selectNodes(‘//tns:’+XMLPortResultNode);
xmlhttp.Send(‘<?xml version=”1.0″ encoding=”utf-8″?><soap:Envelope xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope/”><soap:Body><‘+WSfunction+’ xmlns=”urn:microsoft-dynamics-schemas/codeunit/GetMyStuff”><result></result></’+WSfunction+’></soap:Body></soap:Envelope>’);
// Something went wrong – display: “Service not available”, indicating that there of course are no bugs in the above code:-)
After setting up the variables, we initialize the xmlhttp and setup a delegate function for onreadystatechange on the xmlhttp (this gets invoked when the Web Service method is done). After this we invoke Send with a SOAP document conforming to the WSDL for the Web Service.
When the onreadystatechange event handler is executed we read the XML and update the content of the Gadget. If anything goes wrong we call the updateGadget function with false – indicating that it should change the content to an error message.
The UpdateGadget builds a HTML table and inserts this table into the CONTENT area of the gadget. For every row we add a call to showflyout if the user clicks the row in order to get additional information.
// Add a row to newHTML
newHTML += ‘<tr><td height=”18″ valign=”middle” background=”Images/gadgetmiddle.png”>’;
newHTML += ‘
The showFlyout function is pretty simple
// Show flyout with additional information
System.Gadget.Flyout.show = false;
flyoutNo = no;
System.Gadget.Flyout.show = true;
and after this method has been called, the next thing happening is that the flyoutShowing event handler is invoked – and in this event handler we can calculate the content of the flyout and set it in the flyout.
// Flyout Showing event handler
// Calculate content of flyout
flyoutHTML = ‘<table width=”100%” border=”0″ hspace=”0″ vspace=”0″ cellpadding=”0″ cellspacing=”0″>’;
flyoutHTML += ‘<tr><td height=”31″ align=”left” valign=”middle” background=”Images/topband.png” nowrap><p><strong><font color=”#FFFFFF” size=”3″ face=”Segoe UI”> ’+myXML[flyoutNo].childNodes.text+'</font></strong></p></td></tr>’;
flyoutHTML += ‘<tr><td valign=”top”><table cellspacing=”5″>’;
for(i=3; i<myXML[flyoutNo].childNodes.length; i++)
flyoutHTML += ‘<tr><td>’+myXML[flyoutNo].childNodes[i].nodeName+'</td><td>’;
flyoutHTML += ‘<a href=”dynamicsnav:////runpage?page=’+RTCpage+’&bookmark=’+myXML[flyoutNo].childNodes.text+’&mode=view”>’+myXML[flyoutNo].childNodes[i].text+'</a>’;
flyoutHTML += myXML[flyoutNo].childNodes[i].text;
flyoutHTML += ‘</td></tr>’;
flyoutHTML += ‘</table></td></tr></table>’;
obj = System.Gadget.Flyout.document.getElementById(“CONTENT”);
obj.innerHTML = flyoutHTML;
Really mostly string manipulation in order to create a string that looks correct. I could probably have done the same with XSLT – but this seems pretty easy. As you can see the function enumerates the content of the childNodes to myXML – and adds everything to the flyout. This means that if you add some fields to the XMLPort, then these will be included in the flyout as well.
The flyout.html only contains an empty HTML document with a CONTENT area, which is set by the code above.
The settings.html is really simple, with a method for reading the settings and setting them onto the form
// Initialize settings Form
document.onreadystatechange = function()
// Read settings and set in form
URL.value = System.Gadget.Settings.read(“URL”);
RefreshInterval.value = System.Gadget.Settings.read(“RefreshInterval”);
Type.value = System.Gadget.Settings.read(“Type”);
A method which for setting the settings back into the settings file.
// Event handler for onSettingsClosing
System.Gadget.onSettingsClosing = function(event)
if (event.closeAction == event.Action.commit)
// Write new URL into settings
// State that it is OK to close the settings form
event.cancel = false;
and the form itself in HTML
<table width=”100%” height=”100%”>
Web Service Base URL:<br>
<input type=”textbox” id=”URL” maxlength=”250″>
<select name=”Type” size=”1″>
<option value=”My Customers”>My Customers</option>
<option value=”My Vendors”>My Vendors</option>
<option value=”My Items”>My Items</option>
<select name=”RefreshInterval” size=”1″>
<option value=”10″>5 seconds</option>
<option value=”30″>30 seconds</option>
<option value=”60″>1 minute</option>
<option value=”300″>5 minutes</option>
I will let the code speak for itself.
If you want to see the entire thing, feel free to download it from http://www.freddy.dk/GetMyStuff.zip. the Zip file both contains the Gadget (open that and install – or rename to .zip) and a .fob file with the NAV 2009 objects. You will need to expose the GetMyStuff Codeunit as a webservice with the same name.
Microsoft Dynamics NAV