Macrotone Timesheet User's Guide

Geoffrey S. Chapman

Macrotone Consulting Ltd

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license can be found on-line at

March 2016

Revision History
Revision 1.0.3May 2016 Geoffrey S. Chapman


This book covers the use of the Macrotone Timesheet component which allows you to easily create employee timesheets on your Joomla!™-powered web sites.

Table of Contents

I. User's Guide
1. Introduction and installation
Introducing Macrotone Timesheet
Requirements and compatibility
Updating to the latest release
2. Initial set-up and usage
Parameter Settings
Back End Screens
Front End Screens
Timesheets view
Timesheet view
Timesheet edit
Individual Timecode display
Print output
Modules and Plugins
3. Version Changes
Release Versions
Timesheet 1.0.3
Timesheet 1.0.2
Timesheet 1.0.1
Timesheet 1.0.0
II. Advanced Configuration
4. Print Configuration
Methods of modifying print output
HTML Boxes
Standard Joomla method
Modifying the print output.
Add logo to Joomla print popup
Change size of print popup window
III. Design
5. Design Criteria
Planning and Analysis
Planning and Project Analysis
Gather the Necessary Data
Define Security Requirements
Select Data Management Functions
Select Data Presentation Functions
Define Special Function Requirements
Handling of date fields.
Cron tasks
Multi-Lingual support
6. Database Design
Designing the Database Objects
Database Objects - Procedures, Views, Triggers
Database Triggers
Database Routines (Procedures)
Database Views
Data Model
Timecodes Table
Users Table
Timesheet Table
Timesheet Log Table
Implementing Database Objects
Additional Database Objects Needed
About Building Database Objects
Default Base Data
7. HTML Table grid
jqGrid language files
8. CSS Styling
Back End styling
9. Helper Classes
General Helper
Logging Helper
IV. Appendices
A. GNU General Public License version 3
B. GNU Free Documentation License
Go To Top

The Macrotone Consulting Web site would like to use cookies to store information on your computer, to improve our website. Cookies used for the essential operation of the site have already been set. To find out more about the cookies we use and how to delete them, see our Privacy Policy.

I accept cookies from this site.