[turba] Updating the Turba Schema

[Michael Rubinsky]

Quoting Simon Brereton <simon.brereton at dada.net>:

>> -----Original Message-----
>> From: turba-bounces at lists.horde.org [mailto:turba-
>
>> > 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.
>
> Thanks.  In the end I decided to hide the newly created  
> object_homeEmail and just going with the added workEmail.  Synch is  
> just a mess for now, but I'm going to focus on fixing that elsewhere..
>
> One more question on this topic - what happens when a new Turba is  
> released?  Will I have to make the same changes to the new  
> sources/attributes.php?  I ask, because this could get messy over  
> time.

First off, you would very rarely have to edit attributes.php.  
Secondly, if you are upgrading Turba, part of the upgrade process  
would be to check/merge your current configuration values with any  
changes made in the new version. This is true of any horde  
application. I'm not sure what you think would be "messy" about this  
process. Of course, your DB schema would already exist, so wouldn't  
need to be redone (other than anything upgrade scripts might do).  
Remember, files in an application's configuration directory is, by  
definition a local configuration.

> For example, it occurs to me that a common address format (as much  
> vcard pretends to be) needs updating.  There's no space for IM  
> contact addresses for example.  Now it would be possible for me to  
> add these (to Horde) as a customisation.  Even to the extent that I  
> could have - in the case of skype/gchat - a link that would directly  
> fire up Skype/Talk (thanks to the browser's protocol handler).  But  
> I'm not alone - and having thousands of people make the same  
> customisations seems messy.  I would like to request that in a new  
> version of Turba we review and possibly add a bunch of global  
> attributes.

Again, doing this isn't really a customization, it's configuration.   
attributes.php already contains a number of phone/video fields. If  
there is a field missing from attributes.php that you feel is a  
standard, common field, feel free to add an enhancement request to  
bugs.horde.org.

Having support for these fields in incoming vCards, though, does  
probably need work.  If you have a standard vCard field that is not  
being parsed on import, again, please create an enhancement request  
for this.

> Finally, while we're on feature requests - I've searched and I see  
> no option for this.  I would like when clicking on browsing my  
> address book to see more than just the entries under A.  The  
> alphabet links are for sure useful.  But with a screen resolution of  
> 1900, the extra click that I need in order to see b, c or d entries  
> is just annoyance.

You need to increase the maximum number of items per page to be larger  
than your total number of contacts. If you have done this, and it is  
not working for you, please file a bug report.  FWIW, I just tested  
this in current git master code and it works as expected.


Mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org

Mike

?The only reason for time is so that everything doesn't happen at  
once." - A. Einstein