Welcome, Guest
Username: Password: Remember me

TOPIC: New Feature: Import Subscribers from CSV file

New Feature: Import Subscribers from CSV file 4 years 10 months ago #23141

  • Tuan Pham Ngoc
  • Tuan Pham Ngoc's Avatar
  • Offline
  • Administrator
  • Posts: 25034
  • Thank you received: 2708
  • Karma: 381
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
Attachments:
Last Edit: 4 years 10 months ago by Tuan Pham Ngoc.
The administrator has disabled public write access.
The following user(s) said Thank You: qtech, President - PCASA, Steve Babbitt, Scott Hopkins, Alison Gregory, Scott Sims, Sobem Nwoko, Wendell Payne, Bill

Re: New Feature: Import Subscribers from CSV file 4 years 10 months ago #23175

  • President - PCASA
  • President - PCASA's Avatar
  • Offline
  • Junior Boarder
  • Posts: 24
  • Thank you received: 2
  • Karma: 0
This is exactly what we needed. Thank you.
The administrator has disabled public write access.

Re: New Feature: Import Subscribers from CSV file 4 years 10 months ago #23459

  • Scott Sims
  • Scott Sims's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
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
The administrator has disabled public write access.

Re: New Feature: Import Subscribers from CSV file 4 years 9 months ago #24944

  • Charlene
  • Charlene's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
When the import has been completed, does this automatically email the members with their login details?
The administrator has disabled public write access.

Re: New Feature: Import Subscribers from CSV file 4 years 3 months ago #34183

  • breeze29
  • breeze29's Avatar
  • Offline
  • Junior Boarder
  • Posts: 34
  • Karma: 0
I have AEC extension managing memberships. How do we switch to Membership Pro without overwriting CB user account passwords? Aren't passwords encrypted?
The administrator has disabled public write access.

Re: New Feature: Import Subscribers from CSV file 4 years 3 months ago #34224

  • Tuan Pham Ngoc
  • Tuan Pham Ngoc's Avatar
  • Offline
  • Administrator
  • Posts: 25034
  • Thank you received: 2708
  • Karma: 381
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
The administrator has disabled public write access.
The following user(s) said Thank You: breeze29

Re: New Feature: Import Subscribers from CSV file 4 years 2 months ago #34780

  • gary meadows
  • gary meadows's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 10
  • Thank you received: 1
  • Karma: 0
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.
The administrator has disabled public write access.
The following user(s) said Thank You: Alexis Priddy

Re: New Feature: Import Subscribers from CSV file 4 years 2 months ago #35287

  • Denise Montana
  • Denise Montana's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
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.
The administrator has disabled public write access.

Re: New Feature: Import Subscribers from CSV file 4 years 1 month ago #36469

  • CHM
  • CHM's Avatar
  • Offline
  • Junior Boarder
  • Posts: 22
  • Karma: 0
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?
The administrator has disabled public write access.

Import current subs from OSE already being charged 4 years 1 month ago #36694

  • Stacey Donnelly
  • Stacey Donnelly's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
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!
The administrator has disabled public write access.
Moderators: Tuan Pham Ngoc
Time to create page: 0.230 seconds