topic Re: Creating a dynamic exportData button / re-using same button for exporting data in Integration, Extension & APIs

Creating a dynamic exportData button / re-using same button for exporting data

rbartley — Thu, 02 Feb 2017 17:55:13 GMT

Hello everyone,

I have a mashup and am trying to implement a toolbar panel (see below) that allows users to download data for different charts according to which one is displayed at the time.

While I have no problem with exporting data using a different button for each chart, e.g.

app.getObject('QV52','uHQnzX').then( function( vizModel ) {

$('#cmdExport1').show();

$('#cmdExport1').prop('onclick',null).off('click');

$('#cmdExport1').on('click', function() {

vizModel.exportData().then(function( reply ) {

var url = 'http://' + config.host +'/auth'+reply.result.qUrl;

window.open(url);

});

app.getObject('QV53','uHQnzY').then( function( vizModel ) {

$('#cmdExport2').show();

$('#cmdExport2').prop('onclick',null).off('click');

$('#cmdExport2').on('click', function() {

vizModel.exportData().then(function( reply ) {

var url = 'http://' + config.host +'/auth'+reply.result.qUrl;

window.open(url);

});

Since I am allowing the users to change the displayed chart, I would like to use a single button in the panel to download the data of the selected chart. I tried using the function below, but it does not seem to allocate the onclick function correctly. I assume this is due to the fact that the function is called before the charts are fully loaded in memory.

function updateDownloadButton(qlik,app,strObjectID)

{

console.log('updateDownloadButton= ',strObjectID);

var object = app.getObject('x','vsbGw');

object.then(function(model) {

console.log('in object.then');

var table = new qlik.table(model);

$('#cmdExport1').on('click', function() {

table.exportData({download: true});

});

Does anyone have any ideas?

Thanks in advance,

Richard

Re: Creating a dynamic exportData button / re-using same button for exporting data

Alexander_Thor — Thu, 02 Feb 2017 19:37:17 GMT

Hey Richard,

You could always do something like: Export data - JSFiddle

Now the sample actually wont work since it's a anonymous user that aren't allowed to export but if you check the traffic you'll see that the ExportData method is indeed firing for the correct chart/handle.

Re: Creating a dynamic exportData button / re-using same button for exporting data

rbartley — Fri, 03 Feb 2017 10:14:23 GMT

Hi Alexander,

Thanks for responding. I get a syntax error when using the JSFiddle you provided:

This seems to refer to the the following line:

currentChart.then(model => {

Any ideas?

Re: Creating a dynamic exportData button / re-using same button for exporting data

rbartley — Fri, 03 Feb 2017 11:34:21 GMT

Alexander,

I adapted the JSFiddle script to use the following:

currentChart = app.getObject('chart', 'vsbGw');

$('#cmdX').on('click', function() {

currentChart.then(function(model){

var table = new qlik.table(model);

return table.exportData({download: true})

})

.then(function(url) {

console.log(url)

})

});

This overcame the syntax error problem and also works for pie charts, but generates an error when attempting to export map data:

I assume that this is related to the format of the geographical data. Any ideas how to get around this or exclude certain fields?

Thanks in advance

Re: Creating a dynamic exportData button / re-using same button for exporting data

Alexander_Thor — Fri, 03 Feb 2017 15:14:10 GMT

Oh sorry about that, I used the new ES6 which I don't think IE supports hence the syntax errors.
I don't know about the map, let me check on that.

Re: Creating a dynamic exportData button / re-using same button for exporting data

rbartley — Fri, 03 Mar 2017 11:49:57 GMT

Hi Alex,

Any news on whether it's possible to export map data or not?

Richard