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.
2 – Now, you need to open all your users clicking on the Manage from Members tab.
3 – Then click on the Export Members button.
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.
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
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.
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.
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.
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.
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 column | WordPress default column |
|---|---|
| First Name | first_name |
| Last Name | last_name |
| User Name | user_login |
| user_email |
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.
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
3 – then click on the User/customer Import tab
4 – Now, select your file and click on the Upload file and import button.
5 – The process of importing will started and you will see the progress.
6 – When importing is finished you're done and you have your DAP users imported 🙂
