Cycle in NPrinting and Dynamic Mail

[Anonymous]

Hi,

I'm trying to send a mail to each user with his relevant Data in NPrinting.

I have a Field [User ID] and Another Field [User Mail].

Currently I'm using the Cycle function in order to filter the Data to each each user separately.

2 Main Problems:

1. I don't know how can I sent the relevant data for each User to his mail (Like a dynamic option to send mail).

2. Currently I'm getting the Report only in one "big Mail" and I don't know how can I divide them to each user .

Thanks

[Lech_Miszkiewicz · Accepted solution]

Hi, You need to create recipient based filters for your report (below links). Both your problems will be solved once you apply those. High level steps below:

1. Create NPrinitng Application
2. Create a connection to Qlik Document
3. For every user who supposed to be recipient create a user based filter
   • read more here: https://help.qlik.com/en-US/nprinting/February2018/Content/DeployingQVNprinting/Import-Users-Filters...
   • and here: Importing users: What options are there to import mass users into our NPrinting Nov 2017 environment...
   • and here: https://help.qlik.com/en-US/nprinting/February2018/Content/Recipients&Users/Create-users-filters-gro...
4. Create publish task
5. Add report to your task
6. Add all users (or simply group containing all those users to your taks)
7. Run Publish report task
   • task should the run much longer as it will go through every user and create a dedicated user based report (hence need for user based filters), and it will use user emails as a destination.

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[curiousfellow]

Is this stil lthe best option in Nprinting 19.9.5.0 ?

I prefer to have my user/filterllist in the qlikapp itself. When I create a publish task user/filterlist from the app should be used.

[Lech_Miszkiewicz]

Yes it is. the best option and yes you can use user list + filter from your app. 

The process is however different than in NPrinting 16.

If you want to use users/filters from your app you will need to use API before you run publish task to update your user list,filter list and user/filter association.

You can easily achieve this using the NPrinting.qvs library I created.

cheers