I create a mysql query for my report. In the last field, i set active the flag "Show a total for this column in footer". When I click to export pdf, csv, clipboard, excel data, the total isn't showed. Do you have any solutions, please?
Sorry to disappoint you but unfortunately Sum is added dynamically and it can be displayed just on page It can not be rendered and visible when you click on the buttons ( PDF, CSV, Excel...)
Unfortunately no. You can find all actions and filters in our documentation but there is no hook to add sum in export data tool. This feature is not easy as it looks and i will forward your request to our lead developer and maybe in future we will implement it.
Excel. I try to open the file with Microsoft Excel, Open Office and Libre Office but I have the same problem: float number is loaded as string.
If i open the exported excel file with Notepad++ (or similar note) i see that the float fields are written as inlineStr (but integer fields are written as n=numeric)
We are using datatables library for front end and I think that the issue is in thousand separator. Can you please try to remove this line of code and try after that.
Hello!
I create a mysql query for my report. In the last field, i set active the flag "Show a total for this column in footer". When I click to export pdf, csv, clipboard, excel data, the total isn't showed. Do you have any solutions, please?
Hi Manuel,
Thank you for your purchase.
Can you send me the link so I can take a look.
Thank you.
Kind Regards,
Miloš Jovanović
[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
Hi Bodgan, thanks to the reply.
My page is in private area, but the same issue there is in the official documentation:
http://wpdatatables.com/documentation/table-features/sum-totals-row/
If you click to Excel (for example) the total is not showed.
Any news? :(
Hi Manuel,
We are currently investigating your issue I will let you know as soon as we found the solution.
Thank you for understanding.
Kind Regards,
Miloš Jovanović
[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
Thanks a lot, Bogdan!
Hi Manuel,
Sorry to disappoint you but unfortunately Sum is added dynamically and it can be displayed just on page
It can not be rendered and visible when you click on the buttons ( PDF, CSV, Excel...)
Kind Regards,
Miloš Jovanović
[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
Doesn't exist an action or filter, to add sum in export data tool?
Hi Manuel
Unfortunately no.
You can find all actions and filters in our documentation but there is no hook to add sum in export data tool.
This feature is not easy as it looks and i will forward your request to our lead developer and maybe in future we will implement it.
Kind Regards,
Miloš Jovanović
[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
Bogdan this is other question about Export Tool.
The float values are exported like string and not like decimal number
http://wpdatatables.com/documentation/column-features/float-columns/
How to fix it?
Add information: the float values are exported like inlineStr, but integer values like n (numeric).
Hi Manuel,
Can you please tell me precisely which tool do you use to read the exported data?
Thank you.
Kind Regards,
Miloš Jovanović
[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
Excel. I try to open the file with Microsoft Excel, Open Office and Libre Office but I have the same problem: float number is loaded as string.
If i open the exported excel file with Notepad++ (or similar note) i see that the float fields are written as inlineStr (but integer fields are written as n=numeric)
Hi Manuel,
In file ../wpdatatables/source/class.float.wpdatacolumn.php around line 25 you will find this line of code
We are using datatables library for front end and I think that the issue is in thousand separator.
Can you please try to remove this line of code and try after that.
Kind Regards,
Miloš Jovanović
[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
Hi Bogdan,
i try with comment but not work. Now i add this line:
/* after this */
if( $content == '' ){ return $content; }
/* i added this return*/
return (float) $content;
and it works for me!
HI Manuel,
Good job,we are glad that you found the solution.
If you have any issues feel free to open a new ticket.
Kind Regards,
Miloš Jovanović
[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