Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

State of task via email

Hi Folks, 

i got a Question: Is that possible to make any selection within QMC to make possible any alert-email, when something gone wrong and when everything does work well in QMC.

at the moment i check everyday all my Task manually: i am opening my QMC to check all Status.

 

can i activate any selection to recieve every day the email with Status?

 

Thanks a lot

Beck

Labels (1)
4 Replies
Highlighted
Creator III
Creator III

In the QMC directly you are not able to configure e-mail alerts.

 

However, if you install the web connectors you are able to aim this.

You need to create two apps and add a task based on the App you want to know if has been updated correctly or not:

  1. The first App will reload in case the Apps reload fails
  2. The second App will reload in case the Apps reload success

These Apps will have a message like follows and will send to the wanted mail the message you want

RestConnectorMasterTable:
SQL SELECT
"status",
"result",
"filesattached"
FROM CSV (header on, delimiter ",", quote """") "CSV_source"
WITH CONNECTION (
QUERY "to" "destination e mail address",
QUERY "subject" "Subject",
QUERY "message" "Message",
QUERY "fronName" "noreply",
QUERY "fromEmail" "email address",
QUERY "format" "csv");

 

You need to create the SMTP connection

 

http://localhost:5555/data?connectorID=SMTPConnector&table=SendEmail&SMTPServer=xxxxx&Port=25&SSLmode=None&to=mail&subject=asdfdsa&message=asdfasdf&html=True&fromName=app-invqlik&fromEmail=mail&delayInSeconds=0&ignoreProxy=False&appID=&asDownload=true&format=csv

Highlighted
Master
Master

Hi Lanlizgu,

 

thanks a lot for your responce. Do you have an example to this issue?

Highlighted
Creator III
Creator III

Yes, I have examples but can't share.

 

However, if you follow this video you should be able to develop it 

 

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Sending-Emails-with-Qlik-Sense/ta-p/16...

Highlighted
Master
Master

Thanks a lot for your responce, i wll let you know when i solved the issue