[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