Email error in member import

Hello. I’m having trouble trying to import a .csv list of members, using the following headers:

“User ID “,”Username”,”Password”,”First Name”,”Last Name”,”Display Name”,”Paid Subscr. Gateway”,”Last Payment Date”,”Level”,”Email”

My data is parsed in the file this way:

,aarnold,xxx(hidden for public view by me),Adrienne ,Arnold,aarnold,paypal,7/31/2012,level1,xxxxxxxxxx@gmail.com

The error message I keep getting is:

Line #2. Missing or invalid Email address (); please try again.

Any ideas?

• This topic was modified 3 years, 9 months ago by  Cristián Lávaque. Reason: Remove some details

Thank you for your inquiry.

My data is parsed in the file this way:

,aarnold,xxx(hidden for public view by me),Adrienne ,Arnold,aarnold,paypal,7/31/2012,level1,xxxxxxxxxx@gmail.com

The error seems to be in the format of your file. You must put the fields in the order that they are in the header of the CSV file. Also, the data you had for User Role was incorrect. level1 needs to be s2member_level1.

I can confirm that the following CSV File would import correctly:

"ID","Username","Password","First Name","Last Name","Display Name","Email","Website","Role"
,"aarnold","thispassword","Adrienne","Arnold","aarnold","xxxxxxxxxx@gmail.com","","s2member_level1"

In the future, I would recommend first exporting your current Users, then importing them with your new entries so you have an example of the layout that you need to following to import members.

It worked. Thank you!