Qlik Sense App: Send Data From The Load Script

[stevedark]

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/

[nasirsaikh]

Very Helpful thanx for sharing....

[Anonymous]

Nice, thanks for sharing

[beck_bakytbek]

Thanks a lot for sharing Steve

[stevedark]

Thanks all, glad you find it useful.

[Thiago_Justen_]

Very useful @stevedark. 

[Johnson_Yao]

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

[stevedark]

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

[Johnson_Yao]

@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?

[Johnson_Yao]

@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?

[Johnson_Yao]

@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.