[turba] Default columns prefs

Jan Schneider jan at horde.org
Mon Jul 9 13:23:03 UTC 2012


Zitat von OVi C <csoft2k5 at gmail.com>:

> Hi. I'm using horde webmail edition 4.0.8 and I want to set default columns
> prefs in turba for a shared address book in sql for new users.
>
> Here's the config from prefs.local.php:
>
> $_prefs['addressbooks'] = array(
>     'value' =>  json_encode(array('localsql'))
> );
>
> $_prefs['columns'] = array(
>     'value' => "\nlocalsql\temail\tbirthday"
> );
>
>
>
> After a user gets created the only column that is displayed in the address
> book it's just the name. Why doesn't show also the email and birthday ?

The leading \n is incorrect. And the name field might be mandatory.

> Here the config for turba backend.
>
> $cfgSources['localsql'] = array(
>     // ENABLED by default
>     'disabled' => false,
>     'title' => _("Shared Address Books"),
>     'type' => 'sql',
>     'params' => array(
>         // The default connection details are pulled from the Horde-wide SQL
>         // connection configuration.
>         // To use another DB connection, you must provide configuration
>         // information here - for example,
>         //'sql' => array(
>         //    'persistent' => false,
>         //    'username' => 'horde',
>         //    'password' => 'secret',
>         //    'socket' => '/var/run/mysqld/mysqld.sock',
>         //    'protocol' => 'unix',
>         //    'database' => 'horde',
>         //    'charset' => 'utf-8',
>         //    'ssl' => false,
>         //    'splitread' => false,
>         //    'phptype' => 'mysql'
>         //),
>         'table' => 'turba_objects'
>     ),
>     'map' => array(
>         '__key' => 'object_id',
>         '__owner' => 'owner_id',
>         '__type' => 'object_type',
>         '__members' => 'object_members',
>         '__uid' => 'object_uid',
>         'firstname' => 'object_firstname',
>         'lastname' => 'object_lastname',
>         'middlenames' => 'object_middlenames',
>         'namePrefix' => 'object_nameprefix',
>         'nameSuffix' => 'object_namesuffix',
>         'name' => array('fields' => array('namePrefix', 'firstname',
>                                           'middlenames', 'lastname',
>                                           'nameSuffix'),
>                         'format' => '%s %s %s %s %s',
>                         'parse' => array(
>                             array('fields' => array('firstname',
> 'middlenames',
>                                                     'lastname'),
>                                   'format' => '%s %s %s'),
>                             array('fields' => array('firstname',
> 'lastname'),
>                                   'format' => '%s %s'))),
>         // This is a shorter version of a "name" composite field which only
>         // consists of the first name and last name.
>         // 'name' => array('fields' => array('firstname', 'lastname'),
>         //                 'format' => '%s %s'),
>         'alias' => 'object_alias',
>         'birthday' => 'object_bday',
>         'anniversary' => 'object_anniversary',
>         'spouse' => 'object_spouse',
>         'photo' => 'object_photo',
>         'phototype' => 'object_phototype',
>         'homeStreet' => 'object_homestreet',
>         'homePOBox' => 'object_homepob',
>         'homeCity' => 'object_homecity',
>         'homeProvince' => 'object_homeprovince',
>         'homePostalCode' => 'object_homepostalcode',
>         'homeCountry' => 'object_homecountry',
>         'homeAddress' => array('fields' => array('homeStreet', 'homeCity',
>                                                  'homeProvince',
>                                                  'homePostalCode'),
>                                'format' => "%s \n %s, %s  %s"),
>         'workStreet' => 'object_workstreet',
>         'workPOBox' => 'object_workpob',
>         'workCity' => 'object_workcity',
>         'workProvince' => 'object_workprovince',
>         'workPostalCode' => 'object_workpostalcode',
>         'workCountry' => 'object_workcountry',
>         'workAddress' => array('fields' => array('workStreet', 'workCity',
>                                                  'workProvince',
>                                                  'workPostalCode'),
>                                'format' => "%s \n %s, %s  %s"),
>         'department' => 'object_department',
>         'timezone' => 'object_tz',
>         'email' => 'object_email',
>         'homePhone' => 'object_homephone',
>         'homeFax' => 'object_homefax',
>         'workPhone' => 'object_workphone',
>         'cellPhone' => 'object_cellphone',
>         'assistPhone' => 'object_assistantphone',
>         'fax' => 'object_fax',
>         'pager' => 'object_pager',
>         'title' => 'object_title',
>         'role' => 'object_role',
>         'company' => 'object_company',
>         'logo' => 'object_logo',
>         'logotype' => 'object_logotype',
>         'category' => 'object_category',
>         'notes' => 'object_notes',
>         'website' => 'object_url',
>         'freebusyUrl' => 'object_freebusyurl',
>         'pgpPublicKey' => 'object_pgppublickey',
>         'smimePublicKey' => 'object_smimepublickey',
>         'imaddress' => 'object_imaddress',
>         'imaddress2' => 'object_imaddress2',
>         'imaddress3' => 'object_imaddress3'
>     ),
>     'tabs' => array(
>         _("Personal") => array('firstname', 'lastname', 'middlenames',
>                                'namePrefix', 'nameSuffix', 'name', 'alias',
>                                'birthday', 'spouse', 'anniversary',
> 'photo'),
>         _("Location") => array('homeStreet', 'homePOBox', 'homeCity',
>                                'homeProvince', 'homePostalCode',
> 'homeCountry',
>                                'homeAddress', 'workStreet', 'workPOBox',
>                                'workCity', 'workProvince', 'workPostalCode',
>                                'workCountry', 'workAddress', 'timezone'),
>         _("Communications") => array('email', 'homePhone', 'workPhone',
>                                      'assistPhone', 'homeFax',
>                                      'cellPhone', 'fax', 'pager',
> 'imaddress',
>                                      'imaddress2', 'imaddress3'),
>         _("Organization") => array('title', 'role', 'company',
> 'department', 'logo'),
>         _("Other") => array('category', 'notes', 'website', 'freebusyUrl',
>                             'pgpPublicKey', 'smimePublicKey'),
>     ),
>     'search' => array(
>         'name',
>         'email'
>     ),
>     'strict' => array(
>         'object_id',
>         'owner_id',
>         'object_type',
>     ),
>     'export' => true,
>     'browse' => true,
>     'use_shares' => true,
>     'list_name_field' => 'lastname',
>     'alternative_name' => 'company',
> );
> --
> turba mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: turba-unsubscribe at lists.horde.org


-- 
Jan Schneider
The Horde Project
http://www.horde.org/



More information about the turba mailing list