[horde] problem upgrading turba

[Frantz de Germain]

Le Thu, 08 Jun 2006 00:01:58 +0300
Toomas Aas <toomas.aas at raad.tartu.ee> écrivait:

> Frantz de Germain wrote:
> 
> > I'm migrating from horde-2.2.5/imp-3.2.4/turba-1.2.2/ to
> > horde-3.1.1/imp-h3-4.1.1/turba-h3-2.1/
> > 
> > All seems to work well so far, but I can't see anymore the addresses that
> > were in previous version of turba. That will be a big problem if I can't
> > migrate all the address books of my users.
> 
> Where are your addresses stored? If it's MySQL, did you run the 
> 1.2_to_2.0.sql upgrade script? I recently did a similar Turba upgrade 
> and existing addresses were migrated OK.
> 

I've run 1.2_to_2.0.sql on my postgresql database, and I can see the tuples
in the turba_objects table of the horde database.

Here is the file sources.php :

$cfgSources['localsql'] = array(
    'title' => _("My Address Book"),
    'type' => 'sql',
    'params' => array_merge($conf['sql'], array('table' => 'turba_objects')),
    'map' => array(
        '__key' => 'object_id',
        '__owner' => 'owner_id',
        '__type' => 'object_type',
        '__members' => 'object_members',
        '__uid' => 'object_uid',
        'name' => 'object_name',
        'email' => 'object_email',
        'alias' => 'object_alias',
        'homeAddress' => 'object_homeaddress',
        'workAddress' => 'object_workaddress',
        'homePhone' => 'object_homephone',
        'workPhone' => 'object_workphone',
        'cellPhone' => 'object_cellphone',
        'fax' => 'object_fax',
        'title' => 'object_title',
        'company' => 'object_company',
        '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' => false,
);


$cfgSources['prefs'] = array(
    'title' => _("Private Address Book"),
    'type' => 'prefs',
    'params' => array(
        'name' => 'prefs',
        'charset' => NLS::getCharset()
    ),
    'map' => array(
        '__key' => 'id',
        '__type' => '_type',
        '__members' => '_members',
        '__uid' => 'uid',
        'name' => 'name',
        'email' => 'mail',
        'alias' => 'alias'
    ),
    'search' => array(
        'name',
        'email',
        'alias'
    ),
    'strict' => array(
        'id',
        '_type',
    ),
    'export' => true,
    'browse' => true,
);


Regards.

-- 
Frantz de Germain
Web : http://www.info.univ-angers.fr/pub/frantz
Membre de la Société d'Astronomie de Nantes : http://www.san-fr.com/