Hi, Romain Durand

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.

1.

In regards to importing the data via  a file,

Data that has more than few thousand rows can  sometimes not be imported in this way directly via the plugin ( depending on the server) - this is a limitation that is coming from WordPress itself combined with server performance.

But there is a solution.

What you can do is, you can import the file, in form of Excel, CSV, or spreadsheet directly in your database via your database management tool, such as PhPMyAdmin.

And then you will be able to create a simple SQL query based table from this database table, by using this query (for example):

SELECT * FROM table_1

2.

In regards to filtering the data,

we are not sure what you need exactly,

but if you simply wish to set a filter on a "region" column, you can do so by using any of our advanced column filters.

Please check out all the available advanced column filters here.

-

You can also use dynamic placeholders, if you wish to use same table shortcode,

but for example,  on page 1 you want table to present region value 1,   

and on page 2 you want only to filter for region value 2;

Then you can place a predefined filter value in column "Region",  as %VAR1%,then in shortcode for page 1, it can be something like :

[ wpdatatable id=1 var1=RegionName1 ]

-

You can also use VAR placeholder directly in an SQL Query for tables.

-

Please check more on how you can use dynamic filtering placeholders here.

-

Let us know how that seems, and if you have any questions.

And, just wanted to point out that we have a Demo Sandbox site, where you can try out the plugin functionalities, on this link

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)

Hi, Durand

Thank you for clarifying the goal.

I have made an example for you, here is how it can be done.

Just as you proposed, here is the easiest way - with a VAR placeholder as prefiltered value for the Region column.

Then you can set different shortcodes for the same table, on different pages.

This is, of course, a very simple table i made - i suppose it will be more complex in your project.

For example, if we set a table like this :

And in the Region column, prefiltered value as VAR1 placeholder

Then, this is the shortcode for a page if we want only Region A

-

But i also made a short video, as an example - please check it out here.

Let me know if that is what you needed.

Thank you

Hi, Durand 

You're welcome, i am happy to help and advise.

I am delighted to hear that you will become our premium user, that is awesome!

Of course, we will be here to support you,  so please don't hesitate to open a new ticket for any new question, or issue you might encounter.

Thank you