Roundcube Community Forum

Release Support => Pending Issues => Topic started by: projectmyst on September 10, 2010, 09:00:47 AM

Title: Address Book
Post by: projectmyst on September 10, 2010, 09:00:47 AM
Hi

I want to add more filed to the address book, dose any one know how to do it? I'm using 0.4 Stable
Title: Address Book
Post by: SKaero on September 10, 2010, 11:06:11 AM
You could try using the patch attached to this ticket: http://trac.roundcube.net/ticket/1486377
Title: Address Book
Post by: projectmyst on September 10, 2010, 11:21:27 AM
Is this patch for the sql contacts?
Title: Address Book
Post by: SKaero on September 10, 2010, 11:50:28 AM
Yes, as far as I know its only MySQL.
Title: Address Book
Post by: xrxca on September 18, 2010, 07:34:03 PM
Quote from: skaero;29978Yes, as far as I know its only MySQL.

Actually based on the changes in the SQL directory it looks like it may work for sqlite and postgres as well.

This is one patch that I hope makes it into the next release, but the search routines (search field on Address book page and autosearch on email entry) need to have the option of searching more than just Display name and email address.
Title: [0.5] SQLite additional fileds
Post by: yurayko on April 01, 2011, 09:09:36 PM
Hi,
for now, not working or partially and I need little help :)
I edited these files:

/program/steps/addresbook/show.inc
$form = array(
        'info' => array(
            'name'    => rcube_label('contactproperties'),
            'content' => array(
                'name' => array('type' => 'text', 'size' => $i_size),
                'firstname' => array('type' => 'text', 'size' => $i_size),
                'surname' => array('type' => 'text', 'size' => $i_size),
'address' => array('type' => 'text', 'size' => $i_size),
'zip' => array('type' => 'text', 'size' => $i_size),
'city' => array('type' => 'text', 'size' => $i_size),
'phone' => array('type' => 'text', 'size' => $i_size),
'mobile' => array('type' => 'text', 'size' => $i_size),
'birthday' => array('type' => 'text', 'size' => $i_size),
'company' => array('type' => 'text', 'size' => $i_size),
'url' => array('type' => 'text', 'size' => $i_size),
                'email' => array('type' => 'text', 'size' => $i_size),
            ),
        ),
        'groups' => array(
            'name'    => rcube_label('groups'),
            'content' => '',
        ),
    );

/program/steps/addresbook/edit.inc
$form = array(
        'info' => array(
            'name'    => rcube_label('contactproperties'),
            'content' => array(
                'name' => array('type' => 'text', 'size' => $i_size),
                'firstname' => array('type' => 'text', 'size' => $i_size),
                'surname' => array('type' => 'text', 'size' => $i_size),
'address' => array('type' => 'text', 'size' => $i_size),
'zip' => array('type' => 'text', 'size' => $i_size),
'city' => array('type' => 'text', 'size' => $i_size),
'phone' => array('type' => 'text', 'size' => $i_size),
'mobile' => array('type' => 'text', 'size' => $i_size),
'birthday' => array('type' => 'text', 'size' => $i_size),
'company' => array('type' => 'text', 'size' => $i_size),
'url' => array('type' => 'text', 'size' => $i_size),
                'email' => array('type' => 'text', 'size' => $i_size),
            ),
        ),
        'groups' => array(
            'name'    => rcube_label('groups'),
            'content' => '',
        ),
    );

/program/steps/addresbook/save.inc
$a_save_cols = array('name', 'firstname', 'surname', 'address', 'zip', 'city', 'phone', 'mobile', 'birthday', 'company', 'url','email');
I have added to -
/program/localization/en_US/labels.inc
$labels['address']   = 'Address';
$labels['zip']       = 'ZIP';
$labels['city']      = 'City';
$labels['phone']     = 'Phone';
$labels['mobile']    = 'Mobile';
$labels['birthday']  = 'Birthday';
$labels['company']   = 'Company';
$labels['url']       = 'Homepage';

My problems are: I can edit contacts, but changes are not saved :( message speech --> ALL was saved ... :D and second problem, I can't add contact -->

DB Error in /var/www/google.xxx/roundcube/program/include/rcube_mdb2.php (650): MDB2 Error: null value violates not-null constraint Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO contacts (user_id, changed, del, "name", "email", "firstname", "surname") VALUES (1, now(), 0, 'a', '[email protected]', 'a', 'a')] [Native code: 19] [Native message: contacts.vcard may not be NULL]

MANY THANKS
Title: Address Book
Post by: SKaero on April 02, 2011, 01:16:11 AM
At this point it would be better to update to the SVN which has support for more address book fields.