Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

How to trigger NPrinting job or schedule from Qlikview?

Nprinting has 3 Qlikview extension objects which can trigger tasks and reports, but I see no way to trigger a job or schedule via Qlikview Isn't that possible?

UPDATE: I've managed to get a macro working in Access Point in Internet Explorer and Chrome, other standard browsers should be fine as well.

Code and instructions: Qlikview macro to trigger "on demand" loads of NPrinting job or task · GitHub

Best regards,

Carl-Fredrik

1 Solution

Accepted Solutions
Employee
Employee

Re: How to trigger NPrinting job or schedule from Qlikview?

Carl-Fredrik -

You can do this with NPrinting 16: How to Distribute Reports after Successful .qvw Reload on a QlikView Server with Publisher

This is a gap feature for NPrinting 17 that we hope to implement in an upcoming release.

8 Replies
Employee
Employee

Re: How to trigger NPrinting job or schedule from Qlikview?

Carl-Fredrik -

You can do this with NPrinting 16: How to Distribute Reports after Successful .qvw Reload on a QlikView Server with Publisher

This is a gap feature for NPrinting 17 that we hope to implement in an upcoming release.

Not applicable

Re: How to trigger NPrinting job or schedule from Qlikview?

Thanks Stephen!

I believe I would need to create a macro that renames the xml-file. That would do the trick. But is is possible to trigger a macro from the Access Point?

Employee
Employee

Re: How to trigger NPrinting job or schedule from Qlikview?

I believe so. avinashelite‌ has posted about this in other threads and might be able to provide guidance.

Re: How to trigger NPrinting job or schedule from Qlikview?

Hi Carl,

yes you could trigger a macro from Access point , create a button or text box and a action to execute a macro ..here you need to specify your macro name .

NOTE: 1.In order to execute macro you need enable allow system access in the macro edit window

           2.if your using VBS than it will execute only in IE

to create a macro check this link

technet.microsoft.com/en-us/magazine/2008.02.heyscriptingguy.aspx?pr=PuzzleAnswer

Hope this answers your question

Not applicable

Re: How to trigger NPrinting job or schedule from Qlikview?

Thank you Avinash!

I managed to get a working example in VBS and in actually executes in both IE and Chrome.

Any UI updates (like MsgBox) won't work though, but in my case, changing a file name worked perfectly.

Re: How to trigger NPrinting job or schedule from Qlikview?

please post the sample VBS code so that it will helpful others, who are having similar question

Not applicable

Re: How to trigger NPrinting job or schedule from Qlikview?

I've updated my question with the sample and instructions to get it working.

But 1 more question: With the macro added to the qwv, NPrinting has a hard time to open the file since it requires a "I allow macros to run" button click in the UI. When run as a background job, NPrinting cannot continue. How do I solve this?

Re: How to trigger NPrinting job or schedule from Qlikview?

Did you tried this option: Granting System Access to your macros in the server through QEMC (System, Setup, QlikView Servers, expand and click, Seucrity tab in the right pane "Allow unsafe macro execution on server" and "Allow macro execution on server" ticked) and in the Macro editor, (Ctrl + M, bottom left drop downs)

Community Browser