Migration from AEC to Membership Pro

More
8 years 4 months ago #85322 by Matt Binz
Replied by Matt Binz on topic Migration from AEC to Membership Pro
Thank you I grabbed it from your server

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #85323 by Joseph Gillotti
Replied by Joseph Gillotti on topic Migration from AEC to Membership Pro
Tuan, I installed the new version of AEC but I still get this:
Unknown column 'lifetime' in 'field list' SQL=SELECT id, name, `desc`, `active`, `ordering`, `params`, lifetime FROM #__acctexp_plans ORDER BY id

Thanks, -Joe

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #85387 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Migration from AEC to Membership Pro
Hi Joe

I don't know why in your installation doesn't have that field in database. I decided to remove that field from the code, could you please download the updated version from membershipprodoc.joomservices.com/migrat...ec2membershippro.zip , upgrade it to your site, then try again?

For your information, I wrote full instructions for the migration and publish it at membershipprodoc.joomservices.com/migrat...ec-to-membership-pro

Regards,

Tuan

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #85390 by Joseph Gillotti
Replied by Joseph Gillotti on topic Migration from AEC to Membership Pro
Using the new version and clearing the data (since one group and all the plans were migrated initially) the migration was completed but with many errors: all plans were duplicated; some subscribers were duplicated, and have found at least one subscription where one was merged with another person with the same first name (I haven't gone through all subscribers).I cleared data once more and ran the migrator again, with the same results. -Joe

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #85391 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Migration from AEC to Membership Pro
Did you clear existing data before running the migration again?

Tuan

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #85393 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Migration from AEC to Membership Pro
As you run the script before, before running it again, you should click on Clear Existing Data button. See this screenshot drive.google.com/file/d/0B2RoJ_24efMQRkN...VE/view?usp=drivesdk for more details

Tuan

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #85394 by Joseph Gillotti
Replied by Joseph Gillotti on topic Migration from AEC to Membership Pro
Yes,, as I mentioned in my earlier reply: I cleared data before the first attempt and again with the second attempt.
-Joe

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #85395 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Migration from AEC to Membership Pro
That's strange. Maybe you can submit a support ticket sending us super admin account of your site of your site, I will try to check to see why the issue happens and get it corrected on tomorrow morning

Tuan

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #85396 by Joseph Gillotti
Replied by Joseph Gillotti on topic Migration from AEC to Membership Pro
Okay. I think some of it might because of the messy forms used through the years via Community Builder., which you will see for yourself. -Joe

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago - 8 years 4 months ago #85851 by Matt Binz
Replied by Matt Binz on topic Migration from AEC to Membership Pro
I was able to get the migrator to work.
It imported the plans and users.
I am testing new purchases of the imported plans from AEC to Mpro.
I created a menu item for one plan however the menu will not show it returns a 404 error.
I tried the non sef url and it also did not work

I can create a menu item with list of my gold plans when I hit sign up or details button nothing appears to happen?
I realized I had not imported any of the usergroups form my live site.
I created them in Joomla and set up the ACL in Mpro for the plan
I made a successful purchase and it made the payment sent me the payment notification from Ppal and gave me correct ACL in Joomla and showed up correctly in Mpro
How may I share the login securely with you here in this forum?
Last edit: 8 years 4 months ago by Matt Binz.

Please Log in or Create an account to join the conversation.