Firstly thank you for a great plugin, I spent a long time reading through the documentation and watching the videos and l look forward to releasing the features powered by your plugin.
A few questions for you at this stage...
1) I understand we can filter the table by using parameters in the URL and watching the videos etc, it does not seem to cover a number range and how that might work. Can you help me understand how to apply number ranges in a URL please?
2) Ideally, our users would save their own filters that are specific to them and call them when they want to via buttons/links. I understand users can save a URL which effectively does the same thing but I wondered if there was a more sophisticated way of saving filters on a per user basis.
3) I want to use the plugin to give front end access to two or three large data sets that are updated twice a week. Everything is done on spreadsheets at the moment but the files are large, many columns and many rows. My first thought was to create a table by importing data from data source which worked fine however I couldn't see how I might update that data (twice a week) once it was created. How best to deal with my scenario?
4) Just out of interest, can anyone or has anyone built a URL generator for the filters?
2. Unfortunately no. You can have copies of one table for every customer, but I don't think that's usable. You could add pre-defined filtering values that would be different for every user.
3. If you have large tables, linking to existing data sources wouldn't be a good decision. It will work fine up to 2.000 - 3.000 rows, but anything after that will cause the table to slow down, and eventually break. What you can do, though, is have the table imported in the database, and use SQL Queries to display them. After a couple of weeks, you would need to import the new data in that table in the database, so it's manual work again, but as soon as you update the table in the database, wpDataTable will also be updated.
4. Not that I know of. If they did, they never noticed us.
Just a question regarding updating tables via SQL. If I understand the plugin correctly, it imports and creates a SQL table from a spreadsheet however I cannot update that table via the plugin, I will need to append/update the newly created database myself? Is that correct? If that is correct, your plugin makes it easy to convert a spreadsheet into SQL and without that part of the equation, updating data via a spreadsheet is sometimes problematic.
Regarding the URL generator, personally I feel this would be of great benefit to your users and should be relatively straight forward feature to "Generate Deep link" based on the variables in the current filter. I'm thinking I will have to build something in Gravitar forms build around the filters we have available in hope I can stick the fields together to create a URL.
If you choose to import Excel, CSV or Google Spreadsheet file, the plugin creates a manual table from the provided data, and that is saved in the database as wp_wpdatatable_#, where # is an integer auto-increment table ID for the database.
That table is editable both in the database, and in the plugin, but the source file used for import will not see any of those changes since it's data has only been used to create a table, and that's it. You cannot upload a new file to an existing table, and have it updated, but you can access that table from the database, and import the new rows into it. The structure of the table has to be identical, though (same column count, format, etc).
Thank you for your suggestion about the URL generator. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.
Hi Support, new customer here.
Firstly thank you for a great plugin, I spent a long time reading through the documentation and watching the videos and l look forward to releasing the features powered by your plugin.
A few questions for you at this stage...
1) I understand we can filter the table by using parameters in the URL and watching the videos etc, it does not seem to cover a number range and how that might work. Can you help me understand how to apply number ranges in a URL please?
2) Ideally, our users would save their own filters that are specific to them and call them when they want to via buttons/links. I understand users can save a URL which effectively does the same thing but I wondered if there was a more sophisticated way of saving filters on a per user basis.
3) I want to use the plugin to give front end access to two or three large data sets that are updated twice a week. Everything is done on spreadsheets at the moment but the files are large, many columns and many rows. My first thought was to create a table by importing data from data source which worked fine however I couldn't see how I might update that data (twice a week) once it was created. How best to deal with my scenario?
4) Just out of interest, can anyone or has anyone built a URL generator for the filters?
Thank you for your support
Hello Ryan.
Thank you for your purchase, and for your kind words.
1. You can filter any "range" type filters with the help of pipe symbol " | ". For example, number range might work with this URL:
http://localhost/wpdt-2.6.1/index.php/erp-subscription/?wdt_column_filter[2]=3|6
2. Unfortunately no. You can have copies of one table for every customer, but I don't think that's usable. You could add pre-defined filtering values that would be different for every user.
3. If you have large tables, linking to existing data sources wouldn't be a good decision. It will work fine up to 2.000 - 3.000 rows, but anything after that will cause the table to slow down, and eventually break. What you can do, though, is have the table imported in the database, and use SQL Queries to display them. After a couple of weeks, you would need to import the new data in that table in the database, so it's manual work again, but as soon as you update the table in the database, wpDataTable will also be updated.
4. Not that I know of. If they did, they never noticed us.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you Aleksandar for your response.
Just a question regarding updating tables via SQL. If I understand the plugin correctly, it imports and creates a SQL table from a spreadsheet however I cannot update that table via the plugin, I will need to append/update the newly created database myself? Is that correct? If that is correct, your plugin makes it easy to convert a spreadsheet into SQL and without that part of the equation, updating data via a spreadsheet is sometimes problematic.
Regarding the URL generator, personally I feel this would be of great benefit to your users and should be relatively straight forward feature to "Generate Deep link" based on the variables in the current filter. I'm thinking I will have to build something in Gravitar forms build around the filters we have available in hope I can stick the fields together to create a URL.
Thank you again for your time,
Ryan
Hello Ryan.
You're welcome.
If you choose to import Excel, CSV or Google Spreadsheet file, the plugin creates a manual table from the provided data, and that is saved in the database as wp_wpdatatable_#, where # is an integer auto-increment table ID for the database.
That table is editable both in the database, and in the plugin, but the source file used for import will not see any of those changes since it's data has only been used to create a table, and that's it. You cannot upload a new file to an existing table, and have it updated, but you can access that table from the database, and import the new rows into it. The structure of the table has to be identical, though (same column count, format, etc).
Thank you for your suggestion about the URL generator. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables