stefanwalther / sense-export Goto Github PK

View Code? Open in Web Editor NEW

29.0 8.0 27.0 2.63 MB

Just a simple button to export data in your Qlik Sense applications.

License: Other

JavaScript 61.99% CSS 33.22% HTML 4.80%

qlik-sense visualization-extension export table qlik excel comma-separated-values csv

sense-export's Introduction

sense-export

Just a simple button to export data in your Qlik Sense application without displaying them in a table first.

Purpose and Description
- Why?
- Screenshots
Installation & Download
Configuration
Compatibility
Known Issues
Related Projects
About
- Change Log
Contributing

(TOC generated by verb using markdown-toc)

Purpose and Description

sense-export is a tiny and sweet visualization extension allowing you to export data without showing the underlying table.

Why?

Every object in Qlik Sense provides the export functionality, but sometimes one just wants to provide a download of some data from your data model by putting a tiny little button onto a screen, completely without showing the data first.

Screenshots

Just a very simple button with some properties to define the layout and the behavior of the export. See Configuration for mor details.

Installation & Download

Download the latest version or any other version you want to install.
Then install on either Qlik Sense Desktop or Qlik Sense Server:

Qlik Sense Desktop
- To install, unzip all files and copy the content to the folder folder "C:\Users\%USERNAME%\Documents\Qlik\Sense\Extensions\sense-navigation"
Qlik Sense Server
- See instructions how to import an extension on Qlik Sense Server

NOTE: Do not use the download button on GitHub to download the entire GitHub repository, please follow the instructions below! - otherwise you'll run into issues importing the visualization extension on Qlik Sense Enterprise.

Configuration

Dimensions & Measures

Define dimensions and measures as you would do for every other extension. Pro Tip: Enable the debug mode if you want to see the result.

Button label

Label - Just define the label of the button, defaults to "Export".

Button layout

The possibilities to layout the button should (hopefully) be pretty self-explanatory:

Style - Select on of the predefined styles.
Button width - Define whether the button should take the full width of the object or not.
Alignment - Define the horizontal alignment.
Icon - Select one of the provided icons. Defaults to "download" Pro Tip: Font Awesome icons are used here, go to https://fortawesome.github.io/Font-Awesome/icons/ to get a nice overview of all icons possible.

Export definition

Define the final output of the export:

