Category Archives: timesheet

Selecting TimeControl for Online or On-premises

online_vs_onpremisesWith TimeControl now available to be purchased for on-premises installation and for subscription to our TimeControlOnline hosted timesheet service, there is a choice to make.  Here at HMS we’ve been asked recently “Which is better – Hosted or Purchased?” and the answer isn’t obvious. Whether you subscribe to TimeControlOnline or purchase TimeControl to install on your own servers, there’s lots of great functionality including:

  • Multi-browser easy to use interface
  • TimeControl mobile smartphone interface
  • Links to project management systems like MS Project
  • Links to ERP/Finance, Payroll and HR systems
  • Matrix Approvals
  • Automated Validation Rules
  • Extensive Reporting
  • Vacation approvals
  • Email notifications
  • Multi-lingual functionality

But there specific advantages for both subscribing or installing so we’ve put together some resources that we hope you’ll find useful on our Timesheet Buyer’s Guide solution portal including:

Webcast
A short webcast by our President, Chris Vandersluis comparing the differences of purchasing TimeControl vs. subscribing to TimeControlOnline along with some basic questions you can ask yourself to see which path is optimal for you. Read more…

Slides
A PowerPoint slideshow that is used in the webcast.   Read more…

Factsheet
A 4-page factsheet entitled Online vs. On-premises which puts side-by-side comparison of the different options available with both products.  Read more…

Timesheet Buyer’s Guide
This solution portal contains numerous resources other than those we’ve listed here on how to select a timesheet for your needs and how TimeControl might apply to those requirements.  See more at buyersguide.timecontrol.com.

TimeControl 6.3 now available

TimeControl's new Virtual Trees allows a tremendous volume of data to be displayed virtually instantly.  Click here for a full screen view.TimeControl 6.3 has arrived and with it a long list of great new features many of which have been suggested by our clients.  Some of these features should delight both Administrators and End users.  Here are a few of the new features:
Virtual TreesTimeControl has always allowed for hierarchical display of our charge codes and other table entries.  Some TimeControl clients have tens of thousands of such hierarchical table entries.  In the past, TimeControl has had to load 100% of these records and then had to sort them into their appropriate hierarchy prior to displaying them and when the volume was large, this could take some time. Our new Virtual Tree display allows TimeControl to fetch only the top level of the hierarchy, display that and then fetch only the data the user wishes displayed when they click on the “+” key. We’ve been doing testing with 150,000 records and the results are startlingly fast.

Manage statutory holidays with the new TimeRequest™ WizardThis allows administrators to create pre-approved TimeRequests for employees of their choice. It’s an ideal tool for pre-loading entries such as statutory holidays. A TimeControl administrator can now create a “Statutory Holiday” TimeRequest for every employee in the system that would include all statutory holidays for the year (Canada Day, Thanksgiving, Christmas, etc…). These TimeRequests are automatically approved and will appear on all affected employee timesheets at the time of their creation. TimeRequest iCal Approved TimeRequests can now be input into Outlook with a single click!  Click here for full screen view.When your Vacation is approved in TimeControl you can now just click to have it automatically open in your Outlook or other calendar program! TimeRequest Notifications People love how TimeControl can notify you by email automatically when there’s a problem with a timesheet.  Now you can do the same with TimeRequests.  When your vacation is approved, your supervisor can send you a quick note right from the TimeRequest screen and even include a link to add it to your agenda.  It’ll be nice to get happy emails from TimeControl! Lots, lots more…There are numerous other improvements including:

  • Cache updates right from the menu
  • Copy User Settings from one user to many
  • Copy Status from the Project table directly to all associated charge codes
  • Copy Status from one charge code to all the child charges in a single click

Existing TimeControl clients with current support contracts can find more information on TimeControl 6.3, on the Support/Updates page at timecontrol.com/support/updates.  There is no charge for the upgrade.

TimeControl is your SharePoint timesheet

