19

Importing Users In Bulk Into DAP

DAP allows you to easily import users in bulk from an external system or database.

Importing users in bulk is the same as adding users one at a time using the single-user-add feature. So whichever way you manually add users, DAP is going to all of the following…

  1. Create a new account for them using the email with which they’re being added
  2. Auto-generate a random, unique password for them
  3. Give them access to the product (into which they’re being imported or being added to)
  4. Send out the Welcome Email as per the product’s settings (this welcome email can be configured to send them the email & password to the member’s area along with anything else you want)
  5. Add them to the autoresponder series configured for that product
  6. … and so on.

When you do a single-user-add, all of this is done for that user in real-time. When you do a bulk-add, then all of the above happens for each user being imported, one at a time, when the DAP hourly cron job runs at the top of every hour. That’s the main difference.

Simple Import

Prerequisites For Simple Import

1) You must have already created the DAP 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)

For doing a simple import of user data containing just email, first and/or last name, the format of data (per user, per line) should be like this:

Email,FirstName,LastName

Email and FirstName are mandatory. But LastName is optional. So your user data row could be 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.

Extended Import

DAP will also allow bulk import of users with extended profile information. This includes their existing password and other profile data as detailed in this video (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 only since then.

Pre-requisites For Extended Import

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, by visiting:

http://YourSite.com/dap/dap-bulkImport.php

Note:

* Replace “YourSite.com” with your actual domain name

* Limit the number of users you are importing with this method to not more than 500 users (rows) at a time. Otherwise the import may timeout, because the import occurs real time, because you’re running the script manually, and 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.

Click Here to Leave a Comment Below 19 comments
Jerome - July 9, 2010

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

Reply
Veena Prashanth - July 9, 2010

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

Reply
Jerome - July 9, 2010

thanks for the help 🙂

Reply
Jerome - July 11, 2010

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

Reply
Nirav Mehta - July 30, 2010

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?

Reply
Troubleshooting Bulk-Add & Bulk-Import Of Users — DAP Documentation - October 29, 2010

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

Reply
João Diogo - January 18, 2013

Veena, I have 2 lists I want to import and they might have duplicate entries.

1. If I import one and then the other, will DAP handle the duplicates (not importing a given duplicate) or will I have duplicate users in the same product/list?

2. If I merge both list in tables or excel and the resultant list has duplicates, how will DAP handle it? Will the resultant user list have duplicate entries or not?

Thanks,
jd

Reply
Veena Prashanth - January 20, 2013

Hi Joao,

Yes, there will be 2 records in users->manage page, but both records will be tied to the same user account.

So say list1=product1, list2=product2 in dap, then you will see the same user (same userid/password) associated with product1 and product2 in users->manage page.

To test, simply go to dap add users page and add user first to product1, then go to manage users page and see what you find there. Now add the same user to product 2(via dap admin -> add users page) and then see what you find in users->manage page.

You will see the same user has access to product 1 and product 2 but both products are tied to the same user account and the user can access both products using same id/password.

See – http://www.digitalaccesspass.com/forums/threads/637-Multiple-products-tied-to-the-same-User-Account-same-User-Login

Thanks,
Veena

Reply
Burt - October 5, 2013

Can DAP be integrated to use with the new AutoReponser Service called SendReach?

I’ve been using DAP for many years…with Aweber, but haven’t been able to figure out how to add buyers from my DAP Products to SendReach.

I appreciate your assistance…I tried to comment on the Aweber to DAP page…but it forwarded me to here.

Thanks

Reply
Adam Teow - October 6, 2013

Hi,

Is there any way to integrate sendreach with DAP?

Cheers,
Adam

Reply
Veena Prashanth - October 11, 2013

Hi Adam,

Yes, you can integrate DAP->SendReach for both paid / free products. The integration is one-way – from dap to sendreach.

Last time I checked, SendReach did not have a way to Pass Form Data via HTTP POST to 3rd party scripts. So if you use a SendReach web form and try to connect it to DAP, it wont work.

But if you a DAP signup form, dap will automatically add the subscriber to SendReach list.

Thanks,
Veena

Reply
gavin - June 1, 2014

This video is not working?

I am struggling to work out how to import users into DAP

http://www.digitalaccesspass.com/videos/BulkAddUsersToDAP.php

Gavin

Reply
Veena Prashanth - June 1, 2014

>>This video is not working?

I am struggling to work out how to import users into DAP

http://www.digitalaccesspass.com/videos/BulkAddUsersToDAP.php << Please check. It works now.

Reply
Farha - October 22, 2014

Hello,

We already have a monthly subscription membership site. We want to move over to DAP. Is it possible to import users at various levels of monthly subscription to DAP?

Thanks!

Reply
Ravi Jayagopal - October 23, 2014

Hi Farha,

Yes, you can import users at a product or membership level in DAP. You will have import one product/membership level at a time, but you can do several of them successively, one right after the other, in one sitting.

– Ravi

Reply
Victoria - November 19, 2014

There’s a line above that says “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”

Is that “user already exists on this product” or “user exists”?

For example, if a user already exists and is assigned to Product A, and the bulk import is trying to add them to Product B, the user will already exist – so will the bulk import skip them (as they already exist) or will it add them to the Product B in addition to Product A?

Reply
Victoria - December 22, 2014

One extra detail that would have been useful to me – username can be no more than 20 characters. Anything extra is chopped off.

Reply
James Niblick - November 9, 2015

Veena,
I’m trying to do an extended import with no success on several of the fields. email,firstname, and lastname are successful but that’s it. I’m using your format example (see below) Has it changed order? I’m keeping commas for blank field spaces.

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

Reply
Veena Prashanth - November 9, 2015

Hi James,

It looks fine.

Please open a support ticket with all the details (including logs from dap system->logs). We will take a look.

Thanks,
Veena

Reply

Leave a Reply: