topic Re: Cyclic printing of e-mails in Qlik NPrinting

Cyclic printing of e-mails

wood — Thu, 09 Nov 2023 08:32:42 GMT

Hello，

I have this table now, how can I send the different contents to the mailboxes corresponding to them via NP?

That is, send rows 1, 2 and 3 to AA@HOTMAIL.COM, and row 4 to BB@HOTMAIL.COM and row 5 to CC@hotmail.com

LINE NO.	Dealer	element	Recipient Email
1	AA	ABC	AA@HOTMAIL.CO
2	AA	ABC123	AA@HOTMAIL.CO
3	AA	ABC123	AA@HOTMAIL.CO
4	BB	EFG	BB@HOTMAIL.CO
5	CC	HIJ	CC@HOTMAIL.CO

Re: Cyclic printing of e-mails

Ruggero_Piccoli — Thu, 09 Nov 2023 10:55:23 GMT

Hi,

I strongly suggest you to start by reading the Getting Started chapter of the official help site at https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/Introduction/Get-started.htm. It has a detailed explanation on how to reach your goal.

Best Regards,

Ruggero

Re: Cyclic printing of e-mails

Lech_Miszkiewicz — Thu, 09 Nov 2023 11:10:02 GMT

Hi @wood

Totaly agree with Ruggeros point. You need to first understand how all components are working in NPrinting to see how your solution can be built. There is no point for us to explain here how the core of NPrinitng works as we would have to re-write hundreds of pages from help site just to explain how it all works.

In nutshell search and read help site to learn following topics:

create app
create connection
create report (here you need to choose template you are willing ot work with)
create users and filters
create task and assign users and triggers

Solution you need would be based on user filters so you would need to learn more about it.

Lastly to manage your expectations note that NPrinitng will not cycle through your table and it will not send an email just based on your table. You will need to create nprinting users with emails you have and assign user filters to them.

All this is very well and thoroughly described in help site you just have to read it all through.

good luck!

Re: Cyclic printing of e-mails

wood — Fri, 10 Nov 2023 01:41:48 GMT

Hello,

First of all, thank you for your replies.I am very familiar with the regular operation of NPrinting, the problem I am encountering is that I have thousands of rows of data in this table, which means that there are thousands of mailboxes receiving data, and each mailbox receives different data. (It's like a company pushes the information on the paystub to each employee, and each employee's mailbox can only receive his/her own information) I can't create thousands of users in NPrinting. I can only use a QLIK variable to push the data to each mailbox in a loop. How should I write this variable? Or how should this process be implemented?

Re: Cyclic printing of e-mails

Lech_Miszkiewicz — Fri, 10 Nov 2023 06:42:53 GMT

Hi @wood ,

Well - you say: "I can't create thousands of users in NPrinting." - then I have no solution for you. Distribution of reports to users with data specific to users can only be achieved by use of user filters or section access. In either case you must have users in NPrinting created.

So as far as your description goes the only thing you can do is create those 1000s of users. You can obviously automate that by using recipient import process which is also documented on help site: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm

Highlighted by you variable cannot be used for loop & reduce & send purpose. Data filtering for the users still needs to be based on user-user filter relationship.

The more advanced way of using variables or alternative emails is when you group reports by "dummy users" - each dummy user (which still has to be created in NPrinitng) represents set of filters and can have sets of filters applied. NPrinitng opens the app, applies set of filters and that the can change concatenated list of emails in Qlik variable so that can be passed to NPrinting and reports will be sent to those emails.

cheers

Re: Cyclic printing of e-mails

Ruggero_Piccoli — Fri, 10 Nov 2023 08:18:47 GMT

Hi,

You could also create a dummy user for each filter / report and add all the recipients in one of the the Alternate Email separated by comma. Then in the publish task set to use the selected Alternate Email.

Best Regards,

Ruggero