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 is.