topic Export data-list in excel (running a post ajax request): how retrieve the file? in Alfresco Forum

Export data-list in excel (running a post ajax request): how retrieve the file?

zlucy82 — Tue, 27 Feb 2018 12:02:53 GMT

Hi all,i have implemented a function that exports site data-list informations in a excel file, but i have a problem to retrieve the file.To do this, i've followed the tutorial of KRUTIK JAYSWAL: http://www.krutikjayswal.com/2017/07/alfresco-webscript-export-data-in-excel.html.The difference with its

Re: Export data-list in excel (running a post ajax request): how retrieve the file?

krutik_jayswal — Tue, 27 Feb 2018 17:29:51 GMT

If i understood correctly, you would like to download a file by making an ajax request.There are some complexity in it.

But below code may help you.

function downloadFile(urlToSend) {     var req = new XMLHttpRequest();     req.open("GET", urlToSend, true);     req.responseType = "blob";     req.onload = function (event) {         var blob = req.response;         var fileName = req.getResponseHeader("fileName") //if you have the fileName header available         var link=document.createElement('a');         link.href=window.URL.createObjectURL(blob);         link.download=fileName;         link.click();     };      req.send(); }

This is created in a pure java script but in think you will find some way , how you can use it in YUI.

For more details on this you can refer below link..

javascript - download file using an ajax request - Stack Overflow

Re: Export data-list in excel (running a post ajax request): how retrieve the file?

zlucy82 — Fri, 02 Mar 2018 15:08:48 GMT

Hi Krutik, thank you for your response. I have modified my javascript function following your indications and now it works. This is my new code.

   var json = JSON.stringify( {
            site: this.options.siteId,
            fileName: titleDatalist +"."+ today.getFullYear() + '.' + (today.getMonth()+1) + '.' + today.getDate()
                       + '-' + today.getHours() + '.' + today.getMinutes() + '.' + today.getSeconds();,
            columns: labels,
            rows: req
         } ); 


   var req = new XMLHttpRequest();
   req.open("POST", Alfresco.constants.PROXY_URI + "export/data/post", true);     
   req.setRequestHeader('Content-Type', 'application/json');
   req.responseType = "blob";     
   req.onload = function(e) {
     if (this.status === 200) {
        var blob = this.response;
        var filename = "ExportExcelDataList.xlsx";
        var downloadLink = window.document.createElement('a');
        var contentTypeHeader = req.getResponseHeader("Content-Type");
        downloadLink.href = window.URL.createObjectURL(new Blob([blob], { type: contentTypeHeader }));
        downloadLink.download = filename;
        document.body.appendChild(downloadLink);
        downloadLink.click();
        document.body.removeChild(downloadLink);
        }
     };
   req.send(json);
          ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thank you very much!