article Qlik Sense App: Send Data From The Load Script in Qlik Sense Documents

Qlik Sense App: Send Data From The Load Script

stevedark — Wed, 20 Mar 2019 00:01:42 GMT

QlikView has two features which allow it to send alerts and data to the user, using Alerts in the front end or QMC notifications on the Server. Presently Sense lacks these out of the box, but it is possible to implement the same using the free Qlik Web Connectors SMTP Connector.

This application implements the sending of data as an HTML table embedded in an email each time an app is reloaded.

It was produced to go alongside this blog post, which describes the process in detail:

https://www.quickintelligence.co.uk/send-data-from-qlik-load-script/

I hope that you find the application useful. You will find other applications that I have uploaded under my profile on QlikCommunity or on our Downloads page..

Steve

https://www.quickintelligence.co.uk/blog/

Re: Qlik Sense App: Send Data From The Load Script

nasirsaikh — Mon, 05 Nov 2018 04:48:43 GMT

Very Helpful thanx for sharing....

Re: Qlik Sense App: Send Data From The Load Script

Anonymous — Mon, 05 Nov 2018 11:29:15 GMT

Nice, thanks for sharing

Re: Qlik Sense App: Send Data From The Load Script

beck_bakytbek — Fri, 09 Nov 2018 10:45:51 GMT

Thanks a lot for sharing Steve

Re: Qlik Sense App: Send Data From The Load Script

stevedark — Fri, 09 Nov 2018 11:10:41 GMT

Thanks all, glad you find it useful.

Re: Qlik Sense App: Send Data From The Load Script

Thiago_Justen_ — Fri, 16 Nov 2018 01:42:43 GMT

Very useful @stevedark.

Re: Qlik Sense App: Send Data From The Load Script

Johnson_Yao — Fri, 06 Sep 2019 01:38:36 GMT

I am facing a Service Unavailable issue. Is there anything I need configure?

Re: Qlik Sense App: Send Data From The Load Script

stevedark — Fri, 06 Sep 2019 07:46:58 GMT

Hi @Johnson_Yao It's either going to be something in your QWC setup or the configuration of the GMail settings. The first thing to do to validate anything in QWC is to copy the URL into a browser on the machine where QWC is installed (I see this is also your Sense server, as you are using LocalHost). This will often yield a better error message. It would appear that you have not updated the fromEmail parameter to an email address that you own, and therefore I'm not sure what password you will have used. You will need to configure SMTP and user parameters to match a server you have rights to relay from. Setting up a new GMail account will be one way of doing this. You will need to configure it (in GMail settings) to allow relaying via SMTP. Hopefully that will point you in the right direction. Post back to let me know how you get on. Cheers

Re: Qlik Sense App: Send Data From The Load Script

Johnson_Yao — Mon, 09 Sep 2019 00:58:23 GMT

@stevedarkThank you for your feedback!

I have solved the Service Unavailable issue. But I am facing another Internal Server Error. I tried to change the Email parameter to what is my personal email like smtp.163.com. Please go through the attached pictures which will show you what I did.

I also have questions:

1. Is this solution able to run in localhost? Or it is only be run in server?

2. Can this solution only use gmail? May I use other email service?

Re: Qlik Sense App: Send Data From The Load Script

Johnson_Yao — Mon, 09 Sep 2019 04:37:03 GMT

@stevedarkGood news! I sent mail via this solution successfully! The Internal Server Error caused by internet issue. I configured the company domain SMTP, then it is successful. Please ignore the before message.

I received the email like this. Email just shows the HTML file address, does not show the table directly? As I understand, the table should be shown in the mail. Is there any configuration which I set wrong?

Re: Qlik Sense App: Send Data From The Load Script

Johnson_Yao — Mon, 09 Sep 2019 06:58:48 GMT

@stevedarkGood news again! All the issues have been solved. I can use Send Data From The Load Script successfully.

I cannot show the table in email, because of access declined. I changed the deploy.config as <FileSystemAccessAllowedPaths>*</FileSystemAccessAllowedPaths>. The script can read the HTML right now.

It is a real useful solution to send data.

Re: Qlik Sense App: Send Data From The Load Script

stevedark — Mon, 09 Sep 2019 07:57:44 GMT

