TimeTrex Time and Attendance

Ok, I run setup again and this time it opens the interface!
Thanks for your help!

Dritan

It was finished, upgrading the DB 100%, and after it continued with other steps. Anyway I will try it again now and post the results!

Thanks!

It seems the problem is not the cache. I have cleaned it, but I see that in timetrex.log it gives an error not finding a column in users table.

timetrex.log atached!

shaunw wrote: Try clearing your TimeTrex cache directory to see if that helps.

Thanks to your advice, The upgrade database works, after several retries because at this database were different tables containing duplicated values. (the tables doesn't have primary key and was so difficult). Anyway at the end, after trying to logon with admin credentials, it gives this msg: TimeTr...

Okay, so the issue appears to be that your database is partially corrupted and TimeTrex is not able to create the indexes that it needs during the upgrade process. More specifically there are duplicate rows with the same IDs in the wage_group table. If you are familiar with manually modifying the d...

I have tried to get the log, but it don't show, so I have copied the source of the frame. (attached)

Ok, Shawn, I'll do it again and let's see what will be the result. What about the second question (importing punches from timetrex tools?) Unfortunately the debug logs you sent don't contain any useful information. Please follow instructions at the link I sent you, but you need to read the entire to...

Which may be the solution? I had even 3.1.1 version, and 3.4 version that i thought to upgrade step by step, but even for those it hangs at a different point (example 53%). Another problem for us that I hope it can be solved is that I got this punches from an access control software. I import with i...

I was thinking in this case to upgrade from 3.0.5 version to the latest version in your site, 5.0.4 version. I followed the procedure at README.TXT/Upgrade, but in the 3. Database Configuration it was upgrading the database and it it hangs at 83% (even if I let it hours, I see that is not any activi...

Dear Shawn, Thanks for your help. You are very important here! We have made a kind of job to import punches to Timetrex from an access control software. I solved this problem as you described, so I have changed the line at php\php.ini : memory_limit = 1528M ; Maximum amount of memory a script may co...

Hi! I have a problem with the automatic backups name. When I installed to windows xp normal, it creates backups with name+date. I have installed on 2 servers with windows 2003 server R2, but when it create a backup it named it as name+month. For example: instead of timetrex_database_20111112.sql, it...

Hi Shawn, I have tried to delete from Punches, but I cant. It give me an sql error: Interface: "NovaTime-Debug is unable to connect to its database, please make sure that the database has been started and is running." Log: "user_date_id" does not exist ... this in sql query from ...

Hi! I have a problem with timetrex. I want to delete some punches from 1 date to another date. How can I delete them?
Can you help me with any SQL Query?

I want also to delete older data, because the database is growing a lot.

Thanks and best regards!

Dritan

Can I change this parameter for all users in one or I should change for everyone?

Thanks!

shaunw wrote:Have you tried the "CET - Central European Time" timezone? This timezone should automatically handle DST for you.

Dear Shawn, I remember that I have configured all with +1. I am at Balcans, so we are like Rome, Paris,... zone.
Is there any way to configure globally? or I should change for example for every user?

Hi all! I have a problem with the timezone. We are at +1 time zone "ALBANIA" and every employer is set to have +1 zone. Now the problem is that with the changing of DST -1 hour, the punch time are not correct. Please can you help me if is anything I can do?

Best regards!

HI We have linked timetrex with another software access control that get punches from one or more doors. The software in testing environment was going Ok. But when we installed in a real world, it get confused. So, the users are punching too munch comparing to a time attendance system, and I have do...

Shaunw, where can I find the transfer option?
Is this option available at the versions before? Can I make a upgrade conserving confiturations and punches?

shaunw wrote:There isn't much that can be done, the transfer feature is designed to handle this exact scenario, but unfortunately you're not able to use it.

Dear Shaunw, I know that time attendance clock machine has the option to select the punch type, Normal, Break, Lunch. But in this case is the same problem in some cases. What about a raport to show just the people who has arrived later than 8:15 am for example? I Found to list them in the Exceptions...

I have installed Timetrex in a server, and I have linked to another Software (ACCESS CONTROL). So this system take punches from their database to timetrex database. The problem is that employes, should punch every time they open the door,so they cannot use trensfer punches. What can we do?

Dear Shaunw, The situation is like this: there are 2 buildings 5 minutes distant. The people are punching Out when should move from building A to B and punching IN when arrive to B. So this 5 minutes is calculated as they are Out. So in a 8 hours scheduled time, their timesheet is less than 8 hours,...

Hi! I have to find a solution for this situation: There are 2 buildings:A and B, distant 2-5 minutes. The employees are moving through building for working purpose. The problm is that this 5 minutes difference from 1 building to another, should be counted as in work. Is the Break policy a solution f...

Hi! It's an example to the tools/import directory of TimeTrex, like import_users.php that is using user_column_map.txt. I will look if I can find detailed info for you, cause I didn't do this by myself. thanks! Hi Could you please let me know what did you do to import users from another applications...

Thanks Shaunw! But if for ex. the meal time should be 12:00 - to 14:00 with one hour lunch time, and a person come late or he has taken permission for 3 hour in the morning, then after hi doesn't be able the lunch at that time. I'am using a method to interact with a punch hardware to take punches, a...

Please help me! We have a company which have a group of users that is going to Lunch ex. 12:00 and another group ex. 13:00 with 1 hour time for Lunch. I want to configure timetrex meal policy and Policy_Groups in order that it timetrex register the punches in this way: If Time of Group1_Users punch ...