Importing 100,000 members

Discussion in 'Integration' started by slinky, Nov 20, 2010.

  1. slinky

    slinky Member

    Joined:
    Jul 15, 2010
    Messages:
    200
    I have over 100,000 members in 2 different scripts. There are let's say 140,000 in one and 120,000 in the other. I can combine them into one large list. What are best practices to get them into amember? I'm thinking that the process is as follows:

    1) Back everything up... twice. :)

    2) Combine all the user names and email addresses into one long list - passwords will be meaningless and be replaced anyways. Since I have extra fields, I'll need to fill them with NULL values to make sure that an import will work. Perhaps best is to do a sample export of the 3 users in amember to ensure that the CSV file will be in the exact same format.

    3) Import the user names and email address via phpmyadmin or using a command line interface into the "login" and "email" fields.

    4) Use the "Rebuild" command to sync both scripts with amember. Amember will populate both script 1 and script 2 with user names if they are not contained in those scripts and also supply them with a password. I'm guessing that rebuild might take a while initially so doing this during off hours is important.

    Sound about right?
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Sure this is right, except 2. This should be done from amember CP -> Import, this way aMember will generate password and populate some system fields(like data.status etc..)
    Also, there will be issues if you have duplicate usernames in both scripts(and I'm sure you have). aMember will not import duplicate usernames so I believe this is better to create custom import script that will handle duplicates as well.

Share This Page