Did you know that TimeControl can be deployed right inside the SharePoint interface? For organizations that have adopted the Microsoft SharePoint environment as their Intranet or Corporate Portal software,  TimeControl is the perfect fit because it allows end-users to enter their time in TimeControl without ever leaving SharePoint. 

SharePoint is a  powerful collaboration environment which is used by over 85 million people around the world.  TimeControl is one of the first timesheets anywhere to completely support the SharePoint interface (versions 2003, 2007 and 2010) and provide SharePoint end-users with an uninterrupted user experience!

The following video-presentation shows how you can integrate your TimeControl 6 environment with SharePoint in a couple of ways. First, the demonstration in this webcast shows TimeControl provisioned into a SharePoint worksite. The webcast also shows how SharePoint lists can be saved so they can be imported and implemented right into TimeControl and then shows a timesheet with those SharePoint tasks available as charges on an employee’s timesheet.

To find out more about how TimeControl can be implemented within SharePoint, consult our TimeControl and SharePoint Solution page.

If you are interested in extending your collaborative experience by adding Microsoft Project to the TimeControl / SharePoint mix, be sure to also visit the TimeControl, SharePoint, Microsoft Project Solution Portal.

TimeControl goes Mobile!

ip_l_list_200x106TimeControl is now available for your smartphone.  Included with the regular TimeControl systems is now an all new interface that is designed for use with iPhones, Blackberrys, Android and Windows7Mobile devices.
There’s nothing to install and nothing special to manage when using the new TimeControl Mobile interface because it has been designed as a web application.  Simply point your browser to the special URL that is available with all TimeControl versions from 6.2 and up and the mobile interface is immediately available.
bb_ts_100x177TimeControl Mobile brings the flexibility and power of one of the world’s most popular timesheets right to your hands wherever you are.  The system supports the creation and editing of timesheets in the field as well as automated validation rules, approval including release and reject.  The interface, like all of TimeControl is multilingual and even supports user defined fields for timesheet entry.
TimeControl Mobile can flip from horizontal to landscape orientation and the interface will immediately reorganize itself to take advantage of the screen real estate that’s available.
There’s no additional cost for TimeControl Mobile.  It’s included.
There’s also nothing special to do during the installation or upgrade to make the mobile functionality available to the users.  Users will simply point their mobile browsers at their usual URL plus /mobile and there it is.
TimeControl Mobile is available as of TimeControl 6.2 to all new clients and automatically part of the 6.2 upgrade to existing clients.  Any client with a current support contract has access to version 6.2 on the regular support site.
For more information on TimeControl Mobile and to see a webcast of it working on a Blackberry and iPhone, go to www.timecontrol.com/timesheet/mobile.

TimeControl 6.1 released

employee_table_generaltab_multi-browserWe’re very excited here at HMS to announce the release of TimeControl 6.1.  This version extends the TimeControl 6 family into its next evolution with a range of new features and an even more options in the configuration and architecture
In the architecture department, TimeControl now embraces MySQL along with the existing support for Microsoft SQL Server, Oracle and Sybase as possible databases.  In addition, support for mixed 32/64bit support has been improved.  There are also updates to improve our link to Microsoft Project Server 2010 and in particular for mixed environments where both Project Server 2007 and Project Server 2010 must be linked to simultaneously.
The table functionality has been rewritten in its entirety to follow the TimeControl 6 multi-browser interface architecture.  That’s right, you’re no longer required to use only Internet Explorer to manage your tables but can also use Chrome, Safari, Firefox or Mozilla.  Of course, if you like Internet Explorer, we haven’t forgotten you as IE9 is now part of our testing cycle.
There is a whole new feature called “Personal Pre-load” which we think end users are going to love and updated features for emails, releasing timesheets, tools like charge delete and timesheet audit logs and much, much more. 
To see more details on what’s included in TimeControl 6.1 go to What’s the latest on the TimeControl website.  If you have a current TimeControl support contract or if you’ve purchased in the last year, then you can download the current version from the Updates area of the website.

