I have a multiple external CSV datasets endpoints that are updated daily.
Can your plugin pull data form external CSV URLs, organise, create charts and update charts as soon as data is updated in the endpoint? So that I would have to log in, manually update data and edit the charts.
In addition to that, I need to be able to reorganise the data, cause some of the data is unnecessary for the charts.
For now, I am doing all this with google spreadsheet. I'm pulling raw CSV data, reorganise it in a different Sheet and then create charts based on that reorganised data.
Maybe I could just pull data from that reorganised sheet into your plugin and create charts from that?
Will it pull new data automatically? For now, in google spreadsheet, I have a script that refreshes my tables and datasets every hour. So my charts always updated.
Excel and CSV based tables that are linked to an existing data source use the files you upload to ../wp-content/uploads/YEAR/MONTH folder. However, you can use an URL to create tables linked to an existing CSV file if that URL is on the same domain, and you include the full path instead of the actual URL (so /home/www/html.....).
The charts use the data from existing tables, so whatever the tables are displaying, charts will follow if you enable "Follow table filtering".
Please note that the plugin stores the table's settings in wp_wpdatatables_columns table in the database, so these changes are highly not recommended:
Changing column's name
Changing the structure (existing column order)
Deleting columns
Adding new columns
If you make any of the changes, your table will break, and you will need to recreate it again.
Hello,
I have a multiple external CSV datasets endpoints that are updated daily.
Can your plugin pull data form external CSV URLs, organise, create charts and update charts as soon as data is updated in the endpoint? So that I would have to log in, manually update data and edit the charts.
In addition to that, I need to be able to reorganise the data, cause some of the data is unnecessary for the charts.
For now, I am doing all this with google spreadsheet. I'm pulling raw CSV data, reorganise it in a different Sheet and then create charts based on that reorganised data.
Maybe I could just pull data from that reorganised sheet into your plugin and create charts from that?
Will it pull new data automatically? For now, in google spreadsheet, I have a script that refreshes my tables and datasets every hour. So my charts always updated.
Thank you
Alex
Hello Alex
Thank you for your interest in wpDataTables.
Excel and CSV based tables that are linked to an existing data source use the files you upload to ../wp-content/uploads/YEAR/MONTH folder. However, you can use an URL to create tables linked to an existing CSV file if that URL is on the same domain, and you include the full path instead of the actual URL (so /home/www/html.....).
The charts use the data from existing tables, so whatever the tables are displaying, charts will follow if you enable "Follow table filtering".
Please note that the plugin stores the table's settings in wp_wpdatatables_columns table in the database, so these changes are highly not recommended:
If you make any of the changes, your table will break, and you will need to recreate it again.
There is an option to create tables linked to Google Spreadsheets as well, but the same logic applies regarding changes in the tables.
If you need to change the data, and keep the columns as they are - you will have no issues with the table(s).
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