TimeTrex Time and Attendance

have been able to import using the single timestamp version of the CSV file. A lot more work to get data into that format but I can at least get there now.

Would love to understand why the start and end time stamp version is not working for me.

post update, I'm still unable to get past the database configuration step of the 8.0.6 update. TimeTrex version 8.0.6 from 8.0.4 PHP v5.3.25 I'm able to confirm my previlaged user postgres, timetrex and sadmin with postgres at command line. So I know these usernames and passwords function just as be...

Ya, I already uninstalled and started the re-install process.

Thanks for responding, I really appreciate you willingness to help out.

I've done a backup of the TimeTrex database in pgAdmin III which has resulted in an export with sql statements for restoring the timetrex data.

Looks good as far as I can tell.

runs with no errors but resulting file is empty.

I used

alter user timetrex ENCRYPTED password 'mypassword'

I ran

Select * from pg_authid where rolename='timetrex' and rolpassword='md5'||md5('mypassword'||rolname);

It returned the TimeTrex user record successfully.

Are my postgres sql statement incorrect ?

I believe I've munged the password by updating the password with an alt role command in pg_admin.exe.

TimeTrex is salting its passwords.

So question is how to reset the passwords using the salt md5 format that TimeTrex uses?

I am attempting to upgrade from a previous version. As I begin the process of setting it up for use at our company. I have all of the employee, payperiods, schedules, holiday etc entered. At log in with Admin user I was getting message that I needed to upgrade, that automatic updates failed. So I do...

That works but its still complaining about the timetrex user password.

I've change that Password, confirmed it works a command line and in sql statements.

Not sure what's holding me up.

I was hoping just to update with our restore, but can't seem to get pass the password issue. if I leave the postgres password blank that warning goes away. I can test the timetrex user/pass and it works at the command line. The postgress pass does not work at the command line but I can confirm it wi...

Able to log into postgres with psql.exe timetrex timetrex

Followed by password.

Unable to do the same for the postgres user / pass

Backed up database, then run update "TimeTrex_Community_Edition_v8.0.6-windows-installer", completed and started the process of reconfiguring TimeTrex. At the Database Configuration step I keep getting an error for both the timetrex and the postgres passwords. Connection test to your datab...

Having an issue with importing punch data from previous time system. ERROR: In punches cannot occur after an out punch, in the same punch pair Need some help figuring out why its throwing out this error. Data seems correct. Have tried standard and military times and timestamp format. "m/d/y#g:i...

Having an issue with importing punch data from previous time system. ERROR: In punches cannot occur after an out punch, in the same punch pair Need some help figuring out why its throwing out this error. Data seems correct. Have tried standard and military times and timestamp format. "m/d/y#g:i...