Is there a money back guarantee if this does not work with our setup?
is there a UI in the backend of the premium that allows us to upload data into the DB for querying with lazy loading? Or do we have to do a manual action via phpmyadmin?
We do have 15-day money back guarantee. So if you purchase our plugin, and it doesn't fit your needs you can request and receive a refund in that period of time.
Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
Our plugin performs well on a large number of websites rendering a large amount of data with no issues. We don't have any particular UI, could you please explain this a bit further?
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
That is good to know about the money-back guarantee, the plugin pricing is a little expensive so knowing that if it isn't a good fit for our application we have a fallback provides me confidence in purchasing any product.
For the backend UI where the user could upload a CSV, Excel, ect into the application and it will insert it into the corresponding database schema and tables? Or do I need to manage the insertion/update of data through PHPMyAdmin manually? I ask because we are looking for the most complete turn-key solution possible without having to open the DB to manage thousands of rows of data. There can potentially be 10,000+ rows and the data is subject to change.
Inside of the Create a data table by importing data from a data source option when creating a new WpDataTable, it says the data will be imported in the database. This is the option we are looking for with a quick import of an excel file.
My question I guess would be:
Do these Manual tables have the ability to work with your Lazy-Loading functionality?
There can potentially be 10,000+ rows of data (3 columns of text), will the Manual option be able to handle this?
Is there a way to reupload the datasource from a manual table? Or do you need to create a new table each time you want to update data
This depends on the source file you are using. For example an Excel file type - they generally work slower than CSV-files, or even Google Spreadsheets; this format will work only up to a certain limit (no exact limit, but 3000-5000 cells is a good example).
When your data set is larger than a couple of thousand rows, it can’t effectively be loaded in the page. It first reads the data from the source, and then prints out the complete table data on your page; so, as the row count grows, it makes both the page generation time on server side and the page load and initialization time on client side, slower and slower. If your host has a certain memory or timeout limit defined for PHP scripts, it can ‘break’ the page, because the script would try to allocate more memory than it’s allowed.
So if your table is large, it is much better to port it to a different format, or – even better – to MySQL table (you can use “Create a table by importing data from data source” to import your Excel file to MySQL).
If you upload the file the link between the source file and the table is broken and all changes made either in the source file or in wpDataTables will not be reflected on the other end.
If you created a table linked to the file, you must overwrite the file located in ..wp-content/uploads/YEAR/MONTH/ folder, and the table will be updated when you do that, but you need to keep in mind that you can't change the structure of the source file, so renaming, deleting, adding or reordering columns in the source file will cause the table to break.
To update the table by importing the source file again, you'd need to remove the headers and existing rows, and include only new rows. Then, in the database, find the wp_wpdatatable_# that was created, and then import that new source file in there.
Another option would be to view the table in Excel-like mode in the back-end, and then bulk select; copy and paste the data from Excel. There's no way of updating the existing table by just updating the original source file.
Is there a money back guarantee if this does not work with our setup?
is there a UI in the backend of the premium that allows us to upload data into the DB for querying with lazy loading? Or do we have to do a manual action via phpmyadmin?
Hi Daniel
Thank you for reaching out to us.
We do have 15-day money back guarantee. So if you purchase our plugin, and it doesn't fit your needs you can request and receive a refund in that period of time.
Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
Our plugin performs well on a large number of websites rendering a large amount of data with no issues. We don't have any particular UI, could you please explain this a bit further?
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
Thank you for the response.
That is good to know about the money-back guarantee, the plugin pricing is a little expensive so knowing that if it isn't a good fit for our application we have a fallback provides me confidence in purchasing any product.
For the backend UI where the user could upload a CSV, Excel, ect into the application and it will insert it into the corresponding database schema and tables? Or do I need to manage the insertion/update of data through PHPMyAdmin manually? I ask because we are looking for the most complete turn-key solution possible without having to open the DB to manage thousands of rows of data. There can potentially be 10,000+ rows and the data is subject to change.
Inside of the Create a data table by importing data from a data source option when creating a new WpDataTable, it says the data will be imported in the database. This is the option we are looking for with a quick import of an excel file.
My question I guess would be:
Do these Manual tables have the ability to work with your Lazy-Loading functionality?
There can potentially be 10,000+ rows of data (3 columns of text), will the Manual option be able to handle this?
Is there a way to reupload the datasource from a manual table? Or do you need to create a new table each time you want to update data
Hi Daniel
This depends on the source file you are using. For example an Excel file type - they generally work slower than CSV-files, or even Google Spreadsheets; this format will work only up to a certain limit (no exact limit, but 3000-5000 cells is a good example).
When your data set is larger than a couple of thousand rows, it can’t effectively be loaded in the page. It first reads the data from the source, and then prints out the complete table data on your page; so, as the row count grows, it makes both the page generation time on server side and the page load and initialization time on client side, slower and slower. If your host has a certain memory or timeout limit defined for PHP scripts, it can ‘break’ the page, because the script would try to allocate more memory than it’s allowed.
So if your table is large, it is much better to port it to a different format, or – even better – to MySQL table (you can use “Create a table by importing data from data source” to import your Excel file to MySQL).
If you upload the file the link between the source file and the table is broken and all changes made either in the source file or in wpDataTables will not be reflected on the other end.
If you created a table linked to the file, you must overwrite the file located in ..wp-content/uploads/YEAR/MONTH/ folder, and the table will be updated when you do that, but you need to keep in mind that you can't change the structure of the source file, so renaming, deleting, adding or reordering columns in the source file will cause the table to break.
To update the table by importing the source file again, you'd need to remove the headers and existing rows, and include only new rows. Then, in the database, find the wp_wpdatatable_# that was created, and then import that new source file in there.
Another option would be to view the table in Excel-like mode in the back-end, and then bulk select; copy and paste the data from Excel. There's no way of updating the existing table by just updating the original source file.