Export complete user database

We want to integrate two user databases into one new site.

Some users are registered on both old sites.

How do we export every user from both these site to a new one? Also without duplicating users. Including passwords and usermeta.

We tried your export function but it did not add the users to the the new site. Only some data to every user.
We need to add all our current users to the new site.

Does you plugin support this or could you recommend another plugin that handles user export and import?

• This topic was modified 4 years, 2 months ago by  Patrik Lones.

Hi Patrik.

You could use the s2Member export and import tools. From the previous websites, export the users. Then merge both CSV files into one, removing the user IDs. When importing without user IDs, new accounts will be created.

If you have users registered in both sites, you’d need to remove the duplicates before importing. You’d have to sort by email, username or last name to find them, I guess.

Passwords can’t be exported, so that’ll be blank in the CSV files. You can enter a password for them when you import and tell them what it is. If you import the password field blank, the user will need to use the Lost Password tool to get one generated and emailed to him by WordPress. /wp-login.php?action=lostpassword

I hope that helps. :)

Thanks for your help Cristián!

Do you know if the import and export functions are being modified so that it will be possible to include passwords in the export/import csv files? Having to ask your members/customers to create a new password because their old one is lost doesn’t feel all that good… ;-)

It is possible to include a password in the import, but not the export, since the password is encrypted in the database, it can’t be retrieved.

A user mentioned the possibility of copying the encrypted password from the database and inserting it in the database of the other site directly (not through the import tool, but with a MySQL query), but I haven’t tried this to confirm if it works. I don’t know if when encrypting WordPress takes into account the site’s domain name or something like that. You can give it a shot, though.