topic OnPostReload macro create PDF does not work in QlikView

OnPostReload macro create PDF does not work

Mon, 06 Sep 2010 12:47:10 GMT

Hi All

I have a macro to print pdf's with a trigger OnPostReload that works ok when the QlikView document is reloaded directly via the desktop but when my document is reloaded via the server it does not create the pdf?. Does anyone have any ideas or suggestions. Using 9 sr5, QlikViewPDF, have set Requested Module Security to System Access and Current Local Security to Allow System Access.

'***************************************************

'Functions creates the reports in PDF format

'***************************************************

sub CreateReports

"D:\DataPDF"

"RP01"

set rep = ActiveDocument.GetReport(reportID)

set vShow = ActiveDocument.Variables("vShow")

"on", true

'Create the file name with path

"" & reportID & "_" & reportName & ".pdf"

'print the report

'Call the function

'Rename the report

'checkOutputFile reportFile, tempFolder 'Call the function

'call ClearDefault() 'Call the function

end sub

'***************************************************

'Actual function to print the PDF format without being asked for location to save

'***************************************************

function printReportPDF(oReport, pdfLocation)

Set WSHShell = CreateObject("WScript.Shell")

"HKCU\Software\CUSTPDF Writer\DefaultLocation", pdfLocation, "REG_SZ"

"HKCU\Software\CUSTPDF Writer\UseJobName", "1", "REG_SZ"

"HKCU\Software\CUSTPDF Writer\UseDefaultLocation", "1", "REG_SZ"

'QV Print

"QlikViewPDF",false

set WSHShell = nothing

end function

Many thanks

Steve.

OnPostReload macro create PDF does not work

Miguel_Angel_Baeyens — Mon, 06 Sep 2010 12:53:19 GMT

Hello Steve,

First, have you checked you are allowing macro execution on server in QlikView Management Console / User Documents?

Second, Do you have the report available when you open the document in server?

And last, do you have a "CUSTPDF Writer" printer in your server?

They may be obvious, but they are the main things that may differ from your computer to the server.

Regards.

OnPostReload macro create PDF does not work

Mon, 06 Sep 2010 13:13:38 GMT

Hi Miguel

When I run the QlikView document (Reload) I am actually running it on the server, and it generate the PDF from the OnPostReload trigger, it is only when I use the QlikView Management Console to reload it that it does not trigger the OnPostReload trigger to create the PDF. Please see below in answer to the info you sent.

First, have you checked you are allowing macro execution on server in QlikView Management Console / User Documents? - In QlikView Management Console / QlikView Server Settings / Security - the option Allow Macro Execution on Server - is enabled

Second, Do you have the report available when you open the document in server? Yes the report is available to use and the auto pdf of the report does work. (FYI I develop on the server itself)

And last, do you have a "CUSTPDF Writer" printer in your server? I use PDF-Xchange 3.0

OnPostReload macro create PDF does not work

Mon, 06 Sep 2010 14:37:18 GMT

Macros cant be run like that, see:

http://community.qlik.com/forums/t/26240.aspx

OnPostReload macro create PDF does not work

Mon, 06 Sep 2010 15:32:54 GMT

Hi Danjo

Thanks for your input. Setup a batch with

D:\QVApps\Dev\Sales>"C:\Program Files\QlikView\Qv.exe" /R "D:\QVApps\Dev\SalesEMEAV3.08.qvw"

It opens a window - executes the file (I see the Script execution Progress window come up and run through the qvw file) - but still does not run the OnPostReload trigger to run the macro CreateReports

It also does not close the window when it is finished?

Any ideas?

Regards Steve

OnPostReload macro create PDF does not work

Mon, 06 Sep 2010 15:33:31 GMT

You need to run it twice using the Publisher since the trigger for OnPost Reload does not work when uploads are being done using the Publisher. OnOpen triggers do work in the Publisher.

Each time that you run the upload, you need to pass a parameter that will be use by the OnOpen trigger macro. The first upload's parm will be used in the macro to bypass the PDF cycle and just do the upload of the QV. The second time the QV is is opened for upload, the parm will indicate to the macro to go ahead and run the PDG generation. At the end of the macro, it should save the QV and quit the QV.

