Export DataTable to Excel, CSV, Print & PDF in JetEngine Wordpres with Elementor

[@danicalouwe]

Thanks Moxet! My client requested this download feature for their members data and saw your video. Thanks!

[@MoxetKhanPK]

You are welcome, i am glade that it solve your problem :)

[@stillready6405]

Wow, thank you very much for sharing this video with us. This and you other videos are very good and helpful!

[@comleonmoto]

Just found this amazing tutorial, thank you Abdul. You're great!

[@MoxetKhanPK]

You are welcome..

[@websimmm]

I would like to implement the print, pdf buttons and also the calculation of columns such as: addition, subtraction, percentage of the total.

[@MoxetKhanPK]

Yes possible, check datatable documentations

[@websimmm]

@@MoxetKhanPK Hi partner! I could not. I put a footercallback but it didn't bring the result.

[@JubranZakri]

I really can't thank you enough for this great tutorials. you are the man!

[@MoxetKhanPK]

Glad you like them!

[@davidtedde9634]

You saved me hours, thank you!

[@MoxetKhanPK]

Welcome

[@rain47ful]

Hello professor, I am on a project and here I am really stuck yes really... I come to you to learn some notions "the sum of a desired column in DATA table" I have seen the DATA TABLE documentation but frankly I don't know how to apply this. It will be the best gift just an example of a table but which displays the sum of a desired column really thank you...

[@razakahmad12]

very helpful video.

[@websimmm]

Hello partner! Would it be possible to implement in addition to the buttons the sum of columns in the table? thanks for the tip

[@patrickduhaut3783]

Thank a lot for this trick! 😉

[@rafstudio25]

I am very happy to find your KZbin, it is very inspiring for me. Can you make a tutorial about exporting data using JetEngine? like you made a tutorial about tickets. Thank You

[@MoxetKhanPK]

Hello, you can use the same table to export data from jetengine, if you have CPT or CCT display them in this table and put export buttons.

[@diogo_ferrarezi]

Top demais !!! Obrigado

[@bompard07]

Thanks again :) :)

[@FabioFranciscomasterevolution]

Hello! I would like to translate the copy print buttons into Portuguese Brazilian language, your tutorials are magnificent

[@MoxetKhanPK]

Hello, please check this page stackoverflow.com/questions/13342494/how-to-change-language-for-datatable

[@robinportocarrero640]

Hello, how can I export my active subscriber users from my website through a button. that the button says, for example: EXPORT LIST, and that list is a list in EXCEL and that only the users or active members of my website appear. Which is a monthly subscription website. I appreciate the help and the response!!

[@MoxetKhanPK]

The easiest way is to run a query in query builder which fetch all user with a role ACTIVE etc. display them in dynamic table and apply the same logic of button.

[@robinportocarrero640]

@@MoxetKhanPK You could help me with that issue. The truth is I don't really understand how it could be done. or maybe make a video with this specific topic. I would like to contact you to see how we could do it. Let me know because I'm interested, a hug!!

[@MoxetKhanPK]

@@robinportocarrero640 text me on insta or [e-mail], let me check..

[@daviduarte22]

I'm not able to put the translate and download script in the same expression if you can explain how to do it

[@layarlaras]

Hi, i have a question, in the exported file, there are page title, how to remove it ? thanks sir.

[@MoxetKhanPK]

Hi, use this code datatables.net/forums/discussion/44103/how-to-remove-title-in-print-view

[@layarlaras]

@@MoxetKhanPK thank you 🥰

[@anthonyespino7214]

