topic Re: command for Email in QlikView

command for Email

Mon, 22 Dec 2014 17:58:48 GMT

Hi ,

Is it possible to send an email throguh Script (not as a Button Click) command.

I want to send an email if the amount(ITEM_AMT) exceeds over a specifc value.

Thanks inadvance.

Re: command for Email

jschrader — Mon, 22 Dec 2014 18:05:43 GMT

Under tools, alerts, you can send emails based upon conditions. Also, the email can be sent after an event such as a reload.

Re: command for Email

Anonymous — Mon, 22 Dec 2014 18:19:19 GMT

Jhansi

These Alerts that Jason suggests are what I use & they work perfectly for me.

I have seen posts on this community from people who cannot get such Alerts to work. I'll be interested to see how you fare. Dont be out off by my saying this,as it works fine for me & should do also for you.

There was a QlikView SR that had problems with Alerts, what version are you using ?

Re: command for Email

Mon, 22 Dec 2014 18:21:05 GMT

Hi Jason,

Thank you for your quick response. Yes. I can send the alert in this way. The problem is It is based on alert List.xls file which has the follwing fields like

Region ,Country ,Customer, Amount ,EmailID

So If a particular customer amount exceeds a specific value then need to send to the Eamil specified and this alert List.xls keep on changing every day.

Re: command for Email

Mon, 22 Dec 2014 18:25:28 GMT

I am using QV11.2 SR7

Re: command for Email

rwunderlich — Mon, 22 Dec 2014 19:00:12 GMT

It's a little challenging to fire a variable number of alerts to different email addresses. You may find it easier to use a commandline email program like blat and call the program using the script EXECUTE command.

-Rob

Re: command for Email

jschrader — Mon, 29 Dec 2014 16:13:32 GMT

Rob,

I was wondering if you could explain how to calculate the actual RAM impact that we talked about at the conference? Thanks!

Re: command for Email

rwunderlich — Mon, 29 Dec 2014 18:12:29 GMT

Hi Jason,

I started a new thread to address your question here:

RAM requirements for a document

-Rob

Re: command for Email

ecolomer — Mon, 29 Dec 2014 20:24:26 GMT

Here you have an example:

Re: command for Email

Mon, 29 Dec 2014 20:38:40 GMT

Thank you for posting a sample code. It helped me.

Re: command for Email

ecolomer — Mon, 29 Dec 2014 21:15:12 GMT

I'm happy help you

Re: command for Email

vikasmahajan — Tue, 30 Dec 2014 07:59:27 GMT

PFA sample

Vikas

Re: command for Email

rwunderlich — Tue, 30 Dec 2014 16:41:19 GMT

I don't think the macro solutions presented here will not work in a server reload. They require System Access, which you cannot get in a server reload. These solutions are ok if you are doing manual reloads.

-Rob

Re: command for Email

Mon, 05 Jan 2015 14:16:01 GMT

Hi Rob,

Yes. I can able to reload in my machine. When i deploy in Server it is not working. It is showing the error like "Client was not authenticated". The details i provided are

1. Running macro with "System Access" Mode

2. Giving SMTP Server Name & Port

3. Not providing any authentication(Username & Password) - is it required?

What are the other steps to be taken for working in Server?

Re: command for Email

Mon, 05 Jan 2015 15:31:11 GMT

Another Issue. I tried to send an email on button event trigger. I used same code for this too.

I opened the file in Accesspoint and triggered the button, but it didnot work.

Could you please let me know the reasons why it failed?