[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