[Phpgwtimetrack-developers] Upgrade plans for Timetrack and phpgroupware 0.9.10

[Bob S. <bo...@pr...>]

This is just an announcement to everyone who plans to
upgrade phpgroupware to 0.9.10 and who currently uses
phpgwtimetrack.

The current release of phpgroupware has what I consider
a few serious bugs when it comes to upgrading the
addressbook tables properly, especially when timetrack
is installed. There are currently 2 issues involved,
which are:

1. When setup upgrades the addressbook table by copying
it to phpgw_addressbook, it re-assigns integer id's
in a consecutive order, but if anyone has deleted
contacts, then the original data will not neccessarily
be consecutive in the first place, so any tables which
reference the contact by an id will have incorrect
data returned.

2. Again, while the addressbook is being updated, company
name information is blindly pulled from the company
field, ignoring any company_id fields which are joined
against the customers table to get the company name from
an ID. Supposedly a fix was added to handle this situation,
but it must have got lost somewhere in cvsland.

Do not despair. Thankfully, the current setup leaves the
original addressbook table unchanged and does not drop it.
This is a good thing. I will have an option available for 
those upgrading timetracker which will allow re-doing the
upgrade of the addressbook table to another phpgw_addressbook
table in a way that will preserve all data.

I hope to have a beta release of phpgwtimetracker for
phpgroupware 0.9.10 available within the next week or so. 
If anyone would like an advance copy of what I have so far, 
let me know. I haven't bothered with CVS in quite awhile, 
so you can't get it there.

_____________________________
Bob Schader
CAD Systems Admin
Product Design Intl., Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512
(616) 667-2600 x104