email from QlikView

[datanibbler]

Hi,

this is a rather old and already-much-discussed feature. Still: I have the following dilemma:

- I have both QVS and RtM (a third-party tool to automate reports) running on the company server.

- This server, for very understandable reasons, does not and will not have Outlook or any other emailing program installed.

- I can set up in any QlikView_app an alert with emails - those emails will be triggered upon Reload on the server, but only
   be sent once I open the app locally. I can, however, do that by simply putting it in the "Startup" folder, so it will be
   started in the morning once I boot up my laptop.
   I can also set for this alert a condition that can never be true, so it will fire daily and send those emails.
   <=> I cannot add any attachments to those emails.

Can any of you suggest to me a possible way around this dilemma?

Thanks a lot!

Best regards,

DataNibbler

[marcus_sommer]

Hi DataNibbler,

I run the most tasks with my own domain-account and therefore I don't need authentication for this vbs-mailing or for the mail-settings within the user-properties. In the qmc I use also my account with my credentials (our server-user could only run the server itself).

I would try it at first local without and with credentials - for this there are special cdo-settings:

http://www.paulsadowski.com/wsh/cdo.htm

'Your UserID on the SMTP server
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusername") = "youruserid"

'Your password on the SMTP server
objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "yourpassword"

If all this isn't successful then it could be helpful to ask someone with more experience with this topic like Paul Sadowski.

- Marcus

[datanibbler]

Hi Marcus,

ok, forget it for the moment. I'm going to do that together with an external Qlik_consultant we have. There is still one day of a Workshop open which we already paid. We're going to do it then.

Just one question:

I would like to get an ebook on the topic of VBS to advance my own skills in that respect - which makes me wonder, do I have to mind a difference like that between "Java" and "Javascript" - which are two completely different things which I learned AFTER having bought a book 😉

[marcus_sommer]

Hi DataNibbler,

there isn't a ebook available about qlikview-vbs or one which contained a significant part. But for vbs you will find various possibilities like this: http://xgangand.free.fr/adm/files/books/scripting/microsoft_vbscript_step_by_step.pdf - I hope it's legal published.

But to work through such book will be a lot of effort and it's not specific to qlikview. Therefore I think it's better to read the short chapter within the help and then look into the APIGuide.qvw - there you could learn a lot about the object-model within qlikview and there are also many examples available.

- Marcus

[datanibbler]

Ah,

so the vbs that is used in QlikView is different from or a part of the whole of VBS?

I will have a look at that qvw - where can I find that?

You are right in looking at the relation between the effort and the good it will do - I am sure knowing VBS would be helpful, but I do have to look at the time I have to spend - although, while there is no real management_focus on QlikView here, I am m.o.l. free to make my own agenda and decide what is worth spending time on.

Thanks a lot!

Best regards,

DataNibbler

[marcus_sommer]

Hi DataNibbler,

most of the qv-vbs implementation will be quite the same like the origin vbs with a few exeptions like error-handling (is descripted in the help) but it is of course adjusted to the qv-object.model.

You will find the APIGuide.qvw in your install-folder by automation but within the community there are also versions available: http://community.qlik.com/docs/DOC-7448

- Marcus

[datanibbler]

Thanks a lot!

And if you don't mind, please upload the help_file from your client (you have a current one, I take it?) Mine is very outdated, so I don't quite trust that what's written in my help_file is really up to date.

[marcus_sommer]

My version is older than this one from the link above - it seems that in QV 11 this app isn't more available anymore. Maybe someone else has a newer version?

- Marcus

[marcus_sommer]

There is: http://community.qlik.com/message/268795#268795