topic Re: QV Email and Gmail SMTP in QlikView

QV Email and Gmail SMTP

Fri, 17 Dec 2010 06:10:01 GMT

Hi All,

Anyone know how to configure the mail settings for using gmail smtp? I configure the mail server settings in User Preference -> Mail. I tried all the authentication method, but it doesn't work (no SSL or TLS option in the authentication method). This is for sending an Alert email.

QV Email and Gmail SMTP

suniljain — Fri, 17 Dec 2010 07:35:27 GMT

only SMTP require that is SMTP server's IP and Port no.

QV Email and Gmail SMTP

Fri, 17 Dec 2010 07:48:24 GMT

This is the error. GMail SMTP require TTL/SSL encryption.

QV Email and Gmail SMTP

suniljain — Fri, 17 Dec 2010 08:14:44 GMT

pls allow your sending mail server to send mail through SMTP Server. you have to give permission on SMTP mail server for Qlikview server 's IP and port no.

QV Email and Gmail SMTP

Fri, 17 Dec 2010 12:10:50 GMT

Hi Sunil,

My email client is using the same setting and it is working fine. I believe it is the STARTTLS option is the issue. Maybe QlikView doesn't support encrypted connection?

QV Email and Gmail SMTP

Wed, 08 Jun 2011 08:26:16 GMT

Hi khim_hoe,

since the version 10.5 NPrinting support SMTP with TTL/SSL encryption for QlikView. So if you still need it and it's to send reports in pdf or excel format via mail I would to suggest you to take a look to this blog post:

http://www.nprinting.com/blog/qlikview_images_ssl_tls_mapi/

Best

The NPrinting Team

QV Email and Gmail SMTP

Wed, 28 Mar 2012 20:51:17 GMT

Will there ever be support for SMTP TLS in QlikView designer (under user preferences)? I know there is support in the NPrinting product but am setting up an Alert in the designer that will send out an email based on an expression

Re: QV Email and Gmail SMTP

Wed, 28 Mar 2012 20:52:08 GMT

Re: QV Email and Gmail SMTP

Emmanuelle__Bustos — Tue, 05 Feb 2013 18:35:36 GMT

Hello Friends,

Do you know if there is a way to set the alerts via email in the QV Server --> mail server tab because i tried and it sends the error:

"The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. xd4sm23866094igb.3 - gsmtp"

Re: QV Email and Gmail SMTP

Bill_Britt — Tue, 05 Feb 2013 20:31:20 GMT

This should help you. However, it is not supported.

Bill

Re: QV Email and Gmail SMTP

Emmanuelle__Bustos — Tue, 05 Feb 2013 22:28:56 GMT

Bill Britt

Thank you, but for now i'm using a mail server from my company, and it's working good!

Re: QV Email and Gmail SMTP

Tue, 15 Apr 2014 15:36:33 GMT

I would like to setup SMTP for my company and additional gmail id's. Can you pls guide me to follow the steps. Thanks,

Re: Re: QV Email and Gmail SMTP

Bill_Britt — Tue, 15 Apr 2014 17:40:10 GMT

I want to update this post. QlikView can now do the Use SSL For SMTP. See the attached document.

Re: QV Email and Gmail SMTP

Emmanuelle__Bustos — Tue, 01 Jul 2014 21:50:30 GMT

Hi Bill,

I tried as this document reads but the QMC sends the same error:

The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. ot3sm45362488obc.13 - gsmtp

I have setup QVS 11.20 SR6 11.20.12354

Change the line in the QVManagementService.exe.config file:

Restarted all QV services and even restarted the machine but it doesn't work. Am I missing something?

Re: QV Email and Gmail SMTP

Bill_Britt — Wed, 02 Jul 2014 12:26:06 GMT

You have enable the wrong line. Go down two lines and set UseSSLForSMTP to true.

bill

Re: QV Email and Gmail SMTP

Emmanuelle__Bustos — Wed, 02 Jul 2014 15:09:15 GMT

Oh you're right Bill my apologies for that. I changed back the line I modified and set true that line UseSSLForSMTP and now its working.

It's a great relief that now QVS supports this kind of mail servers.

Once again thank you so much for taking your time to help me.

Best Regards!!!

Re: QV Email and Gmail SMTP

Emmanuelle__Bustos — Wed, 02 Jul 2014 15:11:04 GMT

Hi khim_hoe

you should mark this post as solved by the @bbt 's answer.

Re: QV Email and Gmail SMTP

senarath — Tue, 12 Aug 2014 11:43:43 GMT

Hi Bill,

Finally I saw this post on the tic that I wanted to get some advice too.

I'm having Small Business Edition 11.2SR7 and when I configure mail alert for failed reloads in QMC, all the scheduled reloads got failed and start getting mail alert for failed reloads. But in fact, scheduled reloads got failed only after configuring the alert.

When I removed mail alert settings, reloads were in order.

Any advice on this please....

Many thanks.

Senarath

Re: QV Email and Gmail SMTP

Thu, 02 Oct 2014 15:38:33 GMT

If in my "QVManagmentService.exe" I dont have those lines, what does that means?

<add key="UseSSLForSMTP" value="true"/>

Also I cant find the "QVManagmentService.exe.config"

Any support on this?

Regards!

Re: QV Email and Gmail SMTP

Wed, 15 Oct 2014 17:56:22 GMT

emmanuelle bustos hi.

How do send two or more emails?

I try in field Send all e-mails to: put user1@email.com; user2@email.com;user3@email.com, but unsucess.

Regards.