topic Re: Sending report automatically to multiple users (Not by Excel) in Qlik NPrinting

Sending report automatically to multiple users (Not by Excel)

Orli-Liveu — Fri, 15 Nov 2024 22:19:30 GMT

Hi,

I would like to send my report to the relevant users automatically. (The list of users change frequency)

The list of users are under a variable or dimension in my application in Qlik.

I don't want to add the users in the manually way to Nprinting (not by group and not by importing them from excel file)

I need to do it automatically.

There is a way to send the report to variable in Qlik that contain the names of the users?

Thanks!

Re: Sending report automatically to multiple users (Not by Excel)

Jacob_Poole — Mon, 28 Feb 2022 15:14:04 GMT

You could create the variable in your Qlik app, and use that variable in the publish task in Nprinting. On the To: line of the email, in the add variable drop down there is a Qlik variable option, select the one you've set up.

Be aware that doing so eliminates the user based features of Nprinting.

Re: Sending report automatically to multiple users (Not by Excel)

Orli-Liveu — Mon, 28 Feb 2022 15:56:30 GMT

First, Thank you!

So the relevant users will receive the report according to the variable show on the To:

But, I need that every user will see the filtered data in the report csv by his name (by the same variable I will write on the To: ), it possible?

(I did it manually to a single user by made a filter with the values: "Value is" : name_of_the user)

Thanks!

Re: Sending report automatically to multiple users (Not by Excel)

Jacob_Poole — Mon, 28 Feb 2022 16:13:41 GMT

It sounds like you want the functionality of the Nprinting user filters without having to manage the Nprinting users. I'm not certain of how your app is structured, but I don't think the variable method alone will filter the results of the report for each recipient. Maybe someone else will chime in with another option.

Re: Sending report automatically to multiple users (Not by Excel)

Frank_S — Thu, 03 Mar 2022 20:57:14 GMT

Hi @Orli-Liveu

To achieve your requirement then I suggest you consider using NPrinting user management, NP User filters, NP group management via the NPrinting recipient import process.

If email recipients are changing and filtered reports are needed, then you can manage recipients and groups using the Recipient import process

I suggest:

Follow configuration steps of the recipient import process (see https://community.qlik.com/t5/Knowledge/How-to-create-an-NPrinting-Recipient-import-task-to-import-users/ta-p/1817720)
Add needed NP recipients to the recipient import file
Create an NPrinting Group ie: NPdaily (name it as needed) and add/remove recipients to the NPDaily group via the recipients import file
Manage the recipients of this group via the recipient import file

This may not be exactly what you were hoping for but this is a way to accomplish your requirement.

It will require daily management of the NPrinting recipient import file to update NP group memberships, manage users and user filters, as needed.

However, the NP import task itself can be automated by setting it to run on a scheduled 'Trigger'.

Kind regards...