[imp] Contacts Management

Kris von Mach dev@swishmail.com
Thu, 29 Mar 2001 16:46:56 -0500


I have turba running, and needed to create these tables:

CREATE TABLE Turba_Groups (
   group_ID varchar(32) NOT NULL,
   name varchar(32),
   PRIMARY KEY (group_ID)
);

CREATE TABLE Turba_Groups_Objects (
   group_ID varchar(32) NOT NULL,
   object_ID varchar(32) NOT NULL
);

CREATE TABLE Turba_Objects (
   object_ID varchar(32) NOT NULL,
   owner_ID varchar(32) NOT NULL,
   name varchar(255),
   email varchar(255),
   homeAddress varchar(255),
   workAddress varchar(255),
   homePhone varchar(25),
   workPhone varchar(25),
   cellPhone varchar(25),
   fax varchar(25),
   title varchar(32),
   company varchar(32),
   notes text,
   PRIMARY KEY (object_ID)
);

CREATE TABLE user_turba_prefs (
   uid varchar(32) NOT NULL,
   pref_name varchar(32) NOT NULL,
   pref_value text,
   PRIMARY KEY (uid, pref_name)
);

and in config/sources.php for turba just edit it to reflect your server
info.

$cfgSources['localsql'] = array(
    'title' => 'LocalSql',
    'type' => 'sql',
    'params' => array(
        'phptype' => 'mysql',
        'hostspec' => 'localhost',
        'username' => 'username',
        'password' => 'password',
        'database' => 'horde',
        'options' => '',
        'tty' => '',
        'port' => '5432',
        'table' => 'Turba_Objects'
    ),
    'map' => array(
        '__key' => 'object_ID',
        '__owner' => 'owner_ID',
        'name' => 'name',
        'email' => 'email',
        'homeAddress' => 'homeAddress',
        'workAddress' => 'workAddress',
        'homePhone' => 'homePhone',
        'workPhone' => 'workPhone',
        'cellPhone' => 'cellPhone',
        'fax' => 'fax',
        'title' => 'title',
        'company' => 'company',
        'notes' => 'notes'
    ),
    'public' => false,
    'readonly' => false
);

I am not sure if you need ALL the tables I have, but it was a trial and
error for me type of thing.

__
Kris.

----- Original Message -----
From: "Joe Jenkins" <joe@nowalls.com>
To: <imp@lists.horde.org>
Sent: Thursday, March 29, 2001 4:04 PM
Subject: [imp] Contacts Management


> I am trying to enable the Contacts section of IMP, which I assume is using
> turba..
>
> I keep getting:
>
> None of the available address books are configured to allow you to add new
> entries to them. If you believe this is an error, please contact your
system
> administrator.
>
> The INSTALL file for turba is blank.  Anyone got a pointer to some set up
docs
> for this feature?  Thanks!
>
> Joe
>
> --
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>
>