[imp] Moving preferences and Addresses from old version to new

Theresa M Peter theresa at email.uc.edu
Mon Dec 30 23:03:43 PST 2002


   Hopefully someone out there has done this and can provide me with some 
help.  Here is the issue.

   Currently in production I have Horde 1.2.7 and IMP 2.2.7 with mysql 
backend (I know I am outdated and vulnerable to CSS).

    I would like to move to Horde 2.1, IMP 3.1 and Turba 1.1 with mysql on 
the backend.

   My issue is twofold....

First, dealing with the addressbook my users have put 13,655 email 
addresses into their addressbooks.  I would really like to save all of 
these addresses for them.  The only thing I am worried about is the 
object_id column that is in Turba 1.1.  If I do not put anything into the 
object_id column then an individual can not edit that entry.  The object_id 
is also an unique field, so you can not put duplicates into that 
field.  Can I just put sequential numbers as the object id for the 
addresses that I need to move over?  Will this cause any problems down the 
road?

My insert statement for addressbook: insert turba_objects values ("abc", 
"theresa at email.uc.edu", "Tim Jones", NULL, "tjones at hotmail.com", "", "", 
"", "", "", "", "", "", "");


Second, dealing with the preferences...

In the old version of Horde/IMP the table that stores the preference 
information is imp_pref.  This information is stored in the following 
columns: user, full name, replyto, lang, and sig.  In the new version that 
information is stored in the table horde_prefs and in the columns pref_uid, 
pref_scope, pref_name, pref_value.  Since the old version of Horde/IMP only 
allowed for one identity only, I only need to worry about the populating 
the column pref_value correctly and ensuring that I  have inserted a 
default identity into the horde pref_scope. I am able to do both of the 
inserts successfully, as long as the signature does not have any return 
characters in it. If the signature has return characters in it, none of the 
information will show up in the personal information area.  HELP...  How do 
I insert an individuals signature that has return characters in it??

This is the script that will work:

CONNECT horde;

insert horde_prefs values 
("theresa at email.uc.edu","horde","default_identity","0");

insert horde_prefs values (
"theresa at email.uc.edu","horde","identities","a:1:{i:0;a:11:{s:2:"'"id"'";s:16:"'"Default 
Identity"'";s:8:"'"fullname"'";s:13:"'"Theresa 
Peter"'";s:9:"'"from_addr"'";s:20:"'"theresa at email.uc.edu"'";s:12:"'"replyto_addr"'";s:20:"'"theresa at email.uc.edu"'";s:9:"'"signature"'";s:117:"'"Theresa 
Peter Operating System Analyst University of Cincinnati (513) 556-9008 
Theresa.Peter at uc.edu 
http://www.uc.edu"'";s:9:"'"sig_first"'";i:0;s:10:"'"sig_dashes"'";i:0;s:14:"'"save_sent_mail"'";s:1:"'"1"'";s:16:"'"sent_mail_folder"'";s:9:"'"sent-mail"'";s:11:"'"private_key"'";N;s:16:"'"private_key_type"'";N;}}");

The following script will appear to insert correctly into the database but 
when you go to edit the default identity it does not show up nor will it 
use any of the preferences set here:

CONNECT horde;

insert horde_prefs values 
("theresa at email.uc.edu","horde","default_identity","0");

insert horde_prefs values (
"theresa at email.uc.edu","horde","identities","a:1:{i:0;a:11:{s:2:"'"id"'";s:16:"'"Default 
Identity"'";s:8:"'"fullname"'";s:13:"'"Theresa 
Peter"'";s:9:"'"from_addr"'";s:20:"'"theresa at email.uc.edu"'";s:12:"'"replyto_addr"'";s:20:"'"theresa at email.uc.edu"'";s:9:"'"signature"'";s:122:"'"Theresa 
Peter
Operating System Analyst
University of Cincinnati
(513) 556-9008
Theresa.Peter at uc.edu
http://www.uc.edu"'";s:9:"'"sig_first"'";i:0;s:10:"'"sig_dashes"'";i:0;s:14:"'"save_sent_mail"'";s:1:"'"1"'";s:16:"'"sent_mail_folder"'";s:9:"'"sent-mail"'";s:11:"'"private_key"'";N;s:16:"'"private_key_type"'";N;}}");



If anyone has done this already I would greatly appreciate your expertise.


"Education is not filling a bucket, but lighting a fire."
--William Yeats

Theresa M Peter
Applications Analyst
University of Cincinnati
Bearcat Online Email System
University Hall Suite 400
(513)556-9008



More information about the imp mailing list