If you installed TimeTrex with the Windows installer and you are seeing the following message:
Try changing the Windows user that the maintenance jobs are running as.
To do this go to Start -> Accessories -> System Tools -> Scheduled Tasks, right click on the TimeTrex entry, go to properties, then near the bottom change the "Run As" user to Administrator, and be sure to set the password as well.
Also it is important to ensure that the Scheduled Task is set to run every one (1) minute. If the task scheduler is not running the maintenance jobs every minute many of the jobs will be skipped and never run at all.
Once you have done that, TimeTrex should hopefully fix itself in the next 24hrs or less.
During the TimeTrex installation, if you see the following error:
Failed to create process for initdb: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
Make sure that the Secondary Logon service is enabled and running. Then re-install.
Run the following commands in a command prompt window to generate a self-signed SSL certificate:
cd C:\TimeTrex\apache2\bin set OPENSSL_CONF=c:\timetrex\apache2\conf\openssl.cnf openssl genrsa -passout pass:932a8b329 -des3 -out server.key 1024 openssl req -passin pass:932a8b329 -new -key server.key -out server.csr -subj /CN=TimeTrex openssl rsa -passin pass:932a8b329 -in server.key -out server.key openssl x509 -req -days 9125 -in server.csr -signkey server.key -out server.crt
Copy the certificate to the Apache config directory:
copy server.crt c:\timetrex\apache2\conf\ copy server.key c:\timetrex\apache2\conf\
Modify the Apache config to enable SSL:
Edit c:\TimeTrex\apache2\conf\httpd.conf and uncomment these two lines:
LoadModule ssl_module modules/mod_ssl.so Include conf/extra/httpd-ssl.conf
Edit c:\TimeTrex\apache2\conf\extras\httpd-ssl.conf change the DocumentRoot line to:
Restart TimeTrex services for the changes to take affect and test to make sure its working by pointing your web browser to https://localhost/
If for some reason the automated installer has failed, you can help us in troubleshooting the issue by re-running the installer with the following command:
<installer executable> --debugtrace timetrex_debug.xml
TimeTrex_Community_Edition_v7.3.0-windows-installer.exe --debugtrace timetrex_debug.xml
This will create a debug trace file as well you will find a install.log file in the TimeTrex directory, please email both of these files to firstname.lastname@example.org and one of our support representatives will be happy to assist you.
The following are the major system requirements for TimeTrex:
If you are getting a permission error while installing TimeTrex on Windows, or License.php is coming up blank, try the following:
1. Navigate to Start > Programs > Administrative Tools > Internet Information Services (IIS) Manager
2. Expand the tree to where the TimeTrex directory is located. Expand that directory as well.
3. Locate the templates_c directory, right click it, and choose "Permissions."
4. Locate the user: IIS_WPG. On the bottom dialog box (where allow and deny accesses are set), locate the Write permission, and check the "allow" box, do the same for Modify permissions as well. Also locate user: Internet Guest Account, and enable "write" and "modify" permissions using the same method.
5. Press OK to exit that dialog box.
6. Then highlight the "server" that appears on the left side of the Manager. Choose "action" from the menu, ALL Tasks, and then RESTART the IIS Server.
If that fails, you can also take a look at this article on setting proper write permissions.
TimeTrex requires write permissions to its: timetrex/templates_c directory as well as other directories such as its caching and storage directories set in the timetrex.ini.php file.
[root@timetrex ~]# mysql -u root mysql mysql> GRANT ALL PRIVILEGES ON *.* TO 'timetrex'@'localhost' IDENTIFIED BY '<MY_PASSWORD>' WITH GRANT OPTION; mysql> create database timetrex; mysql> quit;
Now to test that everything worked:
[root@timetrex ~]# mysql -u timetrex -p<MY_PASSWORD> timetrex
It you get the "mysql>" prompt, it worked!
If you are using MySQL with TimeTrex and you are seeing the below error message you must ensure that you have the proper time zone support as described in the MySQL manual.
If you are using Linux, run this command:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -p -u root mysql
If you are using windows, you need to download the latest time zone description files from:
Then shutdown your MySQL server if its running, unzip the time zone description files to your MySQL database data directory, ie:
C:\Program Files\MySQL\MySQL Server 5.0\data\mysql
It should ask to overwrite files that already exist, say yes. Start MySQL again and you should now have full time zone support.
Locate your pg_hba.conf file, usually it is located at: /var/lib/pgsql/data/pg_hba.conf
Once located, edit it and confirm that the "local" line at the bottom has method "password".
# TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all password # IPv4 local connections: host all all 127.0.0.1/32 password # IPv6 local connections: host all all ::1/128 password
Restart PostgreSQL to make sure the changes take effect, then confirm that you are logged in as root and follow the below commands:
[root@timetrex ~]# su postgres [postgres@timetrex root]$ createuser -P timetrex Enter password for new role: <password> Enter it again: <password> Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) y Shall the new role be allowed to create more new roles? (y/n) n CREATE ROLE
[postgres@timetrex root]$ psql template1 timetrex Welcome to psql 8.1.1, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit template1=> create database timetrex; CREATE DATABASE template1=>\q [postgres@timetrex root]$
You should now be ready to install TimeTrex with the "timetrex" user.
If you made a mistake, the easiest thing to do is drop the user and database and start over again. You can do that with these commands at the shell:
dropuser timetrex dropdb timetrex
The upgrade procedure is the exact same as the procedure performed during the initial installation, simply download the latest version from our website and install it over top of your existing TimeTrex folder. The installer will automatically detect this situation and perform the upgrade for you while retaining all of your data. You can upgrade from any older version to any newer version in a single step without a problem and the entire upgrade process usually takes around 5-10 minutes.
TimeTrex Professional, Corporate, or Enterprise Editions can be downloaded from the Online Store after you are logged in with the email address/password originally used to purchase TimeTrex.
If you have not purchased TimeTrex and you are using the Community Edition, it is available from the main download page.
Here are the steps to access TimeTrex On-Site from other computers on your local network:
1. Find the IP address of the computer that TimeTrex is installed on. In Windows this can be done by following these steps:
Ethernet adapter Local Area Connection: Connection-specific DNS Suffix . : Description . . . . . . . . . . . : Realtek RTL8139 Family PCI Physical Address. . . . . . . . . : 00-A0-D1-B9-2A-08 Dhcp Enabled. . . . . . . . . . . : No IP Address. . . . . . . . . . . . : 192.168.1.100 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 192.168.1.1 DNS Servers . . . . . . . . . . . : 192.168.1.1, 192.168.1.2
2. Once you have obtained the IP address of the computer in which TimeTrex is installed on, you can go to another computer on your local network, open a web browser and enter the following URL in the address bar:
For example, if the IP address was 192.168.1.100, you would enter this URL:
If this doesn't work, it is likely that the IP address that you used was incorrect, your network isn't setup to allow such access or you have a firewall in place that is actively blocking the connection. In any case, because TimeTrex has no control over how your computer/network is setup or what firewalls/routers may be actively blocking connections, you will need to consult a IT professional or network administrator who has experience setting up network applications to help you.
If you are a small company and you don't have access to an IT professional with this type of experience, or just simply don't want the added responsibility of hosting TimeTrex yourself, we recommend considering our TimeTrex On-Demand service. No software installation is necessary, no network settings are required, activation is instant and its extremely affordable.
On the source computer (the one that currently has TimeTrex installed on it):
1. In the TimeTrex directory, execute backup_database.bat to dump the latest copy of your database to a .SQL file.
2. Rename the newest timetrex_database_<DATE>.sql file to timetrex_database.sql.
3. Copy timetrex_database.sql and timetrex.ini.php to a temporary directory on the destination computer, for example c:\temp
On the destination computer:
1. Edit the timetrex_database.sql and delete the first 97 lines, or everything from the top of the file to just above the first line that contains:
Make sure the above line still exists in the file.
2. Install a fresh copy of the latest version of TimeTrex, however pause on the final step of the installation procedure where it asks you to launch the web browser to complete the installation.
3. Go to your “Start” button and select the “Run” option, type in:
4. In the command prompt window, navigate to the TimeTrex directory:
5. Restore timetrex_database.sql to the new TimeTrex database with the following command:
6. Edit c:\temp\timetrex.ini.php, and copy the line that starts with salt= to the new c:\timetrex\timetrex.ini.php
7. Copy the entire c:\timetrex\storage directory from the source computer to the same location on the destination computer.
8. Go back to the TimeTrex installer and complete the installation process, which will be referred to by the installer as an upgrade from now on.
9. Once the installation is complete, confirm that you can login to it with your existing username/password, then disable or uninstall TimeTrex from the source computer to prevent employees from accidentally accessing the wrong instance.
To define the export criteria for a desired 3rd party payroll software package follow these steps:
To export timesheet data to a 3rd party payroll software package:
To export General Ledger data to a 3rd party accounting software package follow these steps:
To ensure the highest level of security, TimeTrex does not store human readable images of your fingerprints in its database. Instead each time you scan your fingerprint it is converted into a mathematical representation of the distinguishing patterns that make your fingerprint unique from anyone else's and only that is stored in an encrypted form on the device itself and in the central TimeTrex database. Therefore it is not possible to convert this data back into a image of your fingerprint that could possibly be used for nefarious purposes.
Pay periods are critical to the operation of TimeTrex, regardless if you use TimeTrex for payroll or not. TimeTrex will only total time based on the length of the pay periods, and without pay periods many salary calculations can not be performed either, so it is critical that a proper pay period schedule and pay periods exist at all times.
If you are having problems with Pay Periods, the best way to fix them is to create a new Pay Period Schedule and migrate any existing data across, this ensures that the Pay Periods are correct and haven't been manually modified which often results in TimeTrex failing to carry out its automated tasks. We recommend that you NEVER manually modify Pay Periods, because TimeTrex is a 24hr/day system, so if you modify a Pay Period and are off by even 1 second, it could cause a conflict resulting in TimeTrex not being able to create new Pay Periods on its own. Usually the only reason you would need to modify a Pay Period is if the Pay Period Schedule was incorrect in the first place, so fixing the Pay Period schedule in this way is the proper solution.
Here are the steps to create a new Pay Period Schedule and migrate any data to it:
Determine the Start Date of the earliest Pay Period (usually at the bottom of the list):
1. Click the PayRoll menu item from the menu bar along the top.
2. Click the Pay Periods icon from the icon bar also located along the top.
3. From the list write down the start date of the earliest pay period (usually at the bottom of the list).
Remove employees from the old Pay Period Schedule:
4. Click the Payroll menu item.
5. Click the Pay Period Schedule icon.
6. Edit the schedule in question and unassign all employees from it.
Create a new Pay Period Schedule:
7. Create a new Pay Period Schedule that matches the settings of the existing schedule as much as possible, however when filling out the "Create Initial Pay Periods From" field, use one day earlier then the start date from the earliest Pay Period in step 3. You may also use an earlier date if you wish to enter more historical data.
8. Once the new Pay Period Schedule is created, click the Pay Periods tab, and confirm that all the necessary Pay Periods have been created starting from the date you specified, be sure that the status of each pay period is OPEN.
9. Now you are ready to import punch data from your old Pay Period Schedule to this new one. To do this simply select the newly created Pay Period Schedule and then click the Import Data icon from the icon bar.
TimeTrex should now continue to create new Pay Periods for you automatically without any manual intervention whatsoever.
TimeTrex Enterprise, Corporate and Professional Editions using the On-Site deployment model support multiple companies within a single installation. Companies are 100% separate from one another and no data is shared between them whatsoever, so this functionality is typically designed for resellers who want to host TimeTrex for their customers.
In multiple company mode TimeTrex allows you to define a single "Master Company" that can have "Master Administrators" assigned to it, the master company would typically be the company name of the reseller. Only the company defined as the "Master Company" can enable the permissions described below, as well the company logo defined for the "Master Company" is the logo that will appear on the Login page and all companies utilize the licenses for the "Master Company".
1. Go to Company -> Permission Groups, click the New icon to create a new permission group.
2. Set the name for the permission group to "Master Administrator", select 25 for the level and then click the Save & Continue icon.
4. Find the following additional permissions and make sure they are selected and Allowed: Company -> Add, Company -> View, Company -> Edit, Company -> Delete, Company -> Login as Other Employee
5. You can now assign one or more employees to this "Master Administrator" permission group either from the Permission Groups, or Employee Information'.
Once employees are assigned to the "Master Administrator" permission group, the menu option Company -> Companies menu will be available to them.
If you have installed the TimeTrex Client application and you find that after setting up the pre-amble ("~") and post-amble ("CR") nothing is happening when you scan a barcode, you may need to install the Microsoft Visual C++ v8.0 libraries located here:
In-Direct Link (click Download button near top of page)
TimeTrex does its best to account for clock skew or tampering whenever possible, but in some situations, especially offline mode when the server can't be reached and the clock skew is more then one day, there isn't much it can do.
Because of this, we recommend that you enable Internet Time Server clock synchronization and disable the ability to change the clock by using Local Security Policies.
To enable internet time server synchronization:
1. Right click on the clock in the lower right hand corner of the screen.
2. Adjust Date/Time
3. Click the "Internet Time" tab.
4. Check "Automatically synchronize with an Internet time server"
5. Make sure a time sever is selected.
6. Click the "Update Now" button.
To prevent employees from changing the system clock:
1. Go to: Start -> Control Panel -> Administrative Tools -> Local Security Policy
2. Once in Local Security Settings, go to: Local Policies -> User Rights Assignment
3. On the right hand side, double click on "Change the system time"
4. Remove all users or groups from the list, press "OK"
5. Logoff or reboot your computer.
TimeTrex has the functionality to setup a secure "override" password that allows anyone with knowledge of that password to login as any user in the system, regardless of what their actual password is.
This is useful if a user has forgotten their password and didn't specify an email address to use the "forgot password" functionality. Or for testing advanced permissions/hierarchies where you want to login as other users for testing purposes.
To do this, simply edit the timetrex.ini.php file, and under the [other] section near the bottom of the file, add the following line:
override_password_prefix = <secure_password>.
override_password_prefix = eight8nine9.
The way this works, is that the override prefix that you specify above is just that, a prefix, the full password depends on the user name in the following format:
<override_password_prefix><first two characters of user name>
User Name: john.doe Password: eight8nine9.jo
TimeTrex allows each employee to display time in their own preferred format, which can be set under MyAccount -> Preferences. Its important to understand the difference between the Time Unit formats that are supported, for a detailed explanation please see the Employee Preferences section of the Administrator Guide.
Because TimeTrex supports multiple formats, it may seem like it is adding time incorrectly, but its actually the nature of how time works when it comes to different formats and rounding. TimeTrex actually stores time to the nearest second in its database, but can display time in several formats to the employee.
For example, if the Time Units format selected under MyAccount -> Preferences is "Hours (2.25)", and if an employee works 8.01 hours on Monday and Tuesday, TimeTrex will show a total of 16.02 hours so far for the week. However if you change the time format to "hh:mm (2:15)" it will show that the same employee worked 08:00 on Monday and Tuesday for a total of 16:01 for the week. The reason for this difference is that 8.01 hours is actually 28,836 seconds, or 8 hours and 36 seconds, its not rounded to the nearest minute. Since the time format of "hh:mm (2:15)" can only display hours and minutes, TimeTrex rounds off the 36 seconds and displays just 08:00 instead. However when totaling multiple times together, only the final total is rounded, so that is why the total time for the week is displayed as 16:01, because its actually 16:01:12 (16hours, 1 minute and 12 seconds) with the 12 seconds being rounded off.
Because of this, we recommend that you use the "hh:mm (2:15)" time format as it makes entering time to the nearest minute much easier. For example its impossible to enter just 5 minutes using the "Hours (2.25)" format, as it would be 0.083333333... (repeated to infinity), however its easy using the "hh:mm (2:15)" time format as its would just be 00:05.
TimeTrex is able to handle employees tracking their time from an unlimited number of timezones all at once, however to be consistent all times are displayed in the timezone that the currently logged in employee has selected under MyAccount -> Preferences. This is consistent with calendar programs that display all scheduled events in your own current timezone, events are not displayed in some other timezone of the person who initiated the event, as that would cause confusion between all parties involved and no one would arrive to the event on time. In addition when displaying reports (such as the Whos In Summary report to see all employees currently working) all times are displayed in a single consistent timezone, so you can see in your own timezone when an employee arrived to work and if they are currently at work or not.
When entering time into TimeTrex, by default it is entered in the timezone that the currently logged in employee has selected in their preferences. Therefore if a supervisor located in an Eastern timezone is viewing the timesheet of an employee located in a Pacific timezone, all the employees punches will be displayed in the Eastern timezone equivalent. As an example, if an employee punched in at 8:00AM Pacific (PST) time, the supervisor would see that as 11:00AM Eastern (EST) time and if the supervisor wanted to modify this punch to 7:30AM Pacific (PST) time, it would have to be entered as "10:30AM" (which is assumed to be 10:30AM Eastern (EST) ) or alternatively the full timezone could be specified after the time in the same field to define a timezone separate from the one set under MyAccount -> Preferences, for example "7:30AM PST".
For a step-by-step guide on clearing the cache for each web browser, please see the following link: http://www.wikihow.com/Clear-Your-Browser's-Cache
If you are receiving a message similar to this:
TimeTrex is unable to connect to its database, please make sure that the database service on your own local TimeTrex server has been started and is running. If you are unsure, try rebooting your server.
It is often caused by your computer crashing or being restarted/turned off without properly shutting down first. TimeTrex is an enterprise class application and as such is designed to be installed on a dedicated server that is always running and not turned off. If you do not have a proper server to install TimeTrex on we recommend considering our free cloud hosted version of TimeTrex instead, as no software installation is necessary with it. In order to correct this issue you will need to delete the c:\timetrex\postgresql\data\postmaster.pid file, then restart your computer.
TimeTrex Community Edition is open source and 100% free to use. It does not have any time limits, or restrictions whatsoever.
There are several different editions of TimeTrex that are available. The Community Edition is completely free, however we also offer Professional, Corporate and Enterprise Editions in both On-Site and Cloud Hosted deployments which we do sell. For more information on our different products, please see our Product Comparison Guide.
TimeTrex Community Edition (formerly Standard Edition) is a free product supported by the thriving community that surrounds it. We urge everyone using this product to join the Community Forums to ask questions of all kinds and contribute back by helping others. The larger and more active the community becomes, the greater everyone can benefit from it.
If your issue is urgent, or you just prefer to talk to someone directly, the TimeTrex corporation does offer telephone support, implementation and training at an affordable price, for more information about these support packages please see our Online Store.