1st upload: (content of vPDF = NO)

n:\\\qv.exe /r /vPDF n:\dircrectory\document.qvw

2nd upload (content of vPDF = YES)

n:\\\qv.exe /l vPDF n:\dircrectory\document.qvw

You will probably need to put the above statements in a cmd file to be executed by "External Programs" in the Publisher.

and the statement in the "External Programs" should be something like this:

C:\WINDOWS\system32\CMD.exe /c n:\Qlik\Execution_Batch_Files\Generate PDF.cmd

OnPostReload macro create PDF does not work

Tue, 07 Sep 2010 11:25:28 GMT

Hi Fredrick

Many thanks, I have been trying to create the macro, but I can not seem to get it to work. Any idea as to why? It will not run the CreateReports or set the vPDF to 0.

sub ReportCheck
if vCreatePDF = 1 then
CreateReports
set vPDF = ActiveDocument.Variables("vCreatePDF")
vPDF.SetContent "0",true
end if
End sub

OnPostReload macro create PDF does not work

Miguel_Angel_Baeyens — Tue, 07 Sep 2010 11:40:16 GMT

Hello Steve,

You need first to get the value from the variable, (my guess is that vCreatePDF is not a macro variable but a QlikView variable):

Sub ReportCheck set var = ActiveDocument.Variables("vCreatePDF") val = var.GetContent.String if val = 1 then call CreateReports var.SetContent 0, true end ifEnd Sub

Hope that helps

OnPostReload macro create PDF does not work

Tue, 07 Sep 2010 13:13:58 GMT

Hi Miguel

Thank you very much. I had spent hours trying different things. What you gave me was exactly what I needed. If QlikView don't already pay you a salary they should J

You are very knowledgeable and very helpful. Many thanks

For anyone else out there this is how I got around macro's not working through publisher - through OnPostReload

My full task was to create PDF's on a daily basis with a sales summary.

I created a hidden sheet with a qv variable vshow so that the sheets would not be visible by the users, and I could create custom objects for the report

I created a report in my QlikView document using the objects from the hidden sheet

I created the following macro in the qv document

'***************************************************

'Functions checks if the report should be run

'***************************************************

sub ReportCheck

set var = ActiveDocument.Variables("vCreatePDF")

val = var.GetContent.String

if val = 1 then

call CreateReports

var.SetContent 0, true

end if

End Sub

'***************************************************

'Functions creates the reports in PDF format

'***************************************************

sub CreateReports

tempFolder = "D:\DataPDF"

reportID = "RP01"

set rep = ActiveDocument.GetReport(reportID)

'set vShow = ActiveDocument.Variables("vShow")

'vShow.SetContent "on", true

reportName = rep.Name

'Create the file name with path

reportFile = tempFolder & "\" & reportID & "_" & reportName & ".pdf"

'print the report

printReportPDF reportID, tempFolder 'Call the function

'Rename the report

'checkOutputFile reportFile, tempFolder 'Call the function

'call ClearDefault() 'Call the function

end sub

'***************************************************

'Actual function to print the PDF format without being asked for location to save

'***************************************************

function printReportPDF(oReport, pdfLocation)

Set WSHShell = CreateObject("WScript.Shell")

WSHShell.RegWrite "HKCU\Software\CUSTPDF Writer\DefaultLocation", pdfLocation, "REG_SZ"

WSHShell.RegWrite "HKCU\Software\CUSTPDF Writer\UseJobName", "1", "REG_SZ"

WSHShell.RegWrite "HKCU\Software\CUSTPDF Writer\UseDefaultLocation", "1", "REG_SZ"

'QV Print

ActiveDocument.PrintReport oReport, "PDFCreator",false

set WSHShell = nothing

end function

I created a trigger OnOpen to run macro "ReportCheck"

I created the a second qv document to distribute or create my pdf through a schedule

execute "C:\Program Files\QlikView\Qv.exe" /R /vvCreatePDF=1 /NoSecurity "D:\QVApps\Dev\Sales\EMEA V3.08.qvw"

I run my main qv on a daily schedule through publisher then i run the second qv loading on completion of the first to generate the PDF's

