topic Re: How to export data on qliksense mashup in Integration, Extension & APIs

How to export data on qliksense mashup

xiaojunzai — Wed, 10 Jan 2018 02:16:38 GMT

Hi all,pls tell me how to export data on qliksense mashup,can not be exported by clicking the right mouse button or with an extension without any restrictions,thank you!

Re: How to export data on qliksense mashup

_jespers_ — Wed, 10 Jan 2018 11:48:07 GMT

Hi Junzai,

The code I will display is not the complete code but I will try to guide you through the example.

This is how I have solved it:

In the .js file I have the following function and this is being called everytime a user right-click on a container with the class "right-click-toolbar". Right-clicking on this container brings up a modal with some options. One of the option is the export data link:

$( ".right-click-toolbar" ).contextmenu(function(event) {
    event.preventDefault();

    var containerID = $(this).find("[data-qvobject]").attr('id');
    
    var qlikObjects = setObjects.toString();
    if(qlikObjects.indexOf(containerID) != -1){
        var tmpString = qlikObjects.substr(qlikObjects.indexOf(containerID), qlikObjects.length); 
        var ptrn = /(\d+|\w+|-_)/g;

        var match, qlikID;
        var test = ptrn.exec(tmpString);

        if((match = ptrn.exec(tmpString)) != null){
            qlikID = match[0];
        }        
    }

    $( ".export-data-link" ).attr({
        'qvdata-id': qlikID
    });
});

So what we do here is to find the id of the container that has the QV-object and attach that ID to the export link.

Next part of the the .js-file handles when the user clicks the export button:

$( ".export-data-link" ).click(function(event) {
    event.preventDefault();

    var qlikID = $(this).attr("qvdata-id");

    exportObject(qlikID);
});

var exportObject = function(qvObj){

      app.getObject("export-container", qvObj).then(function(retObj){

          retObj.exportData( 'OOXML', '/qHyperCubeDef').then(function(c){
              var d = "../.." + c.qUrl;
              $('.exportChart').attr({
                  'filename': "download",
                'download': true,
                'href': d
            });
          });
      });
};

The HTML looks like this:

<div class="right-click-toolbar">
    <div id="QV01" class="qvobject" data-qvobject=""></div>
</div>

I have removed a lot of code so it might be so that this will not work as it is since I haven't tested it completely. Let me know if you have any issues.

Re: How to export data on qliksense mashup

rajeshshuklars — Thu, 16 May 2019 20:23:57 GMT

Hi Jesper_snihs,

I tried your solution however its not working. In the container where I am loading the qliksense table its not recognizing the right click context menu and I see regular chrome right click menu. Any though or elaborate steps would be helpful Thanks

Re: How to export data on qliksense mashup

ajaykakkar93 — Mon, 20 May 2019 03:59:04 GMT

Hi,

Visit this link its Table Api will will be used.

in HTML:

<button id="buttonID">Export</button>

in JS :

var app = qlik.openApp('Automotive.qvf', config);

//get objects -- inserted here --
app.getObject('QV01','utuwT').then(function(reply){
$('#buttonID').click(function(){
var qTable = qlik.table(reply);
qTable.exportData({download: true});
});
});

Re: How to export data on qliksense mashup

ajaykakkar93 — Mon, 20 May 2019 04:00:14 GMT

hi,

Here is the example with Table Api

Re: How to export data on qliksense mashup

rajeshshuklars — Fri, 24 May 2019 18:57:11 GMT

Thanks Ajay, I will take a look and get back to you.

Re: How to export data on qliksense mashup

pprakriya — Wed, 04 Dec 2019 14:27:52 GMT

Ajay,

I tried to use this example to export to excel and having trouble not able to see Export button in View in dev hub.

Any ideas on what i am missing?

Appreciate your help.

Thank you,

Padma

Re: How to export data on qliksense mashup

ajaykakkar93 — Thu, 05 Dec 2019 10:23:03 GMT

Check if you have Automotive.qvf
have you altered the code if yes then re download & check if you could share a image it will be helpful

Re: How to export data on qliksense mashup

iharsh220 — Fri, 06 Dec 2019 06:45:28 GMT

hello,

try this out if it will help

https://help.qlik.com/en-US/sense-developer/November2019/Subsystems/APIs/Content/Sense_ClientAPIs/CapabilityAPIs/TableAPI/exportData-method.htm

https://community.qlik.com/t5/Qlik-Sense-Integration/Qlik-Sense-2-1-Engine-API-ExportData-to-CSV/td-p/988007

Thanks Regards,

Harsh Gohil

Re: How to export data on qliksense mashup

Harsh_Gohil — Thu, 12 Dec 2019 10:06:11 GMT

hello,

try this

Re: How to export data on qliksense mashup

jitu2110 — Wed, 12 Feb 2020 08:29:36 GMT

Hi,

do you have any idea how to cancel a Export to excel request? for example exportData is taking too much of time to download , i want to cancel the Exportdata.

please let me know how can we do this.

Re: How to export data on qliksense mashup

Aiham_Azmeh — Thu, 13 Feb 2020 07:14:13 GMT

Hi,

The only way you can do this is through CancelRequest (https://core.qlik.com/services/qix-engine/apis/qix/global/#cancelrequest), unfortunately we do not expose it in the capability APIs, but you should be able to use it through enigma.js

The request id should be part of the returned promise from the exportData method:

const exportObj = vis.exportData({ format: "CSV_C", state: "A" }); // should have something like: /* { $$state: {status: 1, value: "..."}, requestId: 52 // <- requestId then: ƒ patchedThen() } */