Thread: question
I'd like to set up a system where every employee can log into an intranet server and enter the time he/she spend on each of the projects. At the end of the month I'd like to create a list of time per project from this data. My idea was to use PostgreSQL as backend (of course) and a web front-end. Does anyone have a similar system running? Or any ideas concerning how to set this up and what software to use? Thanks in advance. Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!
On Fri, 10 Dec 1999, Michael Meskes wrote: > I'd like to set up a system where every employee can log into an intranet > server and enter the time he/she spend on each of the projects. At the end > of the month I'd like to create a list of time per project from this data. > > My idea was to use PostgreSQL as backend (of course) and a web front-end. > > Does anyone have a similar system running? Or any ideas concerning how to > set this up and what software to use? It would seem rather trivial in PHP to do that. I've done a number of database routines with PostgreSQL and PHP and most of 'em end up as less than a page of code (including blank lines). Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com flame-mail: /dev/null # include <std/disclaimers.h> Have you seenhttp://www.pop4.net? Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
Vince Vielhaber wrote: > On Fri, 10 Dec 1999, Michael Meskes wrote: > > I'd like to set up a system where every employee can log into an intranet > > server and enter the time he/she spend on each of the projects. At the end > > of the month I'd like to create a list of time per project from this data. > It would seem rather trivial in PHP to do that. I've done a number of > database routines with PostgreSQL and PHP and most of 'em end up as less > than a page of code (including blank lines). Try onShore TimeSheet, which uses PostgreSQL -- www.onshoretimesheet.org -- Lamar Owen WGCR Internet Radio
On Fri, Dec 10, 1999 at 11:06:43AM -0500, Vince Vielhaber wrote: > It would seem rather trivial in PHP to do that. I've done a number of > database routines with PostgreSQL and PHP and most of 'em end up as less > than a page of code (including blank lines). That's the kind of answer I expected. But I still hope I can get along with less programming on my part. :-) Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!
On 10-Dec-99 Michael Meskes wrote: > On Fri, Dec 10, 1999 at 11:06:43AM -0500, Vince Vielhaber wrote: >> It would seem rather trivial in PHP to do that. I've done a number of >> database routines with PostgreSQL and PHP and most of 'em end up as less >> than a page of code (including blank lines). > > That's the kind of answer I expected. But I still hope I can get along with > less programming on my part. :-) Right, but the reason I suggested doing it that way is something as small as this is usually quicker to do it yourself than installing a package. Alot of the packages that should be simple (and probably are) end up taking 3-4 hours to figure out, install and setup and may not fit the bill vs an hour or so knocking something out that would be exactly what you want. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com flame-mail: /dev/null # include <std/disclaimers.h> Have you seenhttp://www.pop4.net? Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
Lamar Owen <lamar.owen@wgcr.org> writes: > Try onShore TimeSheet, which uses PostgreSQL -- www.onshoretimesheet.org It's doubly amusing that you suggest this, since the author, like Michael himself, is a Debian developer. :-) Mike.