stefanwalther / sense-export Goto Github PK
View Code? Open in Web Editor NEWJust a simple button to export data in your Qlik Sense applications.
License: Other
Just a simple button to export data in your Qlik Sense applications.
License: Other
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
For November 2017 and versions above, prefix is not being identified 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);
The prefix should be identified properly as expected
Chrome
All OS
[ ] Windows
[ ] OSX
[ ] Linux
All
[ ] Desktop
[ ] Enterprise
All
[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX
This is rendered in IE11:
Just open F12.
text-align
property should be valid CSS.
text-align
property contains variables that couldn't be rendered by the browser (IE11).
IE11 on Win 10 and Win 7.
[x] Windows
[ ] OSX
[ ] Linux
[x] Desktop
[x] Enterprise
[ ] Chrome
[ ] Firefox
[x] Internet Explorer
[ ] Edge
[ ] Others: XXX
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
[Description of the issue]
[What you expected to happen]
[What actually happened]
[Please include log files (e.g. Qlik Sense Server logs or Chrome Dev Tools' console output to the issue).]
[ ] Windows
[ ] OSX
[ ] Linux
[ ] Desktop
[ ] Enterprise
[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX
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.
[ ] Windows 7 Enterprise
[ ] Enterprise
[ ] Internet Explorer
File Name (Optional) is not working
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)
[x] Windows
[ ] OSX
[ ] Linux
[ ] Desktop
[x] Enterprise
[ ] Chrome
[ ] Firefox
[x] Internet Explorer
[ ] Edge
[ ] Others: XXX
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]
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."
The extension shows the properties pane and allows normal configuration.
Extension appears to not be installed, but it, but doesn't function.
[x ] Windows
[ ] OSX
[ ] Linux
[ x] Desktop
[ x] Enterprise
[ ] Chrome
[x ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX
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
Hello,
I downloaded the sense excel extension lately. I have all the requirements installed and verified, but:
Thank you for your help!
Nancy Sbeity
🚨 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.
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.
I expect the filename to have a name like 'Test.xlsx' or '14-9-2017.xlsx'
But the filename still had the predefined code.
[ X] Windows
[ ] OSX
[ ] Linux
[ ] Desktop
[ X] Enterprise
[ X] Chrome
[ ] Firefox
[X ] Internet Explorer
[ ] Edge
[ ] Others: XXX
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?
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.
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.
[ X ] Windows
[ ] OSX
[ ] Linux
[ X ] Desktop
[ ] Enterprise
[ X ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX
Expressions export always =0
The expression must be calculated
Expressions always =0
QlikSense Desktop
QlikSense Enterprise
[ x] Windows
[ ] OSX
[ ] Linux
[x ] Desktop
[ x] Enterprise
[ x] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX
Hello
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
};
Remove + index from qTop value calculation.
Thanks
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]
[What you expected to happen]
[What actually happened]
[Please include log files (e.g. Qlik Sense Server logs or Chrome Dev Tools' console output to the issue).]
[ ] Windows
[ ] OSX
[ ] Linux
[ ] Desktop
[ ] Enterprise
[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX
I cannot re-open closed issue #3 . Stefan could you review my comments there and consider reopening it?
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.
Qlik Sense Enterprise April 2018
[x] Windows
[ ] OSX
[ ] Linux
[ ] Desktop
[x] Enterprise
[x] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX
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
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.
🚨 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.
On a fresh clone of this project, a 'build' completes successfully while a 'release' fails
yarn
to gather all dependencies./node_modules/.bin/sense-go build
- the command completes successfully./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
./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.
The build should completes successfully for the 'release' task.
See section 'Steps to reproduce'.
[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 does not work as expected when export setting is set to "comma separated CSV - client side"
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.
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.
[x] Windows
[ ] OSX
[ ] Linux
[ ] Desktop
[x] Enterprise
[x] Chrome
[x] Firefox
[x] Internet Explorer
[ ] Edge
[ ] Others: XXX
[Description of the issue]
[What you expected to happen]
[What actually happened]
[ ] Windows
[ ] OSX
[ ] Linux
[ ] Desktop
[ ] Enterprise
[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX
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
Despite selecting csv from the settings, the extension only exports Xlsx. Using sense 2.1.1
Hi Stefan,
in your road map have you the "calculation condition" feature?
Thanks in advance
Piermaria
We are using this export widget on our public mashup but the QAP security is blocking the export functionality.
I would really appreciate an export definition "Semicolon Separated CSV".
I can't edit the extension by myself because of the missing wbl-file.
🚨 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.
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?
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.
Allow vertical alignment by a new property
CSV_CLIENTSIDE misses 1 entry every 500 entries.
A table exported through this method should show all entries
The generated export lacks 1 entry every 500 entries.
[No logs are needed for this since it's easily reproduced with any data]
[* ] Windows
[ ] OSX
[ ] Linux
[ ] Desktop
[* ] Enterprise
[* ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX
[Description of the issue]
file downloads on the client side
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.
[x ] Windows
[ ] OSX
[ ] Linux
[ ] Desktop
[x ] Enterprise
[ x] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: XXX
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
The Export button should render regardless of how many dimensions are added.
The Export button did not render in embedded web page when multiple dimensions are added.
Windows 10
Enterprise
[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
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.
[ ] Windows
[ ] Enterprise
[ ] Chrome
[ ] Firefox
[ ] Internet Explorer
[ ] Edge
[ ] Others: Safari
... 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 ;-)
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!
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
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?
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
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
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).
Exported CSV should contain value of all added dimensions and Measures.
Exported CSV has only headings and no data starting 21st dimension/measure (column).
QlikSense September 2017
[ 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]
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.