DAP allows you to import users in bulk from an external system or database.
Pre-requisites for Importing Users
1) You must have already created the Product into which the users will be imported
2) The user list has to be in a CSV (comma separated) format (one user per line), with the exact format being:
Email,FirstName,LastName
LastName is optional. So your user list could have just
Email,FirstName
Example:
Joe@example.com,Joe,Customer
Jill@anothersite.com,Jill
Bob@another.com,Bob,Member
How to do the actual import
1. Go to Users > Add > “Bulk-Add Multiple Users To A Product”
2. Paste your CSV list into the large text area
3. Select the Product into which you want to import the users
4. Check the “Mark Users as Paid” checkbox if you want them to have “Paid” access to the content (just as if they are actual paying members). If you don’t check it, they will all have access as a “Free” user (instead of a “Paid” user), which means they will only have access to content within the Product that you have marked as “Free”.
5. Click on the “Bulk Add Users” button.
That will first save this entire list as a CSV file in your /dap/admin/bulk folder on your site.
And then, the next time the Hourly cron (dap-cron.php) runs, it will add them one by one to the product, and send them emails as per your Product set up.
So if your Product has the “Thankyou-Email” subject and body filled out, it will individually send out each of the users that thankyou email.
DAP will also allow bulk import of users with their existing profile
This includes their existing password and other profile data as detailed in this video.
Pre-requisites for Importing Users with their existing password and profile
1) You must have already created the Product into which the users will be imported
2) The user list has to be in a CSV (comma separated) format (one user per line), with the exact format being:
Email,FirstName,LastName
Email,Firstname,Lastname,Password,ProductName,
Address,City,State,Zip,Country,Phone,Company,
Flag to indicate paid or free user
The only required fields are Email and Firstname. If you do not want to supply a value for any optional field (say Lastname), then just it empty as shown below.
Email,Firstname,,Password,ProductName,
Address,City,State,Zip,Country,Phone,Company,
Flag to indicate paid or free user
Example:
you@yourdomain.com,joe,,test123,Example One-time Product,99 hill ave,cityname,NY,12345,USA,,DAP,y
you@yourdomain-1.com,joe1,smith,,Example One-time Product,99 hill ave,cityname,NY,12345,USA,,DAP,y
How to do the actual import
Update the /dap/bulk/importusers.csv file so it has the users you want to import in the format specified above.
Run this script on your browser to complete the import. Replace yoursite.com with the name of your site.
http://www.yoursite.com/dap/dap-bulkImport.php
Note: Try to limit the number of users you are importing with this method to 50-60 users at a time otherwise the import will timeout as the import occurs real time (not via cron).
If the user already exists in dap, then the script will just skip that user and move on to the next user in the bulk add list.
5 comments ↓
If we do importing users and we include their original password, how are we going to do that? in the case of your instructions above…are they given option to change their password? or add a password? thru the email that will be sent? thnks
Jerome:
We support this type of bulk import with DAP 3.8.
See this video:
http://www.digitalaccesspass.com/videos/BulkAddUsersToDAP.php
Extract the content of importusers.zip and upload to /dap/bulk folder on your site.
Update the importusers.csv file so it has the users you want to import in this format :
emailId,firstname,lastname,password,Product name,address,city,state,zip,country,phone,company,flag to indicate paid or free user
Sample:
you@yourdomain.com,joe,,test123,Example One-time Product,99 hill ave,cityname,NY,12345,USA,,DAP,y
you@yourdomain-1.com,joe1,smith ,,Example One-time Product,99 hill ave,cityname,NY,12345,USA,,DAP,y
Run this script to complete the import:
http://www.digitalaccesspass.com/dap/dap-bulkImport.php
thanks for the help
i dont see dap-bulkimport.php …how do i add the file? where can i get it?
I have two questions:
1. We currently do not use Paypal subscriptions. We would ideally like to let them do a simple purchase for the first time. And then put them on a subscription after first period expires. May be a combination of auto responders with Product B available after Product A? Ideally, we want the product B (renewal) to be available only when the renewal is near.. Can DAP do this?
2. I understood that we can import customers easily into DAP. But when will their subscription expire? Like I said, people have purchased without subscriptions right now. Can we set their “purchase date”, and set an auto responder to request renewal?
Leave a Comment