Re: [Phpgroupware-developers] Addbook vs addressbook

[Brian Johnson]

I understand that one potential complication of separating the companies from 
the
individuals in the table format is that it makes the addressbook app harder to 
work
with those using LDAP

I understand that the current LDAP design in addressbook is made to match a LDAP
standard for the storage of contact information

In my thinking, we have three options:
1. stick with what is done (in which case I'll continue work on addbook)
2. try to get a new LDAP contact standard adopted and wait until that's done 
(see
next paragraph)
3. create a system that utilizes a different database structure than the LDAP
structure and have the code adjust for the different formats

I think 2. would be a huge delay - trying to get 100s or 1000s of people to 
agree
on a new format.  Also, in my limited understanding of LDAP, it is not a 
relational
structure and it might be impossible to separate the companies from the people 
and
maintain a relationship between the data (which would of course prevent the
adoption of a LDAP contact standard format to do this)

I suggest we proceed with the concept of modifying the addressbook database
structure to better normalize the data including separating the companies and 
the
people into separate tables.

So what do you guys think?  Can we start talking about a new database structure 
for
the addressbook and the corresponding changes to the web forms?


Dr. Michael Meskes (address@hidden) wrote:
>
>On Mon, Mar 03, 2003 at 09:00:27PM +0000, Brian Johnson wrote:
>> >field-structur like the addressbook has it know and only change the UI
>> >to keep the org-fields in sync with the org-fields of the other persons
>> >in that org. That is not the cleanest approach (Michael Meskes would say
>> >the db is not normalized) but it is far better than the other ideas
>
>Hey, and what shall I say now? :-)
>
>Fact is you have several advantages by normalizing the data. But you
>can, of course, reimplement the logic inside the GUI. If it was only for
>the database I wouldn't do that, but I do not have enough ldap knowledge
>to say if we could get this going with normalized data.
>
>> time entries for testing purposes but I need to create better filtering and
>> searching abilities in addbook before other switch to it (and I add our 
>> 3000+-
>
>I agree completely.
>
>Michael
>
>P.S.: Also CCed to Carsten who takes care of our phpgw installation,
>although he's on vacation right now.
>Email: address@hidden
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>