Hi, Asad 

Thanks for reaching out to us

-

1.  Regarding the amount of rows for import from files, if you have a very large data set :

Data that has more than a few thousand rows can  not be imported in this way directly via the plugin - 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.

Here is an example how you can do it.

When you're importing a CSV file in your database, you need to navigate to the WordPress database, and click on "Import":

Then click on "Choose file" and select your CSV file:

The structure of the file needs to be set so the first row of the file contains column headers. For example, if the table you're creating is supposed to look like this:

The structure of the CSV file should contain "COLUMN1, COLUMN2, COLUMN3" in the first row, like this:

COLUMN1,COLUMN2,COLUMN3
Google,Test,123
Yahoo,Test2,456
Facebook,Test3,789

Then, when you select that file scroll down, and check the "The first line of the file contains the table column names" check-box, so the first line is used for headers of the table; and then click on GO:

You should see a screen similar to this:

In my case, it's "TABLE 114", and you can click on it to open that database table:

To avoid having any issues when using this table in wpDataTable, my advice is to change its name (because it contains a space). So, go to the "Operations" tab:

And under "Table Options" rename that table to what you want it to be. 

Just make sure not to include dots ( . ) or spaces (don't use any special characters). You can rename the table to be "table_1" for example. After you rename it, click on GO in the right corner of "Table options" section:

And that's it. You're now able to create an SQL query based table using this query (for example):

SELECT * FROM table_1

-

2.  Regarding hiding the table and setting up filters that the user has to select, 

and then load only the filtered data that the user selected,

this can only be achieved with our premium add-on Powerful Filters.

It has special features such as "Cascade Filtering" and "Hide Table before filtering."

Please check more details here.

Before purchase, you can test all plugin and Add-on features on our sandbox site.

-

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, Asad 

You're welcome, i am happy to help.

That is correct, if you log in directly in your database management tool,  ( such as PHPMyAdmin),

from there you should be able to import very large data sets - which you would not be able to import through WordPress, when the file has more than several thousand rows.

-

Then when the table is made in the database from the import,

you can simply make an SQL table in our plugin such as :

SELECT * FROM database_table_name

Let me know if you have any questions. 

-

You can also take a look here at our example that we made from a very large database table via SQL Query,

this table has 2.560.000 rows.

Hi, Asad 

Sorry for the waiting time, we had a National Holiday in the meantime which slowed down our work.

-

I am delighted to hear that this has been resolved. Thank you for letting us know. Anything else that we could assist with, please don't hesitate to create new tickets.

Have a great day!