Category Archives: hms software

HMS is celebrating a remarkable 40 years in business today. 

HMS Software 40th anniversary, TimeControl, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisThe statistics were not in our favor.  45% of companies don’t survive five years.  95% percent of companies don’t survive 30 years.  So we are delighted to be here to tell you that it is our 40th birthday and we could not be prouder.  We thought of how to share this news.  A cake of course, but how would we get it all to you?  A song and dance perhaps on social media, but we’re not that musically inclined.  We decided in the end to ask Gail Robinson who is known to many of you as the source of much of our marketing material to interview Chris Vandersluis.  We wanted our President and the founder of HMS Software to look back and tell us about how HMS has continued to be so successful over such a long period of time.

Gail: Mr. Vandersluis, can you bring us back right to the beginning in 1984 and explain the motivation for starting HMS?

Chris: Sure.  I actually co-founded the company with a partner at the time.  He and I got it started.  We were a two-man consulting company with a lot of enthusiasm and some experience in project management systems.  Our first client was Philips Information Systems who actually designed and manufactured personal computers which were competitors to the IBM PC at the time.  The proliferation of personal computers was just picking up momentum and we were at the right place and the right time to be advisors and consultants about software.  Project Management software is everywhere these days but in 1984 that wasn’t the case.  There were only a few vendors who made such software and we picked one of them for Philips.  The deployment was complex but we were aided a great deal by the company having an established and experienced Project Management Office.  We would come to find out that wasn’t as common as we would have hoped.

The implementation required a timesheet along with the scheduling tool we had picked and Philips agreed to let us write it for them.  That was our first experience with creating a project-based timesheet system. 

My partner and I would work together for some 10 years before he decided to move onto other things but in that time HMS had become recognized as a leader in Canada in high-end project management systems. 

Gail: We call ourselves HMS Software but the full legal name of the company is Heuristic Management Systems. Inc.  Where did that come from?

Chris: That didn’t actually happen until 1987.  The company was continuing to expand and we were hiring our first employees.  We decided to incorporate HMS but we were told by the Canadian government that our “HMS Software” was too close to the names of other possible companies and we would have to expand the acronym.  The original “H” had been for the town my partner lived in so we decided that wasn’t going to work.  We knew the “M” would be “Management” and the “S” would be “Systems” but we struggled for weeks with what the “H” should be.  Finally in frustration, we sat down with a dictionary, committed to find a word in the “H” section we could live with.  We got to “Heuristic” and thought how appropriate it was for people interested in project management analysis. 

Gail: So HMS was primarily a consulting firm in its first 10 years?

Chris: Actually, we took on a product line from a company in Houston, Texas called Welcom Software.  They had the scheduling tool Open Plan that we had deployed at Philips and we became their Canadian distributor.  The combination of reselling Welcom Software’s products and our own consulting was our primary business during that time.  Apart from Philips we were also called upon to write two or three additional timesheet systems during that time which would all come in handy in 1994.

Gail: When did HMS expand from its Canadian focus to its worldwide servicing now?

Chris: In 1993 My partner and I started talking about going our separate ways.  It was an agreeable separation.  I wanted to keep the project management focus and he had other ideas that better suited him so we crafted a deal where I could buy him out of the business.  That culminated in 1994.  My thinking had been to shift from being a distributor and consultant to becoming a software publisher.  All our experience in project-based timesheets had given us some amazing background and experience in that domain and I decided that a timesheet would our first product.  All the timesheet systems we’d written until then had been DOS based interfaces, so character only screens.  We put together a new timesheet in that same mode and called it TimeControl version 1 but we were already hard at work creating a Windows version which would become TimeControl version 2.  That took off at a pace that surprised us and we never looked back. 

It’s HMS Software’s 40th anniversary but it’s also TimeControl’s 30th anniversary which we plan to celebrate later this year.

Gail: That’s a remarkable transformation.  What happened with your dealings with Welcom Software?

Chris: We continued to distribute their Open Plan and Cobra products for a few more years but TimeControl took up more and more of our time and we finally decided to end our distribution agreement.  Again, it was an amicable arrangement.  Welcom would later be purchased by Deltek.  Open Plan and Cobra are still products under the Deltek EPM product line and TimeControl has active links to those products even today, 30 years later.

Gail: Were your sales always done directly from the Montreal office?

