Importation issues.

[Deyson]

I would assume that importing a CSV file that was exported using S2 Member PRO would work like a breeze.

But when I import the CSV file I get this error: Line #1. User ID# 5 does NOT belong to an existing User.

I am migrating my site over to a new host. So any additional advice on how to make this and easy transition would be appreciated.

Thank you.

[Cristián Lávaque]

That's odd. Could you please post the first few lines of your CSV file, x'ing out private info? Please include the line that gave you the error.

[Deyson]

I changed the emails to protect the innocent and removed the administrator that is number 1:

"ID","Username","Password","First Name","Last Name","Display Name","Email","Website","Role","Custom Capabilities","Registration Date","First Payment Date","Last Payment Date","Auto-EOT Date","Custom Value","Paid Subscr. ID","Paid Subscr. Gateway"
"4","whitcrow","","Serg","Voron","Serg","whitec@toch.ru","","s2member_level1","","01/23/2011","","","","","",""
"5","jeff","","Jeff","Mill","Jeff","jeff@gmail.com","","s2member_level1","","01/24/2011","","","","","",""

[Cristián Lávaque]

Ah, I see now. You have to remove the IDs, leave them empty.

[Deyson]

I did that, now I get this error:

Line #2. User ID# 5 does NOT belong to an existing User.

[Cristián Lávaque]

You must have left the ID there if you're getting that error. I used the CSV data you shared above in a test import without the IDs and it was successful.

Try this:

Code: Select all

"ID","Username","Password","First Name","Last Name","Display Name","Email","Website","Role","Custom Capabilities","Registration Date","First Payment Date","Last Payment Date","Auto-EOT Date","Custom Value","Paid Subscr. ID","Paid Subscr. Gateway"
"","whitcrow","","Serg","Voron","Serg","whitec@toch.ru","","s2member_level1","","01/23/2011","","","","","",""
"","jeff","","Jeff","Mill","Jeff","jeff@gmail.com","","s2member_level1","","01/24/2011","","","","","",""

[Deyson]

So I must go through each line and erase each numbered ID one by one and then re-save it as a CSV to upload?

[Cristián Lávaque]

If you're working with Excel, you can just select the column (except the heading) and delete the values.

[Deyson]

Ok thank you

[Cristián Lávaque]

[Deyson]

When I import users it does not show the Date of Expiration. How does s2member know when a membership is expired?

When I first started my site I had a lifetime membership, recently I changed it to 1 year membership both using level 1.

Thank you.

[Deyson]

Also, is there a way I can bring over passwords of the users, I would hate to have them redo their passwords as I switch servers.

[Cristián Lávaque]

There's a column for the EOT time. If you changed the lifetime to 1-year in your button, that's not going to affect the user's ETO time in his profile.

About the password, there's a column you can use to import them, but they won't be exported, so unless you have them already, you won't be able to get them from WordPress' database.

Now, if you're moving to another server, what you could do is migrate the database, instead of export-import the users.

Does that help?

[Deyson]

I have switched servers, everything is set and all I need to do is bring over the members and the passwords. How would I go about that?

[Cristián Lávaque]

Did you migrate the database? Users and their data should be there too. Migrating the database is the only way I can think of to move the passwords too, at least the tables for the users.

[Deyson]

What is the best way to import user database to my new wordpress site?

Thank you

[Cristián Lávaque]

This plugin may do what you need: http://wordpress.org/extend/plugins/wp-migrate-db/

I hope it helps.