How to download the contents of a data collection as a csv file from Front-end

sahanchatu · May 18, 2022, 8:34pm

I need to let members to download their filtered data from the content manager / database, as a CSV file.
Currently using velo code its possible to query the data and get it as a JSON object.
But I’m having the issue with convert JSON data object to CSV downloadable file.

I tried with this >
https://www.wix.com/velo/forum/tips-tutorials-examples/how-to-download-the-contents-of-a-data-collection-in-a-csv-file
and this >

github.com

andreaskviby/wixhtmlpages/blob/master/docs/wix-datacollection-excel-export.html

<html>
<head>
<script>
    var myList=[];
    window.onmessage = function(event){
    if (event.data) {
      myList = event.data;
      if (myList.length>0) {
        buildHtmlTable();
      }
    }
    else {
      myList = [];
    }
  };
 function buildHtmlTable() {
     var columns = addAllColumnHeaders(myList);
 
     for (var i = 0 ; i < myList.length ; i++) {
         var row$ = $('<tr/>');

This file has been truncated. show original

But still no luck.
Any help appreciated.
Thanks.

Certified_Code · May 20, 2022, 5:50am

That works, but there is no “template” for us to copy… It would be good to add it to the velo example. @talyaro Any chance?

sahanchatu · May 20, 2022, 6:45pm

Thanks @certified-code , Issue was that I tested this on a free site.
I checked this on a premium site & worked great.
Thanks anyway.

Topic		Replies	Views
How to download the contents of a data collection in a csv file Show and tell code , wix-stores , question , tips	16	7201	August 19, 2019
Download a Table based on a collection to CSV/ Excel/ PDF Ask the community code , question	2	213	October 4, 2021
Has anybody been able to get wix html element to download a csv file? Ask the community code , question	13	523	December 16, 2022
Download table results to CSV? Ask the community code , question	7	584	May 23, 2021
Export Collection to CSV with Code Ask the community code , wix-members-area , question	3	895	March 23, 2021

How to download the contents of a data collection as a csv file from Front-end

Related topics