Hello, thanks for sharing your knowledge. How would the code be to be able to export in cvs, excel, pdf, etc and the translation. What would all the code look like together? . I'm trying but it doesn't work :(

[@wellingtonmacedos]

I managed to insert the table, everything is ok, except one thing: It only appears for users logged in to Wordpress

[@wellingtonmacedos]

In fact, only admins can view

[@wellingtonmacedos]

I added it to mine, but it only printed 10 data. How can I fetch all records from the table?

[@MoxetKhanPK]

It is due to query, double check in query builder post per page and increase it

[@7xn]

Thank you fro the video, how we can filter data and print it? i used smart filters to filter out data but all exported :(

[@MoxetKhanPK]

Use DataTable filter instead of JetSmart Filter, your data will be clean

[@KamalSingh-zo1ol]

Hi Moxet, Much respect for making this video available so quickly. One more question. Will it work if I connect these tables to jetfilters and will it export csv after application of filters? If not, then is there an easy way to apply filters via JavaScript?

[@MoxetKhanPK]

Thank you Kaldeep, Yes it will work with Jetfilter.

[@JubranZakri]

@@MoxetKhanPK many thanks for your great videos, me too I want to know how to connect this table to cct and export data by jetsmartfilter. thank you again

[@abdulrahmanmohammed6690]

hi moxet, What if the table requires rtl, how do I configure the pdf and print? Thank you !

[@MoxetKhanPK]

It is duable, datatable support Arabic language as well, please check here datatables.net/extensions/fixedcolumns/examples/styling/rtl.html

[@KunalPandyaMaverick]

Hi Moxet, i am the one who posted about data table export thing in the community. I am trying to do what you have just shown in the video but Buttons are not showing. Pls help.

[@MoxetKhanPK]

Hello Kunal, based on our conversation in facebook, i hope the problem is fixed now :)

[@anthonyespino7214]

Hello friend, do you know why it doesn't show me the paginations? I have 50 posts and only in the table it shows me 10, but it doesn't show me the pagination numbers and when I export the data, only 10 posts appear. How could I solve it? Aid!!. Thanks for your time.

[@MoxetKhanPK]

Seems you are showing data from query builder? Make sure in query builder you ignore post per page, make it 0 or empty or 100000 i dont remember exactly but dont control pagination in query.

[@anthonyespino7214]

@@MoxetKhanPK Hello friend, I already did it as you told me, but I still have the same problem, I have 50 posts, but only 10 appear and the pagination does not appear to continue showing more posts and when I export in csv, it only takes the 10 posts. Please help me. Thanks for your valuable time friend. Greetings

[@Janther12]

Hello, thank you very much for this great tutorial. I was wondering if there is a possibility that only the buttons are shown?

[@MoxetKhanPK]

Hi Jim, Yes you can hide table if you need only export, and there is another method for hidding columns as well.

[@orelhassid]

DataTable( { bPaginate: false, searching: false, paging: false, info: false } ); Try this

[@awan.januari]

Hi Moxet, thanks for your tutorial! It's very useful. But how about multiple table in the same page. I tried to make it, but only first table work fine.

[@MoxetKhanPK]

Hello, it works on multiple table in single page as well, make sure to define them with class not ID, just like we use .jet-dynamic-table

[@awan.januari]

I did it, but the buttons doesn't show up. I have put a class in the elementor advanced properties and it didn't work.

[@awan.januari]

Now I knew the problem is. It's because I'm using exportOptions: columns [ ... ] in buttons property. While the number of columns with each other is different. 😢

[@LeandroUbinski]

Hi, always a great video. To use the JetEngine Tables when creating the Query, the number of records is limited... only if we put (-1) in the Query does the pagination work but makes the system slow depending on the number of records, I have 350 here and that's it taking almost 30 seconds. If you don't, it just shows the number of records defined in WordPress. Is there any solution?

[@MoxetKhanPK]

If you want to show the records using Datatable then you can bypass the query builder pagination/records per page. Datatable itself has pagination and number of records per page. 350 is very less number i have more than 5000 records and it works well in datatable.

[@neoacla]

Hi Moxet, very helpful video. Question, can you create a video as well on adding Download PDF button and view pdf link next to the CPT admin column. Basically when a post is created it will generate a pdf download / view link. Thanks

[@MoxetKhanPK]

You have to use plugin for that

[@neoacla]

@@MoxetKhanPK any recommendations?

[@sgogroup7152]

Hey, does it works with jet appoitment if iil use qury builder to build an sql db ?

[@MoxetKhanPK]

it works with any table from db.

[@daviduarte22]

thanks for the content, I managed to do everything you showed but how do I put the two functions at the same time to translate and export

[@MoxetKhanPK]

Hello, you can apply this code. jQuery(document).ready(function($) { $('.jet-dynamic-table').DataTable( { language: { search: 'In der Tabelle finden', }, dom: 'Bfrtip', buttons: [ 'copy', 'csv', 'excel', 'pdf', 'print' ] } ); });

[@daviduarte22]

@@MoxetKhanPK ohhh javascript thanks

[@bompard07]

@@MoxetKhanPK Hi and thanks a big big lot for this tutorial. Although I tried to add the Page length options to exports but I didn't succeed... Would you kindly have a suggestion ? here's the code I tried to enter : jQuery(document).ready(function($) { $('.jet-dynamic-table').DataTable( { dom: 'Bfrtip', buttons: [ 'copy', 'csv', 'excel', 'pdf', 'print' ] }, { "lengthMenu": [ [10, 25, 50, -1], [10, 25, 50, "All"] ] }); }); Thanks

[@ErikaWoelke]

Hi Moxet, thanks for share this! Great tutorial!!! I have some rich text fields in table. In the XLS these fields loses formatting. Any suggestion?

[@MoxetKhanPK]

Hello Erika, please refer to datatable forum, they have dozens of resources on such issues. datatables.net/forums/

[@ErikaWoelke]

@@MoxetKhanPK Thanks!!!

[@pokoman540]

Hi Moxet. I have seen this tutorial, these was really great. But I still need an extended tutorial about exporting the filtered data. Actually, I have doctor's appointment website. So, I want to export csv file of today, weekly, monthly appointment list. Could you please explain how can I export filtered csv file? I follow this tutorial, but I exported whole list from the beginning day.

[@MoxetKhanPK]

Hello, if you want to filter by date/rang you can use this code to extend the functionality of datatable. datatables.net/extensions/datetime/examples/integration/datatables.html If you are planning to add more filters in future, better to go with jetsmartfilter but for date rang this works fine. Make sure your date format match with the format mentioned in datatable.

[@pokoman540]

Actually, I used jetsmartfilter. It works fine. But when I want to export the data as CSV, this is not working. The exported file contain the whole database. I just want to export the Filtered Data. And Thanks for reply me.

[@roygh]

@@pokoman540 Did you manage to do it?

[@pokoman540]

No

[@acarakyta9307]

How to add edit and dalate on table builder prof?

[@MoxetKhanPK]

Use jetform

[@acarakyta9307]

@@MoxetKhanPK but I can't add edit icon on table builder

[@MoxetKhanPK]

@@acarakyta9307 send me request on fiverr

[@JubranZakri]

One question please, I tried to add the buttons code + translation code but I failed to make it work. How Can I do this?

[@JubranZakri]

it finally worked, thanks

[@MoxetKhanPK]

There is issues in bracker, comma sometime, if all placed correctly it will work.

[@anthonyespino7214]

Hello, I'm from Peru, how could I export csv, pdf, etc, but for a listing, could you please help me?

[@MoxetKhanPK]

You need to show your listing in Table, listing itself can't be exported.

[@roygh]

Does it work with jetsmartfilter?

[@MoxetKhanPK]

Yes it works with smartfilter; watch Kate video on Crocoblock

[@roygh]

I know that, but I mean that when filtering only export what is filtered, but not only what the query throws

[@stephenandrewjacobs]

Hi Moxet, can you perhaps make a video regarding dynamic repeater table, please. Is it possible to have data export buttons too? kzbin.info/www/bejne/hWndZnurmJuge7M

[@MoxetKhanPK]

In the video when she add table in before, you have to give a class to that table. The same class will be use in datatable :)

