Introduction

In this tutorial, I’m going to show you how to import DAP (Digital Acess Pass) users as WordPress default users.

If you want to use different membership plugin that uses wordpress users database, or if you just use some other kind of plugin which requires wordpress users database you need to export your DAP users and import them as a wordpress default users because DAP by default use different table in the database for users.

 

What You Will Need

1. Digital Access Pass (DAP) – WordPress membership plugin installed on your WordPress website

2. CSV to XLS convert, or Zamzar converter

*Note: (Zamzar has limit of 2 download per day)

3. WordPress plugin for importing users: Import Export WordPress Users

Export All Users From DAP

1 – To export all users from DAP, go to Digital Access Pass in your administration.

2020 04 27 2133 - How To Import DAP Members Into WordPress

2 – Now, you need to open all your users clicking on the Manage from Members tab.

2020 04 27 2134 - How To Import DAP Members Into WordPress

 

3 – Then click on the Export Members button.

2020 04 27 2137 1024x268 - How To Import DAP Members Into WordPress

 

4 – After clicking on the export button, below you will see new options and filters for exporting.

In our case, we want to export all users and we will just click on the button Export to CSV.
2020 04 27 2142 1024x161 - How To Import DAP Members Into WordPress

NOTE: If you want to export only one group of users, by status, products, etc., you are free to use any of these filters in the screenshot above.

5 – Clicking on the button Export To CSV below you will see the success message and link of the download
2020 04 27 2146 1024x101 - How To Import DAP Members Into WordPress

 

6 – Click on the link as we describe in the image above.

You will be redirected to the new page with all processes/jobs that need to be finished.

To see the new job please select View New/Unprocessed Jobs from the View Jobs option and click on the Search button.

2020 04 27 2152 1024x79 - How To Import DAP Members Into WordPress

 

In this way, you will see all the current unfinished processes.

7 – By default, the DAP plugin runs a CRON job every hour and maybe you will need to wait until your download link is ready.

If you want to run the CRON job manually you can do so by visiting:

https://yoursite.com/dap/dap-cron.php

*Replace “yoursite” with your actual website!

Your CRON status you can find on the right side of the current page.

8 – When your link is ready to download you will be able to download your CSV exported list.

A download link can be found in the Payload column.

2020 04 27 2214 1024x39 - How To Import DAP Members Into WordPress

 

Preparing The DAP CSV so that it is recognizable by WordPress

Because the DAP plugin doesn’t use default the WordPress user database it also spits out its CSV in a unique format.

So we need to prepare and change the DAP CSV that we export so that it’s in a format that WordPress recognizes.

You can find the standard CSV format for importing wordpress here.

Converting DAP CSV to xls Format

As mentioned earlier, we will use an online website called Zamzar converter for this step.

But you can do this process through excel, Google Sheets, Airtable, etc.

1 – Go to zamzar website add your DAP CSV, in the second column select xls and then click on the convert.

2020 04 28 0650 1024x516 - How To Import DAP Members Into WordPress

 

2 – You will see the process of uploading and converting and when converting is finished you will be redirected to the new page where you can download your file.

2020 04 28 0658 - How To Import DAP Members Into WordPress

3 – Now, open default wordpress format for users import that you downloaded in this section and open DAP xls file.

4 – When we have both opened files, you can start to copy columns from DAP file to wordpress-format-for-users-import.xls file.

5 – Required fields are user_email and first_name, other fields are not required.

Also, you may want to set the roles column to the subscriber or whatever you want to set for your users.

6 – Now you can copy fields from DAP to wordpress-format-for-users-import.xls on this way:

DAP columnWordPress default column
First Namefirst_name
Last Namelast_name
User Nameuser_login
Emailuser_email

copy from dap to wp2 - How To Import DAP Members Into WordPress

IMPORTANT: Don’t worry if some users are repeated, the plugin that we will use for importing in the last step will recognize that and ignore it.

7 – When you have copied all fields you can save your wordpress-format-for-users-import.xls file and go to zamzar online converter.

8 – Now we will convert file from XLS to CSV.

The direct link is here: zamzar xls to csv.

9 – Click on the link above, select your wordpress-format-for-users-import.xls file, second column has to be csv and then click on the convert.

After converting is finished you will be redirected to the new page where you can download your CSV file.

2020 04 28 0746 - How To Import DAP Members Into WordPress

Importing DAP Users Into WordPress

1 – In this step we will need plugin Import Export WordPress Users, so please install it on your wordpress website.

2 – After you installed it go to Users -> User Import Export

2020 04 28 0755 - How To Import DAP Members Into WordPress

 

3 – then click on the User/customer Import tab
2020 04 28 0757 - How To Import DAP Members Into WordPress

 

4 – Now, select your file and click on the Upload file and import button.
2020 04 28 0758 - How To Import DAP Members Into WordPress

 

5 – The process of importing will started and you will see the progress.
2020 04 28 0801 1024x173 - How To Import DAP Members Into WordPress

 

6 – When importing is finished you’re done and you have your DAP users imported 🙂

Share This