Time Clock Software Blog

A Blog from the authors of Time Clock MTS, a cost effective time and attendance software solution

Update to Database Export Tool Posted

We’ve just posted a small update to our tool to export data to SQL Server or MySQL. The rather imaginatively named “Database Exporter” will now gracefully handle the case where NULL values have been inserted into numeric database columns. This can ONLY happen if you’ve added custom data columns to the Time Clock MTS database, as Time Clock MTS is well-mannered enough to make sure it actually inserts values into numeric columns rather than leaving them NULL or empty. The latest version of our Database Exporter tool can be downloaded from here. Note that this tool CAN ONLY BE RUN FROM A COMPUTER WITH TIME CLOCK MTS INSTALLED ON IT as it is dependent on libraries that are installed with our time clock software. Note also that it must be installed in the same folder that Time Clock MTS... read more

Setting up Simple 40 Hour Weekly Overtime

Here’s a question we got recently from a user: I’m wondering how to setup our overtime rules. Our overtime is calculated based off a Sunday to Saturday work week. Any hours worked over 40 should be paid at overtime rate. There’s two things to answer here, firstly, how to setup the work week, and second, how to setup the simple 40 hour weekly overtime. The first day of the work week can be configured from the Tools->Options->Payroll Settings screen, which is only accessible when you’re logged in as the time clock administrator. The Payroll Settings screen scan be seen below. To change the First Day of the Week choose an option from the First Day of Week dropdown. In this case we’re going to choose Sunday. This means that overtime calculations will start on Sunday of each week. Next we need to adjust the overtime settings to suit, overtime settings are available on the Tools->Options->Overtime Settings screen (see below). Setting up weekly overtime using this screen is quite simple. Make sure ALL boxes are unchecked except for the Pay Weekly Overtime box. Enter the Weekly Overtime Limit in the text box next to this checkbox, in this case 40 hours. The final step is to choose a Overtime Calculation method from the Overtime Calculation dropdown box. We’ll choose “Weekly Only” in this case. When you’re happy with settings click the Save button and you’re... read more

Exporting Time Clock MTS Data to SQL Server or MySQL

We’ve just made setting up Time Clock MTS to work with a SQL Server Database or a MySQL Database much more quicker and simpler. Our new Database Exporter tool (see the image below) can take all of your existing time clock data and send it straight to an empty SQL Server / SQL Express database or to an empty MySQL database. It makes setting up the Network PLUS Edition of Time Clock MTS a whole bunch easier, allowing your time clock to support up to 100 time clock stations and track up to 1000 employees! You can read more about the Network PLUS Edition of Time Clock MTS... read more

Dusty’s Auto Electrical and Mechanical and Time Clock MTS

The following was emailed to us by Dusty Straub, owner of Dusty’s Auto Electrical and Mechanical, based in Roma, Queensland. We specialize in Auto Electrical and Mechanical repairs to mainly heavy vehicles. We are a small shop operating for 3 years now, we have 2 full time employees plus myself. We have started using TimeClockMTS to record the hours worked on jobs for the shop. It’s a perfect solution, as it allows us to centralize and secure the data collected on an in-house server we run. We have a record of the hours logged to any job and we can “prove” to our customers we have worked those hours on the job. Its more accurate than employees guessing times, as in the past we lost a lot of time with our employees going from job to job and not writing it down. We also have contract staff come in from time to time and they are able to clock in and record their time on-site. They can print off a time attendance sheet which becomes the basis for their invoice based on the time they were here. This avoids any discrepancies with times. As a small business located in Western Queensland, we find Internet services are not always reliable. Hence my reluctance to use cloud based solutions. TimeClockMTS offers us a choice to own our software so to speak and avoid paying ongoing fees for fragmented cloud services. The server provides other services such as mail and intranet for our business. We run MySQL as our backend database for everything. It is easy to manage and backup, so when... read more

Time Clock MTS Versions 6.1.2 and 6.1.3 Released

It’s been a rough few weeks here for us due to a number of technical issues. The complete failure of our Windows 7 build machine kicked it all off. We decided to move to Windows 10 for our build process and that took a bit longer than expected. Throw in some issues that Windows 10 caused, a fairly significant problem with the installer for Time Clock MTS version 6.1.1 that raised issues with a number of users, a false positive virus scan on the program installation file, an obscure Windows XP bug, and dealing with time clock computers with broken Windows Fonts and you’ve got a set of circumstances that have tried us. Never the less, we’re sure we’ve seen all of that off and as a result we’ve come out the other side with a better, more reliable product. Two releases have happened in the last two weeks, versions 6.1.2 and 6.1.3. The changes should be invisible for most people, but I’ll detail them anyway. Windows Font Issues There were at least two users who (somehow) didn’t have the regular version of the Times New Roman font installed on their computer. The reporting system of Time Clock MTS is dependent on this being present, and given that it’s a default Windows font you can (usually) rely on it being present. The software was failing silently if the font was missing. This error is now caught and presented to the user. Fixing the missing font is as simple as finding the valid times.ttf file on another computer, copying it to the broken computer, and installing it. Client First Run... read more
Page 3 of 7812345...102030...Last »