[turba] Updating the Turba Schema

[lst_hoe02 at kwsoft.de]

Zitat von Simon Brereton <simon.brereton at dada.net>:

>> -----Original Message-----
>> From: Simon Brereton
>
>
>> Mike - I'll take another look at it.  I meant to add the third
>> option, that Turba already supported this and I hadn't seen it.
>>
>> However, I'm not sure I can agree that it does :)  if I go into the
>> DB Structure, turba_objects, there are:
>>
>> object_id	owner_id	object_type	object_uid	object_members
>> 	object_firstname	object_lastname	object_middlenames
>> 	object_nameprefix	object_namesuffix	object_alias
>> 	object_photo	object_phototype	object_bday
>> 	object_homestreet	object_homepob	object_homecity
>> 	object_homeprovince	object_homepostalcode
>> 	object_homecountry	object_workstreet	object_workpob
>> 	object_workcity	object_workprovince	object_workpostalcode
>> 	object_workcountry	object_tz	object_geo	object_email
>> 	object_homephone	object_workphone	object_cellphone	object_fax
>> 	object_pager	object_title	object_role	object_logo
>> 	object_logotype	object_company	object_category
>> 	object_notes	object_url	object_freebusyurl
>> 	object_pgppublickey	object_smimepublickey
>>
>> only one email.  And indeed this is what is displayed for all my
>> contacts - system wide.  So it looks like I have to go down the hack
>> route (unless there's a simple .sql I can run?).  So,  I'm a little
>> perplexed, because I feel you should be right (searching on the topic
>> didn't bring up a wealth of previous posts, so either this isn't a
>> feature no one else needed *or* there's something not right with my
>> set up.  This, however, is a fresh install and not an upgrade - so
>> I'm confused as to how I've ended up with only one email field.
>>
>> In the meantime I'll give your instructions a shot.
>
> Mike
>
> Having followed your instructions - and using the blog as crutch I  
> now have what seems to be a working home email and work email fields  
> in Turba. IMP is giving me both options to chose from when I type in  
> the alias, so it looks good (I'll try synching next).
>
> However, I now have an extraneous field -
>
> Email
> Home Email
> Work Email
>
> Is it safe to get rid of this?
>
> Should I just remove it from the communications tab section in  
> backends.php/sources.php?  Or do I need to do it from attributes.php  
> too?
>
> Assume I've copied all current values from Email to homeEmail in the DB.
>
> I just think the extra field will confuse users.

Do not remove anything from attributes.php, you might need it later  
and you don't know if it is used otherwise. Simply remove unneeded  
fields from sources.php and you are done.

Regards

Andreas


-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6046 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.horde.org/archives/turba/attachments/20100915/2b500908/attachment.bin>