Cascading User Defined Fields

Here’s the challenge. On a timesheet you have several user defined fields. Let’s take a simple example. We have consultants who do several things but we want them to identify what city they were in when they were doing the work this week. So, I could populate a drop-down list of 10,000 cities but scrolling through it to find Toronto would be quite tedious.

TimeControl now accomplishes this with “Cascading User Defined Fields”.

To activate this feature you’ll need to have access to the TimeControl Server and follow these steps:

  1. First, create your user defined Text Fields in the timesheet itself. You may want to hide them from others in the User Profiles until you’re ready to display them.
  2. Now, under the TC5 directory add a new folder called “CustomWork”
  3. In this folder make a file called “TimesheetUDF.ini”
    Here’s an example of what would be in the file. In this example, timesheet field 2 would depend on the value in timesheet field1, Timesheet field 3 would depend on the value in timesheet field2.

    [DEPENDENCY]
    TSD_FLD2=TSD_FLD1
    TSD_FLD3=TSD_FLD2

  4. In the fields themselves, we then use periods to distinguish the levels.

    So in TSD_FLD1 we might have:
    CANADA
    USA

    TSD_FLD2 might then have:
    CANADA.QC
    CANADA.ON
    CANADA.BC
    USA.NY
    USA.NV
    USA.FL

    TSD_FLD_3 might then include:

    CANADA.QC.MONTREAL
    CANADA.QC.QUEBEC
    CANADA.ON.TORONTO
    CANADA.ON.OTTAWA
    USA.NY.NEWYORK
    USA.NY.BUFFALO
    USA.NV.LASVEGAS
    UAS.FL.MIAMI

  5. You’ll need to restart your TimeControl Transaction Server for the new definitions to take effect.

When entering a timesheet now, if you choose “Canada” in field 1, then only QC, ON and BC will appear in field 2. If you then choose “ON” in field 2, then TimeControl would only show “TORONTO” or “OTTAWA” in field 3.

The effect is to reduce what is potentially tens of thousands of choices to a tiny handful and that can make the difference between a complicated timesheet entry and a very simple one

TimeControl supports Primavera “Steps”

TimeControl 5.1.2 became available yesterday and along with several improvements came long-awaited support for updating Primavera Steps within the TimeControl Timesheet. As you can see by clicking on the screen at right, there is a new tab called Activity Steps which displays the sub-task level steps and the percent complete for each one. The resource which is designated in Primavera as the ‘primary’ resource will be able to edit the Step progress. Other resources will be able to see them only. New Steps cannot be added within TimeControl. They must be done within Primavera itself. You can see a quick video of Primavera Steps working within TimeControl 5.1.2 on the TimeControl 5.1.2 Steps Screencast.

On demand, scheduled, triggered, which is best?

TimeControl includes a number of links to project management tools and a number of different methods of connecting to them.

If using Microsoft Project Standard or Professional, the link is to a desktop tool and that’s always going to be on-demand but what about if you’re linking to Microsoft Project Server, Primavera or Deltek’s Open Plan? Now the link is typically server-to-server and could be scheduled or on-demand. With Project Server, incoming links can also be triggered by the TimeControl “OnPublish” event that is included with the system. Primavera can also be set up to automatically link data to TimeControl when a new project is created. Here’s the best practice that’s most commonly applied:

