Roundcube Community Forum

Hello All,
sorry, but I couldn't resist to choose that name!

For anyone willing to import contacts from an IMP/Horde db, this is a little and dirty plugin...
Very, very, very basic.

<?php
/**
 * IMPorter Plugin
 *
 * Populate user address book with Turba address book from IMP
 *
 * @version 1.0
 * @author Manuele Cappelleri
 *
 * Example configuration:
 * $_turba_db_name = &quot;&quot;;
 * $_turba_db_host = &quot;&quot;;
 * $_turba_db_type = &quot;&quot;;
 * $_turba_db_username = &quot;&quot;;
 * $_turba_db_password = &quot;&quot;;
 * $_turba_db_table_name = &quot;&quot;;
 *
 */
class imp_orter extends rcube_plugin
{
    function init()
    {
$this->_turba_db_name = &quot;XX&quot;;
  $this->_turba_db_host = &quot;XX&quot;;
        $this->_turba_db_type = &quot;XX&quot;;
        $this->_turba_db_username = &quot;XX&quot;;
        $this->_turba_db_password = &quot;XX&quot;;
        $this->_turba_db_table_name = &quot;turba_objects&quot;;
        $this->_log_file = &quot;/tmp/imp_orter.log&quot;;
        $this->add_hook('create_identity', array($this, 'importAll'));
    }

    function importAll($args)
    {
        $rcmail = rcmail::get_instance();
        $ser = serialize($rcmail->user);
        $curUser = $rcmail->user;
        $username = $curUser->data['username'];
        $userid = $curUser->ID;
        $contacts = $rcmail->get_address_book(0, true);
        
        //
        $dsn = $this->_turba_db_type . &quot;://&quot; . $this->_turba_db_username . &quot;:&quot; . $this->_turba_db_password . &quot;@&quot; . $this->_turba_db_host . &quot;/&quot; . $this->_turba_db_name;
        
        $options = array(
            'result_buffering' => false,
        );
        
        $db =& MDB2::factory($dsn, $options);
        if (PEAR::isError($db)) {
            die($db->getMessage());
        }       else {
                $db->setFetchMode(MDB2_FETCHMODE_ASSOC);
        }

        $sql = &quot;SELECT object_name,object_alias,object_email FROM &quot; . $this->_turba_db_table_name . &quot; WHERE owner_id = '&quot; . $username . &quot;'&quot;;
        $this->debug(&quot;DB Query: $sql&quot;);

        $q = $db->query($sql);
        if (PEAR::isError($q)) {
                die($q->getMessage());
        }
        while($r = $q->fetchRow()) {
                $rec = array();
                $rec['email'] = $r['object_email'];
                if ($r['object_alias'] != '') {
                        $rec['name'] = ltrim(rtrim($r['object_alias']));
                } else {
                        $rec['name'] = ltrim(rtrim($r['object_name']));
                }
                $tmp = $r['object_name'];
                $this->debug(&quot;Name is now: $tmp &quot;);
                $tmp = ucwords(strtolower(ltrim(rtrim($tmp))));
                $this->debug(&quot;Name is now: $tmp &quot;);
                
                $parts = explode(&quot; &quot;,$tmp);
                $this->debug(&quot;Name converted to: &quot; . serialize($parts));
                $rec['firstname'] = $parts[0];
                for ($i = 1; $i < count($parts); $i++) {
                        $rec['surname'] .= $parts[$i];
                        if ($i < count($parts)-1) {
                                $rec['surname'] .= &quot; &quot;;
                        }
                }
                
                $this->debug($username . &quot; <- &quot; . serialize($rec));
                $contacts->insert($rec, true);
                
        }
        
        
        
        
        
        return $args;
    }
    
        function debug($string) {
                if ($this->_log_file) {
                        $log = fopen($this->_log_file,'a');
                        fwrite($log,&quot;\n&quot;.$string,strlen(&quot;\n&quot;.$string));
                        fclose($log);
                }        
        }
}
?>