topic Re: nprinting triger / user upload data in Qlik NPrinting

nprinting triger / user upload data

Robert78 — Sat, 16 Nov 2024 00:35:55 GMT

Hi everybody,

I need to make a setup, but I am not sure if it is possible using nprinting:

context:

many user upload some xml files with some data in order to populate a sql database. The qlick view interrogate this database for certain reports.

requirement:

I need to generate a qv report immediately after the user upload his data in the sql database.

Can I make nprinting server to run a job who send an email , right after the data are uploaded by a certain user ?

many thanks. 🙂

Re: nprinting triger / user upload data

Lech_Miszkiewicz — Wed, 27 May 2020 22:25:33 GMT

Hi,

yes you can. Depending on version of NPrinting there are different solutions available, so first we need to know the exact version of NPrinting you are using

Re: nprinting triger / user upload data

Robert78 — Fri, 29 May 2020 07:18:08 GMT

This is a very good news 🙂

Our Nprintng version is:

Re: nprinting triger / user upload data

Lech_Miszkiewicz — Sat, 30 May 2020 11:14:00 GMT

So the first question is outside of QlikView and NPrinting:

how are you going to know that:
- user has just uploaded new xml?
- and which user just did it

Those 2 informations are important as they drive remaining part of the setup.

at this stage I can imagine there should be a trigger sent from DB (using QlikView EDX) to trigger reload task.
- https://community.qlik.com/t5/QlikView-Documents/Using-EDX-in-QlikView-11/ta-p/1478952
reload task of QlikView is obviously needed to pull that new data so NPrinting can generate report with it.
then using task chaining in QMC you would have another task sending report using NPrinting
- task chaining can be achieved using API and REST connector in Qlik script: https://nprintingadventures.com/2019/04/08/nprinting-api-qlik-rest-subroutines/

Comments:

Using NPrinting 2020 version or even June 2020 once it comes out would be much easier as it supports variable users/recipients. https://help.qlik.com/en-US/nprinting/April2020/Content/NPrinting/DistributionSchedulesAutomation/DistributingReportsbyEmail.htm#anchor-2

So it is all possible, but I am not saying it will be easy task to someone who is not very experienced in QlikView development and NPrinting development.

Re: nprinting triger / user upload data

Robert78 — Tue, 02 Jun 2020 06:05:25 GMT

Thanks Lech.

This is a good start for me for digging for the final solution.

Thank again.

Re: nprinting triger / user upload data

Robert78 — Wed, 03 Jun 2020 11:39:46 GMT

another question is if it is possible from nPrinting to run a task when a file exists in specified location ?

thanks.

Re: nprinting triger / user upload data

Lech_Miszkiewicz — Sat, 06 Jun 2020 02:05:20 GMT

Hi @Robert78

i think your question is too generic.
what do you mean by: if it is possible from nPrinting to run a task when a file exists in specified location ?

Source of data for Nprinting is QlikView or QlikSense only-full stop!
that means that if you want to use content of this file to create Nprinting Report you need to first load it to QlikView or Qlik Sense.

now if your question is different like: if the presence of file in particular location could trigger Nprinting report, then the answer is yes-but nor directly, only via custom built solution using API

Regards

Lech