I want to buy a license for a bunch of my client websites, however, I need a particular problem to be resolved. And I'm wondering whether this plugin will help.
Tell me please if this path is possible using wpdt plugin:
- Create a table using txt file link (in this case file on github github) - Table is created and data is stored in some kind of internal database. I don't want to make an API call for this file in github each time the user views the table - Table is customised - Once every 24 hour (at a specified time by me) the table is automatically updated with new/changed records from the mentioned txt file (from github). It will be also ok for the table to be rebuilt each time if the previous customisations were to be untouched.
Also, the table will have 500-600 records per table so it needs to be kinda reliable and not slow
To store a table in the database, you'd need to either import an existing data source (in which case the data source is read, a manual table is created, and stored in the database, but it is no longer linked to the source file, so you wouldn't be able to update it in any other way other than manually edit it), create a Manual table, or use a database table using the MySQL query method.
If you can find a way to create a database table, that would be updated from GitHub, I guess this would be the solution for you, although I never did this. The link between GitHub and your database would have to be custom-developed and while doing that, you'd define the logic (when it will be updated, from where will it be imported, and so on) and create a wpDataTable linked to this database table.
Customization of the table is somewhat limited, depending on what you want to do, but for now, you can change colors, font, modify borders, etc.
500 - 600 is rather small, as wpDataTables can work with tables that contain millions of rows (this one contains around 2.500.000 rows, for example), as long as they are server-side tables (stored in the database).
If you create a table linked to the external JSON file, every time you'd load the table, it would fetch the data from that file, and it would automatically be updated.
No way (and maybe no reason) to update it every day or so. If the file is accessible, the table will refresh every time it's loaded.
Hiho :)
I want to buy a license for a bunch of my client websites, however, I need a particular problem to be resolved. And I'm wondering whether this plugin will help.
Tell me please if this path is possible using wpdt plugin:
- Create a table using txt file link (in this case file on github github)
- Table is created and data is stored in some kind of internal database. I don't want to make an API call for this file in github each time the user views the table
- Table is customised
- Once every 24 hour (at a specified time by me) the table is automatically updated with new/changed records from the mentioned txt file (from github). It will be also ok for the table to be rebuilt each time if the previous customisations were to be untouched.
Also, the table will have 500-600 records per table so it needs to be kinda reliable and not slow
Hello Testing
Thank you for your interest in our plugin.
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
Tables in wpDataTables can only be created using Excel, CSV, JSON, Serialized PHP Array, Google Sheets, and XML as external sources. Other 3 types of tables are MySQL query-based tables, Manual tables, and Simple Tables.
So, you can't create a table using a txt file.
To store a table in the database, you'd need to either import an existing data source (in which case the data source is read, a manual table is created, and stored in the database, but it is no longer linked to the source file, so you wouldn't be able to update it in any other way other than manually edit it), create a Manual table, or use a database table using the MySQL query method.
If you can find a way to create a database table, that would be updated from GitHub, I guess this would be the solution for you, although I never did this. The link between GitHub and your database would have to be custom-developed and while doing that, you'd define the logic (when it will be updated, from where will it be imported, and so on) and create a wpDataTable linked to this database table.
Customization of the table is somewhat limited, depending on what you want to do, but for now, you can change colors, font, modify borders, etc.
500 - 600 is rather small, as wpDataTables can work with tables that contain millions of rows (this one contains around 2.500.000 rows, for example), as long as they are server-side tables (stored in the database).
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 for the answer Aleksandar :)
Ok, so as I understand even if I had an external JSON file on Github, I couldn't tell wpDataTables to update itself only once every day or so?
That's correct.
If you create a table linked to the external JSON file, every time you'd load the table, it would fetch the data from that file, and it would automatically be updated.
No way (and maybe no reason) to update it every day or so. If the file is accessible, the table will refresh every time it's loaded.
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
Ok, that's fair enough. Thank you Aleksandar for the help! :)
You're most welcome.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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