I then use a program blat and windows schedule to attach my PDF's to emails and send to recipients.

Hope this helps other people out to... Thanks to everyone.

OnPostReload macro create PDF does not work

Thu, 30 Sep 2010 15:17:49 GMT

This might be a dumb question, but if I'm running the /R command from the command line, do I need QlikView Desktop installed on my server? I have Publisher installed on the server, I dont think there's a QV Desktop on it at the moment.

OnPostReload macro create PDF does not work

Tue, 05 Oct 2010 19:02:39 GMT

It depends on where you are trying to load the QV.exe program from. If it is your C: drive on your PC, then yes. Otherwise the location that you are loading the QV.exe from must have it installed there.

OnPostReload macro create PDF does not work

Fri, 21 Jan 2011 13:53:09 GMT

Hello,

I'm having doubts. When I run this macro createreports pdfcretor opening prompt. How can I not open this window?

OnPostReload macro create PDF does not work

Fri, 21 Jan 2011 14:45:06 GMT

Hi Steve,

Have you got the solution .. Please let me know ....

Regards,

Chakravarthy.

OnPostReload macro create PDF does not work

Fri, 21 Jan 2011 14:48:45 GMT

redid the app and it is not opening the window more createpdf, but not the fileis being saved in the directory, anyone know what might be?

thanks...

OnPostReload macro create PDF does not work

Fri, 21 Jan 2011 15:00:06 GMT

Hi Robson/Chakravarthy - It would be a lot easier if you could upload your doc. You could limit your data so as not to give away any real information...

OnPostReload macro create PDF does not work

Fri, 21 Jan 2011 16:48:31 GMT

Hi Steve,

Sorry, I need this in pdf and automatically generate...

thanks

OnPostReload macro create PDF does not work

Tue, 01 Feb 2011 15:22:57 GMT

Hi, I´m testing this command line but I have a problem, the aplicattion reload perfect, but when it has to generate the pdf the status is SPOOLING so it doesn´t generate it.

My command line is this: execute "C:\Program Files\QlikView\QV.exe" /R /vvCreatePDF=1 /NoSecurity E:\Produccion\QlikViewStorage\Admisiones\Aplicaciones\Admisiones_Reporte.qvw

if I reload inside the application it generates the pdf perfectly, i don't know why is failing.

Any ideas???

OnPostReload macro create PDF does not work

Tue, 01 Feb 2011 17:08:25 GMT

Hi Matytr21

I may be wrong as it was a awhile ago, but when I did this I think I had a problem with reloading and creating the PDF in one command. What I can tell you is that I reload the document through management console and then when I run my script it is only to generate the PDF i.e. with the command to execute the variable (/vvCreatePDF=1) and it works... So my *.bat file has the following call "C:\Program Files\QlikView\Qv.exe" /NoSecurity /vvCreatePDF=1 "D:\QVApps\Prod\Sales\Group EMEA.qvw" so no /R.

OnPostReload macro create PDF does not work

Tue, 01 Feb 2011 17:24:22 GMT

Hi Robson

I opened your test doc and when I clicked the "Test" button it did not work, but gave the Current Local Security - Allow System Access and then it worked fine. It will automatically print the PDF to my local printer. It printed the 2 possible values of 10 and 50. If your question it to now do this on a schedule you need to create a *.bat file (call "C:\Program Files\QlikView\Qv.exe" /NoSecurity /vvCreatePDF=1 "D:\QVApps\Prod\Sales\Group EMEA.qvw") replacing my route and file name with yours. The second thing is in Settings - Document Properties - Triggers - OnOpen, add a action - Run Macro "Report Check". Then add this code to your module. Hope this helps and answers your question?

sub ReportCheck

set var = ActiveDocument.Variables("vCreatePDF")

val = var.GetContent.String

if val = 1 then

var.SetContent 0, true

call CreateReports

ActiveDocument.GetApplication.Quit

end if

End Sub

OnPostReload macro create PDF does not work

Tue, 01 Feb 2011 18:18:03 GMT

Hi Steve,

Thanks for the help. My mistake was in setting PDFCreator I had not configuredto automatically print and did not know how to configure a trigger, but with yourhelp I managed to set the trigger.

Thanks!