Migration from Missus

I currently use Missus, but due to development stopping on that component I want to migrate to UddeIM.

I have 4500 users and want to impact them as little as possible by the migration.

Is there a migration guide?

Can I migrate users existing messages somehow?

many thanks

ian rispin

www.wikivorce.com

Good question, uddeIM can import messages from mypms and afaik most PMS components use quite the same table structure.

Could you post the table structure plz? Maybe it is just an export nd reimport of all data, maybe I cann add some code to uddeIM to import this table.

OK,

Missus seems to have 2 main tables (plus 4 or 5 others).

1) A sent messages table: (jos_missus)

id int(11) No auto_increment
senderid int(11) No 0
sendername varchar(60) utf8_general_ci No
sendermail text utf8_general_ci No
datesended datetime No 0000-00-00 00:00:00
sdr_rstate smallint(1) No 0
sdr_tstate smallint(1) No 0
sdr_dstate smallint(1) No 0
is_draft smallint(1) No 0
broadcast smallint(1) No 0
subject text utf8_general_ci No
message text utf8_general_ci No

2) A message received table: (jos_missus_receipt)

id int(11) No
receptorid int(11) No 0
rptr_rstate smallint(1) No 0
rptr_tstate smallint(1) No 0
rptr_dstate smallint(1) No 0
ackstate smallint(1) No 0
replied smallint(1) No 0
forwarded smallint(1) No 0

So each message has an Id.
So to get complete info on message use Id in these two tables.

You get sender id/info and actual message in first table.

You get recipient id/info in second.

There is a 3rd table i think for file attachments:(jos_missus_files)

id int(11) No auto_increment
idmissus int(11) No
filename text utf8_general_ci No

I am really not too bothered to migrate this as i think my users barely use file attachments.

There are a couple of user config tables, which i dont think i would need to migrate.


So just the two tables, and by the way the primary key (id) on each table is indeed the id from the main joomla user table (jos_users).


So what do you think??

Shouldnt be too bad!!

I'd be very happy to work with you on this,
I get my users migrated,
and you get a verified conversion tool from missus to uddeIM that should help you convert more missus users!!

Its a little bit more work then expected. You have to convert dates and several fields are quite different from fields uddeIM uses.

Maybe someone here in the forum likes to write a converter. I (and some other users) would appreciate that. Unfortunately I have not the spare time to support this project, there are other features like J!1.5 compatibility which have higher priority.