Format - Select on of the following values (defaults ot "Open XML (Excel)):
1. Open XML (Excel),
2. Comma separated CSV,
3. Tab separated CSV"
4. Comma separated CSV - Client Side (see below for more information)
State - You can define whether your current selection will be considered or not. If this is the desired behavior, select "Possible values", otherwise "All values", then always all data will be exported, regardless the current selections.
File name - Optionally you can define a file name.

A note on "Comma separated CSV - Client Side"

This is an experimental feature and will generated the exported file client-side, so in your browser, and not using the QIX Engine to generated the file. Why? There is a scenario where Qlik Sense Enterprise is configured to provide anonymous access to dashboard. In that case the QIX Engine generates the export files, but QRS does not allow to serve them (this can obviously seen as a bug and is being investigated).

Use this functionality with caution

Client side generation of export files is much slower
You might run into issues with larger data-sets

Currently tested only with this setup:

Qlik Sense 3.2 SR2, SR3
Chrome, Firefox, IE
Up to about 100.000 records with 10 columns (... takes quite a while, but works)

Debug

While working in edit mode it's quite helpful to test the data (which will then be exported in the defined format). If you enable the debug mode a debug table will be shown to double-check if you you have defined the correct measures and dimensions.

Note:

The debug table will only be shown in edit mode, even if this settings is activated
The debug table only shows the first 500 records (for performance reasons). The export will contain all data, though.

Compatibility

sense-export is designed to work with Qlik Sense 2.1.1 or higher. If you use the visualization extension in an older version of Qlik Sense the following message will be shown:

Known Issues

There are two known improvements which might be addressed in future versions:

Vertical alignment of the button is currently now possible.
Improvement for the mobile view, reserve less space for the export button.
Would be nice to have some kind of spinner in case of the client export

Related Projects

Some related projects (Qlik Sense Visualization Extensions) I have recently created:

qliksense-extension-tutorial: Comprehensive tutorial to start developing Qlik Sense Extensions. | homepage
sense-calendar-heatmap: Qlik Sense Visualization Extension with a diverging color scale. The values are displayed as colored… more | homepage
sense-extension-recipes: Recipes on working with Qlik Sense Visualization Extensions. | homepage
sense-funnel-chart: Funnel Chart for Qlik Sense. | homepage
sense-media-box: Include web pages, videos, images and much more into your Qlik Sense app. | homepage
sense-navigation: Sense Sheet Navigation + Actions visualization extension for Qlik Sense. | homepage
sense-on-off-switch: Set a variable in Qlik Sense to true/false using an on-off switch. | homepage
sense-qr-code: QR Code to be embedded into Qlik Sense. | homepage
sense-range-slider: Slider object for Qlik Sense to manipulate one or two variables. | homepage
sense-themable-kpi-tile: KPI Tile for Qlik Sense with the ability to use themes or to customize background… more | homepage

About

Change Log

See ./CHANGELOG.yml

Contributing

Pull requests and stars are always welcome. For bugs and feature requests, please create an issue. The process for contributing is outlined below:

Create a fork of the project
Work on whatever bug or feature you wish
Create a pull request (PR)

I cannot guarantee that I will merge all PRs but I will evaluate them all.

Using the Project in Dev-Hub

The default build of sense-export minifies the JavaScript files and does not contain a wbfolder.wbl file (which is just necessary for Dev-Hub).

So if you want to edit the extension or create your own extension based on sense-export download the ./build/sense-export_dev.zip file which always contains the latest version + a wbfolder.wbl file.

Author

Stefan Walther

License

MIT

This file was generated by verb-generate-readme, v0.6.0, on July 20, 2017.

sense-export's People

Contributors

Stargazers

Watchers

sense-export's Issues

Action required: Greenkeeper could not be activated 🚨

🚨 You need to enable Continuous Integration on all branches of this repository. 🚨

To enable Greenkeeper, you need to make sure that a commit status is reported on all branches. This is required by Greenkeeper because we are using your CI build statuses to figure out when to notify you about breaking changes.

Since we did not receive a CI status on the greenkeeper/initial branch, we assume that you still need to configure it.

If you have already set up a CI for this repository, you might need to check your configuration. Make sure it will run on all new branches. If you don’t want it to run on every branch, you can whitelist branches starting with greenkeeper/.

We recommend using Travis CI, but Greenkeeper will work with every other CI service as well.

Once you have installed CI on this repository, you’ll need to re-trigger Greenkeeper’s initial Pull Request. To do this, please delete the greenkeeper/initial branch in this repository, and then remove and re-add this repository to the Greenkeeper integration’s white list on Github. You'll find this list on your repo or organization’s settings page, under Installed GitHub Apps.

Export will only download Excel format

Despite selecting csv from the settings, the extension only exports Xlsx. Using sense 2.1.1

Question: Exporting a chart

Hi @stefanwalther, thankyou for this export button! We use it for qlik apps embedded in our online application. Right-clicks don't seem to work when Qlik Sense is embedded in an iframe, so this button is the only way for our users to pull out data.

Now I have a user request for a button to export charts.

Are you aware of any such thing or any tips how we would build it?

Thanks!

akquinet sense excel issue

Hello,
I downloaded the sense excel extension lately. I have all the requirements installed and verified, but:

When I install the akquinet-sense-excel-2.1.2.46.xll the Qlik Sense tab appears. But, I don't have a connection String "Qlik Sense Desktop" and when I add the Server URL it doesn't work.
Also, after adding AutoLoad tick as mentioned in the instruction pdf, we I reopen Excel, the Qlik Sense tab doesn't appear.

Thank you for your help!
Nancy Sbeity

Export Definition: Semicolon Separated CSV

I would really appreciate an export definition "Semicolon Separated CSV".
I can't edit the extension by myself because of the missing wbl-file.

The file name export is different

Hi
when I export my sheet the file name generate code (0a674cab-2b0b-4b95-94ad-99802).xlsx what is solution for export with the name who I mentioned

Limitation to number of dimensions?

Hi, I am new to your extension. Looks wonderful.
I want to use it to export data into an excel-sheet.
For that I want to use more than 10 dimensions, but after I added 10 dimensions the 'Add dimension'-button becomes grey and I am not able to add any more dimensions. To add measures is still possible.
So my question is: Is there a Limitation to the number of dimensions you can use with this Extension?

I hope this is the right place to ask.
Best regards and thanks in advance
anonymouselephant

Can drag and drop but Sense reports "not found on server"

Description

The extension imports to Sense November/February just fine, and appears in the list of extensions while in edit mode. However, upon dragging and dropping the extension onto the canvas, Sense displays the error message "Invalid visualization, The visualization was not found on the server: swr-sense-export."

Steps to Reproduce

Import the extension
Open an app, go into Edit mode
Drag the "Export Button" extension onto the Sense canvas.
Error message "The visualization was not found on the server: swr-sense-export"

Expected behavior

The extension shows the properties pane and allows normal configuration.

Actual behavior

Extension appears to not be installed, but it, but doesn't function.

Environment

Operating system

[x ] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ x] Desktop
[ x] Enterprise

