Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
paul_ripley
Contributor II

Scheduling a refresh of data in N Printing from QV

Hello

I would like my data in N Printing to refresh automatically from QV.

At the moment I have to reload metadata everytime to update N Printing from QV

I can see that I can schedule tasks, but I cant see that I can schedule connections to run.  Is this possible?

We are on N Printing Feb 2018

Many thanks

Paul

1 Solution

Accepted Solutions

Re: Scheduling a refresh of data in N Printing from QV

Paul,

BTW:Running connection can be also scheduled from connection TRIGGER tab.

as usual i am refering to help document:

https://help.qlik.com/en-US/nprinting/June2018/Content/GettingStarted/HowCreateConnections/Reloading...

Reloading metadata via scheduled trigger

You can create triggers to schedule regular metadata reloads.

Do the following:

  1. From the main menu, click the Apps drop-down, and click Connections.
  2. Click on the connection name to open the connection.
  3. Click the Triggers button.
  4. Click Create trigger.
  5. Type a name for the trigger.
  6. Select a Schedule type and Time.
  7. Set a Start date and Time zone.
  8. Click the Enabled button.
  9. Click the Create button.

Your metadata will now reload automatically, based on your settings.

cheers


Lech

--------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
7 Replies
andrewmo
Contributor

Re: Scheduling a refresh of data in N Printing from QV

Initially, I was under the same impression however you only need to refresh the metadata if you make changes to the objects in the nPrinting report. Otherwise it will hit the QV version as is.

Re: Scheduling a refresh of data in N Printing from QV

Hi Paul,

There are 2 scenarios:

  • use of QVP connection which is recommended and in my opinion should be ALWAYS used, does not require daily metadata refresh as your data can be pushed from the server and NPrinting will pick it up.
    • does not require metadata refresh
    • levarages QlikVIew server hardware so NPritnign box can be a lot smaller
    • QVS service handles memory usage and can warm cache
    • can be slower in report execution but in overall is more stable
  • use of LOCAL connection - here are following challenges:
    • requires metadata refresh
    • requires NPrinting server to be powerful enough to open and handle qvw document.
    • hardware resources are not controlled as qv desktop will consume all available resources if required.

My approach would be to use task chaining in Qlik QMC to trigger tasks.

you can then levarage API:

https://help.qlik.com/en-US/nprinting/June2018/Content/Extending/NPrinting-APIs-Reference-Redirect.h...

https://help.qlik.com/en-US/nprinting/June2018/APIs/NP+API/index.html#connectionsIdReloadPatch

It is not difficult to build simple task chaining process using this solution and you do not have to ahve coding knowledge.

step by step instructions here:

Task chaining from QlikView and Qlik Sense to NPrinting17

cheers


Lech

--------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

Re: Scheduling a refresh of data in N Printing from QV

that applies to QLikSense or QlikVIew QVP connection - NOT LOCAL

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

Re: Scheduling a refresh of data in N Printing from QV

Paul,

BTW:Running connection can be also scheduled from connection TRIGGER tab.

as usual i am refering to help document:

https://help.qlik.com/en-US/nprinting/June2018/Content/GettingStarted/HowCreateConnections/Reloading...

Reloading metadata via scheduled trigger

You can create triggers to schedule regular metadata reloads.

Do the following:

  1. From the main menu, click the Apps drop-down, and click Connections.
  2. Click on the connection name to open the connection.
  3. Click the Triggers button.
  4. Click Create trigger.
  5. Type a name for the trigger.
  6. Select a Schedule type and Time.
  7. Set a Start date and Time zone.
  8. Click the Enabled button.
  9. Click the Create button.

Your metadata will now reload automatically, based on your settings.

cheers


Lech

--------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted
arvind1494
Valued Contributor

Re: Scheduling a refresh of data in N Printing from QV

Yes it is available in qlik n printing from feb 2018  onwards:

Go to the edit connection

then chose trigger inside that

create new trigger with any name and put the time at which do u want to load metadata on daily basis.

paul_ripley
Contributor II

Re: Scheduling a refresh of data in N Printing from QV

Thanks Lech, that's super helpful.  We have 2 connections in N Printing to 1 app, and it seems that you can only have 1 server connection to an app, so the other one is local.  The instructions you provided below will enable me to refresh the connections for the server and local connection. So many thanks for your help.  Paul

Re: Scheduling a refresh of data in N Printing from QV

Hi Paul,

This is not true - you can have multiple QVP connections to the same app.

In fact it is very common practice since very often you will have different user filters applied to the same app for different reports and it requires dedicated connections.

So you might want to review your connections again.

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.