Hi. Is there any way to get the HTML from a table / chart to share via email by chance? Or I have an image generation API that I can use HTML and it makes a PDF.
Is there any way to get the HTML for embedding elsewhere?
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
When it comes to our Built-in/ 'out of the box' features/options, we only have these Table Tools Export Options for our Tables.
The table tools functionalities are based on a 3rd party HTML5 library and they are not customizable.
There are some limitations in this library we will emphasize for your awareness:
For tables with server-side processing, only the visible rows will be exported to any format. If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export:
Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed (but the title can – see below).
Conditional formatting is not reflected in any of generated export files.
Other front-end extensions cannot be combined with Table Tools. If you have row grouping enabled for the table, or there are some customizations you did yourself, they won’t be reflected in the generated Excel, CSV or PDF document, nor in the clipboard.
When you export tables with the wpDataTables plugin, please note that you can export values, but not formulas. WpDataTables doesn’t support exporting formulas, so a Formula column will be exported only with values; and any calculations of Average, MIN, MAX, and Total will not be exported at all.
Exporting images and links is not possible at the moment, but you are able to export them as HTML with the new “Include HTML” option. ( You will find this option in the Table Tools settings in the Table's back-end)
You can’t export columns that are hidden – they will not be visible in any exporting or printing tool.
Export numbers with comma as decimal separators have issues in the Excel report. Please use the CSV export button or change column type to string for these columns.
-
If you wish better PDF export options, our advice would be to acquire something like the WP Advanced PDF plugin, which offers a lot more options when creating PDF files from our tables, along with other content on your website.
But, this is to export the data from the table's column/cells in form of a CSV, Excel, "Copy to clipboard" or PDF;
If i understand, you wish to get the entire structure of the Table as HTML, to be able to embed it outside of WordPress?
For that we do not have a built-in way at the moment.
You can suggest it to our developers, though - they will do their best to make a solution in the future.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
If you have coding skills and wish to try to make a custom solution now,
Sorry, you also mentioned exporting the Charts, i only commented about Tables initially.
For exporting Charts,
HighCharts is the only one that currently has the 'out of the box' PDF export, as far as i can see - and these other export options are available for it , such as Export as CSV, Excel, etc:
The only other Chart engine that has some export features is the Apex chart engine, but it does not have PDF :
Every chart engine has its own layout and its settings.
We use free libraries for chart engines, and they are limited as to what we can change from within the plugin's UI.
Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts API, Highcharts API, and Chart.js API.
All necessary resources are available in charts engines API (depends on which one you use). Every engine has a different approach to chart settings. In wpDataChart callbacks, you have to adopt those settings to the wpDataChart object (you can take a look at examples for each engine in our documentation, and also in the Support help center). A huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and Google will search only that website). Also, a lot of examples of charts, chart settings, and customization can be found on jsffidle.net (typing in google for example "line chart highcharts jsffidle")
Please note that using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.
Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts API, Highcharts API, and Chart.js API.
All necessary resources are available in charts engines API (depends on which one you use). Every engine has a different approach to chart settings. In wpDataChart callbacks, you have to adopt those settings to the wpDataChart object (you can take a look at examples for each engine in our documentation, and also in the Support help center). A huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and Google will search only that website). Also, a lot of examples of charts, chart settings, and customization can be found on jsffidle.net (typing in google for example "line chart highcharts jsffidle")
Please note that using hooks or wpDataTable and wpDataChart callbacks requires a certain level of programming skills and included support refers only to advice.
-
You also asked about sending Emails;
If you mean to send an Email with some data directly through our Plugin,
We don't have any built-in solution to achieve this at this time,
but you can suggest it to our developers - they will do their best to make a solution in the future.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
If you have coding skills and wish to try to make a custom solution now,
And here is an example our developers shared before, when a user needed to take an edited data and send it via Email.
To take values after Apply is hit, there's this hook:
wpdatatables_after_frontent_edit_row( $formdata, $rowId, $tableId )
This action is executed after editing action is applied.
$formdata is the array of keys and values for editing.
$rowId is the ID field of the row in MySQL table that was edited.
$tableId is the table identifier from the MySQL plugin table (wp_wpdatatables).
For example:
function sendEmailAfterEdit( $formdata, $rowId, $tableId ){
// create logic for sending emails
}
add_action('wpdatatables_after_frontent_edit_row', 'sendEmailAfterEdit',10,3);
will be triggered in both cases when you edit or adding a new row in the table from front-end.
Please note that data is already saved in database.
-
That is the closest example i could find to the use case.
i hope this helps.
And i just wanted to point out that you can try wpDataTables before purchasing
on our sandbox Demo sites ( you can find links for the main plugin Demo,
as well as add-on Demos, in my signature),
and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Hi. Is there any way to get the HTML from a table / chart to share via email by chance? Or I have an image generation API that I can use HTML and it makes a PDF.
Is there any way to get the HTML for embedding elsewhere?
Thanks!
Hi Gerald,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
When it comes to our Built-in/ 'out of the box' features/options, we only have these Table Tools Export Options for our Tables.
The table tools functionalities are based on a 3rd party HTML5 library and they are not customizable.
There are some limitations in this library we will emphasize for your awareness:
-
If you wish better PDF export options, our advice would be to acquire something like the WP Advanced PDF plugin, which offers a lot more options when creating PDF files from our tables, along with other content on your website.
But, this is to export the data from the table's column/cells in form of a CSV, Excel, "Copy to clipboard" or PDF;
If i understand, you wish to get the entire structure of the Table as HTML, to be able to embed it outside of WordPress?
For that we do not have a built-in way at the moment.
You can suggest it to our developers, though - they will do their best to make a solution in the future.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
If you have coding skills and wish to try to make a custom solution now,
you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.
Please be advised that custom solutions with hooks are not included in our support.
You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.
( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Gerald,
Sorry, you also mentioned exporting the Charts, i only commented about Tables initially.
For exporting Charts,
HighCharts is the only one that currently has the 'out of the box' PDF export, as far as i can see - and these other export options are available for it , such as Export as CSV, Excel, etc:
The only other Chart engine that has some export features is the Apex chart engine, but it does not have PDF :
Every chart engine has its own layout and its settings.
We use free libraries for chart engines, and they are limited as to what we can change from within the plugin's UI.
You can check out all the available chart engines and examples of wpDataCharts documentation here .
If the options you need are not in the chart creation wizard, you can try to find a custom solution using chart callbacks.
You can check our documentation about wpDataCharts callbacks.
You can check our documentation about wpDataCharts callbacks.
-
You also asked about sending Emails;
If you mean to send an Email with some data directly through our Plugin,
We don't have any built-in solution to achieve this at this time,
but you can suggest it to our developers - they will do their best to make a solution in the future.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
If you have coding skills and wish to try to make a custom solution now,
you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.
Please be advised that custom solutions with hooks are not included in our support.
You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.
-
For sending emails, you can use this:
https://www.a2hosting.com/kb/installable-applications/optimization-and-configuration/wordpress2/sending-e-mail-in-wordpress#:~:text=To%20send%20an%20e%2Dmail,authentication%20settings%20you%20defined%20above
And here is an example our developers shared before, when a user needed to take an edited data and send it via Email.
To take values after Apply is hit, there's this hook:
wpdatatables_after_frontent_edit_row( $formdata, $rowId, $tableId ) This action is executed after editing action is applied.
$formdata is the array of keys and values for editing.
$rowId is the ID field of the row in MySQL table that was edited.
$tableId is the table identifier from the MySQL plugin table (wp_wpdatatables).
For example:
function sendEmailAfterEdit( $formdata, $rowId, $tableId ){
// create logic for sending emails } add_action('wpdatatables_after_frontent_edit_row', 'sendEmailAfterEdit',10,3);
will be triggered in both cases when you edit or adding a new row in the table from front-end.
Please note that data is already saved in database.
-
That is the closest example i could find to the use case.
i hope this helps.
And i just wanted to point out that you can try wpDataTables before purchasing
on our sandbox Demo sites ( you can find links for the main plugin Demo,
as well as add-on Demos, in my signature),
and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Let me know if you have any additional questions.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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