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...
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!!
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.
@@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!!
Thank you so much for this tutorial. Please, I have an issue with pagination and name search (for users) when I'm using Jet Dynamic Table with the 'User' custom query. It seems impossible to have pagination if the custom query is 'user query' and not post query. Also, it's difficult getting the search widget of jet smart filters to work in sync with the user data table, where I need it to search for users either by their first_name or their display_name. Can you help, please?
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 :(
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
I am very happy to find your TH-cam, 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
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.
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. 😢
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 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
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?
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.
@@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
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.
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.
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.
@@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
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.
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.
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.
Hi Moxet, can you perhaps make a video regarding dynamic repeater table, please. Is it possible to have data export buttons too? th-cam.com/video/O8z5Huc6mEQ/w-d-xo.html
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 th-cam.com/video/X3KK76UZZ3w/w-d-xo.html ). I want image display on excel file too. thanks ....
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 :)
![[Gegagedigedagedago] NEW Help Gegagedigedagedago Nugget escape from Nikocado Avocado Challenge](http://i.ytimg.com/vi/hJWnwRC2Fz8/mqdefault.jpg)
Thanks Moxet! My client requested this download feature for their members data and saw your video. Thanks!
You are welcome, i am glade that it solve your problem :)
Just found this amazing tutorial, thank you Abdul. You're great!
You are welcome..
I would like to implement the print, pdf buttons and also the calculation of columns such as: addition, subtraction, percentage of the total.
Yes possible, check datatable documentations
@@MoxetKhanPK Hi partner!
I could not. I put a footercallback but it didn't bring the result.
Wow, thank you very much for sharing this video with us. This and you other videos are very good and helpful!
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...
Hello partner!
Would it be possible to implement in addition to the buttons the sum of columns in the table?
thanks for the tip
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!!
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.
@@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!!
@@robinportocarrero640 text me on insta or moxetkhan@gmail.com, let me check..
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?
Hello Erika, please refer to datatable forum, they have dozens of resources on such issues.
datatables.net/forums/
@@MoxetKhanPK Thanks!!!
Thank you so much for this tutorial. Please, I have an issue with pagination and name search (for users) when I'm using Jet Dynamic Table with the 'User' custom query. It seems impossible to have pagination if the custom query is 'user query' and not post query. Also, it's difficult getting the search widget of jet smart filters to work in sync with the user data table, where I need it to search for users either by their first_name or their display_name. Can you help, please?
You can use almost any query with datatable.
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 :(
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
You have to use plugin for that
@@MoxetKhanPK any recommendations?
I am very happy to find your TH-cam, 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
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.
Hello, thank you very much for this great tutorial. I was wondering if there is a possibility that only the buttons are shown?
Hi Jim, Yes you can hide table if you need only export, and there is another method for hidding columns as well.
DataTable( {
bPaginate: false,
searching: false, paging: false, info: false
} );
Try this
Hi, i have a question, in the exported file, there are page title, how to remove it ? thanks sir.
Hi, use this code
datatables.net/forums/discussion/44103/how-to-remove-title-in-print-view
@@MoxetKhanPK thank you 🥰
I really can't thank you enough for this great tutorials. you are the man!
Glad you like them!
very helpful video.
You saved me hours, thank you!
Welcome
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.
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
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.
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. 😢
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?
Thank you Kaldeep, Yes it will work with Jetfilter.
@@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
Thank you fro the video, how we can filter data and print it? i used smart filters to filter out data but all exported :(
Use DataTable filter instead of JetSmart Filter, your data will be clean
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?
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.
I'm not able to put the translate and download script in the same expression if you can explain how to do it
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
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'
]
} );
});
@@MoxetKhanPK ohhh javascript thanks
@@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
hi moxet, What if the table requires rtl, how do I configure the pdf and print? Thank you !
It is duable, datatable support Arabic language as well, please check here
datatables.net/extensions/fixedcolumns/examples/styling/rtl.html
Thank a lot for this trick! 😉
Hello! I would like to translate the copy print buttons into Portuguese Brazilian language, your tutorials are magnificent
Hello, please check this page
stackoverflow.com/questions/13342494/how-to-change-language-for-datatable
Hello, I'm from Peru, how could I export csv, pdf, etc, but for a listing, could you please help me?
You need to show your listing in Table, listing itself can't be exported.
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.
Hello Kunal, based on our conversation in facebook, i hope the problem is fixed now :)
I added it to mine, but it only printed 10 data. How can I fetch all records from the table?
It is due to query, double check in query builder post per page and increase it
One question please, I tried to add the buttons code + translation code but I failed to make it work. How Can I do this?
it finally worked, thanks
There is issues in bracker, comma sometime, if all placed correctly it will work.
Hey, does it works with jet appoitment if iil use qury builder to build an sql db ?
it works with any table from db.
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.
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.
@@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
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.
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.
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.
@@pokoman540 Did you manage to do it?
No
Top demais !!! Obrigado
Thanks again :) :)
Does it work with jetsmartfilter?
Yes it works with smartfilter; watch Kate video on Crocoblock
I know that, but I mean that when filtering only export what is filtered, but not only what the query throws
I managed to insert the table, everything is ok, except one thing: It only appears for users logged in to Wordpress
In fact, only admins can view
How to add edit and dalate on table builder prof?
Use jetform
@@MoxetKhanPK but I can't add edit icon on table builder
@@acarakyta9307 send me request on fiverr
Hi Moxet, can you perhaps make a video regarding dynamic repeater table, please. Is it possible to have data export buttons too? th-cam.com/video/O8z5Huc6mEQ/w-d-xo.html
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 :)
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 th-cam.com/video/X3KK76UZZ3w/w-d-xo.html ). I want image display on excel file too. thanks ....
Hello, you have to check this guideline.
datatables.net/forums/discussion/65174
@@MoxetKhanPK Thanks for your answer. But i don't know coding, i can show me another easy way to do it ??
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 :)
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'
]
} );
});
@@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.🙏
@@bompard07 you are welcome