Browser

[ ] Chrome
[x ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Extension version: Latest
Browser: Latest
Qlik Sense Desktop: November and February 2018
Qlik Sense Enterprise: Confirmed on February 2018
Operating system: Windows 10 / Windows Server 2016
[Other relevant versions]

Virtual Proxy Without Windows Authentication

It seems the extension always creates the link like https://servername/tempcontent/.....xlsx. When using windows authentication this is not a problem because virtual proxies authenticate users automatically. But when using ticket authentication other then windows users, the export link must be https://servername/virtualproxyname/tempconten/....xlsx instead https://servername/tempcontent/.....xlsx. This is the only issue for this extension.

sense-export - The export button suddenly disappears

We are using QlikSense 2.2 and we have integrated the QlikSense object in ASP.NET application. In one our dashboards we have used the sense-export button. It suddenly stopped disappearing from the page. But when we view the QlikSense application directly using QMC -> Hub, we could see the button. But on the version that is integrated with ASP.NET, the button is not appearing.

Environment

Operating system

[ ] Windows

Qlik Sense

[ ] Enterprise

Browser

[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: Safari

Versions

Extension version:
Browser:
Qlik Sense: 2.2
Operating system:
[Other relevant versions]

File Name (Optional) is not working

Create variable for the folder of excel to export
Add OsUser() with right function to get user registerednumber
Combine them in File Name area with FX

When i press Export, i get save as dialog with a name like cc1ba5a4-ea8a-48b9-9dd6-4259017b4ffe.xlsx

What can i do to export the specific folder with a specific name?

Qliksense Server November 2017 (11.24.1)

Operating system

[x] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ ] Desktop
[x] Enterprise

Browser

[ ] Chrome
[ ] Firefox
[x] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Extension version: [Latest (downloaded and installed today)]

by the way don't have a chance to open project in devhub becouse of

Thanks for your help

Tankut Kocabas
[email protected] or [email protected]

Unable to export more than 20 columns in 'Comma Seperated CSV - Client Side'

Description

Unable to export more than 20 columns in 'Comma Separated CSV - Client Side'. This problem does not exist in other 3 option (Open XML, Comma Separated CSV and Tab Separated CSV).

Steps to Reproduce

Change values of 'max' in dimensions and measure variable to have anything more than 20.
Add more than 20 dimensions to extension in chart.
Select 'Comma Seperated CSV - Client Side' in 'Export Defination -> Format'
Click done and Export CSV.

Expected behavior

Exported CSV should contain value of all added dimensions and Measures.

Actual behavior

Exported CSV has only headings and no data starting 21st dimension/measure (column).

Environment

QlikSense September 2017

Operating system

[ x] Windows 10

##### Qlik Sense

[x ] Desktop


##### Browser

[x ] Chrome
[x] Edge



### Versions

* Extension version: Bump 1.3.5
* Browser: Chrome / Edge
* Qlik Sense: September 2017
* Operating system: Windows 10
* [Other relevant versions]

prefix not identified properly due to qlik sense upgrade

Description

For November 2017 and versions above, prefix is not being identified properly

Steps to Reproduce

Start with a new session of the browser with all cache and cookies cleaned up
Log in to qliksense with a vProxy
When export is clicked, it does not identify the prefix properly

The current logic to determine the prefix is based on keyword '/sense' in the url.
This should change to '/extensions'

Current:
var prefix = window.location.pathname.substr(0, window.location.pathname.toLowerCase().lastIndexOf('/sense') + 1);

Should change to:
var prefix = window.location.pathname.substr(0, window.location.pathname.toLowerCase().lastIndexOf('/extensions') + 1);

Expected behavior

The prefix should be identified properly as expected

Environment

Chrome

Operating system

All OS

[ ] Windows
[ ] OSX
[ ] Linux

Qlik Sense

All

[ ] Desktop
[ ] Enterprise

Browser

All

[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Sense Export Button for Anonymous Users not downloading all the rows

Description

We are seeing a weird issue when using Sense Export Button for Anonymous users. The total number of rows downloaded in the csv file is being capped to 500 rows when the number of rows in the table component is between 500 to 1500 rows. When the number of rows is greater than 1500 then the downloaded csv file contains about 99% of the rows but does not match completely.

If I login as a registered user and use this button then the number of rows downloaded in csv will match exactly irrespective of the row count.

Sense Export Button for Anonymous Users
Under properties panel : Export Definition: 'Comma Separated CSV - Client side'
Logged in as Anonymous User:
Selected a Product 1
Vertical Table Displayed 300 records.
Clicked 'Sense Export' button - exported file showed exactly 300 rows
Selected a Product 2
Table displayed 630 records.
Clicked 'Sense Export' button - exported file showed only 500 rows.
Selected Product 3
Table displayed 60610 records.
Clicked 'Sense Export' button - exported file showed only 60605 rows.

Operating system

[ ] Windows 7 Enterprise

Qlik Sense

[ ] Enterprise

Browser

[ ] Internet Explorer

Versions

Browser: IE11
Qlik Sense: 3.2 SR4
Operating system: Windows

User authentication required with alternate virtual proxy

Description

When opening a Qlik Sense app from the Hub through a non-default virtual proxy the user is prompted to authenticate. This does not occur when the Hub is opened through the default virtual proxy.

Steps to Reproduce

Log into the Qlik Sense Hub through a non-default virtual proxy
Open an app with the export button extension
A pop-up window appears where the user is asked to authenticate

Environment

Qlik Sense Enterprise April 2018

Operating system

[x] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ ] Desktop
[x] Enterprise

Browser

[x] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Improve mobile view

... height is (by default in all sense objects) to big, find a way to decrease that. Would be really nice to have css parent selectors ;-)

