From TimeTrex
Jump to: navigation, search
Timetrex logo.png

Frequently Asked Questions (FAQ)



Automated Installer

Why are Maintenance Jobs not running after using the Windows Installer?

If you installed TimeTrex with the Windows installer and you are seeing the following message:

Warning.gif WARNING: TimeTrex maintenance jobs have not run in the last 48hours. Please contact your TimeTrex administrator immediately.

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.

Why am I getting a PostgreSQL installation error when using the Windows installer?

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.

How do I setup Apache to use SSL with a self-signed certificate?

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/
Include conf/extra/httpd-ssl.conf

Edit c:\TimeTrex\apache2\conf\extras\httpd-ssl.conf change the DocumentRoot line to:

DocumentRoot "C:/TimeTrex/timetrex"

Restart TimeTrex services for the changes to take affect and test to make sure its working by pointing your web browser to https://localhost/

Notepad.gif NOTE: Because this is a self signed certificate your web browser will likely complain that it may not be valid, this is normal and you will need to add an exception in your web browser to prevent it from alerting you in the future.

What do I do if the installation has failed for some reason?

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

For Example:

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 and one of our support representatives will be happy to assist you.

Manual Install

What are the system requirements?

The following are the major system requirements for TimeTrex:

  • Automated Installer
- Windows 2000/XP/Vista or newer, Linux, MAC OSX (Intel)
- 1GB of hard disk space available
  • Manual Install
- Windows 2000/XP or Linux
- IIS or Apache web servers
- PHP v5.2 or greater with PEAR installed and SAFEMODE disabled
- MySQL v4.1.3+ or PostgreSQL v8.0+
TimeTrex requires PHP v5.0 or greater because it utilizes many object orientated (OO) programming features that are only available in PHP v5+.

Why am I getting a permission error after installing TimeTrex on Windows?

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.

MySQL Database

How do I create a user and database for TimeTrex in MySQL?

[root@timetrex ~]# mysql -u root mysql
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!

Why am I getting the error: TimeTrex was unable to set your time zone?

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.

Warning.gif WARNING: TimeTrex was unable to set your time zone. Please contact your TimeTrex administrator immediately.

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.

PostgreSQL Database

How do I create a user and database for TimeTrex in PostgreSQL?

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

