Community Support Forums

Re: Importation issues.

2011-12-01T01:44:02-05:00

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

I hope it helps.

Statistics: Posted by Cristián Lávaque — December 1st, 2011, 1:44 am

Re: Importation issues.

2011-11-29T07:02:44-05:00

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

Thank you

Statistics: Posted by Deyson — November 29th, 2011, 7:02 am

Re: Importation issues.

2011-11-29T01:48:37-05:00

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.

Statistics: Posted by Cristián Lávaque — November 29th, 2011, 1:48 am

Re: Importation issues.

2011-11-28T07:03:07-05:00

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?

Statistics: Posted by Deyson — November 28th, 2011, 7:03 am

Re: Importation issues.

2011-11-28T01:15:45-05:00

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?

Statistics: Posted by Cristián Lávaque — November 28th, 2011, 1:15 am

Re: Importation issues.

2011-11-27T06:36:26-05:00

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.

Statistics: Posted by Deyson — November 27th, 2011, 6:36 am

Re: Importation issues.

2011-11-27T06:35:39-05:00

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.

Statistics: Posted by Deyson — November 27th, 2011, 6:35 am

Re: Importation issues.

2011-10-09T01:35:15-05:00

Statistics: Posted by Cristián Lávaque — October 9th, 2011, 1:35 am

Re: Importation issues.

2011-10-08T15:28:31-05:00

Ok thank you

Statistics: Posted by Deyson — October 8th, 2011, 3:28 pm

Re: Importation issues.

2011-10-08T14:56:51-05:00

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

Statistics: Posted by Cristián Lávaque — October 8th, 2011, 2:56 pm

Re: Importation issues.

2011-10-07T06:01:24-05:00

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?

Statistics: Posted by Deyson — October 7th, 2011, 6:01 am

Re: Importation issues.

2011-10-07T00:20:56-05:00

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:: "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","","","","","",""

Statistics: Posted by Cristián Lávaque — October 7th, 2011, 12:20 am

Re: Importation issues.

2011-10-06T09:25:19-05:00

I did that, now I get this error:

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

Statistics: Posted by Deyson — October 6th, 2011, 9:25 am

Re: Importation issues.

2011-10-06T02:15:52-05:00

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

Statistics: Posted by Cristián Lávaque — October 6th, 2011, 2:15 am

Re: Importation issues.

2011-10-05T05:39:49-05:00

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","","","","","",""

Statistics: Posted by Deyson — October 5th, 2011, 5:39 am

Re: Importation issues.

2011-10-05T02:02:52-05:00

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.

Statistics: Posted by Cristián Lávaque — October 5th, 2011, 2:02 am

Importation issues.

2011-10-04T15:49:05-05:00

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.

Statistics: Posted by Deyson — October 4th, 2011, 3:49 pm