topic Re: Task Scheduler does not work with macro in QlikView

Task Scheduler does not work with macro

sifatnabil — Thu, 28 May 2015 06:31:59 GMT

Hi all,

I have a batch file setup on Windows Task Scheduler which works fine with the following code in the batch file:

echo off

echo.

echo Initialize the log file with Command Line reload...

echo Run QlikView and Reload Data...

"C:\Program Files (x86)\QlikView\Qv.exe" /r "C:\Users\bob\Dashboard.qvw"

However, the same batch file does not work if the Qlikview document has a macro that is triggered OnOpen. What might the issue be?

Re: Task Scheduler does not work with macro

mohammadkhatimi — Thu, 28 May 2015 06:35:48 GMT

hie...

.bat file contains below code...

@ECHO OFF

"C:\Program Files\QlikView\qv.exe" /r "Path of your qlikview file"

ECHO Application Reload Completed!

Batch file is been schedule in task schedular..At what time you have to reload..

Hope this will help you

Regards,

Mohammad

Re: Task Scheduler does not work with macro

sifatnabil — Thu, 28 May 2015 06:38:23 GMT

Hi, it doesn't work if the Qlikview document has a macro triggered OnOpen.

Re: Task Scheduler does not work with macro

jerrysvensson — Thu, 28 May 2015 08:34:04 GMT

It should work. What happens?

Re: Task Scheduler does not work with macro

sifatnabil — Thu, 28 May 2015 08:45:11 GMT

Nothing happens actually. It just says "Running". If I double click the batch file though, it works. Just not through Windows Task Scheduler. Are there any alternative task schedulers I could try out?

Re: Task Scheduler does not work with macro

jerrysvensson — Thu, 28 May 2015 08:55:42 GMT

If you remove all actions from OnOpen does it work then?

Also, if Task scheduler runs on a different account then yours it needs a license, That is probably the issue here,

Re: Task Scheduler does not work with macro

rohit214 — Thu, 28 May 2015 09:05:43 GMT

try this

"C:\Program Files (x86)\QlikView\Qv.exe;" /r "C:\Users\bob\Dashboard.qvw;"

Re: Task Scheduler does not work with macro

sifatnabil — Thu, 28 May 2015 09:16:08 GMT

Well it works with the other batch file, so license is not an issue. If I remove OnOpen, how do I make the Qlikview doc automatically run the macro?

Re: Task Scheduler does not work with macro

jerrysvensson — Thu, 28 May 2015 09:22:24 GMT

Well it might be something in your macro that stops the loading process.

Can you give us the code?

Re: Task Scheduler does not work with macro

sifatnabil — Thu, 28 May 2015 09:33:46 GMT

Sure, I used the code to send PDF reports via email:

Sub Bonds

vReport = "RP19" 'Set report

vName = "Bonds" 'Name of output pdf

ActiveDocument.PrintReport(vReport), "Bullzip PDF Printer", false 'Printreport

reportFile = "Z:\Reporting\PDF Reports\" & vName &".pdf" 'Setting outputname

MyPrintPDFWithBullZip(reportFile) 'Call pdf printer

ActiveDocument.GetApplication.Sleep 5000

zendDagrapportBonds

End sub

function zendDagrapportBonds()

Dim objEmail

Const cdoSendUsingPort = 2 ' Send the message using SMTP

Const cdoAnonymous = 0 'Do not authenticate

Const cdoBasic = 1 'basic (clear-text) authentication

Const cdoNTLM = 2 'NTLM

SMTPServer = "XXXX"

Const SMTPPort = 25 ' Port number for SMTP

Const SMTPTimeout = 60 ' Timeout for SMTP in seconds

'Sending mail

Set objEmail = CreateObject("CDO.Message")

Set objConf = objEmail.Configuration

Set objFlds = objConf.Fields

With objFlds

'---------------------------------------------------------------------

' SMTP server details

.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = cdoSendUsingPort

