[sync] Fields in Turba vor vcard import/export. Appropriate sources.php

[Karsten Fourmont]

Todd Pytel wrote:
> On a related subject, what's the deal with First/Last names in Turba?
> Looking at the turba_objects table I can see that names are stored only
> as full names, rather than being split first/last. 

Right. This is as it is for historic reason. Turba is highly flexible 
when it comes to fields. You can use it to manage cooking recipes if you 
want. The default fields for address books are somewhat inconvenient 
when it comes to vcalendar export/import. First name and last name is 
one thing, having the whole address in one field is another.

I use a different sources.php that does more closely match the VCARD 
structure. See below. You need to create approriate fields in your sql 
database of course.

Changing the defaults would be a good thing. But due to the large user 
base I'd like to have a final view on what fields we need before 
proposing a new default set.

Cheers,
  Karsten

--8<---cut here --8<---------

<?php
$cfgSources['localsql'] = array(
     'title' => _("My Addressbook"),
     'type' => 'sql',
     'params' => array_merge($GLOBALS['conf']['sql'], array('table' => 
'turba_objects')),

     'map' => array(
         '__key' => 'object_id',
         '__owner' => 'owner_id',
         '__type' => 'object_type',
         '__members' => 'object_members',
         '__uid' => 'object_uid',
         'name' => array('fields' => array('firstname', 'lastname'),
                         'format' => '%s %s'),
         'firstname' => 'object_firstname',
         'lastname' => 'object_lastname',
         'name_prefix' => 'object_nameprefix',
         'email' => 'object_email',
         'alias' => 'object_alias',
         'homeStreet'  => 'object_homestreet',
         'homeCity'     => 'object_homecity',
         'homeProvince'     => 'object_homeprovince',
         'homePostalCode' => 'object_homepostalcode',
         'homeCountry' => 'object_homecountry',
         'workStreet' => 'object_workstreet',
         'workCity'     => 'object_workcity',
         'workProvince'     => 'object_workprovince',
         'workPostalCode' => 'object_workpostalcode',
         'workCountry' => 'object_workcountry',
         'homePhone' => 'object_homephone',
         'workPhone' => 'object_workphone',
         'cellPhone' => 'object_cellphone',
         'fax' => 'object_fax',
         'pager' => 'object_pager',
         'title' => 'object_title',
         'company' => 'object_company',
         'website' => 'object_url',
         'notes' => 'object_notes',
         'pgpPublicKey' => 'object_pgppublickey',
         'smimePublicKey' => 'object_smimepublickey',
         'freebusyUrl' => 'object_freebusyurl'
     ),
     'search' => array(
         'name',
         'email'
     ),
     'strict' => array(
         'object_id',
         'owner_id',
         'object_type',
     ),
     'export' => true,
     'browse' => true,
     'use_shares' => true,
);