[Phpgwtimetrack-developers] RE: working, but still a few questions

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

Geoffrey,

Apparently, there is more work to be done. As long as you can somehow
migrate the company name from the addressbook to the customer list,
there should be no problem using a current installation. Apparently,
as long as entries are made in the customers list, then you should
start seeing the addressbook data again, albeit perhaps with double
entries (not sure why that's happening) and a Company name of "Not Set".
There is also another bug in the customers list code that appears to
display the last company in the list twice (minor issue right now, I
think, as long as everyone is aware of it and they don't go deleting the
customer thinking it's a  duplicate).

I currently don't have the time to write a migration script, but you
could do the following (in sql):
select company_name from addressbook; (output to a file)
Eliminate duplicate entries from this output.
Input the entries into the Customers table using any number of sql
import methods (Company Name is only required field) ID is autoinc).
Then you should be able to do a cross join to update the company_id
in the addressbook according to a match of the company_name from both
tables.

If your current addressbook isn't that large, just enter the customer
data manually, then you should be able to edit the addressbook entries
and set the company name from the drop downs.

As I mentioned in the last message, I am currently looking at a complete
changeover of how the customers list is used, and since 0.9.10 is also
going through major changes in the addressbook, it will be better that
way. So once that is completed, that should address items 1 and 2 that you
voiced.

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

-----Original Message-----
From: Geoffrey Makstutis [mailto:gm...@51...]
Sent: Thursday, March 08, 2001 12:54 PM
To: bo...@pr...
Subject: working, but still a few questions


Bob,

I've got timetrack working with the addressbook. But only if I create a
whole new
installation. It looks like if you try to add Timetrack to an existing
installation
with a populated addressbook, you will lose all the addressbook entries.

This leads me to a couple of questions/suggestions (I hope I'm not being too
presumptuous. I'm trying to be helpful, honest...):

1. Under the current arrangement you could only ever have company names in
your
addressbook if they are also customers. Is this an unnecessary limitation?
It
precludes the possibility of suppliers and other types of entry in the
addressbook.

2. Do you need the link between customers and the addressbook to be so
'hard'?
Would it not be more efficient to have the option of creating a customer
from the
addressbook rather than a company from the customers?

I'm a fairly pedestrian PHP author, don't know classes very much, but I'd be
happy
to act as a tester for ongoing development and maybe help out on other
aspects
(graphics, design, etc.).

Regards,
Geoffrey