NPrinting 17.2 Dynamic Recipients

[pablomind]

Hello everybody,

I have a QVW with all the info of the report that I need including users and the hotel which corresponds to each one of them. How can I make a filter in the NPrinting which select the right hotel to each user and match it with my Recipients excel where I have all the emails of each user (I use this excel to update the user in the NPrinting console)? Thank you for your help!

[silvacarlos]

I have the same question, I need to do this but on Qlik Sense.

I hope that someone can help!

Thanks

CS

[#3 · Accepted solution]

1) build a chart with all the users, email addresses and information for filters (syntax in this file: http://help.qlik.com/en-US/nprinting/17.2/tutorials/Examples.zip)

2) Export that chart into an Excel file using an NPrinting Excel format report

3) Import the users on the chart using the import task

This will allow you to dynamically keep users updated.

You will probably want to eliminate old users on every import if the hotel+user combination is constantly changing.

[Anonymous]

Hi Carlos,

Did you find the solution?

Best Regards,

Louis

[ergustafsson]

I have created a PowerShell script which solves this as well.

Import Nprinting Users from Active Directory automatically

For the filters you can do something similar, but in NPrinting 17.3 each user needs its owns filter, as it seems. So if you have 1000 emails to be sent (one per user) - you need 1000 filters.

[AbhijitBansode]

Hi, If we create 1000 filters each for every users, How can we ensure that respected users is picked from list of users and mail is only sent to selected users?