Export and Import Question

  • Ben
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
2 weeks 6 days ago #166142 by Ben
Export and Import Question was created by Ben
Hi, I have built a J5 site in a subfolder (with the latest version of Membership Pro) of my soon to be old J2.5 site. I want to export my MPro users from the old site and import into the new site. I am guessing that I also need to export/import the joomla users as well?

Im a little uncertain of the best way to achieve this, so any guidance appreciated. Ben

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

  • Ben
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
2 weeks 6 days ago - 2 weeks 5 days ago #166143 by Ben
Replied by Ben on topic Export and Import Question
I thought the import subscribers from CSV article was the answer for a moment, but Im not sure as it doesnt have joomla user ID or member ID on the attached sample csv file so dont think it ties to the subscriber to the joomla user

My export doesnt seem to have the same fields:

 

 
Last edit: 2 weeks 5 days ago by Ben.

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

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
2 weeks 5 days ago #166155 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export and Import Question
Hi Ben

Honestly, I don't know how you could export Joomla users from Joomla 2.5 to Joomla 5. That version is too old already. Maybe you can try to export the following tables and import it to your Joomla 5 sites to see if it works:

jos_usergroups
jos_users
jos_user_keys
jos_user_notes
jos_user_profiles
jos_user_usergroup_map
jos_viewlevels

(Ignore the tables does not exist on your Joomla 2.5 installation and replace jos_ with the actual database table prefix uses on your site)

Tuan

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

  • Ben
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
2 weeks 5 days ago - 2 weeks 5 days ago #166158 by Ben
Replied by Ben on topic Export and Import Question
Hi Tuan, thanks. I think I have a method for the user export (J2XML) possibly.

assuming I can get the J2.5 users into J5, how does my Membership Pro export/import marry with them? I cant see Joomla user IDs on the MPro exported info. (In fact, my old MPro has less tables than your example CCV - is that ok?)

 

Thanks, Ben
Last edit: 2 weeks 5 days ago by Ben.

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

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
2 weeks 5 days ago #166165 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export and Import Question
Hi Ben

Yes. It's associated via Joomla User ID as you figured out

Regards,

Tuan

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

  • Ben
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
2 weeks 5 days ago #166167 by Ben
Replied by Ben on topic Export and Import Question
Hi Tuan, but my MemPro export doesnt have any Joomla IDs, so not sure how to export with?

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

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
2 weeks 5 days ago #166171 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export and Import Question
You can use username field. For more details, please read the instructions here docs.joomdonation.com/membershippro/subs...t/import-subscribers

Tuan

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