TimeTrex Time and Attendance

This is the result for my live 2.0.2 system (I removed the value of the registration_key): id name value 1 schema_version_group_A 1013A 2 tax_data_version 20070701.1 3 tax_engine_version 1.0.5 4 schema_version_group_T 1004T 5 system_version 2.0.2 6 update_notify 0 7 anonymous_update_notify 0 8 regis...

I found the error within the frame of the progress indicator, after I set Debug Verbosity to 11 within the DatabaseSchema.php file. Attached is a copy/paste of all the text within the frame. I double-checked again, and the wage_group table is not in my database when I restore version 2.2.22 of my ba...

I finally got the opportunity to test out the upgrades for 2.2.22 and 3.3.4 2.0.2 --> 3.3.4 : Upgrade failed at 46% with the same error that I got when I tried to upgrade to 3.3.2 (Unknown column 'company_id' in 'field list']) 2.0.2 --> 2.2.22 : Upgraded successfully without any errors, although I d...

Thanks for the reply. I tested the upgrade on a copy, so I don't need to restore anything.

Do you have an ETA for when 3.3.4 will be released?

I currently have TimeTrex version 2.0.2 and I made a copy of my database and directories in order to test an upgrade to the latest version (3.3.2). The upgrade freezes at 46%. I set Debug Verbosity to 11 within the DatabaseSchema.php file, and looked at the output within the frame of the progress in...

Our company's vacation policy is that employees get 5 days vacation (40 hours) every year. The vacation time should be added to their account on the anniversary of their hire date. So, an employee that was hired July 15th, should get all 40 hours added to their account on July 15th. As the year prog...

Is there a way to force a recalc with the linux command line?

We are using an old version of TimeTrex (2.0.2) because we have made some custom changes to the database/code and upgrading to the latest version would be too much work right now. Anyway, we are looking to start implementing Vacation policies and are trying to figure out how to test our configuratio...

And what settings do I put in to see that changes occurred?

Thanks,

-Ben

Currently using version 2.0.2.

Is there a way to show changes to the Authorization Hierarchy through the Audit Trail Report (or any other method for that matter)?

Thanks,

-Ben

Thanks for the info regarding using created_date vs. updated_date. I already knew that a null station meant a manually added punch, but I was hoping to be able to use the same method for determining both changed and added punches, and thought created_date vs time_stamp would do it. Looking forward t...

I would like to have the timesheet show me exception codes for punches that were entered manually in the timesheet, or have been changed (like if an employee forgot to punch in and the supervisor added the punch in the timesheet or adjusted their time.) I've been looking through the punch table tryi...

Let's see if I understand what is happening. Here is the timesheet for a user: Normal-In 9:05 AM Normal-Out 11:00 AM Normal-In 1:00 PM Normal-Out 5:00 PM The user is scheduled to begin work at 9:00am, has a grace period of 15 minutes and a watch window of 8 hours. When TimeTrex goes to determine In-...

What is the watch window set to on your schedule policy? Ah, I see that a high value for my Watch Window was the cause of the exception. I'm not sure what to set the window to though. I want to avoid the problem, but still get an exception if an employee is very very late. So, let's say that an emp...

Every once in a while a user's Time Sheet is showing an "In Late" Exception even though their first Normal-In punch is well within the Grace Period. I think the exception is happening because there is another Normal-In punch later that day that falls outside the grace period for their sche...

I would like a Who's In type report, but that shows the date, time and status of the last punch of all Active employees. It shouldn't matter when the last punch was, as long as they are active and have had a punch in/out in the past, then they should appear on this list. It should also be possible t...

I'm not sure if I am using TimeTrex correctly for scheduled absences. If I schedule someone to be absent for a day, and pick an absence policy that is linked to an accrual policy, what should happen that day? Should timetrex automatically apply the hours in the schedule to the accrual account in the...

If you download TimeTrex and unzip it, you will see a README.txt file that has the requirements and the instructions on how to install TimeTrex. http://www.timetrex.com/download.php You might consider going with Apache instead of IIS. The main reason I went with Apache on my XP system was because I ...

When you create a Scheduled Task that runs without being logged in, you must specify the password, otherwise you get the 0x0 error status. It is true you need to specify the password even if your computer is in the domain and the user is a domain user. However, 0x0 is the windows completion code fo...

Ok, I see. I guess we are using this differently. For starters I am allowing everyone to view the Who's In Report. For us, it is very important for everyone to quickly check who's here. The notes serve the function of letting everyone know where we are if we are "out" during core hours. Se...

It would help us if notes for punching in/out were associated with the individual punches instead of the punch_control. At the moment if a user forgets to punch in, and the supervisor adds a punch with a note saying "Had to add Punch-in for Roger -john", that note gets overwritten when the...

I would appreciate it if another user could respond as to whether or not they are having the same problem.

I am sorry if this is a known issue and is mentioned elsewhere, I tried to search for it before posting.

Thanks,

-Ben

I would like something that works like Windows' Security Groups. The idea is that you assign permissions to Groups and then assign users to Groups. Instead of changing permissions for each user, you change the permissions for a Group, and that change would "propagate" to every user within ...

Clicking the little up/down arrows next to the fields in the Who's In Report does not change the sorting order. Using TimeTrex 2.0.2, Windows XP SP2, XAMPP 1.6.3: Apache 2.2.4 - MySQL 5.0.45 - PHP 5.2.3 This is MySQL debug info after trying to sort by Employee Name - Ascending: (mysqlt): SET SESSION...