Category Archives: timecontrol

All new Solutions area for those using Excel timesheets

excel_tc_cover_250x317HMS has just released an all new Solutions Portal for those who are using Excel timesheets and know it’s time to graduate to a full timesheet system like TimeControl.  Thousands of organizations every year create their first timesheet in Excel.  And, why not? It’s easy to do, there are numerous free Excel templates available for download and The new solutions area contains a number of resources that will be of interest to those currently using Excel for timesheets and are considering a move to a timesheet application.  Among the collateral on the portal is included:

  • Moving from Excel timesheets to TimeControl Webcast
    This webcast shows the benefits of moving from an Excel timesheet system to TimeControl and how easy and familiar TimeControl will be to those who have used Excel for timesheets in the past.  The webcast shows TimeControl in action and discusses how TimeControl can import and export data directly with Excel.
  • Excel to TimeControl PowerPoint presentation
    This slide presentation shows various free Excel templates and some of the benefits of moving from an Excel-based timesheet to TimeControl.
  • Excel to TimeControl factsheet
    This all-new 4-page factsheet describes the ease of moving from Excel timesheets to TimeControl timesheets and highlights some of the functionality that may be missing from an in-house Excel-based timesheet system that can be found in TimeControl.

The Solutions area is free of charge and can be found at www.timecontrol.com/solutions/excel/.

Getting 2 copies of TimeControl going at once

