Re: [Phpgroupware-developers] Timecard recording

[Jason Wies]

Test environment:
phpGroupWare Version-0_9_14-branch
PostgreSQL 7.1.2
Linux 2.4.12
Mozilla 0.9.9

Installation was smooth, no errors in phpGW.  There were these Postgres 
warnings:

--
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 
'phpgw_ttrack_customers_pkey' for table 'phpgw_ttrack_customers'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 
'phpgw_ttrack_employee_prof_pkey' for table 'phpgw_ttrack_employee_profiles'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 
'phpgw_ttrack_job_details_pkey' for table 'phpgw_ttrack_job_details'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 
'phpgw_ttrack_job_status_pkey' for table 'phpgw_ttrack_job_status'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 
'phpgw_ttrack_jobs_pkey' for table 'phpgw_ttrack_jobs'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 
'phpgw_ttrack_locations_pkey' for table 'phpgw_ttrack_locations'
NOTICE:  identifier "seq_phpgw_ttrack_work_catagories" will be truncated to 
"seq_phpgw_ttrack_work_catagorie"
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 
'phpgw_ttrack_work_catagori_pkey' for table 'phpgw_ttrack_work_catagories'
--

timetrack itself:

"In/Out" link and "Check In" button have no effect
"New Job" link - no Submit button (Popup calendar is cool)
"Customer List" -> "Add".  No type checking is performed on "Last Job" field, 
when entering text string (non-integer), yields this error:

Database error: Invalid SQL: INSERT INTO phpgw_ttrack_customers 
(company_name,website,ftpsite,industry_type,status,software,lastjobnum,lastjobfinished,busrelationship,notes,active)
 VALUES ('Customer 
Name','http://www.customer.com','ftp://ftp.customer.com','Other','Status','Software','The
 Last Job','The date','Relationship','The notes.','N')
PostgreSQL Error: 1 (ERROR: pg_atoi: error in "The Last Job": can't parse "The 
Last Job" )

Ditto for the date field (could use a popup calendar?):
PostgreSQL Error: 1 (ERROR: Bad date external representation 'The date' )

and with no date specified:
PostgreSQL Error: 1 (ERROR: Bad date external representation '' )

Editing Customer works.  Viewing Customer works, except Web Site and FTP Site 
append http:// and ftp:// respectively, which breaks links that were entered 
with http:// or ftp://.

"View Profiles" works.  A list of groups on the initial View Profiles page 
might be nice.

Editing my profile with "Your Profile" reports "Your profile has been updated", 
but the information does not show up in "View Profiles", and the fields are not 
filled on the resulting page after hitting Submit.

I'm willing to test any patches, just let me know.

Jason Wies aka Zone

On Thu, Mar 14, 2002 at 08:05:06PM +0000, address@hidden wrote:
> If anyone is interested in trying Timetrack for 
> 0.9.14RC2, I have made extensive updates to that branch 
> of CVS to the point where I believe it now works for the 
> most part. It now uses the phpgw api setup for 
> installation, table names have been shortened for 
> PostgreSQL and quite a few more changes made. If you
> try it, make sure you pull the correct branch out of 
> cvs. There is currently little to no support for 
> upgrading older versions at this point, strictly new 
> installs (you should be able to manually make any needed 
> table changes though if you really need to.)
> 
> I cannot say for sure if it will run under PostgreSQL at 
> this point. Hopefully someone will be able to try it for 
> me and let me know. I am working to see if I can get the 
> cygwin postgresql running on Windows 2000 to do my own 
> testing down the road.
> 
> Bob Schader
> > I am getting close to having timetrack be fully functional under 0.9.14RC2, 
> > but 
> > can
> > only gaurantee it will work if MySQL is your database. It was not included 
> > in 
> > the
> > RC2 release because it wasn't working at the time. I have not yet commited 
> > my
> > changes to CVS either, but should be within the next week.
> > 
> > Bob Schader
> > 
> > ----- Original Message -----
> > From: "Peter" <address@hidden>
> > To: <address@hidden>
> > Sent: Thursday, March 14, 2002 3:33 AM
> > Subject: [Phpgroupware-developers] Timecard recording
> > 
> > 
> > > Is anyone working on a timecard recording system? I looked through the 
> > > latest 
> > download and did not see anything. Also
> > > I think it would be nice to let people turn off applications in their 
> > > profile. 
> > When I implemented the new version, the icons
> > > ran down the left hand side. Later they appeared across the top of the 
> > > screen. 
> > Either way, there were too many and they
> > > were too close together so I started thinking.
> > >
> > > People warned me not to risk my either of my remaining brain cells but I 
> > continued.
> > >
> > > What if users could control the appearance of icons and applications in 
> > > their 
> > own profile. The administrator gives me
> > > access to all the applications I need then in my profile I turn off those 
> > > I 
> > need only on rare occasions. The ones turned off
> > > could have a start button on the profile page so I can reach them with 
> > > two 
> > clicks. That leaves me with a neat list of icons I
> > > use every day.
> > >
> > > They next step is the option to add an extra space or two between icons.
> > >
> > > Then there is the option to let people reorder the icons their own way by 
> > adding a plus or minus factor to the order. When
> > > I go to the profile page, let me click up or down to order applications 
> > > the 
> > way I like on the profile page and have them
> > > appear that way on the menu.
> > >
> > > Now to time cards. The adding of time to projects is useful to some but 
> > > not 
> > for people working an hour here, an hour
> > > there. One option for day by day or hour by hour work is to pop up a 
> > > project 
> > selection list then the calendar and let
> > > people click the hours they worked for that project.
> > >
> > > Another option is to have a [start] button and a [stop] button with a 
> > > project 
> > selection list. If I select nothing and click start,
> > > the time is allocated to the default project "visiting userfriendly.org". 
> > > When 
> > I select a project and click start, the time is
> > > allocated to the selected project. Clicking start on a new project stops 
> > > the 
> > clock on the existing project and starts the
> > > new one. Clicking stop stops everything and is what you would do when 
> > > going 
> > home. The start and stop buttons could
> > > be appended to selected applications, like email, so I can change 
> > > projects 
> > without changing screens. The appendation
> > > could be accomplished in the user profile.
> > >
> > > Enough of my rambling. The thoughts happened after comparing PHPGroupWare 
> > > and 
> > PHProjekt for a client. I prefer
> > > PHPGroupWare but PHProjekt does some things better than PHPGroupWare and 
> > > they 
> > happen to be the things of most
> > > importance to this client. It would take only a few links between 
> > > PHPGroupWare 
> > projects, tickets, and time cards to
> > > make PHPGroupWare the winner.
> > >
> > > If someone wants help, I can assist until the start of June then throw in 
> > > some 
> > more time after the end of June.
> > >
> > > Peter
> > >
> > >
> > > _______________________________________________
> > > Phpgroupware-developers mailing list
> > > address@hidden
> > > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> > 
> > 
> > _______________________________________________
> > Phpgroupware-developers mailing list
> > address@hidden
> > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers