We are a scientific consultancy and are working on creating a database of charts for elements of the periodic table scientists can use to compare data from different x-rays.
We have tried the Visualiser lite plugin from ThemeIsle and have made an example chart on the site. There are quite a few features we would like the charts to have (which the Visualiser plugin team can't tell us if they would be possible), and so we would like to find out if wpDataTables will be suitable to use for creating these instead.
Features we would like might include:
User ability to upload chart data into a cloud based database (Google Drive or Microsoft OneDrive) - Upload multiple formats not just CSV? User would need to be able to define min/max axis values of data? User front-end action ability to use tick boxes to overlay data from their own charts onto charts we have previously uploaded? User front-end action ability to live edit their data to do comparisons with our charts? User front-end action ability to save revisions of data and download data/chart revisions? We would need to be able to process data via python scripts to develop database further down the line.
Are these features possible with wpDataTables or can they be developed? It would be great if we could speak with someone about this further.
Most of these features would require some customization, which is not included in the support of the plugin.
User ability to upload chart data into a cloud based database (Google Drive or Microsoft OneDrive) - Upload multiple formats not just CSV?
To generate charts with our plugin, you first need to create a table containing data you will use in your charts. There's a possibility to add a separate database connection, but I don't believe clouds are supported yet. To create a table that will be linked to an existing data source, you have the following options:
Only SQL query based tables from this list can be editable.
The source files used to generate the table will be stored in ../wp-content/uploads/YEAR/MONTH and that's the file that will be used for table generation. Also, the URLs provided to generate the table need to be stored on the same domain as WordPress.
User would need to be able to define min/max axis values of data?
These settings are only available during chart creation, and it's not accessible via front-end. Maybe it could be done, but it would require some additional coding to implement this feature.
User front-end action ability to use tick boxes to overlay data from their own charts onto charts we have previously uploaded?
Also, not an option out-of-the box, but would have to be created with a custom javascript that'd generate the check-boxes. But even with this, I don't believe you'd be able to overlay data from another chart onto an existing chart. We have never tried doing this, so I cannot say that it is utterly impossible with 100% certainty.
User front-end action ability to live edit their data to do comparisons with our charts?
You would need to add the table on the same page as well, and enable "Follow table filtering" when creating the chart. Then, when users enter new data in the table, it will automatically be mapped on the chart.
User front-end action ability to save revisions of data and download data/chart revisions?
Only Highcharts engine has the ability to print out a copy of the chart. Again, to make modifications on a chart, you need to modify the table the chart was created from.
All in all, almost all features would have to be implemented as a custom solution, and I cannot guarantee that they can all be utilized. While we do offer paid customization services, I'm sorry to say that our developers are very busy with priority tasks, bugs and fixes and do not have the time for any customizations.
We are a scientific consultancy and are working on creating a database of charts for elements of the periodic table scientists can use to compare data from different x-rays.
We have tried the Visualiser lite plugin from ThemeIsle and have made an example chart on the site. There are quite a few features we would like the charts to have (which the Visualiser plugin team can't tell us if they would be possible), and so we would like to find out if wpDataTables will be suitable to use for creating these instead.
Features we would like might include:
User ability to upload chart data into a cloud based database (Google Drive or Microsoft OneDrive) - Upload multiple formats not just CSV?
User would need to be able to define min/max axis values of data?
User front-end action ability to use tick boxes to overlay data from their own charts onto charts we have previously uploaded?
User front-end action ability to live edit their data to do comparisons with our charts?
User front-end action ability to save revisions of data and download data/chart revisions?
We would need to be able to process data via python scripts to develop database further down the line.
Are these features possible with wpDataTables or can they be developed? It would be great if we could speak with someone about this further.
Many thanks
Hello Mike.
Thank you for your interest in our plugin.
Most of these features would require some customization, which is not included in the support of the plugin.
User ability to upload chart data into a cloud based database (Google Drive or Microsoft OneDrive) - Upload multiple formats not just CSV?
To generate charts with our plugin, you first need to create a table containing data you will use in your charts. There's a possibility to add a separate database connection, but I don't believe clouds are supported yet. To create a table that will be linked to an existing data source, you have the following options:
Only SQL query based tables from this list can be editable.
The source files used to generate the table will be stored in ../wp-content/uploads/YEAR/MONTH and that's the file that will be used for table generation. Also, the URLs provided to generate the table need to be stored on the same domain as WordPress.
User would need to be able to define min/max axis values of data?
These settings are only available during chart creation, and it's not accessible via front-end. Maybe it could be done, but it would require some additional coding to implement this feature.
User front-end action ability to use tick boxes to overlay data from their own charts onto charts we have previously uploaded?
Also, not an option out-of-the box, but would have to be created with a custom javascript that'd generate the check-boxes. But even with this, I don't believe you'd be able to overlay data from another chart onto an existing chart. We have never tried doing this, so I cannot say that it is utterly impossible with 100% certainty.
User front-end action ability to live edit their data to do comparisons with our charts?
You would need to add the table on the same page as well, and enable "Follow table filtering" when creating the chart. Then, when users enter new data in the table, it will automatically be mapped on the chart.
User front-end action ability to save revisions of data and download data/chart revisions?
Only Highcharts engine has the ability to print out a copy of the chart. Again, to make modifications on a chart, you need to modify the table the chart was created from.
All in all, almost all features would have to be implemented as a custom solution, and I cannot guarantee that they can all be utilized. While we do offer paid customization services, I'm sorry to say that our developers are very busy with priority tasks, bugs and fixes and do not have the time for any customizations.
Best regards.
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