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
- Go to Users > Add > “Bulk-Add Multiple Users To A Product”
- Paste your CSV list into the large text area
- Select the Product into which you want to import the users
- 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”.
- Click on the “Bulk Add Users” button. That will first save this entire list as a CSV file in your /dap/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: See Bulk Add Users
But please make sure you are using at least DAP v4.2.1 and LiveLinks v1.7 , because what’s explained below is only available starting those versions.
Pre-requisites for Importing Users with their existing Password, Access Start & End Dates
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,Password,ProductName, Address,City,State,Zip,Country,Phone,Company, Flag (to indicate Paid or Free user), Access Start Date, Access End Date,UserName
Example:
joe@somesite.com,Joe,Member,test123,Example One-time Product,99 hill ave,Cityname,NY,10001,USA,,Plug and Play Inc,y,2011-03-16, 2012-03-15,JoeMember
The only required fields are Email, FirstName and ProductName. If you do not want to supply a value for any of the optional fields, but still wish to import certain others, then just leave those fields empty in the data row (but the commas should remain) as shown below.
Email,Firstname,,,ProductName,,,,,,,,Flag (to indicate Paid or Free user), Access Start Date, Access End Date,UserName
How to do the actual Import
Create a file with the nameĀ /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. To do that, visit the url…
http://www.yoursite.com/dap/dap-bulkImport.php
Note:
* Replace “yoursite.com” with your actual domain name.
* And try to limit the number of users you are importing with this method to not more than 100 users at a time. Otherwise the import may timeout, because 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.

6 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?
[...] You tried to bulk-add users to DAP (i.e., a bulk-import), and it is not working. No users have been added to the [...]
Leave a Comment