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?
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:
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 😉
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.
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.
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
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.
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?