.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = SMTPServer

.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoAnonymous

.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = SMTPPort

.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = False

.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = SMTPTimeout

.Update

'---------------------------------------------------------------------

End With

vName = "Bonds"

vName2 = "CDS"

strbody = "Hi Lee/Grant" & vbNewLine & vbNewLine

objEmail.To = "sifat" 'Email Recipient

objEmail.From = "sifat" 'Email Sender

objEmail.cc = "sifat"

objEmail.Subject = "Desk Report" ' Subject

objEmail.TextBody = strbody

objEmail.AddAttachment "Z:\Reporting\PDF Reports\" & vName &".pdf" ' Attachement

objEmail.AddAttachment "Z:\Reporting\PDF Reports\" & vName2 &".pdf" ' Attachement

objEmail.Send

Set objFlds = Nothing

Set objConf = Nothing

Set objEmail = Nothing

end function

FUNCTION MyPrintPDFWithBullZip (pdfOutputFile)

set obj = CreateObject("Bullzip.pdfSettings")

obj.PrinterName = "Bullzip PDF Printer"

obj.SetValue "Output" , pdfOutputFile

obj.SetValue "ConfirmOverwrite", "no"

obj.SetValue "ShowSaveAS", "never"

obj.SetValue "ShowSettings", "never"

obj.SetValue "ShowPDF", "no"

obj.SetValue "RememberLastFileName", "no"

obj.SetValue "RememberLastFolderName", "no"

obj.SetValue "ShowProgressFinished", "no"

obj.SetValue "ShowProgress", "no"

obj.WriteSettings True

END FUNCTION

Re: Task Scheduler does not work with macro

sifatnabil — Thu, 28 May 2015 09:34:52 GMT

I just replied with the code but it has links for SMTP server so it says "Currently being moderated".

Re: Task Scheduler does not work with macro

sifatnabil — Thu, 28 May 2015 09:35:20 GMT

Hi, this is still not working. It still shows "Running".

Re: Task Scheduler does not work with macro

jonathandienst — Thu, 28 May 2015 10:02:49 GMT

I don't think the OnOpen macro fires when your run with /r ??

Re: Task Scheduler does not work with macro

sifatnabil — Thu, 28 May 2015 10:05:40 GMT

Really? What should I use then?

Re: Task Scheduler does not work with macro

Peter_Cammaert — Thu, 28 May 2015 10:52:18 GMT

OnPostReload? But if the OnOpen trigger doesn't fire, then what is blocking your document?

Re: Task Scheduler does not work with macro

jerrysvensson — Thu, 28 May 2015 11:03:40 GMT

OnOpen will fire when using /r.

Is it actions or macrocode?

Try to remove code until it works, then try to figure out what the problem is.

Re: Task Scheduler does not work with macro

jerrysvensson — Fri, 29 May 2015 06:31:46 GMT

You are using Z:\ drive. If you log in as the service account, does Z drive exists then?

Has the service account correct security rights on that share?

I recommend using UNC instead of mapped drives.

Re: Task Scheduler does not work with macro

martin_dideriks — Fri, 29 May 2015 08:23:45 GMT

The only solution I have got to work so far is this:

Add this at the end of your macro.

ActiveDocument.Save

ActiveDocument.GetApplication.Quit

This will save the reloaded document and close the document when finished.

Your batchfile should look something like this:

"C:\Program Files\QlikView\qv.exe" /l /NoSecurity "C:\QV\ReportGenerator.qvw"

/l opens and reload the document (does not save and close like /r

/NoSecurity makes sure that you dont have to click a button to accept macros.

Hope it helps.

//Martin

Re: Task Scheduler does not work with macro

sifatnabil — Fri, 29 May 2015 08:39:09 GMT

Thanks all for your help. It seems even the other BAT file is not working which leads me to believe I may have lost local admin rights to run tasks when my user is logged off. I need the privileges to run tasks when logged off (run as a service) first. Thanks.