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

zlucy82

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 code is that i don't run a redirect to call the webscript (window.location.href = Alfresco.constants.PROXY_URI+"export/excel/?nodeRef="+file.nodeRef but i need send a json object to the java controller of the webscript.

I've performed an ajax post request to send informations through a webscript that extends the AbstractWebScript webscript type. The java controller class processes the json object and writes the response ( file excel) in the WebScriptResponse object (incomplete function).

Now, i dont't know how get back the file because the webscript returns an incomprensible response.

The javascript function that runs the post request is this:

Alfresco.util.Ajax.request({
      url: Alfresco.constants.PROXY_URI + "export/data/post",
      method: Alfresco.util.Ajax.POST,
      dataObj:
                {
                  site: this.options.siteId,
                  fileName: "report-" + today.getFullYear() + '-' + (today.getMonth()+1) + '-' + today.getDate()
                  + '-' + today.getHours() + '-' + today.getMinutes() + '-' + today.getSeconds(),
                  rows: req                  
                },
      requestContentType: Alfresco.util.Ajax.JSON,
      successMessage: "Successfully retrieved the Hierarchy.",
      successCallback: {
          fn: function(response){ 
                alert(response.serverResponse.responseText);
               },
          scope:this
      },
      failureMessage: "Failed to retrieved the Hierarchy!",
      failureCallback: {
          fn: function(response){},
          scope:this
      },
      execScripts: true
});‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The webscript's descriptor is this:

<webscript>
&nbsp; <shortname>Export to Excel Webscript</shortname>
&nbsp; <description>Sample Export to excel webscript</description>
&nbsp; <url>/export/data/post</url>
&nbsp; <format default="xls">argument</format>
&nbsp; <authentication>user</authentication>
&nbsp; <transaction allow="readonly">required</transaction>
</webscript>‍‍‍‍‍‍‍‍

The java class of the webscript's controller is this:

/**
 * A java class controller of export data in excel
 *
 */
public class ExportDataExcel extends AbstractWebScript {
     private String fileName = "ExcelSheet";
     private String format = "xlsx";
     
     //logging
      Log log = LogFactory.getLog(ExportDataExcel.class);
 
      /**
       * This method is inherited from AbstractWebscript class and called
       * internally.
       */
      @Override
      public void execute(WebScriptRequest req, WebScriptResponse res) throws IOException{
      
           String nomeSito = "";
           String nomeFile = "";
           
           
           //Controlliamo che la richiesta non sia vuota
           if (req.getContent() == null)
          throw new WebScriptException(Status.STATUS_BAD_REQUEST, "Corpo del POST assente.");           
         
         JSONObject datiExcel = null;
          
          //check json object
          Object jsonO = req.parseContent();
          if (jsonO instanceof JSONObject && jsonO != null)
               datiExcel = (JSONObject)jsonO;
          else
          throw new WebScriptException(Status.STATUS_BAD_REQUEST, "JSON errato " + jsonO);
        
        
        
           try{
               //si dovrebbe controllare che sia un JSON valido
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Map<String, Object> map = new HashMap<String, Object>();
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Iterator<String> keyItr = datiExcel.keys();
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while(keyItr.hasNext()) {
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String key = keyItr.next();
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;log.debug(key);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(key.equals("site")) nomeSito = datiExcel.getString(key);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(key.equals("fileName")) nomeFile = datiExcel.getString(key);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(key.equals("rows")){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// TO DO ...
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; map.put(key, datiExcel.getString(key));
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;catch (JSONException e) {
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw new RuntimeException(e);
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//TO DO: pass the json object information to process them
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;writeDataInExcel(res);
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .....‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

zlucy82

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!