Hi cooker,

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.

-

Can you please send me your data source and we will check if the issue is perhaps coming from the file itself?

You can send me an Excel file with your data set, either wrap it inside a zipped file or upload to weTransfer and send me a download link.

If it has any sensitive data, just ensure to mark the reply as PRIVATE, then only we can see it.

And can you confirm, when you are creating a Table from this data set, I presume you are choosing "Create a data table linked to an existing data source"?

Can you please tell me how many rows does the source Sheet have?

For example, if it has more than around 5 to 6 thousand rows - you might be reaching the current PHP limits of the Hosting Server ( such as PHP timeOut limit).

When you try to link a Table from a source file like a Google Sheet/CSV or Excel;

during this process, the plugin needs to read the entire data set coming from the spreadsheet for the initial table creation.

For this, it takes a certain time interval ( depending on how large the data set is).

So, what you can try is to increase the max_execution_time and max_input_time ( or in other words, to increase the timeout limit in php.ini file),

This way, it should prevent the table creation wizard from breaking until the table is generated.

-

When the table successfully generates on the back-end, if you wish to have improved performance, you can try enabling our cache and auto-load cache , in the table settings, 

but the plugin needs to have enough time for the server to process everything/ to read the full data set of the spreadsheet and table.

-

If you want to check what is the current configuration, you can do this from our Plugin's Dashboard, in System Info Tab.

And check the PHP Memory Limit.

 If it is only 128 MB, we recommend increasing it to at least 256 or 512 MB which should be enough for most websites ( depending how many other Plugins and data you plan to have on the site, etc).

Let me know if that helps.

Or, if your file goes over 6 thousand rows, then the best choise is to switch to importing this data to an editable/SQL based Table.

 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. 

To modify this table, 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 import a new/edited CSV to update the table, as well, in the following ways :

• Update manual tables: Replace data within an existing table.
• Update manual tables: Add data to an existing table.
•  Update manual tables: Replace the entire table with new data.

Let me know if that helps.