# "local" is for Unix domain socket connections only
local all all password
# IPv4 local connections:
host all all 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
[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;
[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


How do I upgrade TimeTrex while retaining all my data?

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.

How do I access TimeTrex On-Site from other computers?

TimeTrex is offered in two different deployment models, On-Site and On-Demand. Please click on either of the links for more information regarding the advantages and disadvantages of both models.

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:

  • a. Go to your “Start” button and select the “Run” option
  • b. Type in: cmd /k ipconfig /all
  • c. A command window will pop up and list your IP address, there may be several IP addresses in the list, normally your IP address will be similar to one of these:, or
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. . . . . . . . . . . . :
Subnet Mask . . . . . . . . . . . :
Default Gateway . . . . . . . . . :
DNS Servers . . . . . . . . . . . :, 

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:

http://<IP Address>:8085/

For example, if the IP address was, 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.

How do I migrate TimeTrex On-Site from one computer to another?

Warning.gif WARNING: Migrating TimeTrex and all its data from one computer to another is an involved process and should only be done by an experienced IT professional or a TimeTrex Support representative.

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:

\connect timetrex

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:

cd c:\timetrex

5. Restore timetrex_database.sql to the new TimeTrex database with the following command:

restore_database.bat c:\temp\timetrex_database.sql

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.

How do I export data to a 3rd party payroll or accounting software package?

To define the export criteria for a desired 3rd party payroll software package follow these steps:

  1. Click the Report menu item in the menu bar along the top.
  2. Click the Payroll Reports icon in the icon bar also located along the top.
  3. Click on the Payroll Export item from the Payroll Reports drop-down menu.
  4. Inside the inset that appears select the desired template and other options for the report, in most cases the first template in the list will suffice.
  5. Click on the Export Setup tab located on the inset.
  6. From the Export Format drop-down menu choose the desired export file format.
  7. If necessary configure any fields specific to your payroll software, including hour code names to map TimeTrex hours to their corresponding names in your payroll software.
  8. Click the Save Setup icon to keep the export information for later use.

Notepad.gif NOTE: QuickBooks integration requires that you obtain the Company Created Time from QuickBooks itself so it can be entered in the Company Created Time field under the Export Setup tab described above. To do this follow these steps:

  1. Open your QuickBooks company file
  2. In QuickBooks, go to File > Utilities > Export > Timer Lists.
  3. Save the IIF file and open it with Notepad or any other text editor.
  4. Search on the 2nd line for the Company Create Time number which should have this format 1320645324

To export timesheet data to a 3rd party payroll software package:

  1. Click the Report menu item in the menu bar along the top.
  2. Click the Payroll Reports icon in the icon bar also located along the top.
  3. Click on the Payroll Export item from the Payroll Reports drop-down menu.
  4. Inside the inset that appears select the desired template and other options for the report, in most cases the first template in the list will suffice.
  5. Click on the Export icon to export the payroll report file to your computer.
  6. Now that the data is on your computer you may follow the directions provided by your payroll software provided on importing data.

To export General Ledger data to a 3rd party accounting software package follow these steps:

  1. Click the Report menu item in the menu bar along the top.
  2. Click the Payroll Reports icon in the icon bar also located along the top.
  3. Click on the General Ledger Summary item from the Payroll Reports drop-down menu.
  4. Inside the inset that appears select the desired template and other options for the report.
  5. Click on the Export icon from the icon bar.
  6. Choose the export format that matches your accounting software.

Hardware Devices

Tablet TimeClocks

How do I lock the tablet so employees can use just the TimeTrex App?

For iOS based tablets, enable guided access mode by following the instructions here:

For Android based tablets, enable screen pinning mode by following the instructions here:


How do I migrate from one Pay Period Schedule to another?

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.

Notepad.gif NOTE: If you do not plan on using TimeTrex for payroll, we still recommend that you configure the pay periods to match what your pay periods actually are, or setup a weekly pay period schedule at the very least.

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.

How do I enable multiple company support in TimeTrex?

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.

Notepad.gif NOTE: TimeTrex does support multiple branches within a single company and you can restrict supervisors so they can only see employees within a specific branch, therefore if you wish to track time at different branches/locations within your organization you should use the branch feature instead, this will allow you to easily share data and run reports over multiple branches.

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.

3. Using the Permission Wizard select Administrator from the Role drop-down box, and then click through the rest of the wizard and then the Done-18x18.png.

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.

Warning.gif WARNING: Only limited administrator functions can be carried out for other companies when logged in as a "Master Administrator", this includes creating a new company, and creating new employees for that company. We highly recommend that when creating new companies, the master administrators immediately create an "Administrator" employee for the new company, then login as that "Administrator" if they need to add additional employees or administer that company itself. Master administrator's can easily login as employees for other companies by going to Company -> Company Administration, clicking the Employees button beside any of the companies, then clicking the Login button beside a specific employee.

Notepad.gif NOTE: Anytime permission groups are changed employees may need to clear their browser cache or hold SHIFT while clicking the refresh/reload button in their browser.

Why do barcodes not work with TimeTrex Client Application sometimes?

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:

Direct Download Link

In-Direct Link (click Download button near top of page)

How do I prevent employees from changing the system clock in Windows?

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.

I forgot my password and TimeTrex won't email me a new one, what can I do?

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

For example:

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>

For example:

User Name: john.doe

Warning.gif WARNING: We DO NOT recommend leaving a override password prefix in place, as this can be a security risk. Once you are done using the override password, please remove it, or comment it out so it is deactivated

Why does TimeTrex display different time amounts or totals that do not add up?

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 it would just be 00:05.

I have employees in multiple timezones, but TimeTrex shows all time in the same timezone, whats going on?

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

How do I clear my web browser's cache?

For a step-by-step guide on clearing the cache for each web browser, please see the following link:'s-Cache

TimeTrex is unable to connect to its database and I can't login, what do I do?

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\ file, then restart your computer.

Free Community Edition

Is TimeTrex open source/free?

TimeTrex Community Edition is open source and 100% free to use. It does not have any time limits, or restrictions whatsoever.

Why do you sell TimeTrex on your Online Store then?

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.

What if I need support with the free Community Edition?

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.