Action required: Greenkeeper could not be activated 🚨

🚨 You need to enable Continuous Integration on all branches of this repository. 🚨

Since we did not receive a CI status on the greenkeeper/initial branch, we assume that you still need to configure it.

We recommend using Travis CI, but Greenkeeper will work with every other CI service as well.

Export Button: The requested resource cannot be found

Description

The button works very well on a QAP development server. When I run the APP from another QAP server (public) I get this error: The requested resource cannot be found[Description of the issue]

Steps to Reproduce

[Step one]
[Step two]
...

Expected behavior

[What you expected to happen]

Actual behavior

[What actually happened]

[Please include log files (e.g. Qlik Sense Server logs or Chrome Dev Tools' console output to the issue).]

Environment

Operating system

[ ] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ ] Desktop
[ ] Enterprise

Browser

[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Extension version: [Version of the extension]
Browser:
Qlik Sense Desktop: [Version of Qlik Sense Desktop]
Qlik Sense Enterprise: [Version of Qlik Sense Enterprise]
Operating system:
[Other relevant versions]

Download button asks for user credentials.

The download button tool that you have put in is really awesome. Thank you so much. We are facing a weird behaviour, this works well in Dev environment but when running in Prod environment, we get a pop up message asking for user credentials. Would you have any clue regarding this issue? Any help is highly appreciated.

Don't work on latest QlikSense

Invalid Vizualization

Description

After importing the extension in the qliksense desktop, it shows "invalid vizualization" and does not allow to edit or change.

I'm looking for a way to include the current selections whenever a user exports data. This was possible in QlikView by updating User Preferences. We are on Qlik Sense v3.2.

Description

[Description of the issue]

Steps to Reproduce

[Step one]
[Step two]
...

Expected behavior

[What you expected to happen]

Actual behavior

[What actually happened]

Environment

Operating system

[ ] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ ] Desktop
[ ] Enterprise

Browser

[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Browser:
Qlik Sense:
Operating system:
[Other relevant versions]

Most recent version is missing reference to Filesaver.JS

Description

[Description of the issue]

Steps to Reproduce

Download the latest version of sense-export
Import extension to Qlik Sense server
Configure export button for client side csv

Expected behavior

file downloads on the client side

Actual behavior

reference error : saveAs() not defined. I added a reference to external/file-saver/FileSaver.min in the swr-sense-export file and it resolved the issue.

Environment

Operating system

[x ] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ ] Desktop
[x ] Enterprise

Browser

[ x] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Browser:
Qlik Sense: 3.2 SR4
Operating system:
[Other relevant versions]

CSV_CLIENTSIDE misses 1 entry every 500 entries

Description

CSV_CLIENTSIDE misses 1 entry every 500 entries.

Steps to Reproduce

Create a table with a couple of measures and at least 505 entries (to ensure you can notice the missing one) on the Sense Export Button.
Select de CSV-Clientside option
Press export and check the data.

Expected behavior

A table exported through this method should show all entries

Actual behavior

The generated export lacks 1 entry every 500 entries.

[No logs are needed for this since it's easily reproduced with any data]

Environment

Operating system

[* ] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ ] Desktop
[* ] Enterprise

Browser

[* ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Extension version: Latest
Browser: Chromium 75.0.3900.0 (Official Build) (64-bit)
Qlik Sense Enterprise: June 2019
Operating system: Win10 AutoUpdated to current.

Build fails for the 'release' task but works for 'build'

Description

On a fresh clone of this project, a 'build' completes successfully while a 'release' fails

Steps to Reproduce

clone this repository
execute yarn to gather all dependencies
execute: ./node_modules/.bin/sense-go build - the command completes successfully
execute: ./node_modules/.bin/sense-go release - the command fails and the log shows:

[15:17:56] uglify:tmp An error occurred. Use -d to show details
[15:17:56] release An error occurred. Use -d to show details

execute: ./node_modules/.bin/sense-go release - - the command fails but shows more information on the error

[15:18:10] uglify:tmp An error occurred. Here are the details:
error { uid: 7,
name: 'uglify:tmp',
branch: false,
error:
{ GulpUglifyError: unable to minify JavaScript
Caused by: DefaultsError: beautify is not a supported option
File: C:\work\sources\forks\sense-export.tmp\initialproperties.js
at createError (C:\work\sources\forks\sense-export\node_modules\gulp-uglify\lib\create-error.js:6:14)
at apply (C:\work\sources\forks\sense-export\node_modules\lodash_apply.js:16:25)
at wrapper (C:\work\sources\forks\sense-export\node_modules\lodash_createCurry.js:41:12)
at C:\work\sources\forks\sense-export\node_modules\gulp-uglify\lib\minify.js:54:15
at DestroyableTransform._transform (C:\work\sources\forks\sense-export\node_modules\gulp-uglify\composer.js:10:23)
at DestroyableTransform.Transform._read (C:\work\sources\forks\sense-export\node_modules\readable-stream\lib_stream_transform.js:159:10)
at DestroyableTransform.Transform._write (C:\work\sources\forks\sense-export\node_modules\readable-stream\lib_stream_transform.js:147:83)
at doWrite (C:\work\sources\forks\sense-export\node_modules\readable-stream\lib_stream_writable.js:338:64)
at writeOrBuffer (C:\work\sources\forks\sense-export\node_modules\readable-stream\lib_stream_writable.js:327:5)
at DestroyableTransform.Writable.write (C:\work\sources\forks\sense-export\node_modules\readable-stream\lib_stream_writable.js:264:11)
at DestroyableTransform.ondata (C:\work\sources\forks\sense-export\node_modules\readable-stream\lib_stream_readable.js:541:20)
at emitOne (events.js:116:13)

... - the stack track continues.

Expected behavior

The build should completes successfully for the 'release' task.

Actual behavior

See section 'Steps to reproduce'.

Environment

node v8.10.0
npm 5.6.0
yarn v1.3.2

Operating system

[x ] Windows
[ ] OSX
[ ] Linux

I added this issue for tracking purpose. The fix is to upgrade the sense-go version that is used by this project. I will submit briefly a pull request for this.

Anonymous Export

Description

Anonymous export does not work as expected when export setting is set to "comma separated CSV - client side"

Steps to Reproduce

Create Export Object and the set the Export definition - Format to Comma separated CSV - client side using Qlik Sense Desktop
Deploy the Qlik Sense App on the server
Build and deploy Mashups using the Export object created in setup 1
Access the mashup using the browser as an anonymous user
Or instead of Step 3 & 4 - access the App from Hub

Expected behavior

When User is accessing the App or mashup, he does not need to authenticate to access Export object and it should function as described by the extension developer.

Actual behavior

Mashup site or App prompts for a username and password when browsing the webpage or Sheet where Export object is added. All other Qlik objects loads without the need of user authentication except the Export Object.

Environment

Operating system

[x] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ ] Desktop
[x] Enterprise

Browser

[x] Chrome
[x] Firefox
[x] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Browser: 58.0.3029.110
Qlik Sense: 3.1 SR3
Operating system: Windows 2012 R2
[Other relevant versions]

Export selections

Description

Hello! I would like to request a functionality that is nonexistent in qliksense atm, that is, apart from the data themselves, to include the selections in the excel file. Is this possible?

"Invalid Visualization" message in Qlik Sense Desktop 3.1 SR6

Description

When I drag&drop the extension form the tool box, it shows the message "Invalid Visualization".
For me it is a big problem because I'm using this extension in different apps.

Environment

[ X ] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ X ] Desktop
[ ] Enterprise

Browser

[ X ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Browser: Version 58.0.3029.110 (64-bit)
Qlik Sense: 3.1 SR4
Operating system: Windows 8

Hello Folks,

Description

[Description of the issue]

Steps to Reproduce

[Step one]
[Step two]
...

Expected behavior

[What you expected to happen]

Actual behavior

[What actually happened]

[Please include log files (e.g. Qlik Sense Server logs or Chrome Dev Tools' console output to the issue).]

Environment

Operating system

[ ] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ ] Desktop
[ ] Enterprise

Browser

[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Extension version: [Version of the extension]
Browser:
Qlik Sense Desktop: [Version of Qlik Sense Desktop]
Qlik Sense Enterprise: [Version of Qlik Sense Enterprise]
Operating system:
[Other relevant versions]

There is a bug in client side CSV export, function $scope.getAllData()

Hello

Description

There is a bug in client side CSV export code, specifically in $scope.getAllData() function. This causes some lines being omitted from the export for each 500 lines or so.

The incorrect line is line 153. I believe index should not be added while calculating qTop:

var page = {
    qTop: (pageHeight * index) + index, // +index should not be here
    qLeft: 0,
    qWidth: columns,
    qHeight: pageHeight,
    index: index
};

Steps to Reproduce

Take any application which has more that 500 records
Set the extension object up. Choose Comma separated CSV - Client side option
Export the data using the extension
Export the data using QlikSense native functionality
Compare the results, specifically number of rows.
See some records missing from the extension export.

Proposed solution

Remove + index from qTop value calculation.

Thanks

Large data export truncated

First off- love this extension any many of your other great extensions.

Issue I am experiencing is o sense 2.1.1 and occurs when I try to export a dataset with 15 columns and about 80,000 rows.

The number of rows is truncated to 66501 Flanders I do not know why

Calculation condition

Hi Stefan,
in your road map have you the "calculation condition" feature?
Thanks in advance

Piermaria

SSL: User Authentication Required

When loading a Qlik report via an SSL connection, an authentication dialog (see below) always pops up even though the user has already been authenticated via a URL token. We believe this is being caused by a non-https css reference.

Do you have a solution or work-around for this issue?

Vertical alignment?

Hi,

This is a great extension and works really well.

It is stated that the new version enables vertical alignment for the button? but I can't seem to vertically align the button.

Appreciate any help.

Cheers,

Shaun

please re-open issue #3 "Virtual Proxy Without Windows Authentication"

I cannot re-open closed issue #3 . Stefan could you review my comments there and consider reopening it?

Measures always =0

Description

Expressions export always =0

Steps to Reproduce

Insert dimension
Insert expression
Export as xls.
After the export, all measures are not calculated (=0)

Expected behavior

The expression must be calculated

Actual behavior

Expressions always =0

Environment

QlikSense Desktop
QlikSense Enterprise

Operating system

[ x] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[x ] Desktop
[ x] Enterprise

Browser

[ x] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Browser:
Qlik Sense: x
Operating system: x
[Other relevant versions]

Icon Not Showing

Upgraded from Qlik Sense June 2019 to September 2019.

I use an icon to indicate an active button.

Since the upgrade the icon no longer shows.

Environment
Operating system

[ x ] Windows 7 pro
Qlik Sense

[ x ] Desktop
[ x ] Enterprise
Browser

[ x ] Chrome Versions 78.0.3904.97 (64-bit)
[ x ] Firefox Versions 68.2.0esr (32 bit)

Please assist

Export Definition / State not working (as described?)

I see no difference whether state is set to "Possible Values" or "All values". Selections limit what's exported regardless. Do I misunderstand what it's supposed to do? "All values" is really all values while "Possible values" means selected only, right?

Export button does not Render if the Dashboard is embedded in webpage and have multiple dimension with measures

Export button does not Render if the Dashboard is embedded in web page and have multiple dimension with measures

I created some reports in QLIK Sense which are later embedded in Web page using Qlik sense authentication. I used Export button to allow users to extract the data as the QLIK Sense reports looses export data functionality when embedded in the web page.

The reports work well in QLIK Sense Hub with multiple dimensions and measures. However, I found that when I use Export button extension with more than one Dimension and few measures. It renders correctly in embedded web page. But, as soon as I add one more dimension along with other measures, it stops rendering within embedded web page

Steps to Reproduce

Create a sample dashboard in QLIK Sense hub with Export button with Single Dimension and multiple measures.
Embedd this dashboard in Sample web page using Single Configuration in QLIK Dev-hub.
You will notice that the Export button is working fine.
Now add one more dimension in Export button and refresh the embedded web page. The Export button will not render and you will see blank space.

Expected behavior

The Export button should render regardless of how many dimensions are added.

Actual behavior

The Export button did not render in embedded web page when multiple dimensions are added.

Environment

Operating system

Windows 10

Qlik Sense

Enterprise

Browser

[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge

Versions

Extension version: Latest
Browser: All
Qlik Sense Enterprise: FEB 2020
Operating system: Windows

Optional filename

Description

I've noticed that you can define an optional filename for your export. But I can't seem to figure out how to do that.

Steps to Reproduce

Menu 'Export definition | Format' : Open xml (Excel)
Menu 'Export definition | Filename (optional)'
I have tried to add plain text: ='Test' or just without the equal sign 'Test'
And I've tried using a function like =Date(Today())

Expected behavior

I expect the filename to have a name like 'Test.xlsx' or '14-9-2017.xlsx'

Actual behavior

But the filename still had the predefined code.

Environment

Operating system

[ X] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[ ] Desktop
[ X] Enterprise

Browser

[ X] Chrome
[ ] Firefox
[X ] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Extension version: Latest version, 1.3.5
Qlik Sense: 3.1 SR 1

Stefan, I need some help

I would have contacted you directly, but could not find a way.

I am trying to use sense-export for a specific need of exporting a csv file that needs an EDI Header and the headers and data below it.

I am trying to use the Title to accomplish this. The issue is I cannot figure out how to get the title to export as a part of the csv. I know this is not a normal request. I have tried to make the changes to make it work, but I am not getting what I need.

Would you be able to assist in what would need to be done to accomplish this?

Thanks,

Mike Coleman

Vertical Alignment

Allow vertical alignment by a new property

IE11 alignment option doesn't work

Description

This is rendered in IE11:

Steps to Reproduce

Just open F12.

Expected behavior

text-align property should be valid CSS.

Actual behavior

text-align property contains variables that couldn't be rendered by the browser (IE11).

Environment

IE11 on Win 10 and Win 7.

Operating system

[x] Windows
[ ] OSX
[ ] Linux

Qlik Sense

[x] Desktop
[x] Enterprise

Browser

[ ] Chrome
[ ] Firefox
[x] Internet Explorer
[ ] Edge
[ ] Others: XXX

Versions

Extension version: 1.3.5
Browser: 11
Qlik Sense Desktop: April 2018
Qlik Sense Enterprise: April 2018
Operating system: Windows 10

wbfolder.wbl file missing

Hello,

in version 3.0.0 of Sense I cannot use the extension, the error in Sense Desktop is that the wblfolder.wbl file is missing (in dev-hub). I tried to write one on my own but it still does not work. Also on Sense Server 3.0.0 I cannot upload the extension getting the error of a duplication...? I think the reason should be the same. The Qlik Support also mentioned that the format of the swr-sense-export.qext looks quite old.

KR
Lukas

Export in Firefox

When attempting to use this button in firefox, a "Connection lost" error is thrown
It totally locks up the application.
It will still generate the excel worksheet.

Works fine in Chrome

Environment:
QlikSense Server (3.0.1)
Embedded via single configurator into our flagship application.

Any ideas?

Debug mode not working

The debug-mode should display a table of the data defined.
This is not working since an unofficial call (fetching a state in the AngularJS scope) was used. This has changed in Qlik Sense 3.0
Use the official call qlik.navigation.getMode (https://help.qlik.com/en-US/sense-developer/2.2/Subsystems/APIs/Content/NavigationAPI/NavigationAPI.htm) instead.

Action required: Greenkeeper could not be activated 🚨

🚨 You need to enable Continuous Integration on all branches of this repository. 🚨

Since we did not receive a CI status on the greenkeeper/initial branch, we assume that you still need to configure it.

We recommend using Travis CI, but Greenkeeper will work with every other CI service as well.

Problems of visualization

Hi everybody.

I've been working with this extension and it works fine with CSV, but to export in XML doesn't.
However, this extension already doesn't work, now appear this message in Qlik Sense: "Invalid visualization. The visualization was not found on the server: swr-sense-export"

Can you help us with this issue?
Thanks a lot

Import Error

Hello,

I'm having an issue importing the extension in version 2.2.4 "Server, not Desktop" I'm logged on as the administrator with all the security roles. When I go to import it errors our right away. I can see a folder was created "swr-sense-export" I have deleted the file and retried the import again.

We are looking to add the option to export to .csv

Thanks
Nathan

Unable to export on mashup

We are using this export widget on our public mashup but the QAP security is blocking the export functionality.

stefanwalther / sense-export Goto Github PK

sense-export's Introduction

sense-export

Table of Contents

Purpose and Description

Why?

Screenshots

Installation & Download

Configuration

Dimensions & Measures

Button label

Button layout

Export definition

A note on "Comma separated CSV - Client Side"

Debug

Compatibility

Known Issues

Related Projects

About

Change Log

Contributing

Using the Project in Dev-Hub

Author

License

sense-export's People

Contributors

Stargazers

Watchers

Forkers

sense-export's Issues

Description

Steps to Reproduce

Expected behavior

Actual behavior

Environment

Operating system

Qlik Sense

Browser

Versions

Environment

Operating system

Qlik Sense

Browser

Versions

Operating system

Qlik Sense

Browser

Versions

Description

Steps to Reproduce

Expected behavior

Actual behavior

Environment

Operating system

Description

Steps to Reproduce

Expected behavior

Environment

Operating system

Qlik Sense

Browser

Description

Operating system

Qlik Sense

Browser

Versions

Description

Steps to Reproduce

Environment

Operating system

Qlik Sense

Browser

Description

Steps to Reproduce

Expected behavior

Actual behavior

Environment

Operating system

Qlik Sense

Browser