Chris: There was a long time when products like TimeControl and other project management products needed local representation to be successful.  We embarked on a campaign of recruiting TimeControl dealers some of whom we have maintained business relationships with even today.  But the whole distributor, dealer paradigm started to shift in the early 2000s as Internet speeds increased.  Where once we would have expected a dealer to get in their car and go sell TimeControl to a local prospective client, now that client was asking us to video conference that demonstration so they could see it from the publisher.  It was quite a dramatic shift in the software business and it wasn’t unique to us.  At that time, you’d have had to be a massive company to be able to buy software directly from Microsoft but these days, armed with a credit card, you can sign up for their software in minutes.  Those changes weren’t even restricted to our industry.  Finding a travel agent or insurance broker is much less common as people book their own travel or sign up for insurance online.  So these days, yes, most of our sales are done in communication with our own staff in our Montreal and Toronto offices and the clients could be calling from anywhere.

Gail: Where has TimeControl been sold?

Chris: It’s all over the world.  TimeControl is in use on every continent but Antarctica.  In fact, there was a bid to provide timesheets for the US base in Antarctica many years ago and I would have loved to have closed that deal but the timing was all wrong and we weren’t able to participate.  Having clients worldwide is both a privilege and a challenge.  We have users in all or almost all time zones.  We have users who speak many different languages and have many different devices.  We’ve tried to ensure that TimeControl is highly flexible and highly responsive to different types of users.  It supports multiple languages but the module for creating a new language definition file is included too.  So, if there’s a language we didn’t support or we supported a dialect that the client doesn’t prefer, the client themselves can translate perhaps just the timesheet or as much of the interface as they wish.  Localization also carries to things like currency symbols and the way a date is displayed.

Gail: It’s a pretty remarkable team here.  How long have they been together?

Chris: The staff are all amazing at HMS.  Of our current employees we have three people who have been in the company since the 1980s and have seen the entire evolution of TimeControl from version 1 through today’s 8.5.  It’s not common anymore for people to say they’ve made a career at an IT company but it’s been true here and I find it humbling.

Gail: It’s a remarkable story so far.  Is 40 years enough?

Chris: We’re showing no signs of slowing down.  Last year was our biggest year ever.  The year before was until then the biggest year ever.  We’re both profitable and growing and for any software publisher, that’s as good as it gets.  We’re working hard on the next version of TimeControl and all its iterations including TimeControl Project.

As for myself, I’m not going anywhere.  I’ve been privileged to be part of something that has impacted so many organizations.  Our clients have put things into space and have created incredible engineering marvels.  They’ve made medicines to cure disease.  What else could I do that would have that kind of impact?  It’s been 40 years so far but I can see HMS growing for years to come.

Our websites are sporting a whole new look!

We’re excited to tell you about a major overhaul of HMS Software’s web environment.  HMS are the publishers of TimeControl, the world’s most flexible timesheet system.  This is a significant change to one of the world’s most venerable web environments.
“The HMS Software websites are among the oldest in the world,” said Chris Vandersluis, President of HMS. “HMS has been around for 31 years and the original HMS Software website was established in the mid 1990’s just aver the release of the original Netscape browser.”
Over the last 20 years, the HMS Software web site has gone through a generational change every few years.  As the publishers of TimeControl, one of the world’s most popular timesheet systems, the web environment expanded beyond a simple website to accommodate the numerous perspectives of different types of users.
The original website was more of an online brochure and was one of the first of its kind.  We were rather proud of being about the 7,000th entry in the Yahoo directory.  That might not seem like the very start but the Yahoo directory was registering over 16,000 websites a day at its peak.  With the release of TimeControl in 1994, HMS started to expand the web environment quickly.  The most current iteration of the TimeControl sites has been across 5 domains: timecontrol.com, industrial.timecontrol.com, timecontrol.net, hms.ca and the original hmssoftware.ca.
Under the completely new design, the web environment will be pared down to three domains to respond to the core elements of HMS Software’s business.
The new site structure will allow us to better serve visitors with streamlined navigation, support for multiple devices such as tablets and smartphones and easier to find material.  With so much collateral available on the three sites, it should be much easier to locate and use with the new design.

The main site for TimeControl will remain timecontrol.com where existing clients will still be able to log in and get support and update information as well as access the extensive library of webcasts, white papers, factsheets and other technical collateral.  Prospective clients will be able to try TimeControl for free on the hosted trial site which they can register for here.  Prospective clients can find out about buying TimeControl for on premise installation or subscribing to the TimeControl Online service here. 


