PostgreSQL Database

Discussion for TimeTrex open source community developers.
Locked
loyiso
Posts: 10
Joined: Mon Jan 23, 2012 1:05 am

PostgreSQL Database

Post by loyiso »

Since the PostgreSQL Database used by TimeTrex holds all the employee information, how do I access that information/database from another application. i.e I need the Database connection information that was saved during the first run.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: PostgreSQL Database

Post by shaunw »

Its in the timetrex.ini.php file. However we don't recommend accessing the database directly as it doesn't contain 100% of the data anyways and its constantly changing, instead you should really utilize the remote API located in the api directory.
loyiso
Posts: 10
Joined: Mon Jan 23, 2012 1:05 am

Re: PostgreSQL Database

Post by loyiso »

Ok thanks buddy, but how come I cannot find the file "'../classes/modules/api/client/TimeTrexClientAPI.class.php"?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: PostgreSQL Database

Post by shaunw »

Are you using the latest version of TimeTrex, v5.0.3?
loyiso
Posts: 10
Joined: Mon Jan 23, 2012 1:05 am

Re: PostgreSQL Database

Post by loyiso »

Yes I am
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: PostgreSQL Database

Post by shaunw »

Strange, we will have to investigate to see why this file isn't included in your version.
loyiso
Posts: 10
Joined: Mon Jan 23, 2012 1:05 am

Re: PostgreSQL Database

Post by loyiso »

That would be appreciated thank you very much.
Locked