[turba] Accessing external source

[Andreas Dahlen]

Hi!

We are running Horde 3.0.6, IMP 4.0.4 and Turba 2.0.4.

We have a intranet (not based on Horde) with a usertable that I want to 
use in Turba as source. I can get data from the table, but I don't get 
the mapping to work.

I'd like to search on alias, firstname and lastname.
I'd like to concatenate firstname and lastname.
MailName doesn't contain the domainname, so I'd like to add the 
domainname automaticly.

When searching on firstname or lastname I gett the following in the Horde log.
Nov 08 12:48:11 HORDE [debug] [turba] SQL query by 
Turba_Driver_sql::_read(): SELECT ShortName, FirstName, LastName FROM 
User WHERE ShortName IN (?) [on line 145 of 
"/export/wwwdb/intern/webmail3/turba/lib/Driver/sql.php"]

For my search I get 5 hits, and the browsed values are
Name : [No Value]
Email: Blank

I've tried the following configuration;
$cfgSources['intrasql'] = array(
    'title' => "Sigma nBiT",
    'type' => 'sql',
    'params' => array(
        'phptype' => 'mysql',
        'hostspec' => 'localhost',
        'username' => 'xxxxx',
        'password' => 'xxxxx',
        'database' => 'intranet',
        'table' => 'User',
        'charset' => 'iso-8859-1'
    ),
    'map' => array(
        '__key' => 'ShortName',
        'name' => array('fields' => array('FirstName', 'LastName'),
                        'format' => '%s %s'),
        'email' => array('fields' => array('MailName'),
                        'format' => '%s at example.com'),
        'firstname' => 'FirstName',
        'lastname' => 'LastName'
        'homePhone' => 'HomePhone',
        'workPhone' => 'OfficePhone',
        'cellPhone' => 'Mobile'
    ),
    'search' => array(
        'firstname',
        'lastname',
        'name'
//      'alias'
    ),
    'strict' => array(
//        'alias'
    ),
    'public' => true,
    'readonly' => true,
    'admin' => array(),
    'export' => false
);


/Andreas


----------------------------------------------------------------
This message was sent using IMP (http://www.horde.org).
Running on PHP 4.3.11, Apache 2.0.53, FreeBSD 5.3.