Import CSV - Email not imported

Hi Tuan,

I've got a problem importing email in membership pro :

- I imported around 1500 members from Community Builder to Membership Pro.
No big problem with import file, but I did it with minimal informations : plan, username, last_name, first_name, date_from, date_to

- I did not put email in the csv file because I thought membership would find them... A bit silly, ok .

- In fact, not, Membership Pro does not fill the field email, and so does not send renewal mail.

- I tried to reimport one profil with email, but it doesn't work.

- I also can not map email field in Membership Pro, neither with Joomla, neither with CB.

Would you have a good idea to import email adress (existing in joomla users and CB profiles) so that I do not have to do it all again ?
Thank you !
Catherine

Hi Catherine

To answer your question, I need you to:

1. Send me sample file which you are using to import

2. Tell me exactly what problem you are having?

Just for your information, if your users already exist in Joomla, you should have data for username column in csv file contains username of the users so that the imported subscription records will be assigned to that user account

Regards,

Tuan

OK, should I open a ticket to send you the file ?

Yes I imported the CB profiles whith the username column, so that users have been recognized.

I just can't achieve to import email adresses that I didn't write in my first import file.
So I would like to update the membership profiles with the email adresses.

I tried with a CSV file with just 2 columns, username and email, but it didn't work, then with more columns (but not all), and also didn't work. Do I have to reimport a full csv file. I'm afraid to get double profiles...

I think you can update data by running a SQL command via phpmyadmin

1. Backup data of jos_osmembership_subscribers table

2. Run this SQL command via PHPMYADMIN:

UPDATE jos_osmembership_subscribers AS a INNER JOIN #__users AS b ON a.user_id = b.id SET a.email = b.email WHERE a.email = ""

In the above code, you need to replace jos_ with the actual database table prefix of your Joomla site database

Then check it again, the email will be populated from email of that user account

Regards,

Tuan

Hi Tuan,
Thanks for helping.
I get an error message when I run the SQL command:

SQL query:

UPDATE joo382_osmembership_subscribers AS a INNER JOIN #__users AS b ON a.user_id = b.id SET a.email = b.email WHERE a.email = ""

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Replace #__users with joo382_users and try again, please

command is accepted but only 1 row on 1885 affected

I notice that id users are not the same in CB, Joomla and Membership Pro...
Don't consider this message, error from me!

Hi

In this case, please submit a support ticket sending us super admin account of your site, and also, access to your site database via PHPMyadmin

I will try to find correct SQL command to update data for email field for you. Hopefully, we won't have to write PHP code to do this

Regards,

Tuan