topic Re: How to call power shell script in Qlikview in QlikView

How to call power shell script in Qlikview

keerthika — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

My code is executing in powershell but how to call that script stored in txt file from qlikview, i have encrypted the password here

$Username = "test"

$Password = "D:\test\EmailPassword.txt"

$MyCredential=New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $Username, (Get-Content $Password | ConvertTo-SecureString)

$From = "test@gmail.com"

$To = "test@gmail.com"

$Subject = "Here's the Email Subject"

$Body = "This is what I want to say"

$SMTPServer = "smtp.gmail.com"

$SMTPPort = "587"

Send-MailMessage -From $From -to $To -Subject $Subject -Body $Body -SmtpServer $SMTPServer -port $SMTPPort -UseSsl -Credential ($MyCredential) –DeliveryNotificationOption OnSuccess

Thanks in advance,

keke

Re: How to call power shell script in Qlikview

tresB — Tue, 09 Oct 2018 05:20:40 GMT

Try using qlik's Execute command. Have a look here too: QlikView and Windows PowerShell

Re: How to call power shell script in Qlikview

keerthika — Tue, 09 Oct 2018 05:51:59 GMT

Hi,

I used below command to run powershell script in qlikview. but is shows some error .

Execute cmd /C powershell -command c:\temp\enviar_email_correto.ps1;

Thanks,

Keke