how to reload connection metadata automatically (not manually) for automated daily reports

[ioannagr]

Hi experts.

 I have noticed that in order for the new data from Qlik Sense to reach my excel report in nprinting, I have to manually "Reload Metadata" for the specific Connection.

My question is: 

When I create a report  in Nprinting from Qlik Sense App Production Data which gets updated every day , the daily report that sends out will be automatically updated without me "reloading metadata" ?

[Lucas_Gatling]

You can create Nprinting tasks in the Web console to update the metadata connection. The correct order to do things to make sure your reports are up to date with correct data is to 1) Reload the Sense app via the QMC  2) Create and run the connection tasks that reload the metadata from Sense to NP 3) Run NP task for your NP report. 

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/GettingStarted/HowCreateConnections/...

[ioannagr]

Hi @Lucas_Gatling  and thank you for the quick response. I am not the QMC admin, so because I'll need to point my coworker somewhere, could you please give me more info on step 1) Reload the Sense app via the QMC?

[Lucas_Gatling]

Your QlikSense admin will just need to create a reload task in the QMC for the Sense App (QS App ID) that you have an NPrinting connection with. They just need to schedule a daily, weekly or monthly task for that app to reload. The workflow should work as 1) Sense source App is reloaded 2) Nprinting Metadata connection is reloaded 3) NP report task is run. 

This work flow will ensure that the newest data will be in the NP reports.

[ioannagr]

Okay, I'll contact him asap and let you know if something is up, otherwise I'll come back to thank you and mark your post as a solution 🙂

[Digvijay_Singh]

We don't run Metadata connection if no change is made in the visuals. Regular Data reload in the app doesn't need metadata refresh. Only need to schedule your app reload and trigger nprinting tasks after data reload is completed. In fact we trigger our nprinting tasks from Sense trigger apps using REST connections once the reload finishes. The whole chain is automated using the following setup.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-use-Qlik-NPrinting-APIs-inside-a-Qli...

There are many more good posts in community to create above kinda setup.

Thanks,

[TusharDev_Qlik]

@Lucas_Gatling  we do not schedule the metadata reload for each connection, still we get updated reports after Publish task in Nprinting completes(as the source app reload already completeed). Is it mandatory to have metadata reload before running the publish task?

[Ruggero_Piccoli]

Hi,

No, if you are using connections to Qlik Sense and you don't change the structure of the app (for example by adding a chart) you don't need to reload the cache.

Best Regards,

Ruggero

[Saurabh_K14999]

Hi,

If your data gets updated daily you don't need to reload meta data for that it has to be done in the QMC tasks by scheduling the reload and the data automatically gets updated in the N printing reports too.

Also, Only if you make some changes to the sense app for e.g adding a new column to the table you need to reload meta data and that has to be done manually.

Best Regards,

Saurabh.

[Frank_S]

For more on NP connection reload behavior, see:

• https://help.qlik.com/en-US/nprinting/Content/NPrinting/GettingStarted/HowCreateConnections/Reloadin...