[imp] Migrating addressbook

[Micah Anderson]

It appears as if the old database schema was pretty simple:

CREATE TABLE imp_addr (
  user text,
  address text,
  nickname text,
  fullname text
) TYPE=ISAM PACK_KEYS=1;

an example entry would be:
INSERT INTO imp_addr VALUES 
('micah@riseup.net','myfriend@hotmail.com','myfriend','My Friend ');

I am using turba, which also looks fairly simple to migrate to:

CREATE TABLE Turba_Objects (
  object_ID varchar(32) NOT NULL default '',
  owner_ID varchar(32) NOT NULL default '',
  name varchar(255) default NULL,
  email varchar(255) default NULL,
  homeAddress varchar(255) default NULL,
  workAddress varchar(255) default NULL,
  homePhone varchar(25) default NULL,
  workPhone varchar(25) default NULL,
  cellPhone varchar(25) default NULL,
  fax varchar(25) default NULL,
  title varchar(32) default NULL,
  company varchar(32) default NULL,
  notes text,
  PRIMARY KEY  (object_ID)
) TYPE=ISAM PACK_KEYS=1;

an example entry looks like:

INSERT INTO Turba_Objects VALUES
('432b5937041ac71fd1969e631b9fa0b2','micah','
Micah Anderson','micah@riseup.net','Whevever','Wherever','(206)555-1212',
'206-555-1212','2065551212','','blah','blah','can butter toast fast');

So, I can easily modify the old contacts to fit properly into the new
Turba_Objects table, but I dont know what the object_ID needs to be,
or how I can generate that with...

I assume folks have done this.

Micah


On Sun, 05 Aug 2001, Micah Anderson wrote:

> 
> I am upgrading from IMP 2.0.11 (yes I know it is old, thats why I am
> upgrading. :) to 2.3.7 - I need to migrate my user's addressbook
> entries to the new horde database that I created for this upgrade
> (instead of trying to ugprade the code, I just created a new
> installation so I can work these things out). 
> 
> Is there a way to pull all the contacts from one and put them in the
> other?
> 
> Thanks!
> Micah
> 
> -- 
> IMP mailing list: http://horde.org/imp/
> Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org