Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
meitargold
Contributor III
Contributor III

Cycle in NPrinting and Dynamic Mail

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

1 Solution

Accepted Solutions
Lech_Miszkiewicz

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
  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.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

3 Replies
Lech_Miszkiewicz

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
  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.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

curiousfellow
Creator II
Creator II

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

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.