[@BatdongsanGo99-lp8ne]

Hi, thanks for your video. Can you help me that reason : how if i want export to excel when my dynamic table have a coluum had image ( it load by Elementor template - Jet Listings kzbin.info/www/bejne/jmSufGpsir-Nadk ). I want image display on excel file too. thanks ....

[@MoxetKhanPK]

Hello, you have to check this guideline. datatables.net/forums/discussion/65174

[@BatdongsanGo99-lp8ne]

@@MoxetKhanPK Thanks for your answer. But i don't know coding, i can show me another easy way to do it ??

[@bompard07]

Hi and thanks a big big lot for this tutorial. Although I tried to add the Page length options to exports but I didn't succeed... Would you kindly have a suggestion ? here's the code I tried to enter : jQuery(document).ready(function($) { $('.jet-dynamic-table').DataTable( { dom: 'Bfrtip', buttons: [ 'copy', 'csv', 'excel', 'pdf', 'print' ] }, { "lengthMenu": [ [10, 25, 50, -1], [10, 25, 50, "All"] ] }); }); Thanks again :)

[@MoxetKhanPK]

As per datatable documentation, native drop down is bypass if we use button. Try this code jQuery(document).ready(function($) { $('.jet-dynamic-table').DataTable( { dom: 'Bfrtip', lengthMenu: [ [ 10, 25, 50, -1 ], [ '10 rows', '25 rows', '50 rows', 'Show all' ] ], buttons: [ 'copy', 'csv', 'excel', 'pdf', 'print', 'pageLength' ] } ); });

[@bompard07]

@@MoxetKhanPK THANKS AN AWFUL LOT ! That is great. This is really kind of you to have taken the time to come back to this subject.🙏

[@MoxetKhanPK]

@@bompard07 you are welcome