Scheduling a refresh of data in N Printing from QV

[paul_ripley]

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

[andrewmo]

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.

[Lech_Miszkiewicz]

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.

[Lech_Miszkiewicz]

that applies to QLikSense or QlikVIew QVP connection - NOT LOCAL

[Lech_Miszkiewicz · Accepted solution]

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.

[arvind1494]

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]

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

[Lech_Miszkiewicz]

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