Importing Users In Bulk Into DAP

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/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 ↓

#1 Jerome on 07.09.10 at 2:28 am

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

#2 Veena Prashanth on 07.09.10 at 6:06 pm

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

#3 Jerome on 07.09.10 at 7:37 pm

thanks for the help :-)

#4 Jerome on 07.11.10 at 10:33 pm

i dont see dap-bulkimport.php …how do i add the file? where can i get it?

#5 Nirav Mehta on 07.30.10 at 8:07 am

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?

#6 Troubleshooting Bulk-Add & Bulk-Import Of Users — DAP Documentation on 10.29.10 at 1:23 am

[...] 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