TimeTrex Time and Attendance

Hello Shaun, I noticed in the changelog for v5.0.1 that it mentions "Importing data can now be performed directly from the web interface" I perused your demo and could not find where that can be done. Also, what kind of data can be imported? -schedules? -employees? -punches? Is this availa...

Hi Shaun,

how close is v5.0 to a release date?

Thanks, Shaun

Duh! Boy do I feel dumb.

Hello TimeTrex,

I did not see v3.2.1 in you announcement section. Is there a list of changes, improvements, etc. I am able to review?

Hello TimeTrex folks, I am dusting off my past knowledge of TimeTrex installation notes and recalling that even though you publish that TimeTrex runs on PHP 5.x, it was actually not totally true. My recall says it would not run on 5.3.x. The latest build of XAMMP installs PHP 5.3.1 so want to make s...

Shaun,

I noticed that i did not have the rounding rule setup correctly. The 'Recalculate' function will not work for existing transactions in the current pay period.

Is there a way to force the recalculation after correcting a rule?

Thanks,

Lloyd

Shaun,

is there a way to show actual punch times on the timesheet or Time Card report.

I see that you can add the Actual IN and OUT in the Punch Summary.

Will that be available in the Time Card or timesheet anytime soon?

Thanks,

Lloyd

Hi Shaun,

thanks for the quick response. I did not realize that numerical values were not used.

I have a final question. What about transfers? What alpha values are used for status_id and type_id for transfers?

Thanks,

Lloyd

Hello TimeTrex,

I am doing some punch imports and have a question about what the key values are for type_id and status_id.

example: instead of using IN or OUT for status_id, I would like to use the actual number equivalents.

Also, for type_id, what values are available?

Thanks,

Lloyd

Ok, Shaun, I applied the import_punches.php fix. The import brought the punches in. Only issue is that it is causing an issue in the timesheet. It indicates missing punches. The Pay Policy only has one simple OT rule and nothing else. So, not sure why this is happening. I did not have this issue wit...

Shaun, I have a final question related to this thread. What is the importance of clearing out the cache from the tmp folder after doing a punch import? Is it something that can be done as an every 24hr thing? Or, is it necessary to do right after a punch import? I ask this because I will be automati...

Shaun,

I ran this in TimeTrex 2.2.22 and it works just fine

It seems TimeTrex v3 is having the issue.

I hope this exercise was helpful for you in fixing any bugs.

FYI on versions of what I am running:

This is the result I get after setting Production=FALSE an verbose=11 in timetrex.ini.php -----<hr> (mysqlt): SET SESSION sql_mode='ansi' -----<hr> -----<hr> (mysqlt): SET TRANSACTION ISOLATION LEVEL READ COMMITTED -----<hr> -----<hr> (mysqlt): SET SESSION time_zone='America/Denver' -----<hr> Column...

that was the complete result of script.

I tried the debug and reran, but it was not any more verbose than previously.

I cannot find any log indicating issues.

Shaun, here is my command: php import_punches.php simple_punch_column_map.txt punch.csv here is the result when running without the -n option: Column Mappings... TimeTrex Column: user_name => user_name Default: TimeTrex Column: type_id => type_id Default: Normal TimeTrex Column: status_id => status_...

Shaun, I am still having a time with the punch import. I am not getting data in the database. here is my mapping file: timetrex_column, csv_column, default_value, parse_hint "user_name","","","" "type_id","","Normal","" ...

Hi Shaun, what is the proper syntax to run the punch import here is my command: cd\xampp\php php-win.exe "C:\xampp\htdocs\TimeTrex3\tools\import\import_punches.php" -n -u user_name "C:\xampp\htdocs\TimeTrex3\tools\import\punch_column_map.txt" "C:\xampp\htdocs\TimeTrex3\tools...

I really don't want anything but the punch window to be presented for specific groups of employees. Essentially, a computer based time clock.

I will look into coding my own solution.

Thanks,

Lloyd

Hi Shaun,

Is there a page location in TimeTrex that only presents the punch window after login?

If not, I will build something myself that creates a punch import file.

Thanks,

Lloyd

Shaun, I need to understand the consequences of the chron job not running on a minute-by-minute basis. What all does it do beside keep things calculated, checking for holidays, compute accruals, etc. Anything behind the scenes that we need to be aware of? I have worked with many T&A apps in my c...

Hi Shaun, I log in as an Admin and then log out. I log back in as an Employee with Regular Employee permissions and see all menu items from Admin session. It does not allow the employee to execute menu items they do not have permissions for. Is there a way to have a refresh done automatically every ...

I'm creating the TimeTrex DB. What collation is recommended?
Thanks,

Lloyd

I installed WAMP. Setup timetrex.ini.php (see below) as I thought it should be. Ran TimeTrex from this URL: http://localhost:8088/timetrex Am getting this error when running TimeTrex for first time: Deprecated: Function split() is deprecated in C:\wamp\www\TimeTrex\classes\modules\core\Profiler.clas...

It can run on writable media. However, I noticed a registry entry in Windows that was created by the TimeTrex installation. Can it run without that?

Hello TimeTrex, I am practicing doing TimeTrex installations under different environments. I want to completely uninstall TimeTrex. I used your windows installation and the complete install that gave me Apache, Postgre, and TimeTrex. If I uninstall using windows>control panel>add/remove programs, wi...