Import (former) Members to current aMember Data

deafdavid · Jan 3, 2009

Hi....our volunteers discovered more than 100+ former members that were never imported into aMember when we first setup aMember few years ago.

We have approximate 100+ names that we need to add.

Our organization (we're community based group) have a policy to keep records of former members. Many of them have not been follow up for renewal and we're hoping they'll rejoin our group.

Is it possible to do import 100+ data into current database?

Thanks.
Dave

skippybosco · Jan 3, 2009

Yes, aMember supports importing any number of users via a .csv file.

You can find additional information in the manual here:

http://manual.amember.com/Using_Import
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
Code:
 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
Click to expand...

Weezer · Jan 5, 2009

Don't mean to piggyback this post but I've imported everyone but when I rebuild DB, they don't get added to the remote hpasswd. I've contacted Customer Support about this but I figured I try out the forum while I wait on support's solution.

skippybosco · Jan 5, 2009

For clarification, what do you mean by "remote .hpasswd"?

Do the users that imported have active subscriptions for a product?

Import (former) Members to current aMember Data

deafdavid Member

skippybosco CGI-Central Partner Staff Member

Weezer New Member

skippybosco CGI-Central Partner Staff Member

Share This Page

Import (former) Members to current aMember Data

deafdavid Member

skippybosco CGI-Central Partner Staff Member

Weezer New Member

skippybosco CGI-Central Partner Staff Member

Share This Page

Useful Searches