imageIn older versions of Internet Explorer, you used to be able to keep two copies of TimeControl running at a time. For supervisors and administrators this can be very attractive.  They might want to be looking at charge code items in the table as one user for example while in another screen they do approvals. In IE8 and other more recent versions, this doesn’t at first seem to be possible.  This is because Internet Explorer caches sessions to be more performant in displaying a website.
Not to worry, the old capabilities are still there.  What you need in IE is a “New Session’ rather than just a new tab or new window.  A new session looks like a new window but is, in fact, a whole new instance of IE running at the same time.
To do this, start up your first instance of TimeControl then go to the File Menu (You might need to press ‘Alt’ to see it.  Now select “New Session” and a new window of IE will appear and allow you to relogin as someone else to TimeControl at the same time.

Installing TimeControl 6 on a 64 bit server with Oracle 11g+

We’ve encountered an unusual condition when clients are installing TimeControl 6 on a 64 bit server with the very latest Oracle 11g.  Most 64 bit installations go forward without incident but, if you are installing your TimeControl on a 64 bit server and you are using Oracle 11g or later
Because TimeControl’s architecture now includes elements that are both in 64 bit and 32 bit.  When TimeControl is installed on a 64 bit server and the Oracle 11g or higher driver is installed, you will need to do some specific configuration in order to have the TimeControl Transaction Server (TTS) (in .Net) connect through the 64bit Oracle supplied driver and the TimeControl Administration Transaction Server (ATS) connect through the 32bith Oracle supplied driver.
Do this you will need to create multiple Oracle homes by installing Oracle 32bit and Oracle 64 bit client. For more information on installing and configuring multiple homes please refer to Oracle documentation.
First, install both the:
*
Oracle 32 bit Client Software (minimum Runtime installation) and the; * Oracle 64 bit Client Software (minimum Runtime installation)
image
Next, create an environment variable called TNS_ADMIN to point to the location of your tnsnames.ora file. For more information on creating environment variables, refer to your Oracle documentation.
image
Now update your tnsnames.ora file to have the connection information for your Oracle data.

Now you’re ready to install TimeControl or run the TimeControl database configuration tool.

Take a look at the new TimeControl R&D Tax Credit Solution Portal

HMS has just published a collection of new tools and resources for those organizations which do Research and Development Tax Credits.  R&D tax credit programs are offered by governments all over the world including the US, Canada, the UK, Australia and throughout the EU.  Virtually all R&D tax credit programs require documenting what eligible work was done and who did it and that’s one reason TimeControl is often part of the R&D reporting environment.  If your organization does an R&D tax claim then our new Research and Development solution page includes a range of new tools that you may find of interest:
There’s a new white paper on how R&D tax claims work and how you can configure TimeControl to help overcome the “Triangle Audit” that is often how R&D tax claims are reviewed by the particular jurisdiction.
There’s a new webcast talking and R&D tax claims and a demonstration of TimeControl 6 already configured to do R&D reporting.  The reports we used in that webcast are available for download from the MyTimeControl Plugin library on the timecontrol.com website in the Support area.
There is a new case study of how TimeControl is being used at EXFO in Canada for their R&D reporting requirements.
There are slides, links to online resources in numerous countries, slide presentations, other white papers and fact sheets.  You can even try TimeControl for free on our Free Hosted TimeControl Trial site.
The new TimeControl R&D Tax Credit Solution Portal is at www.timecontrol.com/solutions/randd.

It’s the holidays–Here’s how to deal with absences in TimeControl

With the holiday season approaching, it’s a good time to talk about how to handle timesheets for people who will be away. TimeControl has several options for dealing with absences whether they are planned in advance, or unplanned.

Unplanned absenceTimeRequest_Add If an employee is absent and the timesheet for the week in question has not been started, the employee’s supervisor can create the timesheet and enter the time data on their behalf. The supervisor uses the Add Timesheet function and selects the employee from the Employee List in the Create Timesheet dialogue box. TimeControl is designed to allow supervisors in an employee’s approval path to enter timesheets for them.
If the timesheet has already been started, we have a couple of choices, a supervisor or designated replacement can log in on behalf of the employee by using the alternate log in function. An alternate log in can be specified for any employee from the User Table / Other Information tab. This allows someone to be the delegate of someone else. When setting an alternate log in, you also must set an expiry date. When a user logs in as an alternate for an employee, the audit trail records that the alternate has made the entries, as opposed to the original employee. This function is an easy way for a supervisor to complete a timesheet for an employee who has an unplanned absence or for another supervisor to approve the timesheets of a supervisor who is absent.
There is another option to managing timesheets that are already underway. A supervisor or administrator can use the Change Ownership function to move the control of a timesheet from one user along the approval path to their supervisor to have the timesheet completed and approved.
Planned absence If the absence is planned, TimeControl’s new TimeRequest function allows users to request approval for various types of time including vacation or time off. The employee enters the type of time-off, dates and hours requested and then submits the request to the supervisor. Once the TimeRequest has been approved, it is maintained in a queue and will automatically appear in that employee’s timesheet when it is created.

HMS readies TimeControl 6 upgrades

We know that existing TimeControl clients have been waiting patiently for TimeControl 6 to arrive.  We have been waiting for is the module to convert older TimeControl databases into the TimeControl 6 format.  We’re happy to let everyone know that this code is complete and testing for the migration tool has also been completed.  Packing the TimeControl 6 updates and putting some finishing touches on documentation is wrapping up now and we will be making the TimeControl 6 upgrade available to clients early next week.   This version of TimeControl will be made available at no cost to existing TimeControl clients who have a current support contract.  Clients who wish to ensure their support contract is up to date should check with support@hmssoftware.ca

TimeControl 6 updates as well as a complete installable version and even an ISO CD image file will be available from the www.timecontrol.com/support/updates/ area for any clients whose support is current . 

Managing multiple MS Project versions with TimeControl

With the imminent release of Microsoft Project and Project Server 2010 many organizations are strategizing their migration plans from earlier versions of MS Project. There are multiple scenarios for doing a version migration but one of the most attractive will be a phased roll out of the newest release; using it for the new projects while old projects are completed in the older version. This gets around the technically challenging aspect of physically migrating the data.

There’s only one major fly in the ointment with that plan and it has everything to do with timesheets. Since newer projects in Microsoft Project Server 2010, the system would expect to use the timesheet in 2010. That won’t connect to the older projects in 2007 or 2003. They will expect timesheets from their versions.

Will users have to do two or more timesheets? What about non project time? How will approvals work?

TimeControl provides an easy answer to this challenge. As a timesheet which is independant from the project management system, TimeControl defines its link to scheduling tools like MSP and Project Server at the project level rather than the system level. This means that TimeControl can support multiple versions of Project and Project Server at the same time.

This is good news for those scratching their heads over how to migrate smoothly from one version or even one product to another.

TimeControl’s design means that an employee’s timesheet can contain lines from different projects and whether those projects are managed in MSP Desktop, Project Server 2007, Project Server 2010, Excel or even just in TimeControl, the user will be insulated from having to worry about that. The tasks the employee must accomplish and report their time on will be listed simply on their timesheet like any other task.

As Project Server Administrators and Technical staff make plans to migrate to the new Project versions, many will look to TimeControl as not only the solution to supporting multiple versions simultaneously but also for the additional benefits of a timesheet that can manage the needs of HOUR, Payroll and Finance at the same time.

Knowing that TimeControl has had links with MS Project since 1995 and with Project Server since its inception will make TimeControl a logical choice for many organizations.

Using Generic Resources with TimeControl

During a sales presentation of a project management software solution, the vendor typically speaks about resource management and resource assignments on an individual basis. In this scenario, the resource pool is comprised of individual, named people. In some cases the individuals have additional attributes such as a specific skill or be part of a larger resource group. For example, Bob may be an engineer and may be part of the Engineering resource pool. Kevin may be a designer and part of the Design pool. The intent is that Bob would be assigned to a task that requires Engineering and Kevin assigned to tasks involving design. TimeControl is very happy to work in the manor if desired. Each person making a time sheet within TimeControl has the option of being “related” back to a resource code in the supporting project management system. During the transfer between TimeControl and the PM system, resource information, including assignments is part of the data being shared. Once the timesheet has been completed, hours that Bob has entered for his Engineering tasks get transferred back to the PM software as actual resource hours for the Engineer / Bob code. In this scenario, the resource codes in the PM software represent an individual and match the TimeControl employees on a one to one basis as per the example shown in this screen capture.

clip_image002

In this example, and hours entered by the employee Sally Thompson resolves back to the individual resource code Sally Thompson in the schedule.

Recently I have spoken to several companies who are using their PM software with generic resources and wish to transfer the hours worked by an employee, from TimeControl back to the generic resources. Using generic resources is a very common project management practice in involves doing the planning at a group level such as Engineers, planners, programmers or similar. The resource pool in the PM software is comprised of group codes, and may or may not have individual codes. The project manager assigns tasks to the group code and the line supervisor decides who will actually do the work. The employee who works on the task enters their hours in TimeControl and that data is ultimately returned to the schedule as progress. If an employee in TimeControl is linked to a group resource code (also known as a resource pool code) the total hours for all of the employees who are linked to that resource code will be transferred back to the schedule as progress. An example of this type of reference is shown it this screen capture.

clip_image004

In this example hours worked by Tom Logan are resolved to the resource pool code Analyst in the schedule. In the case where an employee worked on a task and is a member of a resource group that was not originally assigned to the task, TimeControl can be set to create the resource assignment in the schedule as a part of the transfer process.

TimeControl can be used with employee specific resources or with generic resources or a combination of the two, depending on the requirement of the Project Office.

By: Ken Edwards

TimeControl’s new Timesheet AutoFill

TimeControl 5.1.5 has a new feature that we think will be a hit with Human Resources Departments. We all know about TimeControl’s strength as a task-based timesheet system and its links to project management but not all personnel in an organization are project personnel. Many organizations use TimeControl to track the entire staff including those employees who only need their time and attendance tracked. For these users we are often asked if timesheets can be added only “by exception”.

By exception timesheet entry means entering a timesheet only when your weekly timesheet won’t be a complete week of working as per your salaried schedule. So, if you have vacation, sick leave, personal time off or some other exception, you’ll enter only those hours. But what about the rest of the hours that make up your complete week? That’s what AutoFill is for.
TimeControl’s Timesheet AutoFill allows an administrator to create or fill-up timesheets for a selected group of employees. It’s not for all staff. The project personnel should be filling out their timesheets with all their hours per task. Timesheet AutoFill is for those people who only need to track time and attendance.

The Timesheet AutoFill command is in the Tools menu and, when selected, lets the Administrator decide whether to Create timesheets, add to existing unposted timesheets or to already posted timesheets. The Administrator uses the options that are appropriate to their timesheet process.

Then they can determine what to fill the timesheet with, a preset list, a list that comes only from the Employee defaults or a list that comes from Employee defaults when available and Administrator selections when not. Finally, the Administrator chooses which group or filtered group of employees to include in the AutoFill and starts the process. A log identifies exactly what timesheet data was added.

We’re conscious of TimeControl’s auditability so, we have, of course identified the hours that have been entered through AutoFill in both the Timesheet Detail and Posted Lines tables.

If you’d like to see the new function in action, take a look at the TimeControl Timesheet AutoFill webcast.