Update: You should use the bulk member data importer addon to import member data.
You can use the WP CSV to DB plugin to upload member details from a CSV file into the WP eMember’s database.
Before you use this method please note that if you want to import your WordPress users into eMember then there is an easier option for you. Simply browse to the “Import WP Users” tab from the “Members” menu and you will be able to import all your WordPress users into eMember.
Setup/Preparation
- Install the WP CSV to DB plugin.
- Download the members.csv template file and open it using Microsoft Excel.
- Fill up the member details; One member per row (There are two example entries in that file so replace them with actual details).
- Once you are done entering all your member details then save the file as a CSV file.
Specify the General Options
- Enter 2 in the “Starting Row” field. This is the row number in the CSV file where you want the plugin to start reading from (the first row is the column titles so you want to read from the 2nd row)
- Enter “wp_wp_eMember_members_tbl” in the “Database Table Name” field (this is the database table name for the WP eMember’s member table given you haven’t change the default database prefix of wordpress)
- Enter the content of this text file in the “Column Names” field:
Specify the Input CSV file
Use the upload option to upload the CSV file created in the setup/preparation step.
Import into the Database
Hit the “Import to DB” button which will dump the member details from the CSV file into the database.
Now if you browse to the “Member” menu of WP eMember, you should see all the new members that you just added.
Note
This tool can’t handle importing of eMember custom fields. The primary purpose of this tool is to allow importing of some core member data.
@Anne, Try out bulk member import addon for that:
http://www.tipsandtricks-hq.com/wordpress-membership/bulk-member-data-importer-addon-853
If you add custom fields to the member database – can you run the bulk upload/import with this method and if so how do you modify the members.csv template?
@Barbara, the password fields are encrypted using an one way encryption for security. When you directly import the passwords into the database it doesn’t go through the encryption process which is why you are seeing this issue. Simply instruct your members to reset their password and after the reset it will work as normal.
I’ve imported all the entries and everything looks great…but I’ve noticed that the values in the “password” column are not encrypt into the database so the user cannot login.
Did I miss something?
You have specified incorrect values in the “Column Names” field of the plugin.
You need to enter the content of this file in the “Column Names” field:
http://www.tipsandtricks-hq.com/wordpress-membership/wp-content/uploads/2010/08/eMember_column_names.txt
Please, watch the video on this page (the video is for eStore but the concept is the same):
http://www.tipsandtricks-hq.com/ecommerce/how-to-bulk-upload-estore-products-from-a-csv-file-775
I got an error message:
Error occured while trying to import after I hit the ‘Import to DB’ button. The only fields I have in my .csv file are username and email. Help!
Insert into the Database failed for the following Query:
INSERT INTO () VALUES (‘UserName’,’First Name’,’Last Name’,’Password’,’Member Since’,’Membership Level’,’Account State’,’Last Accessed’,’Last Accessedd from IP’,’Email’,’Phone’,’Address Street’,’Address City’,’Address State’,’Address Zipcode’,’Address Country’,’Gender’,’Referrer’,’Extra Info’,’Reg Code’,’Subscription Starts’,’Transaction ID’,’Subscriber ID’,’Company Name
It should import all the entries. I suspect you have some special characters on your row 30 and it’s exiting when processing that record.
Good stuff and thanks .. these instructions are very clear.
I did notice that only the first 30 rows get imported. Anything csv file with more than 32 rows will ignored the remainder of rows. Also if you repeat the process you end up with duplicate user entries.