I've just completed my installation and imported roughly 4000 subscribers for my TWO products. However, I've now got about 700 duplicate accounts -- by this I mean two accounts with different logins but the same email address. It's easy enough to find these and use the Actions -> Move User Payments To A Different Account And Delete Current Customer Record function, but since I'm doing 700 of them that would take forever. Is there an automated method for consolidating records with equal email addresses? Chris W.
Avoid duplicate emails Is there anything in the form that we can use to NOT create a duplicate account for the same member? I'm creating signups remotely from my webpages (instead of using the aMember templates).
Unfortunately, there is no such ability in the form, but it can be done via XMLRPC interface. Contact us via helpdesk for programming details.
Hello! Add through the phpmyadmin UNIQUE to your database user table. This will prevent any duplicates - regardless of the scripts you are using i.e. regardless of amember! But first you must not have any duplicates at all to apply UNIQUE on a table field. If you do have duplicate emails, then you must find them out wih the help of SQL Queries and change the records.