www.hms.ca

The corporate site will now become hms.ca where information about clients, new partnerships or marketing will be managed.  Traffic from the original hmssoftware.ca will be redirected to this site.This site contains our HMS history and news about us such as press releases.

industrial.timecontrol.com

For those interested in TimeControl Industrial, HMS Software’s field data collection version, information will remain at industrial.timecontrol.com.  Here the additional features of crew timesheets and tracking material and equipment usage will be explained along with the other features of Industrial.

The new websites have been optimized for numerous browsers, devices and operating systems so those who are using a tablet or smartphone to access the sites will be able to enjoy a rich user experience.

Wow, what a year!

Thanks to our remarkable clients 2014 was a record year of growth and productivity for us.  HMS experienced growth in every category including services, TimeControl for on-premise, our subscribed TimeControlOnline service and even support services.  So, a big thank you to both our dedicated staff and, of course, our expanding clientele.  2014 was our 30th year of operation and 20th year of operation for TimeControl but we feel like we’re just getting started.
In 2014 we released TimeControl 6.7 and 6.8 including such popular and powerful features as the TimeControl Workflow engine and the new Accruals Module.  We also finally said goodbye to the last of our old ActiveX controls.  They continue to be supported as a legacy feature but new installations of TimeControl won’t even see them by default.
2015 promises to be even more exciting!  We are already putting the final touches on TimeControl 6.9 which is scheduled for release in February and design is underway for a major new wave of TimeControl which we’ll tell you more about during the summer.  We’ll be giving you a sneak peek at the new marquis feature of TimeControl 6.9 right here in the blog in the next couple of weeks!
So, 30 years of HMS history are now behind us but the best is yet to come!

Managing multiple instances of TimeControl

HMS has long supported the notion of having both a production and a staging installation of TimeControl and do not charge additional licensing costs for such use of the system. It is common, for example, to have a staging instance to use for testing upcoming versions or to use for training or internal development of reports, filters and validation rules prior to making these enhancements available to production users. A number of clients have asked what the steps are to support promoting from one instance to another. Once a version or a feature has been tested in the staging environment, how do we then make this available in the new environment? We’ve outlined some standard steps in managing multiple instances in this post.

How to create a second instance of TimeControl

Create a 2nd instance in a virtual environment

Case 1:

TimeControl is installed in a Virtual Machine environment and the database server and database are on the same Virtual Machine. Steps:

  1. Copy the Virtual Machine
  2. Change the IP to be unique
  3. Change the name of the Database Server to be unique
  4. Modify TimeControl.ini to point to the new IP
  5. Modify TimeControl.ini to point to the new database server
  6. Modify TimeControlWeb.ini to change the server’s IP address
  7. Modify host-headers in IIS to be unique and other DNS information as required
  8. See the “Cautions” section below
Case 2:

TimeControl is installed in a Virtual Machine environment and the database server and database are on different Virtual Machines. Steps:

  1. Copy / Backup both the TCSecure and TIMECTRL databases/schemas
  2. Create unique database names for each of these two databases (e.g. TCSECURE_Staging and TIMECTRL_Staging) and copy/restore the database files/schemas
  3. Copy the Virtual Machine
  4. Change the IP to be unique
  5. Modify TimeControl.ini to point to the new IP
  6. Modify TimeControl.ini to point to the new database names
  7. Modify TimeControlWeb.ini to change the server’s IP address
  8. Modify host-headers in IIS to be unique and other DNS information as required

Create a 2nd instance in a separate physical environment

If you are not using a Virtual Machine environment and instead have physical servers and want to set up a 2nd instance of TimeControl on a separate server, this will be the procedure. We will assume the database is also installed on a separate server but even if it is on the original TimeControl server, there is no obvious requirement to install a completely separate instance of your database software. Steps:

  1. Copy / Backup both the TCSecure and TIMECTRL databases/schemas
  2. Create unique database names for each of these two databases (e.g. TCSECURE_Staging and TIMECTRL_Staging) and copy/restore the database files/schemas
  3. Install the identical version of TimeControl on the new server
  4. Use the TimeControl Database Configurator to attach the new instance of TimeControl to the new databases.

Create a 2nd instance in the same physical or virtual environment

