Using Import

From AMember Pro Manual

aMember Pro has built-in import feature that allows you to import your existing customers and subscription information to aMember.

Input file must be in CSV (comma-separated values) format. Although it sounds complex, it is just a text file with fields separated by commas or semicolons, or pipes (|). For example

 john;my_password;john@gmail.com;John;Simpson
 elen;111111;elen@yahoo.com;Elen;Thompson

You can create such file from many programs, particullary Microsoft Excel can save files in CSV format.

aMember Pro can understand and import virtually any contents inside the CSV file, if it has mandatory fields present.

To import a file:

• Click aMember CP -> Import
• The Import. Step 1 of 4: define input format screen opens
• Describe your file format:

  Username 

  choose if that is contained in the file, or should be generated

  Password 

  choose if that is contained in the file, is a fixed value (not recommended!) or should be generated

  E-Mail 

  is a mandatory field, define where it is in the file

  Other Member Profile fields 

  define where fields are in the import file, or keep blank if fields not present

  Subscription Type 

  after import, user will be automatically subscribed to a product, choose if the product number is specified in a file field, or if import script should use a fixed value

  Subscription Begin Date/Expire Date

  if subscription date is present in the import field, specifiy in what field. Or you can use a fixed value. Date must be in format yyyy-mm-dd or mm/dd/yyyy.

  File Format

  choose a field delimited used in the file. It is better to open the import file with text viewer like Notepad to ensure.

• The Import. Step 2 of 4: Please upload file screen opens
• Click Browse..' and select your input file to upload, then click Upload button
• After upload, aMember will display Import. Step 3 of 4: Confirmation screen. It will dump first 20 records parsed from the file. Please check that all fields are filled-in correctly. If everything is correct, click Do Import> and records will be imported to aMember.
• To get members added to htpasswd and third-party integrated scripts, click aMember CP -> Rebuild Db