topic NPrinting, one task, one receiver, multiple / separate emails in Qlik NPrinting

NPrinting, one task, one receiver, multiple / separate emails

jharke — Thu, 22 Jun 2017 10:33:21 GMT

Dear community,

There is a QV file over 14 databases. I use cycle in NPrinting (v16) to make a report per database to send these reports to a manager. He now gets one e-mail with 14 PDF attachments. He asked me to get 14 separate e-mails instead, in order to... whatever.

I don't know how to do that. Any suggestion?

Re: NPrinting, one task, one receiver, multiple / separate emails

Ruggero_Piccoli — Thu, 22 Jun 2017 16:02:38 GMT

In Qlik NPrinting 16 all reports generated in a single task for a specific user are grouped in a single email to improve performances. Sending a single email requires only one connection to your SMTP server instead of open and close a connection for each email.

There is not an option to force to create a single email for each report. The only solution to send a different email for each report is to create a different task for each report. You can clone the original task and leave a single report for each task.

Evaluate also the idea to deliver reports to a shared folder instead of send them via email if the recipient is internal.

Re: NPrinting, one task, one receiver, multiple / separate emails

jharke — Mon, 26 Jun 2017 15:43:01 GMT

I was afraid of this..

Well, I guess I have to deal with it (or, my manager has to deal with it )

Re: NPrinting, one task, one receiver, multiple / separate emails

Arek92 — Tue, 30 Apr 2024 11:05:11 GMT

Hello @Ruggero_Piccoli ,

Do you know if this functionality is working in Nprinting May 2023 version?

After experimenting I assume not, but maybe I miss sth

Thanks in advance!

Re: NPrinting, one task, one receiver, multiple / separate emails

Lech_Miszkiewicz — Tue, 30 Apr 2024 11:22:40 GMT

Yes - you miss something @Arek92

You could have dummy users set as a separate recipient with its user filter applied to only produce report for individual value of your choice. Then you could use alternate email to deliver it to single recipient. That saves you from creating multiple tasks.

I explained that here: https://nprintingadventures.com/2020/06/17/small-big-change-dynamic-email-address/

cheers

Re: NPrinting, one task, one receiver, multiple / separate emails

Arek92 — Tue, 30 Apr 2024 12:28:59 GMT

@Lech_Miszkiewicz Thank you for the quick response

Will your approach be still applicable with using cycle?

I am kind of forced to cycle through the table to prepare report for each of account number. I can't do filtering through each account number as each day there can be multpile, new account numbers..

Again, many thanks for helping me to figure it out 🙂

Re: NPrinting, one task, one receiver, multiple / separate emails

Lech_Miszkiewicz — Tue, 30 Apr 2024 13:10:43 GMT

@Arek92

No, cycles obviously will not work unless you are willing to have zipped reports in single file.
The alternative solution i provided before can be automated by creating multi-step process:

export required accounts
create/update/delete dummy users for them, their filters and group
run your report

as i said-this can be automated, but requires planning and would work best when used with API trigger so you can ensure task chaining as above steps require minimum 3 tasks