[Tickets #8795] Re: LDIF import fail

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8795
------------------------------------------------------------------------------
  Ticket             | 8795
  Updated By         | lst_hoe02 at kwsoft.de
  Summary            | LDIF import fail
  Queue              | Turba
  Version            | 2.3.3
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Matt Selsky
------------------------------------------------------------------------------


lst_hoe02 at kwsoft.de (2010-01-28 08:50) wrote:

The source.php in question:

$cfgSources['pers_sql'] = array(
     'title' => _("My Address Book"),
     'type' => 'sql',
     'charset' => 'utf-8',
     // The default connection details are pulled from the Horde-wide SQL
     // connection configuration.
     'params' => array_merge($GLOBALS['conf']['sql'], array('table' =>  
'turba_objects')),
     // Using two tables as datasource.
     // 'params' => array_merge($GLOBALS['conf']['sql'],
     //                         array('table' => 'leaddetails LEFT  
JOIN leadaddress ON leaddetails.leadid = leadaddress.leadaddressid',
     //                               'filter' =>  
'leaddetails.converted = 0')),
     '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',
         // The photo field requires at least Horde 3.3 and a matching type
         // field.
         'photo' => 'object_photo',
         'phototype' => 'object_phototype',
         'homeStreet' => 'object_homestreet',
         'homePOBox' => 'object_homepob',
         'homeCity' => 'object_homecity',
         'homeProvince' => 'object_homeprovince',
         'homePostalCode' => 'object_homepostalcode',
         'homeCountry' => 'object_homecountry',
         // This is an example composite field for addresses, so you  
can display
         // the various map links. If you use this, be sure to add  
'homeAddress'
         // to the 'tabs' parameter below.
         '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',
         'timezone' => 'object_tz',
         'email' => 'object_email',
         'homeEmail' => 'object_email_home',
         'workEmail' => 'object_email_work',
         'homePhone' => 'object_homephone',
         'workPhone' => 'object_workphone',
         'cellPhone' => 'object_cellphone',
         'fax' => 'object_fax',
         'pager' => 'object_pager',
         'title' => 'object_title',
         'role' => 'object_role',
         'company' => 'object_company',
         // The logo field requires at least Horde 3.3 and a matching type
         // field.
         // 'logo' => 'object_logo',
         // 'logotype' => 'object_logotype',
         'category' => 'object_category',
         'notes' => 'object_notes',
         'website' => 'object_url',
         'freebusyUrl' => 'object_freebusyurl',
         'pgpPublicKey' => 'object_pgppublickey',
         'smimePublicKey' => 'object_smimepublickey',
     ),
     'tabs' => array(
         _("Personal") => array('firstname', 'lastname', 'middlenames',
                                'namePrefix', 'nameSuffix', 'name', 'alias',
                                'birthday', 'photo'),
         _("Location") => array('homeStreet', 'homePOBox', 'homeCity',
                                'homeProvince', 'homePostalCode',  
'homeCountry',
                                'workStreet', 'workPOBox', 'workCity',
                                'workProvince', 'workPostalCode',  
'workCountry',
                                'timezone'),
         _("Communications") => array('email', 'homeEmail',  
'workEmail', 'homePhone', 'workPhone',
                                      'cellPhone', 'fax', 'pager'),
         _("Organization") => array('title', 'role', 'company', 'logo'),
         _("Other") => array('category', 'notes', 'website', 'freebusyUrl',
                             'pgpPublicKey', 'smimePublicKey'),
     ),
     'search' => array(
         'name',
         'email',
         'homeEmail',
         'workEmail',
         'homePhone',
         'workPhone',
         'cellPhone'
     ),
     'strict' => array(
         'object_id',
         'owner_id',
         'object_type',
     ),
     'export' => true,
     'browse' => true,
     'use_shares' => true,
     'list_name_field' => 'lastname',
     'alternative_name' => 'company',
);