Some organizations wish to install a 2nd instance of TimeControl on the identical physical server. (It is quite unusual to install multiple instances on a virtual server as it is so easily replicated). Installing a 2nd instance of TimeControl on the same physical server is possible however the standard installation modules and upgrade modules will only work on the default installation. In order to update multiple instances on the same physical server, a series of manual steps must be performed. HMS Technical Services can guide you through this process if you require it.  

Cautions

Once you have copied your 2nd instance, you may wish to check for scheduled and automated functions that were activated in your production instance that you may wish to disable in your 2nd instance. These may include the following:

  1. Project Management Links
    If there are links to a project management system, then the scheduled links you’ve created will activate on schedule if you don’t make any changes. The Connection Pool information in the Interface Definition will be pointing to your production project management tool. If there is a scheduled job pending then data will move in and/or out of the project tool as scheduled. If there is pending posted data for the pm system or if you enter any data in the 2nd instance, it will be sent to your project pm system. We recommend immediately disabling scheduled jobs and repointing the interface definition to a 2nd project management system instance.
    Caution: If you do not repoint these project links to a non-production instance of your project management tool or disable the links, then you may send duplicate timesheet entries to your project management system!
  2. Email notifications
    If you have scheduled automated email notifications of missing timesheets, the 2nd instance will start happily sending them out along with the production instance. We recommend disabling any scheduled jobs.
    Caution: Not disabling email notifications can cause confusion as users may receive email notices from the 2nd instance complaining of a missing timesheet which has already been completed by the user in the main instance.
  3. Triggers
    If you have made triggers within the database to move data in and/or out of TimeControl to link to finance, payroll, billing etc., these triggers will continue to function in the 2nd instance unless you disable them.
    Caution: Not disabling triggers which were designed to move data to finance for billing or payroll may result in data being sent twice!

How do we promote features between instances?

Once you have a 2nd instance implemented and you have checked the Caution section and taken the appropriate actions, you are able to start thinking of how to use the 2nd instance for testing and staging. There are some elements of TimeControl which were designed to be easily moved between instances. Other elements are more difficult.

What can be promoted easily

  1. Filters
  2. Validation Rules
  3. Language Definitions
  4. Reports

For all 4 of these categories, you can create a Export Package from the Links menu. Exporting a Validation Rule will also export any filters which are reference within it. Exporting a filter will also automatically include any “filters within filters” which are referenced. In the production instance, you can then Import a Package from the Links menu and this item will be successfully promoted and instantly available.

Categories of data that are more difficult to promote

  1. User Defined Fields
  2. Pop-up values for user defined fields
  3. Import/Export definitions
  4. Personal settings

For these categories, we assumed that this information would be updated directly in the production system. User Defined Fields are typically only created during the deployment. The Import/Export definitions carry an entire audit aspect of them which is managed behind the scenes and Personal settings are, well, personal. The best practice for almost all cases involving these 4 categories is to create them manually in the production instance.

Other methods of moving data from staging to production

There are several other methods of moving data from the 2nd instance back into production but each requires some skill.

  1. Export tables from staging and Import into production
    TimeControl’s standard export and import modules allow all kinds of data to be moved. Export from one system and Import to the 2nd system definitions can be created and saved and then the actual creation of the transaction file and its import is very quick.
  2. Triggers and custom code
    For those who have more intimate and long standing links required, creating triggers at the database level can be accomplished. This has the benefit of being hidden from the user and the disadvantage of being hidden from the user. When triggers move data automatically in the background, a best practice is to have solid process and procedure documentation that lets all relevant parties know what is happening to the data and why.

Maintaining a “Cold Server” for disaster recovery

Some organizations have a requirement to create a “Cold Server” and keep it in stand-by for disaster recovery. This is relatively simple to do. First, follow the instructions on creating a 2nd instance to ensure it has been updated correctly. You will need to update the 2nd instance each time you do a TimeControl Upgrade of the production instance. Once the instance is established, you can hibernate the Virtual Machine or turn off the physical server (if it is dedicated) or simply turn off the TimeControl ATS, TimeControl TTS and TimeControl Scheduler Services along with the TimeControl Website (In IIS) Second, ensure that regular backups of your production instance are occurring. Should a disaster occur, activating the Cold Server is very simply:

  1. Turn on the Virtual Machine, turn on the Physical Server or Start the TimeControl ATS, TimeControl TTS and TimeControl Scheduler as required.
  2. Restore the production database backup to the 2nd instance

Ask for help

HMS Services often assist our TimeControl clients with establishing and updating multiple instances.  Contact customer server at info@hms.ca to inquire about our services.