Hi @Johnson_Yao

Sorry I didn't chip in as you were getting this working, it was overnight for me.

Pleased to wake up to find you got it all working. Thanks for sharing about the config setting needed to make it work for you.

Cheers,

Steve

Re: Qlik Sense App: Send Data From The Load Script

Johnson_Yao — Tue, 10 Sep 2019 01:34:44 GMT

@stevedarkAnother further question about send picturelike *.png via SMTP connector. Is it possible to send a picture in load script?

Re: Qlik Sense App: Send Data From The Load Script

stevedark — Tue, 10 Sep 2019 06:23:01 GMT

Yes. Refer to the file on disk in the same way as you do the HTML to add an attachment. I'm not sure you can embed one in the message, though I would have thought there will be a way.

You can always put the image on a web server and refer to it there in HTML, or UUEncode the image and have it in plain text.

Good luck!

Re: Qlik Sense App: Send Data From The Load Script

Johnson_Yao — Tue, 10 Sep 2019 07:33:37 GMT

@stevedark I write the code:

***<table>
***<tr><img src=file://C:/temp/logo.PNG width=420 height=120></tr>
***</table>

to show the logo successfully.

I am continue thinking about how to add iframe which I copied from embed.

I pasted the <iframe> into script like this:

***<table>
***<iframe src=http://localhost:4848/single/?appid=D%3A%5CUserData%5Cz003wnbw%5CDocuments%5CQlik%5CSense%5CApps%5COrder%20intake.qvf&obj=SsCuK&opt=ctxmenu,currsel style=border:none;width:100%;height:100%;></iframe>
***</table>

But when I load the data, the HTML will show as below:

***<table>
***<iframe src=http://localhost:4848/single/?appid=D%3A%5CUserData%5Cz003wnbw%5CDocuments%5CQlik%5CSense%5CApps%5COrder%20intake.qvf&obj=SsCuK&opt=ctxmenu
***</table>

something missed (,currsel style=border:none;width:100%;height:100%;></iframe>). So the iframe cannot be show successfully in the mail.

Would you please help to look into this

Re: Qlik Sense App: Send Data From The Load Script

stevedark — Tue, 10 Sep 2019 07:45:37 GMT

The issue is that the comma is being treated as the end of the field in Sense and only the first of two fields on that row is then written out. If you can drop the selection style from the URL then it may then work. Note that it will only work if the email is being read on the Sense server, as you are referring to Localhost. You will need to swap this out with the server address for it to work when received by others. Note that the recipient will also need to have a licence to the server with that object on it. I'm not sure how mail clients will react to the fact you have an iframe in your HTML, they may see it as a security risk and block it. Steve

Re: Qlik Sense App: Send Data From The Load Script

Johnson_Yao — Tue, 10 Sep 2019 07:52:06 GMT

@stevedarkThank you for your clear explanation! I also think the issue is caused by comma, but I don't know how to solve. I am not familiar with HTML. I will try your solution. I am just working on my local environment for solution validation. So there's no security right now.

Thank you very much! Keep in touch.

Re: Qlik Sense App: Send Data From The Load Script

Johnson_Yao — Tue, 10 Sep 2019 08:54:23 GMT

@stevedarkYes， you are right, outlook react the iframe. 😂 So it is impossible to add qlik app in to email. Right? Do you have any other solution?

Re: Qlik Sense App: Send Data From The Load Script

stevedark — Tue, 10 Sep 2019 20:37:03 GMT

I believe that with the API you can call a URL which will create a PNG of the chart you are wanting. This is not something that I have attempted though. Out of the box the best way will be a link that the user clicks to get to the content. If you want a charts in an email, with a UI for setting up and configuring these, then you should look at NPrinting. Alternatively, you can build things in plain HTML and send using the method above. Combine that with https://www.image-charts.com/ and you can get some good looking charts, with a bit of effort and tweaking. Good luck!

Re: Qlik Sense App: Send Data From The Load Script

AV1 — Tue, 14 Dec 2021 10:00:46 GMT

Hi Steve,

Thanks for the blog very helpful. But I'm getting noFileSize error. Not sure why its happening as I have encoded the password and I can see the html file getting stored. Can you please help me on that ?