First for incoming changes in data, this is a link that is meant to keep the TimeControl charge and activity code information up to date with the changes that may exist in the project files. It’s most typical to create the incoming links as scheduled or automatic events. If the link is with Project Server, then the “OnPublish” event module that is part of the installation is perfect for this. If the link is with Open Plan or Primavera then a regular scheduled link moving information on a server-to-server basis is ideal.
How often should the links happen? As often as the project is likely to be updated. For most projects a weekly link will probably be fine. If your week-ending day is Friday, then a link on Thursday night might be appropriate. Some projects are highly dynamic and need to be updated multiple times per week or even multiple times per day. Create as many scheduled events to do this. A scheduled link can be daily or weekly and you can pick the day and/or time when you’d want it to occur.
For project updates that will move timesheet information back to the project management tool, we recommend making most of these links “on-demand” for the project manager. That means that the project manager will pull the data from TimeControl to their project management tool when they are ready for it. You can make the link automatically scheduled of course but we had an image of a project manager working on his project late one night and suddenly “poof” everything changes as the automatic link moves the data in from TimeControl. Most project managers will want to bring in the data when they’re ready to see the project advance.
There may be exceptions of course. Some projects such as regular maintenance projects aren’t really managed the same way and an automatic link to update those files from TimeControl may make more sense. You have the option to do both.
With TimeControl, you get the ability to make your links as automatic or as manual as you wish and each situation can be different.

Why not put in the hours for me?

I get this question all the time. Users who look at the robust TimeControl interface ask why we can’t seek out the planned hours from the project scheduling system and populate them into the timesheet. ‘We must have access to the planned hours from the task assignments in the project system,’ they argue so surely we could make their lives easier by simply putting the hours into TimeControl for them. ‘We could go one step further,’ they say. We could look at the remaining hours not accounted for by the project system and fill them in with ‘Miscellaneous’ to make up a 40 hour work-week and complete the timesheet.

‘Wouldn’t that ease of use increase the overall percentage of compliance of the timesheet and therefore be better?’

It wouldn’t.

The problem is not technological. These people are quite right. We do have access to the hours planned in the project management system and automatically populating the timesheet with all the hours would be technically easy to do.

Why not do it then?

Because of what we already know about human behavior. Imaging a timesheet which is pre-populated for you. You need only click ‘Ok’ to complete the timesheet and send it on its way for approval. It’s the end of a long week and the weekend beckons. Do you click ‘Ok’ or, do you review each line to ensure it’s correct? Most people will just click ‘Ok’.

Ok, your personnel are diligent people who would never just click Ok. Let’s accept that. Now imagine that it’s the end of the week and the timesheet system indicates that the plan of the week was to spend 35 hours on that design task and 5 hours on that documentation task. Unfortunately you’ve just done the opposite. You’ve spent 35 hours on the documentation task. Won’t there be a tremendous temptation to click ‘Ok’ with a promise to yourself to make it up later? There will.

Here at HMS we know that the most valuable thing TimeControl can deliver is accurate complete information so that management can make better decisions. If all we do is return data that matches expectations, then there’s little point in tracking it at all.

So, TimeControl can optionally pre-populate a list of the tasks you were scheduled to work on based on the assignments in a project management system but it won’t put in the estimated hours for each day.

Years ago I was in a presentation showing TimeControl to a small group of technology professionals. The Chief Financial Officer was in the room and at one point asked why we didn’t automatically complete tasks in the project management system from the TimeControl timesheet. I pointed out that we did, in fact, allow the Estimate to Complete to be entered in TimeControl and that when there was nothing left to complete, the task would be marked as completed in the project management system. The CFO though was insistent. Why didn’t the timesheet just figure that out from the hours worked.

“What would you expect to happen,” I asked, “in a task with a plan of 40 hours when you’d done 40 hours of work?”

“I’d expect the task to be automatically marked as complete,” he answered.

I was stunned. “But what if it’s not complete?” I replied.

“I don’t understand your answer,” the CFO said. “If you’ve done 40 hours then the task is over.”

A senior VP had to take the CFO out to explain that life doesn’t always match up to our expectations in a project.

We’ve remembered that lesson very well at HMS and it’s reflected in the TimeControl design. There are all kinds of links between TimeControl and project management tools that give users a tremendous access to data from both the timesheet and the project management environment but we have resisted the most requested feature in the system for over 15 years now. TimeControl will pre-populate a list of what the end user was supposed to work on, but it won’t load all the expected hours. End users are responsible to declare what they actually did with their time.