Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
QSense
Contributor II

sending alert mail when getting error while reloading

hello everyone,

I want to send email while my document gets error when reloading.

my script is:

SET ErrorMode=0;

LOAD AA,

     B,

     C

FROM

(ooxml, no labels, table is Sheet1);

SET ErrorMode=1;

I added alert. for condition I wrote ScriptErrorCount<>0 but any email comes to mail adress.

Is there anyone who met this problem before

thanks.

Tags (1)
5 Replies
swarup_malli
Valued Contributor

Re: sending alert mail when getting error while reloading

Ahnet,

Do you mean when the reload fails on the QV server an email should be sent to the concerned person ?

SM


QSense
Contributor II

Re: sending alert mail when getting error while reloading

yes exactly I mean that. Swarrup

balrajprabhu
Contributor

Re: sending alert mail when getting error while reloading

Type the email id in the spot that has been highligted with an black ellipse.

qvCommunity.png

QSense
Contributor II

Re: sending alert mail when getting error while reloading

I know management console side.In there alerts system is available for all server dcuments.

I want only for a specified document.

It can be made by alert but ı couldnt succeeded

hectorgarcia
Contributor III

Re: sending alert mail when getting error while reloading

modify your script to:

table:

LOAD * INLINE [

dummyfield

];

SET ErrorMode=0;

Concatenate (table)

table:

LOAD AA,

     B,

     C

FROM

(ooxml, no labels, table is Sheet1);

SET ErrorMode=1;

let vAlert=NoOfRows('table');

then in the ui you can set up the alert tools\alerts based on the value of the variable vAlert

I hope it helps

Hector

Community Browser