How do I import Mighty Membership users from J1.5 site?

this question leads to a problem how to migrate your users from Joomla 1.5 to Joomla 3 and keep their IDs. Theer may be ven better way, but I know only this one.

1. Joomla 1.5 and 3 stores user very differently. Biggest difference is binding to user groups. So I would start with updating Joomla 1.5 to Joomla 2.5 just to make DB structure the same. You can make copy of your 1.5 site and apply update on it.

Read here how to do that

http://docs.joomla.org/J2.5 :Migrating_from_Joomla_1.5_to_Joomla_2.5

2. Now when user groups structure the same with J!3, make sure table prefixes are the same on both DBs.

3. Now you have to transfer all your users. For that start with SQL patch on your old Joomla 2.5 DB.

ALTER TABLE `jos_users` ADD COLUMN `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `params`,

  ADD COLUMN `resetCount` int(11) NOT NULL DEFAULT '0' AFTER `lastResetTime`,

  ADD COLUMN `otpKey` varchar(1000) NOT NULL DEFAULT '' AFTER `resetCount`,

  ADD COLUMN `otep` varchar(1000) NOT NULL DEFAULT '' AFTER `otpKey`;

This query will make users table the same as it is in J! 3.

3. Now use PMA to dump tables #__users, #__user_usersgroup_map and all #jcs*

4. Now use PMA to upload dump to your new Joomla.

5. Make sure, that Emerald 9 has no groups, plans or sales. And then go to import and import.

That is it.

Hi,

I've decide to start from scratch. I have update my web site from J1.5 to J2.5 using SPupgrade.

My new 2.5 DB shows only 35 users in "_jcs_user_subscr" group. In fact the original DB in J1.5 only shows 35 users as well. However, I have some 275 subscribers according to Mighty Member when viewed from the backend of my original site. I'd like to import all the users.

I can even import the J1.5 "gavg_0_jcs_user_subscr" files using SPupgrade into the new 2.5 site, however, it only import 35 subscribers, all from earlier years. Some from as early as 2009, but no current users.

I have to say this is real confusing, especially for a semi-newbie. I can usually figure these things out but this is increasingly perplexing. I thought the move from Mighty to Emerald was going to be much more seamless. Any additional thoughts would be appreciated.

D. Ashley

My new 2.5 DB shows only 35 users in "_jcs_user_subscr" group. In fact the original DB in J1.5 only shows 35 users as well. However, I have some 275 subscribers according to Mighty Member when viewed from the backend of my original site. I'd like to import all the users.

that is sounds like your site and DB you are looking into are different. If you have 36 in DB then it will be 35 in backend. There is no way membership could do 200 out of 35. Most probably those are different DBs

My new 2.5 DB shows only 35 users in "_jcs_user_subscr" group. In fact the original DB in J1.5 only shows 35 users as well. However, I have some 275 subscribers according to Mighty Member when viewed from the backend of my original site. I'd like to import all the users.

I can usually figure these things out but this is increasingly perplexing

This is why it took years for us to start developing for Joomla 2.5 and above and even though we could not make extensions updates and had to create all new extensions from scratch.

My new 2.5 DB shows only 35 users in "_jcs_user_subscr" group. In fact the original DB in J1.5 only shows 35 users as well. However, I have some 275 subscribers according to Mighty Member when viewed from the backend of my original site. I'd like to import all the users.

I can usually figure these things out but this is increasingly perplexing

I thought the move from Mighty to Emerald was going to be much more seamless

It is one button click in Emerald. Just import and it is done. All the complexity comes from updating Joomla 1.5 to Joomla 3.0 and all your problems has nothing to do with membership or Emerald. You did not even get to the point where you start subscribers transfer from membership to Emerald. You stack on updating your site.

Actually any tool that update Joomla should not touch Membership tables at all. So if there are 200 subscriptions before you start update to Joomla 2.5, there will be 200 subscription when you finish.

I am really sorry that you experience all those problems. I clearly remember how I was mad when I tryed to update my old sites. That was nightmare. Although I am 10 years full time Joomla developer.