New Feature: Import Subscribers from CSV file

1. Overview : This feature allows you to import subscribers from a CSV file into Membership Pro subscribers. This feature is usually used when you migrate subscribers from a different system or have an existing list of subscribers which you want to import into the system .

2. In order to use this feature, the first step is that you need to download latest version 1.5.2 of Membership Pro, upgrade it to your site .

3. Prepare data for running the import. The data needs to be stored into a CSV file (comma separated). Please look at the attached file for a sample of CSV file :

- The first row in the csv file must contains the name of the fields you want to import (please note : the name of field, not title of the field. Go to Membership Pro -> Custom Fields and you will see the name of all fields/custom fields). The fields can be in different order, but the name must be the same .

- Below are the meaning of some important fields :

+ Plan : The title of the subscription plan which the subscriber will be imported to. Please note you will need to create all subscription plans first before running the import.

+ username : Username of the subscriber. If this username exists in your system, the subscription record will be assigned to this user account. If this username doesn't exist, the system will create a new account for this subscriber. You can leave this field empty and no account will be created.

+ password : Password of the account. If it is empty, the system will generate a random password for the subscriber (of course this field won't be used if the username field is empty).

+ payment_date : The data which the payment was made .

+ from_date : The date which the subscription start for this subscriber. (Note , it must be in yyyy-mm-dd format).
+ to_date : The date which the subscription for this subscriber expired. ( (Note , it must be in yyyy-mm-dd format).
+ published : The subscription status : 0 => Pending, 1 => Active , 2 => Expired.
+ amount : The original amount of the subscription (not including tax, discount)
+ tax_amount : Tax amount.
+ discount_amount : Discount Amount
+ gross_amount: The amount including tax substract for the discount_amount

+ payment_method : Name of the payment method
+ transaction_id : Transaction ID
+ osm_quantity : A sample of custom field
+ osm_pdf_application : Another sample of custom field.


Hope the instructions are clear to you. If you have any questions, please don't hesitate to ask !

Tuan

This is exactly what we needed. Thank you.

I noticed that user details fields are missing options for these things.

1. Saltutation (eg Mr/Mrs/Ms etc)
2. Mobile Phone

If they could be added to the import section and to Membership Pro in general it would be appreciated.

Thanks
Scott

When the import has been completed, does this automatically email the members with their login details?

I have AEC extension managing memberships. How do we switch to Membership Pro without overwriting CB user account passwords? Aren't passwords encrypted?

Hi

If your users already existing in database, the system won't create any account, just assign the subscription records to his account. So I don't think there is any problem with the import !

Tuan

FYI for Mac users:

If you're on Excel, make sure to save as "Windows Comma Separated". Just selecting "Comma Separated Values" doesn't work for importing.

Thank you so much for taking the time to post the note about saving as Windows Comma Separated on a Mac. You saved me a lot of time and trouble.

When I import a new subscriber, or even add one individually in the backend, does the membership pro module add the user to the access group that has permission? In other words, can I look at the individuals user record and see that they have been added to the permission group as a result of adding them to membership pro backend?

Does it work if the subscriber was already a site member? After adding them to a subscription in the membership pro backend will i then see the user has been added to the permission group in their user record?

I'm SO over OSE - horrible software... I have 2100 subs... ( 571 paying premiums and active with their cards already in authorize) and the others just registered users...I want to use your software! I have a database/programmer guy - his question - after the import will, or how will the users still be associated with authorize so that their cards continue to be charged seamlessly? is there some kind of identifier that can be added in? Also, with your software , if their card is declined in authorize, will it knock them down to "registered" on the site? Thank you!