eMember- Import error with CSV to DB plugin

[Gabriella Hovarth]

I have installed the CSV to DB plugin for eMember and am trying to get the CSV import feature to work. I followed the instructions and set the following values in General Settings:

Starting Row: 2

Table Name: wp_wp_eMember_members_tbl

Column Names: user_name, first_name, last_name, password, member_since, membership_level, account_state, last_accessed, last_accessed_from_ip, email, phone, address_street, address_city, address_state, address_zipcode, country, gender, referrer, extra_info, reg_code, subscription_starts, txn_id, subscr_id, company_name

When I try to import the sample CSV file [

http://www.tipsandtricks-hq.com/wordpress-membership/wp-content/uploads/2010/08/members.csv%5D

I get this error message:

There was an error uploading the file, please try again.

I tried editing the file to create valid dates and change the member levels to 2 from 1, but still the same problem. I had some custom fields created, so I deleted those, in case they were interfering. Still no luck.

What could be causing this problem?

[Peter]

I’m not sure why you are getting this error but you can try the alternative way to do the import by using PHPMyAdmin.

Please see the video in this post:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[Gabriella Hovarth]

OK, thanks. I will try that.

[Gabriella Hovarth]

As you advised, I am trying to use PHP MyAdmin to upload my membership list in CSV format. When I browse the xiyk_wp_eMember_members_tbl table I see the member records, but they don’t include any of the custom fields I created using the Custom Field Settings tab. In what table are my custom fields stored and how do I import to them? It seems like this will be an awkward process if some fields must be imported into xiyk_wp_eMember_members_tbl and other fields imported into a different table.

[admin]

We currently don’t have any option to import custom fields. How many custom fields per user are we talking about?

[Gabriella Hovarth]

There are just 2 custom fields.

[Gabriella Hovarth]

I have been experimenting with using PHP MyAdmin to import member records into eMember. After I did a test import, I used PHP MyAdmin to delete the imported records and then imported them again. Things seemed to work after doing this a few times, but now I think the database may be corrupted. The passwords no longer work. When I create a new account manually, using the eMember interface, it creates two members with the same name and the passwords don’t work. Is it possible that using PHP MyAdmin to directly delete members, instead of deleting them from the eMember interface has corrupted the database? Is there any way to restore the database, or will I have to uninstall and reinstall eMember?

[admin]

Yes, you can delete member records from your PHPMyAdmin. Go to the members table from PHPMyAdmin and you will that each row has a delete button in it.

[Gabriella Hovarth]

If deleting the members from within PHP MyAdmin didn’t cause the problem I’m seeing, what could have caused it and how can I rectify it? When I go to Add/Edit Member in the eMember Dashboard and add a new member manually, two new members are created. This is what I see in the dashboard listing:

870 | test_user | Joe | Blow | joe@gmail.com | Standard | 2013-01-18 | pending

871 | test_user | Joe | Blow | joe@gmail.com | Standard | 2013-01-18 | active

Two membership entries have been created with different IDs but the same user details. One is marked pending and the other active. I am able to log in using the test_user username and password.

There is currently no real member data in the database, so blowing it away to fix the problem is OK, if that is necessary.

[Peter]

Can you please firstly download a fresh copy of the latest version of eMember and then try adding a new member manually as you did before and see if the problem persists?

https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins

[Gabriella Hovarth]

Installing the new version seems to have solved the problem. Thanks.

[Gabriella Hovarth]

I can import the member list now, but I have two new problems:

1. The passwords that are imported do not work; they won’t let me log in. If I edit an imported member account and change the password, the new password then allows me to log in as that user.

2. When the members are imported, the email notification isn’t sent informing the member that the registration is complete. This notification is sent to the email address if I add a member manually.

How can I solve these two problems. To sole the latter problem, is there an option to send a mailing to all members or all selected members?

[admin]

1) The password you import will never work as it is not encrypted. eMember uses an encrypted password system just like WordPress. This is for security. The only way to get around this is to instruct your member to reset the password once after you import them.

2) Importing data into the database won’t trigger any email. Do the following after you import the member data:

– Go to WP eMember -> Members -> Member Lists

– Get the list of member emails

– Open your favorite email sending application

– Send email to all the users instructing them to go to the login page and reset the password

[Gabriella Hovarth]

But how can new members change their passwords if they don’t have a password that allows them to get into the site to change their password?

[Gabriella Hovarth]

The solution you suggest for mailings is problematic. The emails are intended to notify members that an account has been created for them and to provide them with log in instructions. Each email would have to include the member’s username and password, so it would require a complex mail merge. Is there any way eMember can help with that?

What about using the “Send a Notification to the User” option on the Add/Edit Members screen? If I could import all the members and then go into each member account, create their password, select “Send Notification,” and save the account, that would save some time over having to create all the members manually. When I paste the following text into the email field for the “Send a Notification” option, the email is sent but the password and login_link are left blank. Is there a way to get this to work? I use exactly the same text for the “Registration Complete” notification email when the account is created manually and the email is sent with the fields filled out correctly.

Dear {first_name} {last_name}

Your registration is now complete!

Registration details:

Username: {user_name}

Password: {password}

Please login to the member area at the following URL:

{login_link}

Thank You

[Author]

Posts