In my older version of Time Registration for Dynamics NAV I had ASP web site working on Microsoft SQL server that is used as an attendance list for an office. On the web site by clicking on the employee name a page with punch in or punch out appears. From the older system the user had to manually synchronize the external SQL database.
On the new version of Time Registration for Dynamics NAV I am using the new web service support of NAV 2009. The task was to change the ASP web site and remove the SQL server connection on the web site. The result is a success, the web site is available here. The data is directly from Dynamics NAV and all updates are directly inserted into Dynamics NAV.
I was reading Freddys Blog and found a function to encode URI Component. I tested the function but found that I needed to change the function to correctly encode my URL.
In Iceland the Company Names in many cases include characters in the range from 128 to 255. This new function can handle this upper range correctly.
I wanted to replace MySQL with NAV Web Service as a data source for my PHP web site. I started to look around and found all I needed in Freddys Blog. First post is about changes in authentication method of the web service, the later post displays the code needed to connect to the web service with php.
I have an php web on my Windows Home Server and needed to activate two more extensions to get things working.
Here are the php files that I used – PHP consume NAV Web Service