i am retrieving data using SQL. is there any hooks for customize export data? e.g. i have 'detail' column in table so it is exported as a 'detail' text. i know by clicking 'Include HTML' it will export anchor tag. but i only want to export only href attribute (link) into excel or csv. is it possible?
or also something can i do, that column is not visible in front end datatable, but i want to export it in excel/csv/pdf.
please guide me how to do. is that possible or not with your plugin?
The table tools functionalities are based on a 3rd party HTML5 library.
Unfortunately, the library allows very little “fine-tuning” of the generated files.
Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and some other properties cannot be changed.
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.
Exporting images is not possible at the moment, but as you know,
we are able to export them as HTML with the new “Include HTML” option.
-
The "include HTML" option is not customizable with any built-in capabilities.
Our developers did not find the time yet to try custom workarounds on something like this,
so we don't have any working example of any hook or other method at the moment;
but you can make a suggestion, and they will try to find 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 find a solution now,
I can completely understand that this option is important for you.
We will do our best to work on it as soon as possible, I just can't promise an exact ETA, because our developers have a lot of tasks,
they are doing their best to go through all the tasks and bug fixes as quick as possible,
and there are unpredictable factors that can postpone development.
Thank you for the feedback and for this improvement suggestion.
Could you just refer us to what you meant when you wrote that it is already included with datatables library? Do you have a reference link, I can pass it to our developers ( they probably already know it, but I just like to gather all the details).
hello,
i am retrieving data using SQL. is there any hooks for customize export data? e.g. i have 'detail' column in table so it is exported as a 'detail' text. i know by clicking 'Include HTML' it will export anchor tag. but i only want to export only href attribute (link) into excel or csv. is it possible?
or also something can i do, that column is not visible in front end datatable, but i want to export it in excel/csv/pdf.
please guide me how to do. is that possible or not with your plugin?
Hi, badal
Thanks for reaching out to us
-
The table tools functionalities are based on a 3rd party HTML5 library.
Unfortunately, the library allows very little “fine-tuning” of the generated files.
we are able to export them as HTML with the new “Include HTML” option.
-
The "include HTML" option is not customizable with any built-in capabilities.
Our developers did not find the time yet to try custom workarounds on something like this,
so we don't have any working example of any hook or other method at the moment;
but you can make a suggestion, and they will try to find 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 find a solution now,
you can check out our available hooks for Developers on this documentation and see if you can find any hook that might do the trick.
Please be advised that custom solutions with hooks are not included in our support.
( We do like to give examples for certain solutions, but for this use-case we unfortunately don't have anything yet)
You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.
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
but this is the important features, as it is already provided with datatables library.
Hi, badal
I can completely understand that this option is important for you.
We will do our best to work on it as soon as possible, I just can't promise an exact ETA, because our developers have a lot of tasks,
they are doing their best to go through all the tasks and bug fixes as quick as possible,
and there are unpredictable factors that can postpone development.
Thank you for the feedback and for this improvement suggestion.
Could you just refer us to what you meant when you wrote that it is already included with datatables library? Do you have a reference link, I can pass it to our developers ( they probably already know it, but I just like to gather all the details).
Thank you
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