Hi Mark,

Sorry to disappoint you, but our Plugin does not have a native integration with any Membership Plugin, and we also don't have any integration with the event plugin (https://wp-events-plugin.com/).

If you wish to see these native integrations in the future :

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

Since we don't have a native integration, pulling this kind of data can only be done through custom SQL Queries in our SQL based tables.

The difficulty level is higher than usual because this kind of data from Plugins like that is usually stored in the database as serialized JSON format,

so a certain level of SQL skill is needed to make a custom Query.

Please be advised that writing custom SQL Queries or debugging custom Queries does not fall under what our support covers.

You can reach out to the support of each of those Plugins and ask if they can help you identify which SQL tables hold the data you need and in which columns - that can make it easier for you to try and make a Query from the Wordpress database.

Other than that, a good way to achieve pulling custom SQL Query data from the database can be to experiment using our WPDB SQL Query Constructor tool.

You can also try the other option “Generate a query to MySQL database” which has a 'wider range' of choosing additional SQL Tables,

it is a more 'generic'  SQL Query Constructor Tool.

You can check more details explained about that second Constructor Helper Tool here.

- Please note:

 this tool is not an ultimate query generator. It simply constructs a suggestion of a query. 

We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. 

Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. 

So, you will often need to play around with the resulting query.

You can check out this official page of WP codex,  for help with writing custom Queries.

Another way you can try is, you can first try to make a Custom SQL Query of selecting the Columns+data you need directly in your Database Management Tool,

such as PHPMyAdmin or any other you choose.

Then if you manage to pull the data you need there,

you can prepare a MySQL view (which will return the data that you need, call it e.g. “ViewName” and then build a wpDataTables based on a simple query like "SELECT * FROM ViewName″.

 If you need help with that, you can see our video, where we show an example of using an SQL View in our plugin.

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions. 

Hi Mark,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

You're welcome, I am happy to help.

1. In regards to trying custom Queries, of course, you can try, just note our Support does not cover debugging custom SQL Queries.

We can only help with some basic Query issues, but this use-case goes above that complexity level.

I hope your programmer manages to write a working custom Query, of course.

You can go through all the advised details, we hope it helps at least to get started in the right direction.

If you get the Query to return the data as needed in the Database - the last resort is to make the SQL VIEW as proposed, then call it in our SQL Table as a simple  'SELECT * FROM ViewName' and it should work.

2. I also think exporting the data to a spreadsheet and then using an AI tool to generate the queries could be an option. Do you have any thoughts on this?

We have not tried anything like that yet, so I honestly can't comment on that subject.

For example, if you were to export the data to a Google Sheet, you can easily link a table with our Plugin as per this Documentation.

If you plan to use any formulas in the google Sheet, use this workaround.

- If the data is on a Spreadsheet, then it is not in your SQL Database anymore, so I am not sure how that could work in terms of generating a Query;

but I heard from some users that they managed to somehow create a function which sends the data from Google Sheets into their SQL Database - then they call a Query in our SQL Query based table and they say that works - but we don't have any experience with that.

You can always, of course, search places like Stack Overflow and other similar Sites where users share their custom solutions and see if you can find a good advice there.

3. You could also use Google Sheets to import the data via our Plugin to make a Manual Table.

This makes a new SQL Table in your database. More details on how this works :

If you import the file, the plugin reads the source file and creates a manual table. 

Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa. 

This table will be editable in our Plugin.

If you need quicker editing, you can either switch to the Excel-like view, 

and then select and copy the range of cells you want to paste from the source file, and paste it in the Excel-like view, 

or you can Update manual tables from source files (CSV, Excel or Google sheet) with three options :

• Replace data within an existing table.
• Or Add data to an existing table.
•  Or  Replace the entire table with new data.

I hope that helps.