TimeTrex Time and Attendance

Hello, there is a new version of Postgres 11.4.1 and still I cannot install your timetrex. I cannot downgrade according your howto because I have Ubunutu 16.04 So what is the workaround for me? Unfortunately the PostgreSQL community has not yet released a new version that fixes the bug causing Time...

Have you completed the data mapping grid at the bottom of the Export Setup tab? By default with ADP all the ADP hours are set to "DO NOT EXPORT", so you need to click on those and change them to the proper selection and hour code values to match how your ADP is setup. Once you are done, be...

ventieldopje wrote: ↑Tue Jul 30, 2019 12:11 pm Problem solved, not all fields of company information are filled in . If i fill in every field it works.

Excellent, I think it was specifically related to the "City" field not being filled out, and that issue will be fixed in the next version of TimeTrex.

Upon further investigation, if you are not filling out *all* the fields on the "Company Information" step, it may be causing an error later on in the install process. Please make sure you complete all fields during the installation and see if that makes a difference.

If you are running PostgreSQL 10.9, we have posted a quick guide on how to work around the PostgreSQL bug that is affecting new TimeTrex installs here:
viewtopic.php?f=6&t=7837

We have posted a quick guide on how to work around the PostgreSQL bug that is affecting new TimeTrex installs here:
viewtopic.php?f=6&t=7837

We have posted a quick guide on how to work around the PostgreSQL bug that is affecting new TimeTrex installs here:
viewtopic.php?f=6&t=7837

NOTE: As of August 8th 2019, this bug is fixed in all supported versions of PostgreSQL, therefore the below instructions are no longer required. Unfortunately a bug was introduced in PostgreSQL v9.4.23, v9.5.18, v9.6.14, v10.9 and v11.4, all of which were released on 20-Jun-2019. The specific bug w...

According to the log file, the database creation step succeeded without a problem, so you are running into a different issue. I noticed several permission errors in the log file, which could be contributing to the problem. However to know for sure please turn on debugging mode as described here: htt...

Hello but the problem to install TimeTrex is also with the latest version of Postgresql for Ubuntu - psql (11.4 (Ubuntu 11.4-1.pgdg16.04+1)) Still it fails while filling in the main database during the install process. What is the manual workaround to install it please? I can't install TimeTrex to ...

Upon further investigation it appears this is actually a bug in PostgreSQL v9.4.23, v9.5.18, v9.6.14, v10.9 (version you are running) and v11.4. All of which were released on 20-Jun-2019 and the specific bug was introduced by the release note item: "Fix failure of ALTER TABLE ... ALTER COLUMN T...

Upon further investigation it appears this is actually a bug in PostgreSQL v9.4.23, v9.5.18, v9.6.14, v10.9 (version you are running) and v11.4. All of which were released on 20-Jun-2019 and the specific bug was introduced by the release note item: "Fix failure of ALTER TABLE ... ALTER COLUMN T...

We need to confirm if it is in fact the same underlying error or not. Please enable debug logging as described in this FAQ, then try to connect again and attach a copy of the log file here, it should contain a more specific error message.

Very strange, the error message is not actually a connection problem, but a SQL query failure: DBError(-1) Message: postgres8 error: [-1: ERROR: operator class "int4_ops" does not accept data type uuid] Unfortunately that isn't an error we have seen before, and we aren't able to replicate ...

The community edition doesn't have any limitations on the number of employees that it can process, so go ahead and give it a try.

Please enable debug logging as described in this FAQ, then try to connect again and attach a copy of the log file here, it should contain a more specific error message.

PostgreSQL has restrictions based on how/where connections can be made from in the pg_hba.conf file, so that could be blocking access. I would try using a blank database host name first though and see if that works.

You can also check the timetrex log file for a more detailed error message.

What permission group are the employees assigned to?

If you view the punch it will show an "Actual Time" field which is pre-rounded. Also in most TimeSheet related reports there are "Actual Time" related columns, though those are mostly for administrators and not employees.

1) I used the rounding policy and added Day Total 15 mins with a strict schedule. See image. Applied and recalculated the timesheets, no difference? Total time 8:08 remained 8:08. Expected that to go down to 8:00. Recalculating timesheets does not re-apply rounding policies. You have to edit a punc...

You would have two options then: 1. Round the punch time to their schedule (strict rounding), however keep in mind that TimeTrex still allows you to see the "Actual" non-rounded time for reporting purposes. 2. Use Premium Policies to calculate all pay, rather than regular time and overtime...

Unfortunately not at this time.

I see, due to the complexities of overtime policies, TimeTrex will only trigger overtime policies that increase the employees rate of pay, not decrease it. Since you are trying to use an overtime policy that decreases the employees rate of pay, TimeTrex is ignoring it. Its very unusual that you woul...

Can you please include a screenshot of the employees timesheet showing the overtime, after you click the "Show Wages" icon to the right of the date field.

While I can't speak to the NGINX setup itself, TimeTrex does need to be configured to function properly behind a reverse proxy, by setting the following in the timetrex.ini.php file: [other] proxy_ip_address_header_name = 'HTTP_X_FORWARDED_FOR' proxy_protocol_header_name = 'HTTP_X_FORWARDED_PROTO' I...