Time Tracking and Reporting Application

Design and develop a customised time tracking and reporting tool with regards to project time and personnel, that can provide exports and connectivity to Sage 50 and Sage 200 Accounting systems

Sector – Medical Marketing

Scope

Create a fully featured time tracking system that records time segments of 15 minutes, with the ability to enter data per day, week and month. Provide a facility to report personnel time usage as well as department, product and the company overall.

A Flexible reporting system was required to enable management staff to cut data in various ways exporting out to formats supported by Sage 50 and 200. Full user and product administration was needed as well as graphical representation of tasks, projects and spend (P&L sheets, overbudget project highlighting etc) in the form of information dashboards.

Implemented Solution

A Yii framework solution was developed to provide a rapid development, modularised, flexible system that had the capacity to be expanded as business need grew.  Access to the system was controlled by LDAP as the company had in place an Active directory structure. Projects were split into sections which were then assigned tasks and personnel.  Each task included estimated effort as well as actual time spent for profit and loss calculation at the end of a project.  Tasks time was graphically represented on dashboards by a series of line graphs and data tables. The reporting feature provided views to query the system according to project, task, user, department and company overall.  Export features were provided throughout the system, exporting to CSV for Sage 50 and 200  and XLSX for further manipulation. A dedicated administration module serviced access to the system as well as user permissions, project groups, default task assignment and dashboard view preferences.

The system was hosted by Saxby Willson according to a maintenance SLA for the Client.  The project underwent two additional expansions post the initial scope.

Technologies/Services utilised

LAMP, Yii,  JavaScript, JQuery, Adobe Flex, LDAP, Google Charts, Google Maps API

 

 

Saxby Willson uses cookies to help improve your overall browsing experience on this site. Are you happy to accept cookies? More Info...

Use of cookies

On 26th May 2011, new EU rules came into force regarding cookies. These rules require that cookies can only be placed on devices where the user has given their consent. This notice is designed to provide you with more information about how Saxby Willson Limited uses cookies and adheres to these rules.

Cookies are small files which are sent to your Web browser and are stored on your computer's hard drive. There are many purposes for this - our site uses them to help analyse web traffic to improve your overall browsing experience. You may set your Web browser to notify you of cookie placement requests or to decline cookies completely. You can delete the files that contain cookies; those files are stored as part of your internet browser.

If you have any further questions or queries about the use of cookies on this site, please contact us through our 'contact us' form.

Close